Interesting, I tried to make a query taking a long time using join and got 37.43s:

    SELECT * FROM trips
    JOIN gas_prices ON gas_prices.timestamp = trips.pickup_datetime;