PREVIEW / futures_1hour / 2024-03-31
file: by_date/futures_1hour/2024/2024-03-31.parquet size: 18 KB rows: 378
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-31 18:00:00 | ES | Futures | 5639.39 | 5652.66 | 5637.0 | 5651.86 | 13776.0 |
| 2024-03-31 19:00:00 | ES | Futures | 5651.86 | 5659.82 | 5651.59 | 5658.76 | 9893.0 |
| 2024-03-31 20:00:00 | ES | Futures | 5658.49 | 5658.76 | 5653.19 | 5655.04 | 11139.0 |
| 2024-03-31 21:00:00 | ES | Futures | 5654.78 | 5655.84 | 5652.66 | 5652.92 | 5085.0 |
| 2024-03-31 22:00:00 | ES | Futures | 5653.19 | 5653.19 | 5650.8 | 5652.66 | 5536.0 |
| 2024-03-31 23:00:00 | ES | Futures | 5652.39 | 5654.51 | 5651.06 | 5654.25 | 3412.0 |
| 2024-03-31 18:00:00 | NQ | Futures | 19798.51 | 19887.59 | 19795.83 | 19872.34 | 9783.0 |
| 2024-03-31 19:00:00 | NQ | Futures | 19872.07 | 19915.14 | 19871.54 | 19911.39 | 6587.0 |
| 2024-03-31 20:00:00 | NQ | Futures | 19911.66 | 19914.07 | 19891.33 | 19895.88 | 5626.0 |
| 2024-03-31 21:00:00 | NQ | Futures | 19897.48 | 19898.82 | 19885.45 | 19886.78 | 3837.0 |
| 2024-03-31 22:00:00 | NQ | Futures | 19887.32 | 19888.39 | 19866.72 | 19873.41 | 4515.0 |
| 2024-03-31 23:00:00 | NQ | Futures | 19873.41 | 19887.05 | 19862.98 | 19885.71 | 4196.0 |
| 2024-03-31 18:00:00 | YM | Futures | 42635.8 | 42770.7 | 42635.8 | 42769.6 | 2193.0 |
| 2024-03-31 19:00:00 | YM | Futures | 42770.7 | 42848.2 | 42770.7 | 42835.4 | 2257.0 |
| 2024-03-31 20:00:00 | YM | Futures | 42834.4 | 42836.5 | 42790.9 | 42804.7 | 1445.0 |
| 2024-03-31 21:00:00 | YM | Futures | 42802.5 | 42805.7 | 42778.1 | 42780.2 | 578.0 |
| 2024-03-31 22:00:00 | YM | Futures | 42780.2 | 42781.3 | 42769.6 | 42779.2 | 503.0 |
| 2024-03-31 23:00:00 | YM | Futures | 42779.2 | 42803.6 | 42772.8 | 42803.6 | 641.0 |
| 2024-03-31 18:00:00 | CL | Futures | 69.95 | 70.14 | 69.89 | 69.94 | 3025.0 |
| 2024-03-31 19:00:00 | CL | Futures | 69.94 | 70.0 | 69.89 | 69.99 | 1006.0 |
| 2024-03-31 20:00:00 | CL | Futures | 69.99 | 70.0 | 69.81 | 69.81 | 1624.0 |
| 2024-03-31 21:00:00 | CL | Futures | 69.82 | 70.24 | 69.82 | 70.21 | 3961.0 |
| 2024-03-31 22:00:00 | CL | Futures | 70.21 | 70.29 | 70.15 | 70.26 | 2408.0 |
| 2024-03-31 23:00:00 | CL | Futures | 70.25 | 70.27 | 70.23 | 70.25 | 1040.0 |
| 2024-03-31 18:00:00 | GC | Futures | 2451.6 | 2459.0 | 2447.6 | 2449.5 | 9462.0 |
| 2024-03-31 19:00:00 | GC | Futures | 2449.6 | 2460.9 | 2448.1 | 2459.2 | 5359.0 |
| 2024-03-31 20:00:00 | GC | Futures | 2459.4 | 2470.7 | 2457.0 | 2463.8 | 9520.0 |
| 2024-03-31 21:00:00 | GC | Futures | 2463.8 | 2474.2 | 2463.8 | 2470.1 | 12938.0 |
| 2024-03-31 22:00:00 | GC | Futures | 2470.3 | 2473.1 | 2469.2 | 2471.9 | 3127.0 |
| 2024-03-31 23:00:00 | GC | Futures | 2471.8 | 2480.6 | 2470.9 | 2479.8 | 6702.0 |
| 2024-03-31 18:00:00 | ZN | Futures | 111.663075 | 111.757558 | 111.631581 | 111.694569 | 22734.0 |
| 2024-03-31 19:00:00 | ZN | Futures | 111.710316 | 111.726063 | 111.678822 | 111.694569 | 7255.0 |
| 2024-03-31 20:00:00 | ZN | Futures | 111.710316 | 111.741811 | 111.600086 | 111.631581 | 21472.0 |
| 2024-03-31 21:00:00 | ZN | Futures | 111.615833 | 111.631581 | 111.600086 | 111.615833 | 10259.0 |
| 2024-03-31 22:00:00 | ZN | Futures | 111.615833 | 111.678822 | 111.615833 | 111.647328 | 6544.0 |
| 2024-03-31 23:00:00 | ZN | Futures | 111.647328 | 111.678822 | 111.631581 | 111.678822 | 6761.0 |
> showing 36 of 378 rows — these rows as CSV