PREVIEW / futures_1hour / 2024-01-01
file: by_date/futures_1hour/2024/2024-01-01.parquet size: 19 KB rows: 406
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-01 18:00:00 | ES | Futures | 5176.28 | 5181.11 | 5173.86 | 5179.5 | 13302.0 |
| 2024-01-01 19:00:00 | ES | Futures | 5179.23 | 5180.04 | 5177.08 | 5178.16 | 4608.0 |
| 2024-01-01 20:00:00 | ES | Futures | 5178.16 | 5181.38 | 5176.01 | 5177.08 | 11946.0 |
| 2024-01-01 21:00:00 | ES | Futures | 5177.35 | 5178.43 | 5175.2 | 5176.82 | 7864.0 |
| 2024-01-01 22:00:00 | ES | Futures | 5177.08 | 5178.7 | 5176.55 | 5177.89 | 3806.0 |
| 2024-01-01 23:00:00 | ES | Futures | 5177.89 | 5180.04 | 5177.35 | 5179.23 | 2819.0 |
| 2024-01-01 18:00:00 | NQ | Futures | 18462.59 | 18482.12 | 18456.9 | 18473.98 | 4582.0 |
| 2024-01-01 19:00:00 | NQ | Futures | 18474.53 | 18475.34 | 18462.05 | 18471.27 | 2270.0 |
| 2024-01-01 20:00:00 | NQ | Futures | 18471.0 | 18483.75 | 18453.64 | 18457.71 | 5255.0 |
| 2024-01-01 21:00:00 | NQ | Futures | 18457.71 | 18462.59 | 18443.07 | 18450.93 | 3541.0 |
| 2024-01-01 22:00:00 | NQ | Futures | 18450.93 | 18456.08 | 18444.42 | 18450.12 | 2024.0 |
| 2024-01-01 23:00:00 | NQ | Futures | 18449.85 | 18456.08 | 18445.51 | 18450.39 | 1526.0 |
| 2024-01-01 18:00:00 | YM | Futures | 40795.6 | 40863.3 | 40791.3 | 40841.8 | 2056.0 |
| 2024-01-01 19:00:00 | YM | Futures | 40841.8 | 40851.5 | 40826.8 | 40835.4 | 689.0 |
| 2024-01-01 20:00:00 | YM | Futures | 40836.4 | 40856.8 | 40812.8 | 40825.7 | 1102.0 |
| 2024-01-01 21:00:00 | YM | Futures | 40825.7 | 40836.4 | 40823.5 | 40833.2 | 770.0 |
| 2024-01-01 22:00:00 | YM | Futures | 40835.4 | 40844.0 | 40830.0 | 40840.7 | 496.0 |
| 2024-01-01 23:00:00 | YM | Futures | 40841.8 | 40857.9 | 40837.5 | 40852.5 | 548.0 |
| 2024-01-01 18:00:00 | CL | Futures | 59.95 | 60.43 | 59.89 | 60.16 | 3240.0 |
| 2024-01-01 19:00:00 | CL | Futures | 60.16 | 60.28 | 60.12 | 60.17 | 1060.0 |
| 2024-01-01 20:00:00 | CL | Futures | 60.16 | 60.98 | 60.15 | 60.57 | 9083.0 |
| 2024-01-01 21:00:00 | CL | Futures | 60.57 | 60.86 | 60.57 | 60.74 | 2909.0 |
| 2024-01-01 22:00:00 | CL | Futures | 60.74 | 60.9 | 60.74 | 60.78 | 2425.0 |
| 2024-01-01 23:00:00 | CL | Futures | 60.78 | 60.87 | 60.72 | 60.84 | 1118.0 |
| 2024-01-01 18:00:00 | GC | Futures | 2293.0 | 2296.4 | 2292.5 | 2293.3 | 2786.0 |
| 2024-01-01 19:00:00 | GC | Futures | 2293.4 | 2295.6 | 2291.6 | 2295.1 | 2538.0 |
| 2024-01-01 20:00:00 | GC | Futures | 2295.0 | 2299.9 | 2294.4 | 2296.0 | 4467.0 |
| 2024-01-01 21:00:00 | GC | Futures | 2296.1 | 2297.8 | 2293.3 | 2297.1 | 3682.0 |
| 2024-01-01 22:00:00 | GC | Futures | 2297.2 | 2300.3 | 2295.7 | 2299.6 | 2520.0 |
| 2024-01-01 23:00:00 | GC | Futures | 2299.6 | 2300.8 | 2298.7 | 2299.6 | 1310.0 |
| 2024-01-01 18:00:00 | ZN | Futures | 114.239534 | 114.382096 | 114.176173 | 114.207854 | 19668.0 |
| 2024-01-01 19:00:00 | ZN | Futures | 114.207854 | 114.223694 | 114.128653 | 114.128653 | 14549.0 |
| 2024-01-01 20:00:00 | ZN | Futures | 114.128653 | 114.144493 | 114.065292 | 114.096972 | 14658.0 |
| 2024-01-01 21:00:00 | ZN | Futures | 114.096972 | 114.112812 | 113.970251 | 113.986091 | 15139.0 |
| 2024-01-01 22:00:00 | ZN | Futures | 114.001931 | 114.081132 | 113.986091 | 114.049452 | 9859.0 |
| 2024-01-01 23:00:00 | ZN | Futures | 114.033611 | 114.081132 | 114.017771 | 114.065292 | 6160.0 |
> showing 36 of 406 rows — these rows as CSV