PREVIEW / futures_1hour / 2024-07-21
file: by_date/futures_1hour/2024/2024-07-21.parquet size: 20 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-07-21 18:00:00 | ES | Futures | 5835.25 | 5836.29 | 5827.64 | 5835.25 | 14218.0 |
| 2024-07-21 19:00:00 | ES | Futures | 5835.25 | 5845.21 | 5835.25 | 5843.11 | 10630.0 |
| 2024-07-21 20:00:00 | ES | Futures | 5843.37 | 5844.16 | 5835.51 | 5842.32 | 10013.0 |
| 2024-07-21 21:00:00 | ES | Futures | 5842.32 | 5842.85 | 5826.07 | 5827.12 | 11309.0 |
| 2024-07-21 22:00:00 | ES | Futures | 5827.38 | 5831.05 | 5823.71 | 5829.22 | 8962.0 |
| 2024-07-21 23:00:00 | ES | Futures | 5829.48 | 5838.65 | 5829.22 | 5833.93 | 7561.0 |
| 2024-07-21 18:00:00 | NQ | Futures | 20853.56 | 20901.87 | 20830.6 | 20897.65 | 10495.0 |
| 2024-07-21 19:00:00 | NQ | Futures | 20897.65 | 20951.76 | 20896.33 | 20925.36 | 10049.0 |
| 2024-07-21 20:00:00 | NQ | Futures | 20925.1 | 20932.76 | 20872.04 | 20919.03 | 7174.0 |
| 2024-07-21 21:00:00 | NQ | Futures | 20918.24 | 20921.41 | 20837.46 | 20850.13 | 8583.0 |
| 2024-07-21 22:00:00 | NQ | Futures | 20850.39 | 20873.1 | 20821.62 | 20858.05 | 6713.0 |
| 2024-07-21 23:00:00 | NQ | Futures | 20858.31 | 20906.89 | 20855.94 | 20883.39 | 5633.0 |
| 2024-07-21 18:00:00 | YM | Futures | 42661.7 | 42675.3 | 42621.7 | 42668.0 | 1299.0 |
| 2024-07-21 19:00:00 | YM | Futures | 42668.0 | 42719.4 | 42668.0 | 42718.4 | 1061.0 |
| 2024-07-21 20:00:00 | YM | Futures | 42718.4 | 42722.6 | 42675.3 | 42695.3 | 1019.0 |
| 2024-07-21 21:00:00 | YM | Futures | 42696.3 | 42698.4 | 42604.9 | 42609.1 | 1204.0 |
| 2024-07-21 22:00:00 | YM | Futures | 42609.1 | 42641.7 | 42594.4 | 42634.3 | 1029.0 |
| 2024-07-21 23:00:00 | YM | Futures | 42634.3 | 42674.3 | 42634.3 | 42639.6 | 766.0 |
| 2024-07-21 18:00:00 | CL | Futures | 68.54 | 68.61 | 68.37 | 68.61 | 3669.0 |
| 2024-07-21 19:00:00 | CL | Futures | 68.6 | 68.65 | 68.51 | 68.61 | 1269.0 |
| 2024-07-21 20:00:00 | CL | Futures | 68.61 | 68.7 | 68.57 | 68.64 | 1876.0 |
| 2024-07-21 21:00:00 | CL | Futures | 68.64 | 68.69 | 68.42 | 68.43 | 3424.0 |
| 2024-07-21 22:00:00 | CL | Futures | 68.41 | 68.62 | 68.38 | 68.61 | 2410.0 |
| 2024-07-21 23:00:00 | CL | Futures | 68.61 | 68.7 | 68.58 | 68.67 | 1870.0 |
| 2024-07-21 18:00:00 | GC | Futures | 2581.2 | 2591.4 | 2579.9 | 2591.0 | 4630.0 |
| 2024-07-21 19:00:00 | GC | Futures | 2591.0 | 2591.9 | 2588.6 | 2591.5 | 2307.0 |
| 2024-07-21 20:00:00 | GC | Futures | 2591.6 | 2591.6 | 2586.6 | 2587.8 | 2956.0 |
| 2024-07-21 21:00:00 | GC | Futures | 2587.6 | 2592.7 | 2585.5 | 2586.4 | 5217.0 |
| 2024-07-21 22:00:00 | GC | Futures | 2586.2 | 2588.0 | 2582.7 | 2586.2 | 3739.0 |
| 2024-07-21 23:00:00 | GC | Futures | 2586.0 | 2589.3 | 2585.3 | 2586.1 | 2158.0 |
| 2024-07-21 18:00:00 | ZN | Futures | 111.548951 | 111.548951 | 111.438973 | 111.533239 | 16260.0 |
| 2024-07-21 19:00:00 | ZN | Futures | 111.517528 | 111.564662 | 111.501817 | 111.564662 | 11509.0 |
| 2024-07-21 20:00:00 | ZN | Futures | 111.548951 | 111.564662 | 111.501817 | 111.501817 | 10241.0 |
| 2024-07-21 21:00:00 | ZN | Futures | 111.501817 | 111.517528 | 111.454684 | 111.486106 | 13252.0 |
| 2024-07-21 22:00:00 | ZN | Futures | 111.486106 | 111.517528 | 111.454684 | 111.501817 | 7021.0 |
| 2024-07-21 23:00:00 | ZN | Futures | 111.501817 | 111.533239 | 111.486106 | 111.517528 | 4791.0 |
> showing 36 of 429 rows — these rows as CSV