PREVIEW / futures_30min / 2025-04-09
file: by_date/futures_30min/2025/2025-04-09.parquet size: 132 KB rows: 4,152
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 |
|---|---|---|---|---|---|---|---|
| 2025-04-09 00:00:00 | ES | Futures | 5006.62 | 5027.2 | 4969.02 | 4970.04 | 19572.0 |
| 2025-04-09 00:30:00 | ES | Futures | 4969.28 | 5004.33 | 4963.94 | 4981.73 | 13488.0 |
| 2025-04-09 01:00:00 | ES | Futures | 4982.23 | 4996.21 | 4967.75 | 4985.54 | 11014.0 |
| 2025-04-09 01:30:00 | ES | Futures | 4985.28 | 4994.17 | 4950.48 | 4994.17 | 12644.0 |
| 2025-04-09 02:00:00 | ES | Futures | 4994.43 | 5049.05 | 4993.41 | 5004.84 | 24806.0 |
| 2025-04-09 02:30:00 | ES | Futures | 5004.84 | 5038.38 | 5003.83 | 5031.01 | 17508.0 |
| 2025-04-09 03:00:00 | ES | Futures | 5030.76 | 5139.23 | 5027.45 | 5094.27 | 45335.0 |
| 2025-04-09 03:30:00 | ES | Futures | 5094.77 | 5132.88 | 5083.85 | 5115.1 | 29731.0 |
| 2025-04-09 04:00:00 | ES | Futures | 5115.35 | 5131.61 | 5076.99 | 5078.77 | 19821.0 |
| 2025-04-09 04:30:00 | ES | Futures | 5078.77 | 5114.84 | 5051.33 | 5110.78 | 22458.0 |
| 2025-04-09 05:00:00 | ES | Futures | 5110.27 | 5123.23 | 5096.04 | 5106.71 | 16152.0 |
| 2025-04-09 05:30:00 | ES | Futures | 5106.97 | 5113.06 | 5075.72 | 5086.39 | 12975.0 |
| 2025-04-09 06:00:00 | ES | Futures | 5086.39 | 5094.27 | 5050.32 | 5065.3 | 14274.0 |
| 2025-04-09 06:30:00 | ES | Futures | 5065.56 | 5114.08 | 5048.03 | 5076.48 | 19516.0 |
| 2025-04-09 07:00:00 | ES | Futures | 5076.99 | 5079.53 | 5000.02 | 5035.58 | 50365.0 |
| 2025-04-09 07:30:00 | ES | Futures | 5035.84 | 5060.48 | 4980.96 | 5006.11 | 42312.0 |
| 2025-04-09 08:00:00 | ES | Futures | 5005.86 | 5020.85 | 4989.35 | 4998.24 | 31304.0 |
| 2025-04-09 08:30:00 | ES | Futures | 4997.98 | 5070.64 | 4988.58 | 5042.95 | 44533.0 |
| 2025-04-09 09:00:00 | ES | Futures | 5042.69 | 5098.58 | 5042.69 | 5063.53 | 61039.0 |
| 2025-04-09 09:30:00 | ES | Futures | 5063.27 | 5152.44 | 5063.27 | 5129.83 | 179948.0 |
| 2025-04-09 10:00:00 | ES | Futures | 5129.83 | 5169.46 | 5097.06 | 5121.19 | 118113.0 |
| 2025-04-09 10:30:00 | ES | Futures | 5121.45 | 5148.88 | 5060.48 | 5062.0 | 99282.0 |
| 2025-04-09 11:00:00 | ES | Futures | 5062.0 | 5129.07 | 5060.48 | 5114.08 | 79482.0 |
| 2025-04-09 11:30:00 | ES | Futures | 5114.08 | 5127.54 | 5078.26 | 5090.2 | 73379.0 |
| 2025-04-09 12:00:00 | ES | Futures | 5089.95 | 5137.71 | 5077.75 | 5124.5 | 55724.0 |
| 2025-04-09 12:30:00 | ES | Futures | 5124.24 | 5158.79 | 5117.89 | 5144.57 | 62286.0 |
| 2025-04-09 13:00:00 | ES | Futures | 5144.57 | 5475.07 | 5106.2 | 5378.03 | 300816.0 |
| 2025-04-09 13:30:00 | ES | Futures | 5378.79 | 5508.1 | 5368.63 | 5491.58 | 275890.0 |
| 2025-04-09 14:00:00 | ES | Futures | 5491.84 | 5540.61 | 5452.46 | 5525.12 | 198274.0 |
| 2025-04-09 14:30:00 | ES | Futures | 5525.12 | 5542.39 | 5447.13 | 5450.94 | 158386.0 |
| 2025-04-09 15:00:00 | ES | Futures | 5450.94 | 5562.21 | 5438.49 | 5549.0 | 145201.0 |
| 2025-04-09 15:30:00 | ES | Futures | 5549.25 | 5609.2 | 5539.09 | 5578.21 | 306154.0 |
| 2025-04-09 16:00:00 | ES | Futures | 5578.21 | 5599.8 | 5568.56 | 5593.45 | 114339.0 |
| 2025-04-09 16:30:00 | ES | Futures | 5593.45 | 5606.92 | 5585.83 | 5602.6 | 23088.0 |
| 2025-04-09 18:00:00 | ES | Futures | 5591.42 | 5605.9 | 5578.72 | 5605.39 | 12806.0 |
| 2025-04-09 18:30:00 | ES | Futures | 5604.89 | 5608.95 | 5597.01 | 5608.7 | 9038.0 |
| 2025-04-09 19:00:00 | ES | Futures | 5608.44 | 5618.1 | 5599.55 | 5603.11 | 8732.0 |
| 2025-04-09 19:30:00 | ES | Futures | 5603.62 | 5608.95 | 5598.03 | 5603.87 | 7435.0 |
| 2025-04-09 20:00:00 | ES | Futures | 5603.36 | 5607.17 | 5583.8 | 5585.32 | 13959.0 |
| 2025-04-09 20:30:00 | ES | Futures | 5585.58 | 5586.85 | 5563.99 | 5585.32 | 12912.0 |
| 2025-04-09 21:00:00 | ES | Futures | 5585.32 | 5595.74 | 5552.55 | 5552.55 | 13376.0 |
| 2025-04-09 21:30:00 | ES | Futures | 5553.06 | 5567.03 | 5552.55 | 5564.24 | 10362.0 |
| 2025-04-09 22:00:00 | ES | Futures | 5564.24 | 5571.61 | 5555.35 | 5563.22 | 7670.0 |
| 2025-04-09 22:30:00 | ES | Futures | 5563.48 | 5565.51 | 5553.32 | 5553.82 | 6160.0 |
| 2025-04-09 23:00:00 | ES | Futures | 5553.57 | 5558.4 | 5535.02 | 5537.06 | 9212.0 |
| 2025-04-09 23:30:00 | ES | Futures | 5537.31 | 5545.95 | 5532.48 | 5543.66 | 6757.0 |
| 2025-04-09 00:00:00 | NQ | Futures | 17245.34 | 17333.96 | 17077.27 | 17094.33 | 9093.0 |
| 2025-04-09 00:30:00 | NQ | Futures | 17094.59 | 17237.19 | 17061.99 | 17138.13 | 8055.0 |
| 2025-04-09 01:00:00 | NQ | Futures | 17134.82 | 17202.56 | 17072.69 | 17156.47 | 7798.0 |
| 2025-04-09 01:30:00 | NQ | Futures | 17158.0 | 17210.2 | 17046.46 | 17210.2 | 5822.0 |
> showing 50 of 4,152 rows — these rows as CSV