PREVIEW / futures_1hour / 2024-03-17
file: by_date/futures_1hour/2024/2024-03-17.parquet size: 19 KB rows: 429
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-17 18:00:00 | ES | Futures | 5503.03 | 5509.13 | 5499.58 | 5502.5 | 6824.0 |
| 2024-03-17 19:00:00 | ES | Futures | 5502.76 | 5504.62 | 5500.11 | 5503.03 | 5138.0 |
| 2024-03-17 20:00:00 | ES | Futures | 5503.03 | 5504.36 | 5498.78 | 5503.56 | 6645.0 |
| 2024-03-17 21:00:00 | ES | Futures | 5503.56 | 5508.6 | 5502.76 | 5507.8 | 6677.0 |
| 2024-03-17 22:00:00 | ES | Futures | 5507.8 | 5510.99 | 5507.01 | 5509.93 | 5354.0 |
| 2024-03-17 23:00:00 | ES | Futures | 5510.19 | 5512.58 | 5509.66 | 5511.78 | 4358.0 |
| 2024-03-17 18:00:00 | NQ | Futures | 19338.94 | 19370.5 | 19326.9 | 19336.26 | 5599.0 |
| 2024-03-17 19:00:00 | NQ | Futures | 19336.8 | 19354.99 | 19327.7 | 19345.09 | 3948.0 |
| 2024-03-17 20:00:00 | NQ | Futures | 19344.82 | 19360.34 | 19328.24 | 19356.32 | 3588.0 |
| 2024-03-17 21:00:00 | NQ | Futures | 19355.25 | 19380.93 | 19351.24 | 19377.46 | 4496.0 |
| 2024-03-17 22:00:00 | NQ | Futures | 19378.53 | 19392.97 | 19373.98 | 19388.42 | 3856.0 |
| 2024-03-17 23:00:00 | NQ | Futures | 19388.69 | 19396.18 | 19384.68 | 19394.31 | 2928.0 |
| 2024-03-17 18:00:00 | YM | Futures | 41554.0 | 41575.2 | 41533.8 | 41543.4 | 1627.0 |
| 2024-03-17 19:00:00 | YM | Futures | 41543.4 | 41548.7 | 41527.4 | 41540.2 | 628.0 |
| 2024-03-17 20:00:00 | YM | Futures | 41540.2 | 41546.5 | 41513.6 | 41542.3 | 868.0 |
| 2024-03-17 21:00:00 | YM | Futures | 41541.2 | 41567.8 | 41533.8 | 41563.5 | 877.0 |
| 2024-03-17 22:00:00 | YM | Futures | 41562.5 | 41577.3 | 41558.2 | 41573.1 | 576.0 |
| 2024-03-17 23:00:00 | YM | Futures | 41574.1 | 41592.2 | 41573.1 | 41581.6 | 675.0 |
| 2024-03-17 18:00:00 | CL | Futures | 67.8 | 67.95 | 67.79 | 67.88 | 1465.0 |
| 2024-03-17 19:00:00 | CL | Futures | 67.89 | 67.9 | 67.81 | 67.82 | 613.0 |
| 2024-03-17 20:00:00 | CL | Futures | 67.82 | 67.93 | 67.79 | 67.88 | 1492.0 |
| 2024-03-17 21:00:00 | CL | Futures | 67.88 | 68.1 | 67.78 | 68.03 | 3092.0 |
| 2024-03-17 22:00:00 | CL | Futures | 68.03 | 68.12 | 68.01 | 68.05 | 1973.0 |
| 2024-03-17 23:00:00 | CL | Futures | 68.04 | 68.11 | 68.02 | 68.09 | 742.0 |
| 2024-03-17 18:00:00 | GC | Futures | 2367.4 | 2367.4 | 2362.1 | 2365.5 | 5906.0 |
| 2024-03-17 19:00:00 | GC | Futures | 2365.4 | 2367.7 | 2364.2 | 2367.2 | 2762.0 |
| 2024-03-17 20:00:00 | GC | Futures | 2367.2 | 2368.4 | 2365.5 | 2367.4 | 4279.0 |
| 2024-03-17 21:00:00 | GC | Futures | 2367.4 | 2367.4 | 2360.1 | 2362.7 | 14531.0 |
| 2024-03-17 22:00:00 | GC | Futures | 2362.7 | 2363.9 | 2355.9 | 2357.7 | 11691.0 |
| 2024-03-17 23:00:00 | GC | Futures | 2357.7 | 2357.9 | 2355.8 | 2356.4 | 4320.0 |
| 2024-03-17 18:00:00 | ZN | Futures | 110.891464 | 110.922959 | 110.828476 | 110.907211 | 13493.0 |
| 2024-03-17 19:00:00 | ZN | Futures | 110.907211 | 110.922959 | 110.875717 | 110.922959 | 4308.0 |
| 2024-03-17 20:00:00 | ZN | Futures | 110.907211 | 110.922959 | 110.812729 | 110.907211 | 16504.0 |
| 2024-03-17 21:00:00 | ZN | Futures | 110.907211 | 110.985947 | 110.875717 | 110.985947 | 9127.0 |
| 2024-03-17 22:00:00 | ZN | Futures | 110.9702 | 111.001694 | 110.954453 | 110.954453 | 7867.0 |
| 2024-03-17 23:00:00 | ZN | Futures | 110.954453 | 110.9702 | 110.907211 | 110.907211 | 9251.0 |
> showing 36 of 429 rows — these rows as CSV