PREVIEW / futures_1hour / 2024-07-14
file: by_date/futures_1hour/2024/2024-07-14.parquet size: 19 KB rows: 417
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-07-14 18:00:00 | ES | Futures | 5957.41 | 5959.77 | 5941.16 | 5945.88 | 17583.0 |
| 2024-07-14 19:00:00 | ES | Futures | 5945.88 | 5948.24 | 5942.73 | 5947.98 | 3741.0 |
| 2024-07-14 20:00:00 | ES | Futures | 5948.24 | 5951.65 | 5945.09 | 5950.6 | 7099.0 |
| 2024-07-14 21:00:00 | ES | Futures | 5950.6 | 5951.91 | 5949.55 | 5951.12 | 4603.0 |
| 2024-07-14 22:00:00 | ES | Futures | 5951.12 | 5952.43 | 5948.76 | 5950.6 | 5680.0 |
| 2024-07-14 23:00:00 | ES | Futures | 5950.34 | 5952.17 | 5949.81 | 5951.38 | 2994.0 |
| 2024-07-14 18:00:00 | NQ | Futures | 21731.04 | 21741.6 | 21655.01 | 21692.5 | 10276.0 |
| 2024-07-14 19:00:00 | NQ | Futures | 21692.23 | 21710.98 | 21677.45 | 21709.92 | 4031.0 |
| 2024-07-14 20:00:00 | NQ | Futures | 21710.71 | 21728.66 | 21698.04 | 21720.48 | 3799.0 |
| 2024-07-14 21:00:00 | NQ | Futures | 21720.74 | 21732.1 | 21717.84 | 21725.5 | 2903.0 |
| 2024-07-14 22:00:00 | NQ | Futures | 21725.76 | 21732.62 | 21709.92 | 21723.65 | 5687.0 |
| 2024-07-14 23:00:00 | NQ | Futures | 21722.59 | 21731.04 | 21719.95 | 21726.55 | 1481.0 |
| 2024-07-14 18:00:00 | YM | Futures | 42438.9 | 42468.3 | 42384.3 | 42407.4 | 2154.0 |
| 2024-07-14 19:00:00 | YM | Futures | 42408.4 | 42413.7 | 42384.3 | 42410.5 | 653.0 |
| 2024-07-14 20:00:00 | YM | Futures | 42409.5 | 42428.4 | 42385.3 | 42415.8 | 759.0 |
| 2024-07-14 21:00:00 | YM | Futures | 42416.8 | 42422.1 | 42408.4 | 42420.0 | 737.0 |
| 2024-07-14 22:00:00 | YM | Futures | 42417.9 | 42426.3 | 42408.4 | 42417.9 | 696.0 |
| 2024-07-14 23:00:00 | YM | Futures | 42417.9 | 42428.4 | 42413.7 | 42416.8 | 395.0 |
| 2024-07-14 18:00:00 | CL | Futures | 70.28 | 70.62 | 70.17 | 70.46 | 620.0 |
| 2024-07-14 19:00:00 | CL | Futures | 70.45 | 70.49 | 70.35 | 70.35 | 277.0 |
| 2024-07-14 20:00:00 | CL | Futures | 70.35 | 70.35 | 69.95 | 69.96 | 1235.0 |
| 2024-07-14 21:00:00 | CL | Futures | 69.95 | 70.49 | 69.83 | 70.43 | 1581.0 |
| 2024-07-14 22:00:00 | CL | Futures | 70.43 | 70.46 | 70.34 | 70.41 | 604.0 |
| 2024-07-14 23:00:00 | CL | Futures | 70.41 | 70.47 | 70.38 | 70.46 | 193.0 |
| 2024-07-14 18:00:00 | GC | Futures | 2598.0 | 2598.7 | 2589.4 | 2590.1 | 3345.0 |
| 2024-07-14 19:00:00 | GC | Futures | 2590.1 | 2591.5 | 2588.1 | 2591.4 | 1618.0 |
| 2024-07-14 20:00:00 | GC | Futures | 2591.4 | 2591.9 | 2589.0 | 2591.4 | 2425.0 |
| 2024-07-14 21:00:00 | GC | Futures | 2591.5 | 2593.6 | 2587.5 | 2593.2 | 3272.0 |
| 2024-07-14 22:00:00 | GC | Futures | 2593.3 | 2594.1 | 2591.1 | 2592.3 | 2508.0 |
| 2024-07-14 23:00:00 | GC | Futures | 2592.3 | 2595.3 | 2591.3 | 2594.8 | 1248.0 |
| 2024-07-14 18:00:00 | ZN | Futures | 111.611795 | 111.611795 | 111.376128 | 111.486106 | 85525.0 |
| 2024-07-14 19:00:00 | ZN | Futures | 111.486106 | 111.501817 | 111.423262 | 111.486106 | 12608.0 |
| 2024-07-14 20:00:00 | ZN | Futures | 111.501817 | 111.548951 | 111.470395 | 111.517528 | 17999.0 |
| 2024-07-14 21:00:00 | ZN | Futures | 111.517528 | 111.517528 | 111.470395 | 111.470395 | 16467.0 |
| 2024-07-14 22:00:00 | ZN | Futures | 111.470395 | 111.517528 | 111.470395 | 111.486106 | 5717.0 |
| 2024-07-14 23:00:00 | ZN | Futures | 111.501817 | 111.517528 | 111.486106 | 111.501817 | 2595.0 |
> showing 36 of 417 rows — these rows as CSV