PREVIEW / futures_1hour / 2024-01-21
file: by_date/futures_1hour/2024/2024-01-21.parquet size: 20 KB rows: 433
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-01-21 18:00:00 | ES | Futures | 5234.83 | 5242.08 | 5234.83 | 5236.98 | 11266.0 |
| 2024-01-21 19:00:00 | ES | Futures | 5236.98 | 5250.14 | 5235.91 | 5249.33 | 14049.0 |
| 2024-01-21 20:00:00 | ES | Futures | 5249.07 | 5250.95 | 5244.5 | 5246.11 | 15116.0 |
| 2024-01-21 21:00:00 | ES | Futures | 5246.11 | 5248.26 | 5242.62 | 5244.77 | 6933.0 |
| 2024-01-21 22:00:00 | ES | Futures | 5245.04 | 5246.38 | 5243.16 | 5244.5 | 5492.0 |
| 2024-01-21 23:00:00 | ES | Futures | 5244.5 | 5246.65 | 5244.23 | 5245.31 | 4109.0 |
| 2024-01-21 18:00:00 | NQ | Futures | 18947.51 | 18983.85 | 18947.51 | 18967.04 | 9394.0 |
| 2024-01-21 19:00:00 | NQ | Futures | 18967.58 | 19052.74 | 18962.7 | 19045.69 | 11027.0 |
| 2024-01-21 20:00:00 | NQ | Futures | 19045.41 | 19059.25 | 19030.5 | 19036.46 | 12133.0 |
| 2024-01-21 21:00:00 | NQ | Futures | 19037.28 | 19051.65 | 19025.07 | 19038.36 | 5577.0 |
| 2024-01-21 22:00:00 | NQ | Futures | 19038.63 | 19043.79 | 19027.24 | 19035.11 | 3532.0 |
| 2024-01-21 23:00:00 | NQ | Futures | 19035.38 | 19044.33 | 19034.02 | 19041.35 | 2313.0 |
| 2024-01-21 18:00:00 | YM | Futures | 40866.5 | 40938.5 | 40866.5 | 40905.2 | 1841.0 |
| 2024-01-21 19:00:00 | YM | Futures | 40904.1 | 40975.0 | 40893.4 | 40970.7 | 2403.0 |
| 2024-01-21 20:00:00 | YM | Futures | 40969.6 | 40983.6 | 40928.8 | 40941.7 | 1836.0 |
| 2024-01-21 21:00:00 | YM | Futures | 40939.5 | 40952.4 | 40917.0 | 40931.0 | 796.0 |
| 2024-01-21 22:00:00 | YM | Futures | 40931.0 | 40943.8 | 40920.2 | 40929.9 | 822.0 |
| 2024-01-21 23:00:00 | YM | Futures | 40929.9 | 40939.5 | 40922.4 | 40926.7 | 540.0 |
| 2024-01-21 18:00:00 | CL | Futures | 61.56 | 61.63 | 61.13 | 61.21 | 3328.0 |
| 2024-01-21 19:00:00 | CL | Futures | 61.21 | 61.25 | 61.0 | 61.08 | 2867.0 |
| 2024-01-21 20:00:00 | CL | Futures | 61.08 | 61.23 | 60.97 | 61.06 | 3400.0 |
| 2024-01-21 21:00:00 | CL | Futures | 61.05 | 61.18 | 60.97 | 61.18 | 2172.0 |
| 2024-01-21 22:00:00 | CL | Futures | 61.18 | 61.39 | 61.13 | 61.23 | 2957.0 |
| 2024-01-21 23:00:00 | CL | Futures | 61.23 | 61.23 | 60.99 | 61.03 | 1472.0 |
| 2024-01-21 18:00:00 | GC | Futures | 2247.8 | 2248.2 | 2244.5 | 2245.0 | 2225.0 |
| 2024-01-21 19:00:00 | GC | Futures | 2245.0 | 2246.9 | 2242.8 | 2246.8 | 2517.0 |
| 2024-01-21 20:00:00 | GC | Futures | 2246.7 | 2250.3 | 2246.5 | 2246.7 | 3386.0 |
| 2024-01-21 21:00:00 | GC | Futures | 2246.7 | 2247.8 | 2245.8 | 2247.3 | 1990.0 |
| 2024-01-21 22:00:00 | GC | Futures | 2247.2 | 2247.3 | 2242.9 | 2244.1 | 2660.0 |
| 2024-01-21 23:00:00 | GC | Futures | 2244.3 | 2244.4 | 2241.5 | 2242.4 | 2684.0 |
| 2024-01-21 18:00:00 | ZN | Futures | 112.766395 | 112.766395 | 112.671354 | 112.718875 | 15516.0 |
| 2024-01-21 19:00:00 | ZN | Futures | 112.718875 | 112.798076 | 112.703034 | 112.782236 | 21120.0 |
| 2024-01-21 20:00:00 | ZN | Futures | 112.782236 | 112.877277 | 112.766395 | 112.829756 | 21848.0 |
| 2024-01-21 21:00:00 | ZN | Futures | 112.845596 | 112.908957 | 112.829756 | 112.893117 | 12054.0 |
| 2024-01-21 22:00:00 | ZN | Futures | 112.877277 | 112.908957 | 112.845596 | 112.845596 | 13682.0 |
| 2024-01-21 23:00:00 | ZN | Futures | 112.845596 | 112.861437 | 112.829756 | 112.845596 | 9430.0 |
> showing 36 of 433 rows — these rows as CSV