PREVIEW / futures_1hour / 2024-06-04
file: by_date/futures_1hour/2024/2024-06-04.parquet size: 68 KB rows: 2,074
schema
timestamp TIMESTAMP symbol VARCHAR asset_type VARCHAR open DOUBLE high DOUBLE low DOUBLE close DOUBLE volume DOUBLE
sample rows
| timestamp | symbol | asset_type | open | high | low | close | volume |
|---|---|---|---|---|---|---|---|
| 2024-06-04 00:00:00 | ES | Futures | 5623.47 | 5624.8 | 5621.62 | 5621.62 | 3366.0 |
| 2024-06-04 01:00:00 | ES | Futures | 5621.62 | 5622.68 | 5619.76 | 5622.15 | 5732.0 |
| 2024-06-04 02:00:00 | ES | Futures | 5622.41 | 5622.41 | 5610.47 | 5611.8 | 13972.0 |
| 2024-06-04 03:00:00 | ES | Futures | 5612.07 | 5616.84 | 5605.17 | 5612.6 | 24324.0 |
| 2024-06-04 04:00:00 | ES | Futures | 5612.86 | 5612.86 | 5591.64 | 5593.23 | 32880.0 |
| 2024-06-04 05:00:00 | ES | Futures | 5593.49 | 5595.35 | 5583.94 | 5589.52 | 35625.0 |
| 2024-06-04 06:00:00 | ES | Futures | 5589.78 | 5594.03 | 5585.01 | 5592.96 | 19540.0 |
| 2024-06-04 07:00:00 | ES | Futures | 5592.96 | 5603.31 | 5592.7 | 5602.78 | 20436.0 |
| 2024-06-04 08:00:00 | ES | Futures | 5602.78 | 5605.96 | 5594.56 | 5604.9 | 28688.0 |
| 2024-06-04 09:00:00 | ES | Futures | 5604.64 | 5612.07 | 5600.66 | 5608.35 | 164538.0 |
| 2024-06-04 10:00:00 | ES | Futures | 5608.62 | 5622.15 | 5600.66 | 5602.78 | 313959.0 |
| 2024-06-04 11:00:00 | ES | Futures | 5602.78 | 5609.94 | 5594.03 | 5595.09 | 176210.0 |
| 2024-06-04 12:00:00 | ES | Futures | 5595.09 | 5613.39 | 5591.9 | 5608.35 | 142994.0 |
| 2024-06-04 13:00:00 | ES | Futures | 5608.35 | 5615.51 | 5599.86 | 5612.33 | 118618.0 |
| 2024-06-04 14:00:00 | ES | Futures | 5612.07 | 5637.27 | 5610.74 | 5628.78 | 167257.0 |
| 2024-06-04 15:00:00 | ES | Futures | 5628.78 | 5631.17 | 5609.94 | 5628.51 | 279805.0 |
| 2024-06-04 16:00:00 | ES | Futures | 5628.51 | 5631.43 | 5624.8 | 5629.31 | 51419.0 |
| 2024-06-04 18:00:00 | ES | Futures | 5629.57 | 5633.29 | 5626.92 | 5633.29 | 4782.0 |
| 2024-06-04 19:00:00 | ES | Futures | 5633.02 | 5637.53 | 5633.02 | 5636.47 | 7191.0 |
| 2024-06-04 20:00:00 | ES | Futures | 5636.21 | 5637.27 | 5633.82 | 5634.08 | 6932.0 |
| 2024-06-04 21:00:00 | ES | Futures | 5634.08 | 5638.33 | 5631.96 | 5636.47 | 9459.0 |
| 2024-06-04 22:00:00 | ES | Futures | 5636.47 | 5639.92 | 5635.94 | 5638.06 | 10092.0 |
| 2024-06-04 23:00:00 | ES | Futures | 5637.8 | 5639.92 | 5637.0 | 5638.59 | 4086.0 |
| 2024-06-04 00:00:00 | NQ | Futures | 19960.08 | 19964.9 | 19951.79 | 19951.79 | 1304.0 |
| 2024-06-04 01:00:00 | NQ | Futures | 19952.06 | 19957.41 | 19941.89 | 19951.79 | 2311.0 |
| 2024-06-04 02:00:00 | NQ | Futures | 19952.06 | 19953.39 | 19893.2 | 19902.3 | 5594.0 |
| 2024-06-04 03:00:00 | NQ | Futures | 19902.3 | 19937.34 | 19866.99 | 19921.56 | 10401.0 |
| 2024-06-04 04:00:00 | NQ | Futures | 19921.83 | 19922.9 | 19842.65 | 19854.15 | 13515.0 |
| 2024-06-04 05:00:00 | NQ | Futures | 19854.95 | 19862.71 | 19807.34 | 19841.31 | 13286.0 |
| 2024-06-04 06:00:00 | NQ | Futures | 19841.84 | 19868.86 | 19827.4 | 19854.68 | 8553.0 |
| 2024-06-04 07:00:00 | NQ | Futures | 19855.22 | 19900.43 | 19854.68 | 19898.82 | 9274.0 |
| 2024-06-04 08:00:00 | NQ | Futures | 19898.29 | 19917.28 | 19861.91 | 19911.93 | 13166.0 |
| 2024-06-04 09:00:00 | NQ | Futures | 19911.93 | 19956.6 | 19880.36 | 19904.97 | 68151.0 |
| 2024-06-04 10:00:00 | NQ | Futures | 19905.24 | 19970.78 | 19867.79 | 19904.44 | 114378.0 |
| 2024-06-04 11:00:00 | NQ | Futures | 19904.17 | 19945.1 | 19876.62 | 19887.32 | 60935.0 |
| 2024-06-04 12:00:00 | NQ | Futures | 19887.05 | 19958.21 | 19871.0 | 19933.33 | 53131.0 |
| 2024-06-04 13:00:00 | NQ | Futures | 19933.06 | 19951.25 | 19896.68 | 19933.87 | 42196.0 |
| 2024-06-04 14:00:00 | NQ | Futures | 19932.8 | 20066.28 | 19927.98 | 20021.07 | 70101.0 |
| 2024-06-04 15:00:00 | NQ | Futures | 20020.8 | 20023.75 | 19936.54 | 20011.17 | 92346.0 |
| 2024-06-04 16:00:00 | NQ | Futures | 20011.17 | 20024.55 | 19992.98 | 20016.26 | 15351.0 |
| 2024-06-04 18:00:00 | NQ | Futures | 20021.07 | 20030.97 | 20005.29 | 20029.1 | 2747.0 |
| 2024-06-04 19:00:00 | NQ | Futures | 20029.1 | 20051.83 | 20029.1 | 20049.43 | 2975.0 |
| 2024-06-04 20:00:00 | NQ | Futures | 20049.69 | 20058.52 | 20038.19 | 20040.06 | 3527.0 |
| 2024-06-04 21:00:00 | NQ | Futures | 20039.8 | 20060.39 | 20025.62 | 20056.65 | 4354.0 |
| 2024-06-04 22:00:00 | NQ | Futures | 20056.92 | 20079.92 | 20054.78 | 20067.08 | 4986.0 |
| 2024-06-04 23:00:00 | NQ | Futures | 20067.35 | 20076.98 | 20063.07 | 20071.63 | 1827.0 |
| 2024-06-04 00:00:00 | YM | Futures | 41042.2 | 41055.0 | 41034.8 | 41034.8 | 448.0 |
| 2024-06-04 01:00:00 | YM | Futures | 41034.8 | 41041.2 | 41023.1 | 41040.1 | 798.0 |
| 2024-06-04 02:00:00 | YM | Futures | 41036.9 | 41038.0 | 40969.0 | 40978.5 | 1852.0 |
| 2024-06-04 03:00:00 | YM | Futures | 40976.4 | 40998.7 | 40932.9 | 40971.1 | 2273.0 |
> showing 50 of 2,074 rows — these rows as CSV