PREVIEW / futures_1hour / 2024-03-24
file: by_date/futures_1hour/2024/2024-03-24.parquet size: 19 KB rows: 424
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-03-24 18:00:00 | ES | Futures | 5614.19 | 5617.11 | 5610.74 | 5613.13 | 6210.0 |
| 2024-03-24 19:00:00 | ES | Futures | 5612.86 | 5617.11 | 5611.0 | 5616.84 | 9632.0 |
| 2024-03-24 20:00:00 | ES | Futures | 5616.84 | 5618.7 | 5614.98 | 5615.51 | 8113.0 |
| 2024-03-24 21:00:00 | ES | Futures | 5615.51 | 5618.96 | 5613.92 | 5617.11 | 16083.0 |
| 2024-03-24 22:00:00 | ES | Futures | 5617.11 | 5617.11 | 5611.0 | 5613.92 | 7237.0 |
| 2024-03-24 23:00:00 | ES | Futures | 5614.19 | 5614.19 | 5611.53 | 5613.39 | 3140.0 |
| 2024-03-24 18:00:00 | NQ | Futures | 19866.99 | 19885.71 | 19851.74 | 19860.84 | 4551.0 |
| 2024-03-24 19:00:00 | NQ | Futures | 19860.3 | 19889.46 | 19855.49 | 19886.78 | 3254.0 |
| 2024-03-24 20:00:00 | NQ | Futures | 19887.59 | 19899.62 | 19882.5 | 19884.91 | 3581.0 |
| 2024-03-24 21:00:00 | NQ | Futures | 19885.18 | 19903.64 | 19878.22 | 19892.67 | 4231.0 |
| 2024-03-24 22:00:00 | NQ | Futures | 19892.4 | 19892.94 | 19865.65 | 19878.22 | 4070.0 |
| 2024-03-24 23:00:00 | NQ | Futures | 19877.96 | 19878.22 | 19866.99 | 19876.89 | 2382.0 |
| 2024-03-24 18:00:00 | YM | Futures | 42306.7 | 42309.9 | 42262.1 | 42291.9 | 1549.0 |
| 2024-03-24 19:00:00 | YM | Futures | 42289.7 | 42302.5 | 42280.2 | 42298.2 | 876.0 |
| 2024-03-24 20:00:00 | YM | Futures | 42299.3 | 42305.7 | 42282.3 | 42286.5 | 918.0 |
| 2024-03-24 21:00:00 | YM | Futures | 42285.5 | 42301.4 | 42272.7 | 42286.5 | 1220.0 |
| 2024-03-24 22:00:00 | YM | Futures | 42286.5 | 42288.7 | 42258.9 | 42272.7 | 641.0 |
| 2024-03-24 23:00:00 | YM | Futures | 42272.7 | 42273.8 | 42252.6 | 42267.4 | 415.0 |
| 2024-03-24 18:00:00 | CL | Futures | 68.03 | 68.09 | 67.81 | 67.99 | 2156.0 |
| 2024-03-24 19:00:00 | CL | Futures | 67.98 | 68.07 | 67.97 | 68.06 | 748.0 |
| 2024-03-24 20:00:00 | CL | Futures | 68.05 | 68.13 | 68.02 | 68.09 | 1026.0 |
| 2024-03-24 21:00:00 | CL | Futures | 68.09 | 68.3 | 68.09 | 68.28 | 3007.0 |
| 2024-03-24 22:00:00 | CL | Futures | 68.27 | 68.35 | 68.25 | 68.32 | 1406.0 |
| 2024-03-24 23:00:00 | CL | Futures | 68.32 | 68.39 | 68.26 | 68.31 | 1514.0 |
| 2024-03-24 18:00:00 | GC | Futures | 2374.7 | 2377.3 | 2374.4 | 2375.9 | 2121.0 |
| 2024-03-24 19:00:00 | GC | Futures | 2375.8 | 2378.5 | 2375.3 | 2377.8 | 3843.0 |
| 2024-03-24 20:00:00 | GC | Futures | 2377.9 | 2379.0 | 2373.2 | 2374.9 | 6070.0 |
| 2024-03-24 21:00:00 | GC | Futures | 2374.8 | 2387.1 | 2373.0 | 2385.3 | 19594.0 |
| 2024-03-24 22:00:00 | GC | Futures | 2385.3 | 2388.9 | 2383.8 | 2385.5 | 3778.0 |
| 2024-03-24 23:00:00 | GC | Futures | 2385.2 | 2385.2 | 2379.8 | 2380.2 | 3312.0 |
| 2024-03-24 18:00:00 | ZN | Futures | 111.726063 | 111.804799 | 111.710316 | 111.741811 | 19892.0 |
| 2024-03-24 19:00:00 | ZN | Futures | 111.741811 | 111.773305 | 111.726063 | 111.757558 | 8766.0 |
| 2024-03-24 20:00:00 | ZN | Futures | 111.741811 | 111.789052 | 111.741811 | 111.773305 | 12642.0 |
| 2024-03-24 21:00:00 | ZN | Futures | 111.773305 | 111.804799 | 111.647328 | 111.663075 | 31369.0 |
| 2024-03-24 22:00:00 | ZN | Futures | 111.663075 | 111.678822 | 111.631581 | 111.647328 | 12415.0 |
| 2024-03-24 23:00:00 | ZN | Futures | 111.663075 | 111.694569 | 111.647328 | 111.678822 | 8138.0 |
> showing 36 of 424 rows — these rows as CSV