PREVIEW / futures_1hour / 2024-05-10
file: by_date/futures_1hour/2024/2024-05-10.parquet size: 55 KB rows: 1,664
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-05-10 00:00:00 | ES | Futures | 5561.92 | 5565.64 | 5561.92 | 5565.11 | 3070.0 |
| 2024-05-10 01:00:00 | ES | Futures | 5565.11 | 5566.7 | 5564.31 | 5564.58 | 4391.0 |
| 2024-05-10 02:00:00 | ES | Futures | 5564.84 | 5569.35 | 5563.52 | 5568.82 | 6431.0 |
| 2024-05-10 03:00:00 | ES | Futures | 5568.82 | 5573.33 | 5568.82 | 5570.41 | 15093.0 |
| 2024-05-10 04:00:00 | ES | Futures | 5570.41 | 5578.37 | 5566.7 | 5578.37 | 14074.0 |
| 2024-05-10 05:00:00 | ES | Futures | 5578.64 | 5582.62 | 5577.84 | 5581.03 | 17269.0 |
| 2024-05-10 06:00:00 | ES | Futures | 5581.29 | 5581.29 | 5577.58 | 5578.11 | 9032.0 |
| 2024-05-10 07:00:00 | ES | Futures | 5578.37 | 5580.23 | 5574.92 | 5576.25 | 10446.0 |
| 2024-05-10 08:00:00 | ES | Futures | 5575.99 | 5579.96 | 5571.21 | 5571.48 | 24882.0 |
| 2024-05-10 09:00:00 | ES | Futures | 5571.74 | 5586.07 | 5570.68 | 5583.94 | 141420.0 |
| 2024-05-10 10:00:00 | ES | Futures | 5583.94 | 5583.94 | 5557.68 | 5562.46 | 234998.0 |
| 2024-05-10 11:00:00 | ES | Futures | 5562.72 | 5564.58 | 5552.9 | 5561.39 | 128847.0 |
| 2024-05-10 12:00:00 | ES | Futures | 5561.39 | 5565.64 | 5555.82 | 5563.25 | 87844.0 |
| 2024-05-10 13:00:00 | ES | Futures | 5563.25 | 5566.43 | 5556.35 | 5565.9 | 75725.0 |
| 2024-05-10 14:00:00 | ES | Futures | 5565.9 | 5567.5 | 5558.48 | 5567.23 | 78234.0 |
| 2024-05-10 15:00:00 | ES | Futures | 5567.23 | 5572.01 | 5563.78 | 5566.17 | 143157.0 |
| 2024-05-10 16:00:00 | ES | Futures | 5566.43 | 5566.97 | 5561.39 | 5562.19 | 37332.0 |
| 2024-05-10 00:00:00 | NQ | Futures | 19492.48 | 19505.06 | 19490.61 | 19504.25 | 2144.0 |
| 2024-05-10 01:00:00 | NQ | Futures | 19503.99 | 19513.35 | 19501.04 | 19503.99 | 3058.0 |
| 2024-05-10 02:00:00 | NQ | Futures | 19503.99 | 19533.95 | 19497.3 | 19532.07 | 4192.0 |
| 2024-05-10 03:00:00 | NQ | Futures | 19532.88 | 19557.75 | 19520.04 | 19521.64 | 8221.0 |
| 2024-05-10 04:00:00 | NQ | Futures | 19522.44 | 19572.2 | 19507.73 | 19571.93 | 8091.0 |
| 2024-05-10 05:00:00 | NQ | Futures | 19571.66 | 19588.52 | 19567.38 | 19583.7 | 8438.0 |
| 2024-05-10 06:00:00 | NQ | Futures | 19583.7 | 19585.31 | 19565.78 | 19570.86 | 5779.0 |
| 2024-05-10 07:00:00 | NQ | Futures | 19571.13 | 19582.9 | 19557.49 | 19565.51 | 6407.0 |
| 2024-05-10 08:00:00 | NQ | Futures | 19565.24 | 19583.43 | 19527.53 | 19530.74 | 14924.0 |
| 2024-05-10 09:00:00 | NQ | Futures | 19531.27 | 19632.66 | 19525.39 | 19612.06 | 71541.0 |
| 2024-05-10 10:00:00 | NQ | Futures | 19612.06 | 19613.13 | 19461.99 | 19494.62 | 107854.0 |
| 2024-05-10 11:00:00 | NQ | Futures | 19494.62 | 19520.84 | 19466.8 | 19513.35 | 52644.0 |
| 2024-05-10 12:00:00 | NQ | Futures | 19513.35 | 19531.54 | 19483.66 | 19522.44 | 39220.0 |
| 2024-05-10 13:00:00 | NQ | Futures | 19522.18 | 19532.34 | 19482.32 | 19529.93 | 35133.0 |
| 2024-05-10 14:00:00 | NQ | Futures | 19529.93 | 19541.7 | 19505.06 | 19534.75 | 33940.0 |
| 2024-05-10 15:00:00 | NQ | Futures | 19534.48 | 19550.26 | 19518.43 | 19532.07 | 46542.0 |
| 2024-05-10 16:00:00 | NQ | Futures | 19532.34 | 19533.41 | 19514.95 | 19516.29 | 8812.0 |
| 2024-05-10 00:00:00 | YM | Futures | 42009.4 | 42028.5 | 42009.4 | 42028.5 | 530.0 |
| 2024-05-10 01:00:00 | YM | Futures | 42027.5 | 42038.1 | 42021.1 | 42026.4 | 776.0 |
| 2024-05-10 02:00:00 | YM | Futures | 42026.4 | 42049.8 | 42023.2 | 42042.4 | 1447.0 |
| 2024-05-10 03:00:00 | YM | Futures | 42042.4 | 42077.4 | 42042.4 | 42070.0 | 1943.0 |
| 2024-05-10 04:00:00 | YM | Futures | 42068.9 | 42083.8 | 42032.8 | 42079.5 | 1878.0 |
| 2024-05-10 05:00:00 | YM | Futures | 42080.6 | 42118.8 | 42074.2 | 42098.6 | 1679.0 |
| 2024-05-10 06:00:00 | YM | Futures | 42099.7 | 42105.0 | 42085.9 | 42088.0 | 1130.0 |
| 2024-05-10 07:00:00 | YM | Futures | 42085.9 | 42096.5 | 42056.2 | 42060.4 | 1552.0 |
| 2024-05-10 08:00:00 | YM | Futures | 42062.5 | 42091.2 | 42049.8 | 42062.5 | 3304.0 |
| 2024-05-10 09:00:00 | YM | Futures | 42063.6 | 42168.7 | 42060.4 | 42144.3 | 15697.0 |
| 2024-05-10 10:00:00 | YM | Futures | 42141.1 | 42141.1 | 42015.8 | 42050.8 | 18973.0 |
| 2024-05-10 11:00:00 | YM | Futures | 42050.8 | 42062.5 | 41970.2 | 42024.3 | 10308.0 |
| 2024-05-10 12:00:00 | YM | Futures | 42025.4 | 42090.1 | 41999.9 | 42070.0 | 8276.0 |
| 2024-05-10 13:00:00 | YM | Futures | 42072.1 | 42075.3 | 42029.6 | 42068.9 | 6259.0 |
| 2024-05-10 14:00:00 | YM | Futures | 42068.9 | 42079.5 | 42016.9 | 42076.3 | 5598.0 |
| 2024-05-10 15:00:00 | YM | Futures | 42075.3 | 42123.0 | 42051.9 | 42081.6 | 11318.0 |
> showing 50 of 1,664 rows — these rows as CSV