PREVIEW / futures_1hour / 2025-05-04
file: by_date/futures_1hour/2025/2025-05-04.parquet size: 20 KB rows: 448
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 |
|---|---|---|---|---|---|---|---|
| 2025-05-04 18:00:00 | ES | Futures | 5797.19 | 5797.45 | 5776.87 | 5778.9 | 8989.0 |
| 2025-05-04 19:00:00 | ES | Futures | 5778.65 | 5781.44 | 5762.64 | 5769.76 | 9500.0 |
| 2025-05-04 20:00:00 | ES | Futures | 5770.01 | 5774.84 | 5767.47 | 5772.81 | 6193.0 |
| 2025-05-04 21:00:00 | ES | Futures | 5772.81 | 5772.81 | 5751.72 | 5753.5 | 10181.0 |
| 2025-05-04 22:00:00 | ES | Futures | 5753.24 | 5761.63 | 5751.97 | 5759.09 | 5840.0 |
| 2025-05-04 23:00:00 | ES | Futures | 5759.09 | 5764.68 | 5754.26 | 5761.63 | 7113.0 |
| 2025-05-04 18:00:00 | NQ | Futures | 20557.1 | 20577.73 | 20482.49 | 20489.36 | 5957.0 |
| 2025-05-04 19:00:00 | NQ | Futures | 20488.09 | 20496.75 | 20425.7 | 20458.8 | 7089.0 |
| 2025-05-04 20:00:00 | NQ | Futures | 20458.55 | 20485.8 | 20441.23 | 20478.16 | 5959.0 |
| 2025-05-04 21:00:00 | NQ | Futures | 20476.63 | 20477.14 | 20363.56 | 20376.3 | 9382.0 |
| 2025-05-04 22:00:00 | NQ | Futures | 20376.04 | 20423.41 | 20367.38 | 20408.13 | 5342.0 |
| 2025-05-04 23:00:00 | NQ | Futures | 20408.13 | 20447.35 | 20394.38 | 20430.03 | 5059.0 |
| 2025-05-04 18:00:00 | YM | Futures | 42612.7 | 42612.7 | 42487.1 | 42507.7 | 916.0 |
| 2025-05-04 19:00:00 | YM | Futures | 42505.6 | 42519.0 | 42386.3 | 42434.6 | 1108.0 |
| 2025-05-04 20:00:00 | YM | Futures | 42433.6 | 42453.2 | 42419.2 | 42428.5 | 853.0 |
| 2025-05-04 21:00:00 | YM | Futures | 42427.4 | 42430.5 | 42324.5 | 42331.7 | 1456.0 |
| 2025-05-04 22:00:00 | YM | Futures | 42329.7 | 42366.7 | 42325.5 | 42349.2 | 556.0 |
| 2025-05-04 23:00:00 | YM | Futures | 42354.4 | 42376.0 | 42320.4 | 42361.6 | 765.0 |
| 2025-05-04 18:00:00 | CL | Futures | 53.01 | 53.03 | 51.64 | 52.52 | 19820.0 |
| 2025-05-04 19:00:00 | CL | Futures | 52.51 | 52.81 | 52.15 | 52.23 | 4807.0 |
| 2025-05-04 20:00:00 | CL | Futures | 52.22 | 52.59 | 52.11 | 52.34 | 3774.0 |
| 2025-05-04 21:00:00 | CL | Futures | 52.35 | 52.64 | 52.21 | 52.45 | 3746.0 |
| 2025-05-04 22:00:00 | CL | Futures | 52.45 | 52.56 | 52.3 | 52.35 | 1770.0 |
| 2025-05-04 23:00:00 | CL | Futures | 52.35 | 52.42 | 52.21 | 52.36 | 1955.0 |
| 2025-05-04 18:00:00 | GC | Futures | 3354.4 | 3358.8 | 3350.3 | 3353.5 | 3592.0 |
| 2025-05-04 19:00:00 | GC | Futures | 3353.7 | 3367.2 | 3352.7 | 3362.8 | 4936.0 |
| 2025-05-04 20:00:00 | GC | Futures | 3362.9 | 3363.6 | 3355.4 | 3360.7 | 3326.0 |
| 2025-05-04 21:00:00 | GC | Futures | 3361.4 | 3386.7 | 3360.6 | 3380.3 | 9874.0 |
| 2025-05-04 22:00:00 | GC | Futures | 3380.3 | 3389.0 | 3375.4 | 3386.6 | 6856.0 |
| 2025-05-04 23:00:00 | GC | Futures | 3386.6 | 3388.2 | 3368.7 | 3370.7 | 5944.0 |
| 2025-05-04 18:00:00 | ZN | Futures | 111.281152 | 111.390558 | 111.281152 | 111.32804 | 12202.0 |
| 2025-05-04 19:00:00 | ZN | Futures | 111.34367 | 111.437446 | 111.312411 | 111.421817 | 11691.0 |
| 2025-05-04 20:00:00 | ZN | Futures | 111.406187 | 111.453075 | 111.374928 | 111.374928 | 10914.0 |
| 2025-05-04 21:00:00 | ZN | Futures | 111.374928 | 111.406187 | 111.249893 | 111.265523 | 15442.0 |
| 2025-05-04 22:00:00 | ZN | Futures | 111.249893 | 111.32804 | 111.234264 | 111.312411 | 9029.0 |
| 2025-05-04 23:00:00 | ZN | Futures | 111.32804 | 111.32804 | 111.265523 | 111.281152 | 3669.0 |
> showing 36 of 448 rows — these rows as CSV