PREVIEW / futures_1hour / 2024-04-14
file: by_date/futures_1hour/2024/2024-04-14.parquet size: 20 KB rows: 431
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-04-14 18:00:00 | ES | Futures | 5482.6 | 5504.89 | 5480.21 | 5499.31 | 35945.0 |
| 2024-04-14 19:00:00 | ES | Futures | 5499.05 | 5505.15 | 5497.46 | 5500.11 | 15765.0 |
| 2024-04-14 20:00:00 | ES | Futures | 5500.38 | 5502.23 | 5487.64 | 5496.93 | 21609.0 |
| 2024-04-14 21:00:00 | ES | Futures | 5496.66 | 5497.46 | 5488.7 | 5495.34 | 13698.0 |
| 2024-04-14 22:00:00 | ES | Futures | 5495.07 | 5498.25 | 5494.54 | 5494.8 | 10796.0 |
| 2024-04-14 23:00:00 | ES | Futures | 5495.07 | 5500.38 | 5492.42 | 5497.99 | 6997.0 |
| 2024-04-14 18:00:00 | NQ | Futures | 19421.86 | 19520.04 | 19417.31 | 19497.57 | 15626.0 |
| 2024-04-14 19:00:00 | NQ | Futures | 19497.3 | 19533.14 | 19496.5 | 19514.42 | 6506.0 |
| 2024-04-14 20:00:00 | NQ | Futures | 19514.42 | 19524.58 | 19466.27 | 19499.17 | 9740.0 |
| 2024-04-14 21:00:00 | NQ | Futures | 19499.71 | 19504.25 | 19468.41 | 19498.1 | 5916.0 |
| 2024-04-14 22:00:00 | NQ | Futures | 19498.1 | 19509.87 | 19495.96 | 19495.96 | 3013.0 |
| 2024-04-14 23:00:00 | NQ | Futures | 19497.03 | 19520.3 | 19487.13 | 19507.2 | 3693.0 |
| 2024-04-14 18:00:00 | YM | Futures | 40503.9 | 40731.1 | 40502.9 | 40688.7 | 3901.0 |
| 2024-04-14 19:00:00 | YM | Futures | 40688.7 | 40723.7 | 40681.2 | 40695.1 | 1148.0 |
| 2024-04-14 20:00:00 | YM | Futures | 40695.1 | 40712.0 | 40621.8 | 40675.9 | 1866.0 |
| 2024-04-14 21:00:00 | YM | Futures | 40680.2 | 40682.3 | 40619.7 | 40671.7 | 1226.0 |
| 2024-04-14 22:00:00 | YM | Futures | 40670.6 | 40688.7 | 40663.2 | 40664.3 | 893.0 |
| 2024-04-14 23:00:00 | YM | Futures | 40664.3 | 40694.0 | 40650.5 | 40684.4 | 748.0 |
| 2024-04-14 18:00:00 | CL | Futures | 71.9 | 72.33 | 71.63 | 71.76 | 3789.0 |
| 2024-04-14 19:00:00 | CL | Futures | 71.75 | 72.01 | 71.73 | 71.94 | 806.0 |
| 2024-04-14 20:00:00 | CL | Futures | 71.93 | 72.08 | 71.63 | 71.78 | 1463.0 |
| 2024-04-14 21:00:00 | CL | Futures | 71.8 | 71.89 | 71.36 | 71.82 | 2324.0 |
| 2024-04-14 22:00:00 | CL | Futures | 71.81 | 71.85 | 71.61 | 71.67 | 516.0 |
| 2024-04-14 23:00:00 | CL | Futures | 71.69 | 71.8 | 71.63 | 71.77 | 426.0 |
| 2024-04-14 18:00:00 | GC | Futures | 2571.2 | 2593.1 | 2564.2 | 2575.1 | 21014.0 |
| 2024-04-14 19:00:00 | GC | Futures | 2574.9 | 2585.0 | 2572.8 | 2584.0 | 5253.0 |
| 2024-04-14 20:00:00 | GC | Futures | 2584.0 | 2585.3 | 2567.9 | 2570.7 | 10866.0 |
| 2024-04-14 21:00:00 | GC | Futures | 2571.1 | 2577.9 | 2565.5 | 2573.8 | 13398.0 |
| 2024-04-14 22:00:00 | GC | Futures | 2573.8 | 2583.8 | 2571.2 | 2578.2 | 8360.0 |
| 2024-04-14 23:00:00 | GC | Futures | 2578.4 | 2579.0 | 2573.0 | 2576.8 | 4866.0 |
| 2024-04-14 18:00:00 | ZN | Futures | 109.521462 | 109.537209 | 109.238013 | 109.25376 | 60945.0 |
| 2024-04-14 19:00:00 | ZN | Futures | 109.25376 | 109.36399 | 109.222266 | 109.332496 | 24854.0 |
| 2024-04-14 20:00:00 | ZN | Futures | 109.332496 | 109.426979 | 109.269507 | 109.332496 | 29878.0 |
| 2024-04-14 21:00:00 | ZN | Futures | 109.332496 | 109.395485 | 109.269507 | 109.269507 | 20816.0 |
| 2024-04-14 22:00:00 | ZN | Futures | 109.269507 | 109.332496 | 109.206519 | 109.206519 | 17569.0 |
| 2024-04-14 23:00:00 | ZN | Futures | 109.206519 | 109.222266 | 109.175024 | 109.190772 | 13061.0 |
> showing 36 of 431 rows — these rows as CSV