PREVIEW / futures_30min / 2024-04-23
file: by_date/futures_30min/2024/2024-04-23.parquet size: 110 KB rows: 3,942
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-04-23 00:00:00 | ES | Futures | 5356.32 | 5358.44 | 5355.79 | 5355.79 | 1397.0 |
| 2024-04-23 00:30:00 | ES | Futures | 5355.79 | 5356.59 | 5354.2 | 5354.99 | 1355.0 |
| 2024-04-23 01:00:00 | ES | Futures | 5354.99 | 5355.79 | 5352.61 | 5353.4 | 1970.0 |
| 2024-04-23 01:30:00 | ES | Futures | 5353.14 | 5357.38 | 5352.08 | 5355.79 | 2292.0 |
| 2024-04-23 02:00:00 | ES | Futures | 5356.06 | 5356.32 | 5351.81 | 5351.81 | 2412.0 |
| 2024-04-23 02:30:00 | ES | Futures | 5351.81 | 5359.5 | 5351.01 | 5358.97 | 3873.0 |
| 2024-04-23 03:00:00 | ES | Futures | 5358.97 | 5363.75 | 5357.12 | 5362.16 | 10515.0 |
| 2024-04-23 03:30:00 | ES | Futures | 5362.16 | 5362.69 | 5357.65 | 5360.3 | 9048.0 |
| 2024-04-23 04:00:00 | ES | Futures | 5360.57 | 5368.52 | 5360.57 | 5365.87 | 8873.0 |
| 2024-04-23 04:30:00 | ES | Futures | 5365.87 | 5366.67 | 5359.24 | 5361.63 | 7025.0 |
| 2024-04-23 05:00:00 | ES | Futures | 5361.63 | 5366.67 | 5360.83 | 5365.87 | 5259.0 |
| 2024-04-23 05:30:00 | ES | Futures | 5365.87 | 5366.67 | 5358.71 | 5360.57 | 5991.0 |
| 2024-04-23 06:00:00 | ES | Futures | 5360.57 | 5369.32 | 5360.03 | 5367.99 | 8500.0 |
| 2024-04-23 06:30:00 | ES | Futures | 5367.99 | 5374.1 | 5367.73 | 5373.3 | 7637.0 |
| 2024-04-23 07:00:00 | ES | Futures | 5373.56 | 5376.22 | 5370.12 | 5370.65 | 9662.0 |
| 2024-04-23 07:30:00 | ES | Futures | 5370.65 | 5371.44 | 5365.34 | 5367.2 | 9628.0 |
| 2024-04-23 08:00:00 | ES | Futures | 5367.46 | 5368.26 | 5360.3 | 5367.73 | 14923.0 |
| 2024-04-23 08:30:00 | ES | Futures | 5367.46 | 5377.54 | 5367.46 | 5375.16 | 19114.0 |
| 2024-04-23 09:00:00 | ES | Futures | 5375.42 | 5380.99 | 5373.56 | 5379.67 | 24863.0 |
| 2024-04-23 09:30:00 | ES | Futures | 5379.67 | 5400.09 | 5373.56 | 5393.46 | 188703.0 |
| 2024-04-23 10:00:00 | ES | Futures | 5393.46 | 5407.79 | 5389.22 | 5406.73 | 127122.0 |
| 2024-04-23 10:30:00 | ES | Futures | 5406.99 | 5417.87 | 5406.2 | 5416.54 | 124511.0 |
| 2024-04-23 11:00:00 | ES | Futures | 5416.54 | 5417.6 | 5403.81 | 5412.03 | 83072.0 |
| 2024-04-23 11:30:00 | ES | Futures | 5412.3 | 5414.42 | 5405.93 | 5406.99 | 61780.0 |
| 2024-04-23 12:00:00 | ES | Futures | 5406.99 | 5418.93 | 5405.67 | 5417.6 | 52604.0 |
| 2024-04-23 12:30:00 | ES | Futures | 5417.6 | 5420.52 | 5413.36 | 5416.01 | 43898.0 |
| 2024-04-23 13:00:00 | ES | Futures | 5416.01 | 5419.99 | 5409.38 | 5418.13 | 50234.0 |
| 2024-04-23 13:30:00 | ES | Futures | 5418.13 | 5425.56 | 5415.48 | 5424.5 | 42313.0 |
| 2024-04-23 14:00:00 | ES | Futures | 5424.5 | 5425.56 | 5419.2 | 5423.71 | 38101.0 |
| 2024-04-23 14:30:00 | ES | Futures | 5423.97 | 5425.56 | 5416.81 | 5421.85 | 40936.0 |
| 2024-04-23 15:00:00 | ES | Futures | 5421.58 | 5422.38 | 5413.62 | 5417.6 | 47330.0 |
| 2024-04-23 15:30:00 | ES | Futures | 5417.6 | 5421.85 | 5413.36 | 5420.26 | 145515.0 |
| 2024-04-23 16:00:00 | ES | Futures | 5420.26 | 5425.83 | 5415.75 | 5424.5 | 61051.0 |
| 2024-04-23 16:30:00 | ES | Futures | 5424.77 | 5426.36 | 5423.97 | 5425.03 | 6608.0 |
| 2024-04-23 18:00:00 | ES | Futures | 5428.22 | 5430.6 | 5424.5 | 5425.03 | 5247.0 |
| 2024-04-23 18:30:00 | ES | Futures | 5425.03 | 5427.42 | 5424.24 | 5427.15 | 3271.0 |
| 2024-04-23 19:00:00 | ES | Futures | 5426.89 | 5429.28 | 5426.09 | 5429.01 | 2866.0 |
| 2024-04-23 19:30:00 | ES | Futures | 5429.28 | 5432.99 | 5427.15 | 5429.28 | 5468.0 |
| 2024-04-23 20:00:00 | ES | Futures | 5429.28 | 5431.66 | 5426.62 | 5431.66 | 4547.0 |
| 2024-04-23 20:30:00 | ES | Futures | 5431.66 | 5434.05 | 5430.6 | 5433.26 | 3714.0 |
| 2024-04-23 21:00:00 | ES | Futures | 5432.99 | 5434.58 | 5431.93 | 5433.52 | 2802.0 |
| 2024-04-23 21:30:00 | ES | Futures | 5433.52 | 5435.38 | 5431.13 | 5435.11 | 3467.0 |
| 2024-04-23 22:00:00 | ES | Futures | 5434.85 | 5437.24 | 5434.05 | 5436.7 | 4287.0 |
| 2024-04-23 22:30:00 | ES | Futures | 5436.44 | 5436.7 | 5434.58 | 5436.7 | 2176.0 |
| 2024-04-23 23:00:00 | ES | Futures | 5436.7 | 5440.95 | 5436.17 | 5438.83 | 5106.0 |
| 2024-04-23 23:30:00 | ES | Futures | 5439.09 | 5440.15 | 5437.77 | 5438.83 | 2099.0 |
| 2024-04-23 00:00:00 | NQ | Futures | 18545.52 | 18556.49 | 18544.18 | 18547.66 | 1009.0 |
| 2024-04-23 00:30:00 | NQ | Futures | 18547.39 | 18549.26 | 18537.76 | 18544.45 | 1116.0 |
| 2024-04-23 01:00:00 | NQ | Futures | 18543.91 | 18547.12 | 18532.95 | 18536.96 | 1620.0 |
| 2024-04-23 01:30:00 | NQ | Futures | 18536.69 | 18556.22 | 18530.0 | 18550.07 | 2216.0 |
> showing 50 of 3,942 rows — these rows as CSV