PREVIEW / futures_1hour / 2025-06-19
file: by_date/futures_1hour/2025/2025-06-19.parquet size: 55 KB rows: 1,663
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 |
|---|---|---|---|---|---|---|---|
| 2025-06-19 00:00:00 | ES | Futures | 6069.93 | 6073.96 | 6067.91 | 6073.2 | 2577.0 |
| 2025-06-19 01:00:00 | ES | Futures | 6072.95 | 6072.95 | 6060.1 | 6061.11 | 3368.0 |
| 2025-06-19 02:00:00 | ES | Futures | 6060.86 | 6065.14 | 6053.56 | 6061.11 | 9127.0 |
| 2025-06-19 03:00:00 | ES | Futures | 6061.36 | 6064.39 | 6040.71 | 6043.73 | 11980.0 |
| 2025-06-19 04:00:00 | ES | Futures | 6044.24 | 6055.82 | 6043.98 | 6053.81 | 9051.0 |
| 2025-06-19 05:00:00 | ES | Futures | 6053.56 | 6059.6 | 6053.05 | 6054.56 | 5519.0 |
| 2025-06-19 06:00:00 | ES | Futures | 6054.31 | 6060.1 | 6049.27 | 6057.33 | 5255.0 |
| 2025-06-19 07:00:00 | ES | Futures | 6057.33 | 6058.34 | 6043.73 | 6049.02 | 7172.0 |
| 2025-06-19 08:00:00 | ES | Futures | 6049.02 | 6053.56 | 6034.16 | 6037.69 | 13084.0 |
| 2025-06-19 09:00:00 | ES | Futures | 6037.69 | 6044.49 | 6014.26 | 6023.08 | 32596.0 |
| 2025-06-19 10:00:00 | ES | Futures | 6023.08 | 6032.9 | 6020.81 | 6030.64 | 31828.0 |
| 2025-06-19 11:00:00 | ES | Futures | 6030.89 | 6034.92 | 6017.79 | 6019.05 | 38763.0 |
| 2025-06-19 12:00:00 | ES | Futures | 6018.8 | 6031.64 | 6018.8 | 6023.08 | 13621.0 |
| 2025-06-19 18:00:00 | ES | Futures | 6038.95 | 6070.68 | 6036.43 | 6064.39 | 18495.0 |
| 2025-06-19 19:00:00 | ES | Futures | 6064.39 | 6067.16 | 6059.35 | 6062.37 | 5744.0 |
| 2025-06-19 20:00:00 | ES | Futures | 6062.12 | 6074.21 | 6061.11 | 6063.88 | 8807.0 |
| 2025-06-19 21:00:00 | ES | Futures | 6064.13 | 6065.9 | 6051.79 | 6058.34 | 8725.0 |
| 2025-06-19 22:00:00 | ES | Futures | 6058.59 | 6064.89 | 6056.58 | 6062.37 | 3326.0 |
| 2025-06-19 23:00:00 | ES | Futures | 6062.37 | 6069.42 | 6060.36 | 6066.15 | 3827.0 |
| 2025-06-19 00:00:00 | NQ | Futures | 22073.34 | 22094.27 | 22066.03 | 22088.98 | 2065.0 |
| 2025-06-19 01:00:00 | NQ | Futures | 22087.97 | 22089.23 | 22038.04 | 22042.58 | 2282.0 |
| 2025-06-19 02:00:00 | NQ | Futures | 22041.57 | 22065.27 | 22007.27 | 22042.07 | 6012.0 |
| 2025-06-19 03:00:00 | NQ | Futures | 22042.07 | 22061.74 | 21972.47 | 21984.57 | 5793.0 |
| 2025-06-19 04:00:00 | NQ | Futures | 21985.84 | 22030.22 | 21985.84 | 22016.35 | 3267.0 |
| 2025-06-19 05:00:00 | NQ | Futures | 22016.1 | 22041.06 | 22013.83 | 22021.9 | 2031.0 |
| 2025-06-19 06:00:00 | NQ | Futures | 22022.91 | 22046.86 | 22002.23 | 22035.01 | 2214.0 |
| 2025-06-19 07:00:00 | NQ | Futures | 22037.53 | 22038.79 | 21976.5 | 22004.24 | 3454.0 |
| 2025-06-19 08:00:00 | NQ | Futures | 22003.74 | 22015.34 | 21931.87 | 21953.05 | 5340.0 |
| 2025-06-19 09:00:00 | NQ | Futures | 21953.3 | 21976.5 | 21838.82 | 21874.12 | 17994.0 |
| 2025-06-19 10:00:00 | NQ | Futures | 21874.37 | 21922.54 | 21860.25 | 21915.73 | 15632.0 |
| 2025-06-19 11:00:00 | NQ | Futures | 21915.98 | 21930.1 | 21864.29 | 21869.83 | 14347.0 |
| 2025-06-19 12:00:00 | NQ | Futures | 21869.08 | 21931.11 | 21867.06 | 21892.03 | 7825.0 |
| 2025-06-19 18:00:00 | NQ | Futures | 21937.67 | 22121.25 | 21935.15 | 22084.94 | 10610.0 |
| 2025-06-19 19:00:00 | NQ | Futures | 22087.21 | 22096.79 | 22060.73 | 22077.12 | 4571.0 |
| 2025-06-19 20:00:00 | NQ | Futures | 22078.13 | 22118.99 | 22071.07 | 22077.38 | 6304.0 |
| 2025-06-19 21:00:00 | NQ | Futures | 22078.64 | 22085.7 | 22037.28 | 22066.03 | 6175.0 |
| 2025-06-19 22:00:00 | NQ | Futures | 22066.28 | 22094.78 | 22058.46 | 22083.43 | 2894.0 |
| 2025-06-19 23:00:00 | NQ | Futures | 22083.68 | 22103.1 | 22073.59 | 22091.5 | 3309.0 |
| 2025-06-19 00:00:00 | YM | Futures | 43374.9 | 43394.3 | 43361.6 | 43389.2 | 338.0 |
| 2025-06-19 01:00:00 | YM | Futures | 43391.3 | 43392.3 | 43305.5 | 43311.6 | 489.0 |
| 2025-06-19 02:00:00 | YM | Futures | 43310.6 | 43330.0 | 43272.8 | 43330.0 | 1449.0 |
| 2025-06-19 03:00:00 | YM | Futures | 43330.0 | 43330.0 | 43174.7 | 43191.0 | 1582.0 |
| 2025-06-19 04:00:00 | YM | Futures | 43191.0 | 43302.4 | 43191.0 | 43258.5 | 1672.0 |
| 2025-06-19 05:00:00 | YM | Futures | 43260.5 | 43287.1 | 43247.2 | 43255.4 | 424.0 |
| 2025-06-19 06:00:00 | YM | Futures | 43255.4 | 43297.3 | 43220.7 | 43279.9 | 1265.0 |
| 2025-06-19 07:00:00 | YM | Futures | 43280.9 | 43288.1 | 43194.1 | 43218.6 | 685.0 |
| 2025-06-19 08:00:00 | YM | Futures | 43217.6 | 43237.0 | 43120.6 | 43138.9 | 1482.0 |
| 2025-06-19 09:00:00 | YM | Futures | 43140.0 | 43179.8 | 42995.9 | 43047.0 | 3220.0 |
| 2025-06-19 10:00:00 | YM | Futures | 43049.0 | 43110.3 | 43033.7 | 43083.8 | 2440.0 |
| 2025-06-19 11:00:00 | YM | Futures | 43085.8 | 43119.5 | 43000.0 | 43007.2 | 3408.0 |
> showing 50 of 1,663 rows — these rows as CSV