PREVIEW / futures_1hour / 2024-06-12
file: by_date/futures_1hour/2024/2024-06-12.parquet size: 63 KB rows: 1,912
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-12 00:00:00 | ES | Futures | 5716.59 | 5716.86 | 5715.0 | 5715.8 | 1423.0 |
| 2024-06-12 01:00:00 | ES | Futures | 5715.53 | 5719.78 | 5715.53 | 5719.24 | 3797.0 |
| 2024-06-12 02:00:00 | ES | Futures | 5718.98 | 5721.9 | 5715.8 | 5715.8 | 7158.0 |
| 2024-06-12 03:00:00 | ES | Futures | 5716.06 | 5717.12 | 5714.47 | 5716.59 | 10228.0 |
| 2024-06-12 04:00:00 | ES | Futures | 5716.33 | 5719.78 | 5715.0 | 5718.18 | 10522.0 |
| 2024-06-12 05:00:00 | ES | Futures | 5718.45 | 5721.63 | 5717.39 | 5719.51 | 8173.0 |
| 2024-06-12 06:00:00 | ES | Futures | 5719.51 | 5722.16 | 5717.92 | 5720.84 | 6457.0 |
| 2024-06-12 07:00:00 | ES | Futures | 5720.57 | 5722.43 | 5718.45 | 5720.57 | 11212.0 |
| 2024-06-12 08:00:00 | ES | Futures | 5720.31 | 5764.35 | 5717.12 | 5763.55 | 122757.0 |
| 2024-06-12 09:00:00 | ES | Futures | 5763.55 | 5776.55 | 5757.98 | 5773.63 | 220412.0 |
| 2024-06-12 10:00:00 | ES | Futures | 5773.37 | 5787.16 | 5772.04 | 5777.88 | 213561.0 |
| 2024-06-12 11:00:00 | ES | Futures | 5777.88 | 5781.32 | 5771.77 | 5777.08 | 137692.0 |
| 2024-06-12 12:00:00 | ES | Futures | 5777.08 | 5778.14 | 5770.71 | 5774.96 | 91825.0 |
| 2024-06-12 13:00:00 | ES | Futures | 5774.96 | 5780.79 | 5768.06 | 5772.04 | 94435.0 |
| 2024-06-12 14:00:00 | ES | Futures | 5772.3 | 5777.61 | 5753.73 | 5771.24 | 291476.0 |
| 2024-06-12 15:00:00 | ES | Futures | 5771.24 | 5788.22 | 5747.63 | 5758.77 | 389619.0 |
| 2024-06-12 16:00:00 | ES | Futures | 5758.51 | 5771.77 | 5755.59 | 5771.24 | 73403.0 |
| 2024-06-12 18:00:00 | ES | Futures | 5768.86 | 5770.18 | 5765.67 | 5766.73 | 5263.0 |
| 2024-06-12 19:00:00 | ES | Futures | 5766.73 | 5769.39 | 5764.61 | 5768.59 | 3206.0 |
| 2024-06-12 20:00:00 | ES | Futures | 5768.59 | 5771.24 | 5768.06 | 5770.18 | 5745.0 |
| 2024-06-12 21:00:00 | ES | Futures | 5770.18 | 5772.04 | 5769.39 | 5770.18 | 4728.0 |
| 2024-06-12 22:00:00 | ES | Futures | 5770.45 | 5770.71 | 5768.32 | 5770.45 | 3111.0 |
| 2024-06-12 23:00:00 | ES | Futures | 5770.71 | 5774.16 | 5770.45 | 5773.63 | 4009.0 |
| 2024-06-12 00:00:00 | NQ | Futures | 20615.73 | 20616.54 | 20602.09 | 20605.03 | 1322.0 |
| 2024-06-12 01:00:00 | NQ | Futures | 20604.77 | 20617.07 | 20602.36 | 20614.66 | 2091.0 |
| 2024-06-12 02:00:00 | NQ | Futures | 20614.93 | 20625.9 | 20602.89 | 20603.96 | 4248.0 |
| 2024-06-12 03:00:00 | NQ | Futures | 20603.7 | 20606.1 | 20587.38 | 20600.22 | 6029.0 |
| 2024-06-12 04:00:00 | NQ | Futures | 20600.49 | 20613.06 | 20592.46 | 20607.98 | 5447.0 |
| 2024-06-12 05:00:00 | NQ | Futures | 20607.17 | 20622.96 | 20604.23 | 20616.27 | 4061.0 |
| 2024-06-12 06:00:00 | NQ | Futures | 20616.27 | 20623.49 | 20608.51 | 20617.07 | 3991.0 |
| 2024-06-12 07:00:00 | NQ | Futures | 20617.07 | 20627.5 | 20610.65 | 20618.94 | 6615.0 |
| 2024-06-12 08:00:00 | NQ | Futures | 20618.41 | 20821.18 | 20611.45 | 20781.85 | 51778.0 |
| 2024-06-12 09:00:00 | NQ | Futures | 20782.12 | 20870.4 | 20731.29 | 20855.68 | 104058.0 |
| 2024-06-12 10:00:00 | NQ | Futures | 20855.68 | 20915.34 | 20843.91 | 20870.4 | 94108.0 |
| 2024-06-12 11:00:00 | NQ | Futures | 20870.66 | 20906.78 | 20862.64 | 20881.63 | 52399.0 |
| 2024-06-12 12:00:00 | NQ | Futures | 20881.1 | 20893.13 | 20858.09 | 20875.48 | 38313.0 |
| 2024-06-12 13:00:00 | NQ | Futures | 20875.75 | 20904.64 | 20855.42 | 20884.31 | 31672.0 |
| 2024-06-12 14:00:00 | NQ | Futures | 20885.11 | 20910.25 | 20810.21 | 20884.04 | 100441.0 |
| 2024-06-12 15:00:00 | NQ | Futures | 20884.84 | 20960.28 | 20793.62 | 20857.02 | 119444.0 |
| 2024-06-12 16:00:00 | NQ | Futures | 20857.29 | 20985.42 | 20826.53 | 20983.28 | 31442.0 |
| 2024-06-12 18:00:00 | NQ | Futures | 20974.46 | 20975.26 | 20956.8 | 20961.35 | 3712.0 |
| 2024-06-12 19:00:00 | NQ | Futures | 20961.08 | 20976.6 | 20953.32 | 20972.85 | 2384.0 |
| 2024-06-12 20:00:00 | NQ | Futures | 20972.32 | 20997.73 | 20969.91 | 20989.17 | 3953.0 |
| 2024-06-12 21:00:00 | NQ | Futures | 20989.97 | 20999.07 | 20989.17 | 20993.98 | 2863.0 |
| 2024-06-12 22:00:00 | NQ | Futures | 20995.59 | 20996.66 | 20984.09 | 20992.65 | 2070.0 |
| 2024-06-12 23:00:00 | NQ | Futures | 20992.65 | 21012.98 | 20991.31 | 21012.17 | 3051.0 |
| 2024-06-12 00:00:00 | YM | Futures | 41187.7 | 41197.2 | 41186.6 | 41197.2 | 433.0 |
| 2024-06-12 01:00:00 | YM | Futures | 41196.2 | 41228.0 | 41195.1 | 41225.9 | 861.0 |
| 2024-06-12 02:00:00 | YM | Futures | 41224.8 | 41253.5 | 41201.5 | 41206.8 | 1623.0 |
| 2024-06-12 03:00:00 | YM | Futures | 41206.8 | 41233.3 | 41198.3 | 41224.8 | 1780.0 |
> showing 50 of 1,912 rows — these rows as CSV