NYC taxi meter and options pricing

Tancrede Collard

Tancrede Collard

QuestDB Team

Every cab I have ever ridden has been complaining about how hard it is to make ends meet as a driver. The public is generally quick to blame unfair competition from the likes of Uber. However, additional forces are also to blame.

Going through more than 10 years worth of NYC taxi data, I analyse how the antiquated meter system impacts the livelihood of NYC cabbies by drawing an analogy with stock options trading. Interestingly, this approach allows us to show that drivers have progressively been worse-off, independently of competition from Uber.

In order to do so, we have loaded a dataset into our database QuestDB. This dataset includes over 1.6 billion taxi rides, 700 million FHV rides (Uber, Lyft etc), and 10 years of weather and gas prices data.

Light-weight, blazing fast stack for your IoT application

Shan Desai

Shan Desai

QuestDB Contributor

Note: I wanted you to know that this post is written by one of our contributors, Shan Desai. Shan is a research scientist working for the Bremen Institute for Production and Logistics (BIBA). His work involves the use of IoT devices in order to improve product tracking and transparency in a B2B marketplace. You can find more details on Shan's personnal website.

Thanks a lot for your contribution Shan!

Re-examining our approach to memory mapping

David G. Simmons

David G. Simmons

QuestDB Team

How does QuestDB get the kind of performance it does, and how are we continuing to squeeze another 50-60% out of it? We are constantly learning more about the fundamental concepts of memory performance, and this is one example of how what we at first thought would be worse for performance ended up bringing us a rather substantial boost in overall memory performance.

We will walk you through how some of our initial thoughts on storage and memory-mapping evolved to bring us better performance overall.

If you like QuestDB, please do give us a star on GitHub

Use QuestDB and get swag!

David G. Simmons

David G. Simmons

QuestDB Team

We've been upping our SWAG game a lot lately, and we want to share it with you, the valuable members of our community! We want to give you the chance to show off your projects, show off your love for QuestDB, and to show just off!