PREVIEW / futures_30min / 2024-11-07
file: by_date/futures_30min/2024/2024-11-07.parquet size: 118 KB rows: 4,075
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-07 00:00:00 | ES | Futures | 6193.79 | 6196.12 | 6192.23 | 6194.05 | 2528.0 |
| 2024-11-07 00:30:00 | ES | Futures | 6194.05 | 6197.94 | 6193.01 | 6197.16 | 3508.0 |
| 2024-11-07 01:00:00 | ES | Futures | 6197.16 | 6199.24 | 6195.08 | 6198.2 | 2537.0 |
| 2024-11-07 01:30:00 | ES | Futures | 6198.46 | 6198.72 | 6193.79 | 6194.56 | 2548.0 |
| 2024-11-07 02:00:00 | ES | Futures | 6194.56 | 6195.6 | 6186.26 | 6186.78 | 5435.0 |
| 2024-11-07 02:30:00 | ES | Futures | 6186.78 | 6191.19 | 6186.52 | 6188.6 | 3612.0 |
| 2024-11-07 03:00:00 | ES | Futures | 6188.6 | 6200.53 | 6188.08 | 6200.01 | 12941.0 |
| 2024-11-07 03:30:00 | ES | Futures | 6199.75 | 6199.75 | 6191.45 | 6195.08 | 7906.0 |
| 2024-11-07 04:00:00 | ES | Futures | 6195.08 | 6200.53 | 6191.71 | 6196.9 | 9452.0 |
| 2024-11-07 04:30:00 | ES | Futures | 6196.9 | 6198.98 | 6194.3 | 6194.82 | 5569.0 |
| 2024-11-07 05:00:00 | ES | Futures | 6195.08 | 6198.98 | 6194.56 | 6195.6 | 6495.0 |
| 2024-11-07 05:30:00 | ES | Futures | 6195.6 | 6198.72 | 6194.56 | 6198.46 | 5714.0 |
| 2024-11-07 06:00:00 | ES | Futures | 6198.72 | 6198.72 | 6192.49 | 6195.08 | 5593.0 |
| 2024-11-07 06:30:00 | ES | Futures | 6195.08 | 6198.46 | 6191.97 | 6198.46 | 5877.0 |
| 2024-11-07 07:00:00 | ES | Futures | 6197.94 | 6202.87 | 6197.42 | 6201.83 | 10756.0 |
| 2024-11-07 07:30:00 | ES | Futures | 6201.57 | 6202.09 | 6195.86 | 6200.79 | 8119.0 |
| 2024-11-07 08:00:00 | ES | Futures | 6200.79 | 6204.69 | 6200.01 | 6201.05 | 14327.0 |
| 2024-11-07 08:30:00 | ES | Futures | 6200.79 | 6202.61 | 6194.3 | 6200.79 | 20211.0 |
| 2024-11-07 09:00:00 | ES | Futures | 6200.79 | 6206.24 | 6198.46 | 6204.69 | 27303.0 |
| 2024-11-07 09:30:00 | ES | Futures | 6204.69 | 6214.81 | 6203.65 | 6213.77 | 119114.0 |
| 2024-11-07 10:00:00 | ES | Futures | 6214.03 | 6218.7 | 6211.95 | 6216.88 | 83092.0 |
| 2024-11-07 10:30:00 | ES | Futures | 6216.88 | 6224.67 | 6215.07 | 6222.85 | 71863.0 |
| 2024-11-07 11:00:00 | ES | Futures | 6222.85 | 6225.19 | 6215.33 | 6220.78 | 63167.0 |
| 2024-11-07 11:30:00 | ES | Futures | 6220.78 | 6227.78 | 6220.26 | 6226.23 | 43082.0 |
| 2024-11-07 12:00:00 | ES | Futures | 6226.49 | 6228.04 | 6222.33 | 6227.26 | 38577.0 |
| 2024-11-07 12:30:00 | ES | Futures | 6227.0 | 6230.64 | 6224.67 | 6229.08 | 35797.0 |
| 2024-11-07 13:00:00 | ES | Futures | 6229.08 | 6229.6 | 6220.0 | 6223.37 | 38193.0 |
| 2024-11-07 13:30:00 | ES | Futures | 6223.37 | 6226.49 | 6216.1 | 6222.33 | 46167.0 |
| 2024-11-07 14:00:00 | ES | Futures | 6222.33 | 6229.08 | 6216.36 | 6221.55 | 51505.0 |
| 2024-11-07 14:30:00 | ES | Futures | 6221.55 | 6235.57 | 6213.51 | 6235.57 | 103817.0 |
| 2024-11-07 15:00:00 | ES | Futures | 6235.57 | 6242.06 | 6229.6 | 6236.35 | 82178.0 |
| 2024-11-07 15:30:00 | ES | Futures | 6236.35 | 6239.46 | 6227.0 | 6231.16 | 157158.0 |
| 2024-11-07 16:00:00 | ES | Futures | 6230.9 | 6238.42 | 6229.86 | 6235.57 | 45357.0 |
| 2024-11-07 16:30:00 | ES | Futures | 6235.57 | 6236.87 | 6233.75 | 6235.31 | 25009.0 |
| 2024-11-07 18:00:00 | ES | Futures | 6236.61 | 6237.9 | 6230.64 | 6235.83 | 3458.0 |
| 2024-11-07 18:30:00 | ES | Futures | 6235.83 | 6236.87 | 6233.49 | 6236.09 | 2164.0 |
| 2024-11-07 19:00:00 | ES | Futures | 6236.09 | 6237.9 | 6234.01 | 6234.27 | 2231.0 |
| 2024-11-07 19:30:00 | ES | Futures | 6234.01 | 6235.05 | 6231.94 | 6232.45 | 2541.0 |
| 2024-11-07 20:00:00 | ES | Futures | 6232.71 | 6234.01 | 6230.64 | 6233.49 | 3139.0 |
| 2024-11-07 20:30:00 | ES | Futures | 6233.49 | 6234.53 | 6231.68 | 6234.27 | 2584.0 |
| 2024-11-07 21:00:00 | ES | Futures | 6234.01 | 6235.83 | 6232.97 | 6233.23 | 2511.0 |
| 2024-11-07 21:30:00 | ES | Futures | 6233.23 | 6234.01 | 6229.86 | 6230.12 | 2791.0 |
| 2024-11-07 22:00:00 | ES | Futures | 6230.12 | 6232.45 | 6230.12 | 6231.16 | 2001.0 |
| 2024-11-07 22:30:00 | ES | Futures | 6231.16 | 6232.97 | 6231.16 | 6231.68 | 1558.0 |
| 2024-11-07 23:00:00 | ES | Futures | 6231.42 | 6234.01 | 6230.64 | 6233.49 | 2138.0 |
| 2024-11-07 23:30:00 | ES | Futures | 6233.49 | 6233.49 | 6231.16 | 6231.68 | 1072.0 |
| 2024-11-07 00:00:00 | NQ | Futures | 21835.23 | 21851.93 | 21829.23 | 21843.58 | 1870.0 |
| 2024-11-07 00:30:00 | NQ | Futures | 21843.32 | 21868.63 | 21842.27 | 21863.41 | 2441.0 |
| 2024-11-07 01:00:00 | NQ | Futures | 21863.41 | 21879.59 | 21856.89 | 21877.24 | 1904.0 |
| 2024-11-07 01:30:00 | NQ | Futures | 21876.72 | 21881.41 | 21859.76 | 21864.71 | 1715.0 |
> showing 50 of 4,075 rows — these rows as CSV