PREVIEW / futures_1hour / 2024-06-16
file: by_date/futures_1hour/2024/2024-06-16.parquet size: 18 KB rows: 415
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-06-16 18:00:00 | ES | Futures | 5767.61 | 5772.06 | 5764.2 | 5772.06 | 3190.0 |
| 2024-06-16 19:00:00 | ES | Futures | 5771.8 | 5772.33 | 5768.66 | 5769.44 | 2161.0 |
| 2024-06-16 20:00:00 | ES | Futures | 5769.7 | 5770.75 | 5767.61 | 5768.39 | 3481.0 |
| 2024-06-16 21:00:00 | ES | Futures | 5768.66 | 5768.66 | 5764.72 | 5767.61 | 2838.0 |
| 2024-06-16 22:00:00 | ES | Futures | 5767.61 | 5769.18 | 5766.3 | 5766.82 | 2304.0 |
| 2024-06-16 23:00:00 | ES | Futures | 5766.82 | 5769.7 | 5766.82 | 5768.13 | 1544.0 |
| 2024-06-16 18:00:00 | NQ | Futures | 21070.82 | 21100.12 | 21044.95 | 21096.43 | 3313.0 |
| 2024-06-16 19:00:00 | NQ | Futures | 21096.43 | 21104.08 | 21083.49 | 21089.03 | 1686.0 |
| 2024-06-16 20:00:00 | NQ | Futures | 21089.56 | 21095.63 | 21074.78 | 21076.1 | 2158.0 |
| 2024-06-16 21:00:00 | NQ | Futures | 21076.1 | 21079.27 | 21061.84 | 21077.15 | 2109.0 |
| 2024-06-16 22:00:00 | NQ | Futures | 21077.15 | 21082.96 | 21070.56 | 21075.83 | 1740.0 |
| 2024-06-16 23:00:00 | NQ | Futures | 21076.36 | 21083.75 | 21073.72 | 21077.15 | 1060.0 |
| 2024-06-16 18:00:00 | YM | Futures | 40967.9 | 40989.1 | 40958.4 | 40988.1 | 355.0 |
| 2024-06-16 19:00:00 | YM | Futures | 40990.2 | 40991.3 | 40965.8 | 40971.1 | 127.0 |
| 2024-06-16 20:00:00 | YM | Futures | 40974.3 | 40980.6 | 40963.7 | 40965.8 | 299.0 |
| 2024-06-16 21:00:00 | YM | Futures | 40963.7 | 40963.7 | 40928.6 | 40947.7 | 388.0 |
| 2024-06-16 22:00:00 | YM | Futures | 40946.7 | 40962.6 | 40941.4 | 40943.5 | 247.0 |
| 2024-06-16 23:00:00 | YM | Futures | 40944.6 | 40969.0 | 40944.6 | 40964.7 | 220.0 |
| 2024-06-16 18:00:00 | CL | Futures | 66.81 | 66.81 | 66.63 | 66.75 | 2348.0 |
| 2024-06-16 19:00:00 | CL | Futures | 66.75 | 66.75 | 66.6 | 66.6 | 744.0 |
| 2024-06-16 20:00:00 | CL | Futures | 66.61 | 66.69 | 66.56 | 66.63 | 1685.0 |
| 2024-06-16 21:00:00 | CL | Futures | 66.63 | 66.65 | 66.44 | 66.64 | 2885.0 |
| 2024-06-16 22:00:00 | CL | Futures | 66.65 | 66.65 | 66.56 | 66.57 | 959.0 |
| 2024-06-16 23:00:00 | CL | Futures | 66.56 | 66.59 | 66.48 | 66.52 | 1212.0 |
| 2024-06-16 18:00:00 | GC | Futures | 2521.9 | 2522.1 | 2515.7 | 2517.1 | 2050.0 |
| 2024-06-16 19:00:00 | GC | Futures | 2517.1 | 2517.8 | 2515.4 | 2516.9 | 1613.0 |
| 2024-06-16 20:00:00 | GC | Futures | 2516.7 | 2516.8 | 2512.8 | 2514.2 | 2258.0 |
| 2024-06-16 21:00:00 | GC | Futures | 2514.3 | 2517.0 | 2509.7 | 2514.1 | 5730.0 |
| 2024-06-16 22:00:00 | GC | Futures | 2513.9 | 2513.9 | 2508.7 | 2510.0 | 3796.0 |
| 2024-06-16 23:00:00 | GC | Futures | 2510.0 | 2513.0 | 2509.0 | 2511.9 | 2388.0 |
| 2024-06-16 18:00:00 | ZN | Futures | 111.344706 | 111.360417 | 111.187595 | 111.203306 | 17017.0 |
| 2024-06-16 19:00:00 | ZN | Futures | 111.187595 | 111.250439 | 111.187595 | 111.234728 | 10416.0 |
| 2024-06-16 20:00:00 | ZN | Futures | 111.250439 | 111.281862 | 111.219017 | 111.234728 | 20109.0 |
| 2024-06-16 21:00:00 | ZN | Futures | 111.250439 | 111.281862 | 111.234728 | 111.234728 | 9781.0 |
| 2024-06-16 22:00:00 | ZN | Futures | 111.250439 | 111.26615 | 111.219017 | 111.234728 | 5983.0 |
| 2024-06-16 23:00:00 | ZN | Futures | 111.250439 | 111.250439 | 111.203306 | 111.234728 | 6783.0 |
> showing 36 of 415 rows — these rows as CSV