PREVIEW / futures_30min / 2024-01-01
file: by_date/futures_30min/2024/2024-01-01.parquet size: 29 KB rows: 778
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 | 5180.31 | 8431.0 |
| 2024-01-01 18:30:00 | ES | Futures | 5180.58 | 5180.84 | 5178.7 | 5179.5 | 4871.0 |
| 2024-01-01 19:00:00 | ES | Futures | 5179.23 | 5180.04 | 5177.35 | 5177.62 | 2533.0 |
| 2024-01-01 19:30:00 | ES | Futures | 5177.62 | 5178.96 | 5177.08 | 5178.16 | 2075.0 |
| 2024-01-01 20:00:00 | ES | Futures | 5178.16 | 5181.38 | 5178.16 | 5179.77 | 8181.0 |
| 2024-01-01 20:30:00 | ES | Futures | 5179.77 | 5180.04 | 5176.01 | 5177.08 | 3765.0 |
| 2024-01-01 21:00:00 | ES | Futures | 5177.35 | 5178.43 | 5176.82 | 5177.35 | 4041.0 |
| 2024-01-01 21:30:00 | ES | Futures | 5177.62 | 5177.62 | 5175.2 | 5176.82 | 3823.0 |
| 2024-01-01 22:00:00 | ES | Futures | 5177.08 | 5178.7 | 5177.08 | 5177.62 | 2088.0 |
| 2024-01-01 22:30:00 | ES | Futures | 5177.89 | 5178.43 | 5176.55 | 5177.89 | 1718.0 |
| 2024-01-01 23:00:00 | ES | Futures | 5177.89 | 5178.43 | 5177.35 | 5178.43 | 1161.0 |
| 2024-01-01 23:30:00 | ES | Futures | 5178.43 | 5180.04 | 5178.43 | 5179.23 | 1658.0 |
| 2024-01-01 18:00:00 | NQ | Futures | 18462.59 | 18482.12 | 18456.9 | 18478.05 | 3466.0 |
| 2024-01-01 18:30:00 | NQ | Futures | 18478.05 | 18481.31 | 18471.54 | 18473.98 | 1116.0 |
| 2024-01-01 19:00:00 | NQ | Futures | 18474.53 | 18475.34 | 18462.05 | 18463.41 | 1222.0 |
| 2024-01-01 19:30:00 | NQ | Futures | 18463.41 | 18472.36 | 18462.05 | 18471.27 | 1048.0 |
| 2024-01-01 20:00:00 | NQ | Futures | 18471.0 | 18483.75 | 18470.46 | 18473.71 | 2664.0 |
| 2024-01-01 20:30:00 | NQ | Futures | 18473.44 | 18476.15 | 18453.64 | 18457.71 | 2591.0 |
| 2024-01-01 21:00:00 | NQ | Futures | 18457.71 | 18462.59 | 18453.1 | 18454.46 | 1696.0 |
| 2024-01-01 21:30:00 | NQ | Futures | 18454.73 | 18456.36 | 18443.07 | 18450.93 | 1845.0 |
| 2024-01-01 22:00:00 | NQ | Futures | 18450.93 | 18456.08 | 18446.86 | 18451.75 | 1130.0 |
| 2024-01-01 22:30:00 | NQ | Futures | 18452.02 | 18453.1 | 18444.42 | 18450.12 | 894.0 |
| 2024-01-01 23:00:00 | NQ | Futures | 18449.85 | 18451.47 | 18445.51 | 18450.39 | 627.0 |
| 2024-01-01 23:30:00 | NQ | Futures | 18450.66 | 18456.08 | 18449.85 | 18450.39 | 899.0 |
| 2024-01-01 18:00:00 | YM | Futures | 40795.6 | 40863.3 | 40791.3 | 40861.1 | 1538.0 |
| 2024-01-01 18:30:00 | YM | Futures | 40861.1 | 40861.1 | 40833.2 | 40841.8 | 518.0 |
| 2024-01-01 19:00:00 | YM | Futures | 40841.8 | 40851.5 | 40826.8 | 40835.4 | 443.0 |
| 2024-01-01 19:30:00 | YM | Futures | 40836.4 | 40842.9 | 40828.9 | 40835.4 | 246.0 |
| 2024-01-01 20:00:00 | YM | Futures | 40836.4 | 40856.8 | 40833.2 | 40841.8 | 578.0 |
| 2024-01-01 20:30:00 | YM | Futures | 40844.0 | 40845.0 | 40812.8 | 40825.7 | 524.0 |
| 2024-01-01 21:00:00 | YM | Futures | 40825.7 | 40833.2 | 40823.5 | 40830.0 | 446.0 |
| 2024-01-01 21:30:00 | YM | Futures | 40831.1 | 40836.4 | 40824.6 | 40833.2 | 324.0 |
| 2024-01-01 22:00:00 | YM | Futures | 40835.4 | 40844.0 | 40834.3 | 40838.6 | 270.0 |
| 2024-01-01 22:30:00 | YM | Futures | 40838.6 | 40842.9 | 40830.0 | 40840.7 | 226.0 |
| 2024-01-01 23:00:00 | YM | Futures | 40841.8 | 40844.0 | 40837.5 | 40842.9 | 193.0 |
| 2024-01-01 23:30:00 | YM | Futures | 40844.0 | 40857.9 | 40842.9 | 40852.5 | 355.0 |
| 2024-01-01 18:00:00 | CL | Futures | 59.95 | 60.43 | 59.89 | 60.18 | 2790.0 |
| 2024-01-01 18:30:00 | CL | Futures | 60.17 | 60.18 | 60.08 | 60.16 | 450.0 |
| 2024-01-01 19:00:00 | CL | Futures | 60.16 | 60.28 | 60.15 | 60.19 | 633.0 |
| 2024-01-01 19:30:00 | CL | Futures | 60.18 | 60.26 | 60.12 | 60.17 | 427.0 |
| 2024-01-01 20:00:00 | CL | Futures | 60.16 | 60.98 | 60.15 | 60.62 | 7252.0 |
| 2024-01-01 20:30:00 | CL | Futures | 60.62 | 60.67 | 60.49 | 60.57 | 1831.0 |
| 2024-01-01 21:00:00 | CL | Futures | 60.57 | 60.7 | 60.57 | 60.65 | 1109.0 |
| 2024-01-01 21:30:00 | CL | Futures | 60.67 | 60.86 | 60.67 | 60.74 | 1800.0 |
| 2024-01-01 22:00:00 | CL | Futures | 60.74 | 60.9 | 60.74 | 60.8 | 1854.0 |
| 2024-01-01 22:30:00 | CL | Futures | 60.8 | 60.82 | 60.74 | 60.78 | 571.0 |
| 2024-01-01 23:00:00 | CL | Futures | 60.78 | 60.79 | 60.72 | 60.73 | 533.0 |
| 2024-01-01 23:30:00 | CL | Futures | 60.73 | 60.87 | 60.72 | 60.84 | 585.0 |
| 2024-01-01 18:00:00 | GC | Futures | 2293.0 | 2296.4 | 2292.5 | 2294.8 | 1660.0 |
| 2024-01-01 18:30:00 | GC | Futures | 2294.9 | 2295.4 | 2292.7 | 2293.3 | 1126.0 |
> showing 50 of 778 rows — these rows as CSV