PREVIEW / futures_30min / 2024-11-24
file: by_date/futures_30min/2024/2024-11-24.parquet size: 30 KB rows: 874
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-11-24 18:00:00 | ES | Futures | 6234.79 | 6239.98 | 6234.27 | 6238.42 | 12507.0 |
| 2024-11-24 18:30:00 | ES | Futures | 6238.42 | 6239.98 | 6236.35 | 6237.64 | 3258.0 |
| 2024-11-24 19:00:00 | ES | Futures | 6237.9 | 6241.54 | 6237.64 | 6241.02 | 4076.0 |
| 2024-11-24 19:30:00 | ES | Futures | 6240.76 | 6243.09 | 6239.98 | 6242.84 | 4611.0 |
| 2024-11-24 20:00:00 | ES | Futures | 6242.58 | 6244.13 | 6241.8 | 6243.09 | 4865.0 |
| 2024-11-24 20:30:00 | ES | Futures | 6243.09 | 6244.39 | 6241.8 | 6242.32 | 3825.0 |
| 2024-11-24 21:00:00 | ES | Futures | 6242.32 | 6243.87 | 6242.06 | 6242.84 | 2353.0 |
| 2024-11-24 21:30:00 | ES | Futures | 6243.09 | 6243.61 | 6242.06 | 6243.35 | 1541.0 |
| 2024-11-24 22:00:00 | ES | Futures | 6243.61 | 6244.13 | 6242.32 | 6242.32 | 1645.0 |
| 2024-11-24 22:30:00 | ES | Futures | 6242.58 | 6242.84 | 6241.28 | 6242.32 | 1500.0 |
| 2024-11-24 23:00:00 | ES | Futures | 6242.58 | 6243.61 | 6242.32 | 6243.61 | 1739.0 |
| 2024-11-24 23:30:00 | ES | Futures | 6243.35 | 6243.61 | 6242.32 | 6242.84 | 1276.0 |
| 2024-11-24 18:00:00 | NQ | Futures | 21848.8 | 21868.89 | 21842.8 | 21856.1 | 4995.0 |
| 2024-11-24 18:30:00 | NQ | Futures | 21857.15 | 21861.06 | 21842.01 | 21849.32 | 1935.0 |
| 2024-11-24 19:00:00 | NQ | Futures | 21849.58 | 21869.15 | 21848.54 | 21865.76 | 2069.0 |
| 2024-11-24 19:30:00 | NQ | Futures | 21866.02 | 21871.24 | 21856.89 | 21869.15 | 1518.0 |
| 2024-11-24 20:00:00 | NQ | Futures | 21869.15 | 21881.41 | 21868.11 | 21878.8 | 2391.0 |
| 2024-11-24 20:30:00 | NQ | Futures | 21879.06 | 21883.24 | 21864.45 | 21867.06 | 2042.0 |
| 2024-11-24 21:00:00 | NQ | Futures | 21867.84 | 21879.59 | 21867.32 | 21875.15 | 1402.0 |
| 2024-11-24 21:30:00 | NQ | Futures | 21875.15 | 21877.24 | 21868.37 | 21874.37 | 1139.0 |
| 2024-11-24 22:00:00 | NQ | Futures | 21874.37 | 21883.24 | 21870.98 | 21871.76 | 1492.0 |
| 2024-11-24 22:30:00 | NQ | Futures | 21871.76 | 21878.02 | 21866.28 | 21875.93 | 1042.0 |
| 2024-11-24 23:00:00 | NQ | Futures | 21875.41 | 21884.54 | 21873.58 | 21883.24 | 1158.0 |
| 2024-11-24 23:30:00 | NQ | Futures | 21883.24 | 21885.85 | 21876.45 | 21880.37 | 1037.0 |
| 2024-11-24 18:00:00 | YM | Futures | 46312.4 | 46450.9 | 46303.1 | 46432.1 | 1979.0 |
| 2024-11-24 18:30:00 | YM | Futures | 46433.2 | 46438.4 | 46410.3 | 46420.7 | 535.0 |
| 2024-11-24 19:00:00 | YM | Futures | 46417.6 | 46444.6 | 46416.5 | 46441.5 | 510.0 |
| 2024-11-24 19:30:00 | YM | Futures | 46440.4 | 46458.1 | 46434.2 | 46455.0 | 418.0 |
| 2024-11-24 20:00:00 | YM | Futures | 46455.0 | 46462.3 | 46443.6 | 46451.9 | 496.0 |
| 2024-11-24 20:30:00 | YM | Futures | 46449.8 | 46474.8 | 46448.8 | 46458.1 | 596.0 |
| 2024-11-24 21:00:00 | YM | Futures | 46460.2 | 46473.8 | 46457.1 | 46467.5 | 360.0 |
| 2024-11-24 21:30:00 | YM | Futures | 46466.5 | 46476.9 | 46462.3 | 46475.8 | 232.0 |
| 2024-11-24 22:00:00 | YM | Futures | 46474.8 | 46480.0 | 46467.5 | 46468.5 | 235.0 |
| 2024-11-24 22:30:00 | YM | Futures | 46467.5 | 46471.7 | 46457.1 | 46468.5 | 251.0 |
| 2024-11-24 23:00:00 | YM | Futures | 46469.6 | 46474.8 | 46461.3 | 46470.6 | 443.0 |
| 2024-11-24 23:30:00 | YM | Futures | 46470.6 | 46472.7 | 46464.4 | 46468.5 | 248.0 |
| 2024-11-24 18:00:00 | CL | Futures | 64.81 | 64.84 | 64.47 | 64.74 | 1811.0 |
| 2024-11-24 18:30:00 | CL | Futures | 64.76 | 64.77 | 64.66 | 64.66 | 304.0 |
| 2024-11-24 19:00:00 | CL | Futures | 64.67 | 64.73 | 64.6 | 64.62 | 674.0 |
| 2024-11-24 19:30:00 | CL | Futures | 64.62 | 64.65 | 64.59 | 64.64 | 526.0 |
| 2024-11-24 20:00:00 | CL | Futures | 64.65 | 64.8 | 64.65 | 64.74 | 1127.0 |
| 2024-11-24 20:30:00 | CL | Futures | 64.75 | 64.75 | 64.53 | 64.55 | 953.0 |
| 2024-11-24 21:00:00 | CL | Futures | 64.55 | 64.59 | 64.44 | 64.46 | 1129.0 |
| 2024-11-24 21:30:00 | CL | Futures | 64.47 | 64.49 | 64.32 | 64.36 | 1374.0 |
| 2024-11-24 22:00:00 | CL | Futures | 64.36 | 64.38 | 64.27 | 64.28 | 1220.0 |
| 2024-11-24 22:30:00 | CL | Futures | 64.28 | 64.44 | 64.25 | 64.43 | 1129.0 |
| 2024-11-24 23:00:00 | CL | Futures | 64.43 | 64.5 | 64.33 | 64.37 | 920.0 |
| 2024-11-24 23:30:00 | CL | Futures | 64.37 | 64.41 | 64.27 | 64.28 | 636.0 |
| 2024-11-24 18:00:00 | GC | Futures | 2860.8 | 2864.1 | 2832.5 | 2863.8 | 5857.0 |
| 2024-11-24 18:30:00 | GC | Futures | 2863.8 | 2867.4 | 2861.0 | 2865.8 | 2628.0 |
> showing 50 of 874 rows — these rows as CSV