PREVIEW / futures_30min / 2023-06-01
file: by_date/futures_30min/2023/2023-06-01.parquet size: 109 KB rows: 3,853
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 |
|---|---|---|---|---|---|---|---|
| 2023-06-01 00:00:00 | ES | Futures | 4651.77 | 4655.1 | 4650.94 | 4653.44 | 2242.0 |
| 2023-06-01 00:30:00 | ES | Futures | 4653.44 | 4654.54 | 4651.77 | 4651.77 | 1564.0 |
| 2023-06-01 01:00:00 | ES | Futures | 4651.77 | 4654.54 | 4651.77 | 4654.27 | 2360.0 |
| 2023-06-01 01:30:00 | ES | Futures | 4654.27 | 4655.1 | 4652.88 | 4652.88 | 2044.0 |
| 2023-06-01 02:00:00 | ES | Futures | 4652.88 | 4655.93 | 4650.38 | 4655.1 | 4347.0 |
| 2023-06-01 02:30:00 | ES | Futures | 4655.38 | 4656.49 | 4653.99 | 4654.82 | 3857.0 |
| 2023-06-01 03:00:00 | ES | Futures | 4655.1 | 4660.09 | 4652.05 | 4658.7 | 13655.0 |
| 2023-06-01 03:30:00 | ES | Futures | 4658.7 | 4659.81 | 4654.27 | 4655.1 | 7474.0 |
| 2023-06-01 04:00:00 | ES | Futures | 4655.1 | 4655.93 | 4650.11 | 4654.27 | 8643.0 |
| 2023-06-01 04:30:00 | ES | Futures | 4654.54 | 4660.65 | 4654.54 | 4659.54 | 7536.0 |
| 2023-06-01 05:00:00 | ES | Futures | 4659.26 | 4659.81 | 4656.49 | 4657.04 | 5407.0 |
| 2023-06-01 05:30:00 | ES | Futures | 4657.04 | 4659.26 | 4655.38 | 4658.98 | 3896.0 |
| 2023-06-01 06:00:00 | ES | Futures | 4658.98 | 4661.48 | 4657.04 | 4661.48 | 6285.0 |
| 2023-06-01 06:30:00 | ES | Futures | 4661.48 | 4663.42 | 4657.32 | 4657.32 | 8973.0 |
| 2023-06-01 07:00:00 | ES | Futures | 4657.32 | 4662.59 | 4657.04 | 4657.87 | 9501.0 |
| 2023-06-01 07:30:00 | ES | Futures | 4657.87 | 4659.81 | 4654.82 | 4656.21 | 10124.0 |
| 2023-06-01 08:00:00 | ES | Futures | 4656.21 | 4658.43 | 4647.89 | 4650.94 | 24608.0 |
| 2023-06-01 08:30:00 | ES | Futures | 4650.66 | 4657.87 | 4645.95 | 4649.27 | 30343.0 |
| 2023-06-01 09:00:00 | ES | Futures | 4649.0 | 4652.6 | 4646.22 | 4649.83 | 24585.0 |
| 2023-06-01 09:30:00 | ES | Futures | 4649.83 | 4651.77 | 4635.13 | 4639.57 | 239657.0 |
| 2023-06-01 10:00:00 | ES | Futures | 4639.84 | 4656.76 | 4639.29 | 4648.44 | 184309.0 |
| 2023-06-01 10:30:00 | ES | Futures | 4648.44 | 4668.13 | 4646.78 | 4663.97 | 141245.0 |
| 2023-06-01 11:00:00 | ES | Futures | 4663.97 | 4674.51 | 4661.48 | 4672.57 | 104942.0 |
| 2023-06-01 11:30:00 | ES | Futures | 4672.85 | 4683.11 | 4671.74 | 4682.56 | 92013.0 |
| 2023-06-01 12:00:00 | ES | Futures | 4682.83 | 4691.43 | 4682.56 | 4690.32 | 77595.0 |
| 2023-06-01 12:30:00 | ES | Futures | 4690.32 | 4691.16 | 4685.05 | 4689.77 | 54250.0 |
| 2023-06-01 13:00:00 | ES | Futures | 4689.77 | 4692.54 | 4685.05 | 4687.55 | 59315.0 |
| 2023-06-01 13:30:00 | ES | Futures | 4687.83 | 4694.21 | 4685.33 | 4694.21 | 54988.0 |
| 2023-06-01 14:00:00 | ES | Futures | 4694.21 | 4695.87 | 4690.32 | 4693.65 | 53147.0 |
| 2023-06-01 14:30:00 | ES | Futures | 4693.93 | 4698.92 | 4690.88 | 4698.09 | 62930.0 |
| 2023-06-01 15:00:00 | ES | Futures | 4698.37 | 4703.64 | 4690.88 | 4691.99 | 86435.0 |
| 2023-06-01 15:30:00 | ES | Futures | 4691.99 | 4693.1 | 4680.62 | 4691.43 | 237609.0 |
| 2023-06-01 16:00:00 | ES | Futures | 4691.16 | 4695.59 | 4689.21 | 4693.65 | 76529.0 |
| 2023-06-01 16:30:00 | ES | Futures | 4693.37 | 4695.59 | 4693.1 | 4694.76 | 20937.0 |
| 2023-06-01 18:00:00 | ES | Futures | 4694.76 | 4695.87 | 4693.93 | 4694.48 | 1684.0 |
| 2023-06-01 18:30:00 | ES | Futures | 4694.21 | 4695.32 | 4693.65 | 4695.32 | 1262.0 |
| 2023-06-01 19:00:00 | ES | Futures | 4695.32 | 4695.32 | 4693.37 | 4694.21 | 998.0 |
| 2023-06-01 19:30:00 | ES | Futures | 4694.21 | 4694.48 | 4692.54 | 4693.1 | 2487.0 |
| 2023-06-01 20:00:00 | ES | Futures | 4693.1 | 4694.21 | 4691.99 | 4693.37 | 3980.0 |
| 2023-06-01 20:30:00 | ES | Futures | 4693.37 | 4693.65 | 4691.99 | 4692.26 | 1955.0 |
| 2023-06-01 21:00:00 | ES | Futures | 4692.54 | 4693.65 | 4691.71 | 4692.54 | 2895.0 |
| 2023-06-01 21:30:00 | ES | Futures | 4692.82 | 4695.04 | 4692.26 | 4693.37 | 3435.0 |
| 2023-06-01 22:00:00 | ES | Futures | 4693.65 | 4695.87 | 4692.54 | 4695.59 | 2353.0 |
| 2023-06-01 22:30:00 | ES | Futures | 4695.59 | 4695.59 | 4693.1 | 4694.21 | 1943.0 |
| 2023-06-01 23:00:00 | ES | Futures | 4694.21 | 4696.7 | 4693.93 | 4696.7 | 1819.0 |
| 2023-06-01 23:30:00 | ES | Futures | 4696.42 | 4701.14 | 4696.42 | 4698.64 | 4118.0 |
| 2023-06-01 00:00:00 | NQ | Futures | 16082.31 | 16096.1 | 16079.21 | 16092.16 | 1060.0 |
| 2023-06-01 00:30:00 | NQ | Futures | 16092.73 | 16097.23 | 16084.56 | 16087.38 | 806.0 |
| 2023-06-01 01:00:00 | NQ | Futures | 16088.22 | 16102.86 | 16087.38 | 16101.74 | 1251.0 |
| 2023-06-01 01:30:00 | NQ | Futures | 16102.58 | 16105.4 | 16094.7 | 16095.54 | 1215.0 |
> showing 50 of 3,853 rows — these rows as CSV