PREVIEW / futures_30min / 2024-04-30
file: by_date/futures_30min/2024/2024-04-30.parquet size: 116 KB rows: 3,918
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-30 00:00:00 | ES | Futures | 5457.66 | 5457.93 | 5456.34 | 5456.6 | 904.0 |
| 2024-04-30 00:30:00 | ES | Futures | 5456.87 | 5457.13 | 5455.54 | 5456.07 | 1093.0 |
| 2024-04-30 01:00:00 | ES | Futures | 5456.07 | 5456.87 | 5454.21 | 5454.48 | 1673.0 |
| 2024-04-30 01:30:00 | ES | Futures | 5454.48 | 5455.28 | 5449.44 | 5455.01 | 4055.0 |
| 2024-04-30 02:00:00 | ES | Futures | 5455.01 | 5458.46 | 5453.95 | 5457.13 | 3643.0 |
| 2024-04-30 02:30:00 | ES | Futures | 5457.13 | 5458.99 | 5456.07 | 5457.4 | 3387.0 |
| 2024-04-30 03:00:00 | ES | Futures | 5457.4 | 5458.99 | 5453.95 | 5456.87 | 5268.0 |
| 2024-04-30 03:30:00 | ES | Futures | 5456.87 | 5458.99 | 5454.75 | 5456.34 | 3717.0 |
| 2024-04-30 04:00:00 | ES | Futures | 5456.07 | 5457.66 | 5453.42 | 5455.28 | 4268.0 |
| 2024-04-30 04:30:00 | ES | Futures | 5455.28 | 5456.07 | 5450.24 | 5450.77 | 5272.0 |
| 2024-04-30 05:00:00 | ES | Futures | 5451.03 | 5455.54 | 5449.44 | 5453.68 | 10221.0 |
| 2024-04-30 05:30:00 | ES | Futures | 5453.95 | 5455.54 | 5451.83 | 5453.42 | 6976.0 |
| 2024-04-30 06:00:00 | ES | Futures | 5453.68 | 5454.75 | 5452.62 | 5453.42 | 2421.0 |
| 2024-04-30 06:30:00 | ES | Futures | 5453.42 | 5460.05 | 5452.62 | 5459.79 | 7416.0 |
| 2024-04-30 07:00:00 | ES | Futures | 5459.52 | 5460.32 | 5456.34 | 5457.4 | 7168.0 |
| 2024-04-30 07:30:00 | ES | Futures | 5457.66 | 5458.19 | 5455.28 | 5456.07 | 6634.0 |
| 2024-04-30 08:00:00 | ES | Futures | 5455.81 | 5460.05 | 5455.01 | 5457.93 | 9369.0 |
| 2024-04-30 08:30:00 | ES | Futures | 5458.19 | 5458.19 | 5433.79 | 5440.68 | 72457.0 |
| 2024-04-30 09:00:00 | ES | Futures | 5440.68 | 5447.05 | 5437.5 | 5444.66 | 26636.0 |
| 2024-04-30 09:30:00 | ES | Futures | 5444.93 | 5455.81 | 5440.95 | 5451.56 | 127868.0 |
| 2024-04-30 10:00:00 | ES | Futures | 5451.3 | 5455.81 | 5442.28 | 5442.28 | 92880.0 |
| 2024-04-30 10:30:00 | ES | Futures | 5442.28 | 5453.42 | 5439.89 | 5445.72 | 87811.0 |
| 2024-04-30 11:00:00 | ES | Futures | 5445.72 | 5445.72 | 5421.58 | 5426.89 | 124231.0 |
| 2024-04-30 11:30:00 | ES | Futures | 5426.89 | 5427.42 | 5417.6 | 5423.44 | 79212.0 |
| 2024-04-30 12:00:00 | ES | Futures | 5423.71 | 5428.22 | 5418.4 | 5424.5 | 54523.0 |
| 2024-04-30 12:30:00 | ES | Futures | 5424.77 | 5424.77 | 5404.07 | 5409.38 | 93576.0 |
| 2024-04-30 13:00:00 | ES | Futures | 5409.64 | 5414.15 | 5403.01 | 5409.11 | 60215.0 |
| 2024-04-30 13:30:00 | ES | Futures | 5408.85 | 5419.99 | 5407.52 | 5418.13 | 48042.0 |
| 2024-04-30 14:00:00 | ES | Futures | 5418.4 | 5422.91 | 5407.26 | 5408.32 | 59775.0 |
| 2024-04-30 14:30:00 | ES | Futures | 5408.58 | 5414.95 | 5399.83 | 5404.07 | 66447.0 |
| 2024-04-30 15:00:00 | ES | Futures | 5404.34 | 5409.64 | 5397.97 | 5404.07 | 72279.0 |
| 2024-04-30 15:30:00 | ES | Futures | 5404.07 | 5408.58 | 5374.89 | 5374.89 | 252975.0 |
| 2024-04-30 16:00:00 | ES | Futures | 5375.16 | 5387.89 | 5360.03 | 5363.22 | 147302.0 |
| 2024-04-30 16:30:00 | ES | Futures | 5363.22 | 5367.99 | 5362.95 | 5364.28 | 13019.0 |
| 2024-04-30 18:00:00 | ES | Futures | 5358.97 | 5366.4 | 5357.38 | 5361.89 | 10461.0 |
| 2024-04-30 18:30:00 | ES | Futures | 5361.89 | 5366.67 | 5361.89 | 5365.08 | 2959.0 |
| 2024-04-30 19:00:00 | ES | Futures | 5364.81 | 5369.59 | 5363.48 | 5364.81 | 3865.0 |
| 2024-04-30 19:30:00 | ES | Futures | 5365.08 | 5367.46 | 5361.89 | 5367.2 | 3863.0 |
| 2024-04-30 20:00:00 | ES | Futures | 5367.46 | 5369.59 | 5365.87 | 5367.73 | 3819.0 |
| 2024-04-30 20:30:00 | ES | Futures | 5367.73 | 5369.59 | 5365.87 | 5369.05 | 2553.0 |
| 2024-04-30 21:00:00 | ES | Futures | 5368.79 | 5370.12 | 5367.46 | 5370.12 | 3916.0 |
| 2024-04-30 21:30:00 | ES | Futures | 5369.85 | 5370.38 | 5367.2 | 5369.85 | 1915.0 |
| 2024-04-30 22:00:00 | ES | Futures | 5369.85 | 5369.85 | 5366.93 | 5368.79 | 1797.0 |
| 2024-04-30 22:30:00 | ES | Futures | 5369.05 | 5372.5 | 5368.79 | 5371.18 | 2400.0 |
| 2024-04-30 23:00:00 | ES | Futures | 5371.44 | 5373.83 | 5371.44 | 5373.03 | 2152.0 |
| 2024-04-30 23:30:00 | ES | Futures | 5373.03 | 5374.89 | 5371.97 | 5374.63 | 2237.0 |
| 2024-04-30 00:00:00 | NQ | Futures | 19164.79 | 19165.86 | 19159.17 | 19160.78 | 586.0 |
| 2024-04-30 00:30:00 | NQ | Futures | 19161.05 | 19162.38 | 19155.7 | 19158.64 | 846.0 |
| 2024-04-30 01:00:00 | NQ | Futures | 19158.91 | 19159.71 | 19144.19 | 19144.46 | 1580.0 |
| 2024-04-30 01:30:00 | NQ | Futures | 19144.73 | 19146.07 | 19123.33 | 19143.66 | 2699.0 |
> showing 50 of 3,918 rows — these rows as CSV