PREVIEW / futures_1hour / 2024-06-30
file: by_date/futures_1hour/2024/2024-06-30.parquet size: 19 KB rows: 432
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-30 18:00:00 | ES | Futures | 5803.52 | 5805.88 | 5797.49 | 5803.52 | 12070.0 |
| 2024-06-30 19:00:00 | ES | Futures | 5803.26 | 5803.52 | 5796.71 | 5798.28 | 8965.0 |
| 2024-06-30 20:00:00 | ES | Futures | 5798.54 | 5804.83 | 5795.4 | 5804.57 | 8245.0 |
| 2024-06-30 21:00:00 | ES | Futures | 5804.57 | 5805.88 | 5803.52 | 5805.62 | 6044.0 |
| 2024-06-30 22:00:00 | ES | Futures | 5805.36 | 5807.46 | 5805.1 | 5805.88 | 4796.0 |
| 2024-06-30 23:00:00 | ES | Futures | 5805.88 | 5807.72 | 5804.57 | 5805.62 | 4559.0 |
| 2024-06-30 18:00:00 | NQ | Futures | 21086.92 | 21102.23 | 21059.73 | 21090.88 | 5855.0 |
| 2024-06-30 19:00:00 | NQ | Futures | 21089.83 | 21090.88 | 21049.17 | 21061.58 | 5107.0 |
| 2024-06-30 20:00:00 | NQ | Futures | 21061.84 | 21101.44 | 21046.27 | 21100.65 | 4805.0 |
| 2024-06-30 21:00:00 | NQ | Futures | 21099.86 | 21110.94 | 21093.26 | 21108.3 | 3566.0 |
| 2024-06-30 22:00:00 | NQ | Futures | 21108.04 | 21120.98 | 21106.19 | 21115.17 | 2937.0 |
| 2024-06-30 23:00:00 | NQ | Futures | 21115.7 | 21123.88 | 21103.55 | 21114.64 | 3509.0 |
| 2024-06-30 18:00:00 | YM | Futures | 41566.8 | 41566.8 | 41489.0 | 41526.9 | 1200.0 |
| 2024-06-30 19:00:00 | YM | Futures | 41525.8 | 41525.8 | 41493.2 | 41495.3 | 1065.0 |
| 2024-06-30 20:00:00 | YM | Futures | 41496.4 | 41538.4 | 41483.8 | 41533.2 | 1251.0 |
| 2024-06-30 21:00:00 | YM | Futures | 41531.1 | 41537.4 | 41520.6 | 41530.0 | 650.0 |
| 2024-06-30 22:00:00 | YM | Futures | 41530.0 | 41535.3 | 41525.8 | 41525.8 | 500.0 |
| 2024-06-30 23:00:00 | YM | Futures | 41526.9 | 41536.3 | 41521.6 | 41524.8 | 506.0 |
| 2024-06-30 18:00:00 | CL | Futures | 69.66 | 69.86 | 69.6 | 69.68 | 1265.0 |
| 2024-06-30 19:00:00 | CL | Futures | 69.69 | 69.99 | 69.67 | 69.9 | 1521.0 |
| 2024-06-30 20:00:00 | CL | Futures | 69.89 | 69.93 | 69.81 | 69.88 | 1864.0 |
| 2024-06-30 21:00:00 | CL | Futures | 69.87 | 70.06 | 69.83 | 70.0 | 1541.0 |
| 2024-06-30 22:00:00 | CL | Futures | 70.0 | 70.08 | 69.96 | 70.05 | 1012.0 |
| 2024-06-30 23:00:00 | CL | Futures | 70.05 | 70.16 | 70.04 | 70.08 | 1377.0 |
| 2024-06-30 18:00:00 | GC | Futures | 2508.7 | 2510.0 | 2505.4 | 2507.1 | 1384.0 |
| 2024-06-30 19:00:00 | GC | Futures | 2506.9 | 2508.8 | 2505.5 | 2507.5 | 1418.0 |
| 2024-06-30 20:00:00 | GC | Futures | 2507.3 | 2508.0 | 2504.5 | 2507.4 | 2189.0 |
| 2024-06-30 21:00:00 | GC | Futures | 2507.3 | 2511.6 | 2506.0 | 2510.8 | 2301.0 |
| 2024-06-30 22:00:00 | GC | Futures | 2510.6 | 2510.6 | 2507.2 | 2509.7 | 2703.0 |
| 2024-06-30 23:00:00 | GC | Futures | 2509.6 | 2510.6 | 2507.1 | 2507.3 | 1624.0 |
| 2024-06-30 18:00:00 | ZN | Futures | 110.197794 | 110.229217 | 110.072105 | 110.182083 | 32363.0 |
| 2024-06-30 19:00:00 | ZN | Futures | 110.182083 | 110.213505 | 110.119239 | 110.182083 | 15381.0 |
| 2024-06-30 20:00:00 | ZN | Futures | 110.182083 | 110.244928 | 110.103528 | 110.244928 | 55624.0 |
| 2024-06-30 21:00:00 | ZN | Futures | 110.244928 | 110.323483 | 110.229217 | 110.27635 | 33656.0 |
| 2024-06-30 22:00:00 | ZN | Futures | 110.27635 | 110.323483 | 110.260639 | 110.323483 | 18685.0 |
| 2024-06-30 23:00:00 | ZN | Futures | 110.307772 | 110.354905 | 110.292061 | 110.339194 | 11772.0 |
> showing 36 of 432 rows — these rows as CSV