PREVIEW / futures_30min / 2023-05-25
file: by_date/futures_30min/2023/2023-05-25.parquet size: 107 KB rows: 3,827
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-05-25 00:00:00 | ES | Futures | 4593.8 | 4596.3 | 4593.8 | 4594.64 | 1617.0 |
| 2023-05-25 00:30:00 | ES | Futures | 4594.91 | 4595.19 | 4592.97 | 4593.25 | 1357.0 |
| 2023-05-25 01:00:00 | ES | Futures | 4593.25 | 4595.75 | 4591.86 | 4594.08 | 3293.0 |
| 2023-05-25 01:30:00 | ES | Futures | 4594.08 | 4597.69 | 4593.53 | 4595.47 | 3471.0 |
| 2023-05-25 02:00:00 | ES | Futures | 4595.19 | 4604.62 | 4594.36 | 4604.07 | 8762.0 |
| 2023-05-25 02:30:00 | ES | Futures | 4604.07 | 4608.78 | 4601.85 | 4606.29 | 8564.0 |
| 2023-05-25 03:00:00 | ES | Futures | 4606.29 | 4606.84 | 4598.52 | 4600.46 | 17539.0 |
| 2023-05-25 03:30:00 | ES | Futures | 4600.74 | 4601.02 | 4587.98 | 4591.86 | 17636.0 |
| 2023-05-25 04:00:00 | ES | Futures | 4591.86 | 4602.12 | 4591.03 | 4600.74 | 12956.0 |
| 2023-05-25 04:30:00 | ES | Futures | 4601.02 | 4604.62 | 4597.69 | 4604.34 | 8529.0 |
| 2023-05-25 05:00:00 | ES | Futures | 4604.34 | 4607.39 | 4604.34 | 4606.84 | 10111.0 |
| 2023-05-25 05:30:00 | ES | Futures | 4607.12 | 4611.0 | 4605.73 | 4610.17 | 10105.0 |
| 2023-05-25 06:00:00 | ES | Futures | 4610.17 | 4611.0 | 4607.12 | 4609.06 | 6646.0 |
| 2023-05-25 06:30:00 | ES | Futures | 4608.78 | 4610.45 | 4603.23 | 4603.23 | 8503.0 |
| 2023-05-25 07:00:00 | ES | Futures | 4603.23 | 4605.45 | 4601.85 | 4603.51 | 10043.0 |
| 2023-05-25 07:30:00 | ES | Futures | 4603.23 | 4607.67 | 4599.07 | 4607.12 | 15939.0 |
| 2023-05-25 08:00:00 | ES | Futures | 4606.84 | 4615.99 | 4606.56 | 4610.72 | 21703.0 |
| 2023-05-25 08:30:00 | ES | Futures | 4611.0 | 4621.82 | 4605.45 | 4619.32 | 52754.0 |
| 2023-05-25 09:00:00 | ES | Futures | 4619.6 | 4622.65 | 4611.83 | 4615.99 | 42053.0 |
| 2023-05-25 09:30:00 | ES | Futures | 4615.99 | 4617.1 | 4592.14 | 4598.24 | 261101.0 |
| 2023-05-25 10:00:00 | ES | Futures | 4598.24 | 4606.01 | 4590.2 | 4598.24 | 162758.0 |
| 2023-05-25 10:30:00 | ES | Futures | 4598.24 | 4607.95 | 4593.25 | 4605.18 | 111680.0 |
| 2023-05-25 11:00:00 | ES | Futures | 4605.18 | 4615.16 | 4602.68 | 4603.79 | 113862.0 |
| 2023-05-25 11:30:00 | ES | Futures | 4603.79 | 4604.9 | 4592.42 | 4597.96 | 99075.0 |
| 2023-05-25 12:00:00 | ES | Futures | 4598.24 | 4614.33 | 4597.96 | 4610.17 | 86050.0 |
| 2023-05-25 12:30:00 | ES | Futures | 4610.17 | 4611.55 | 4603.23 | 4604.62 | 64926.0 |
| 2023-05-25 13:00:00 | ES | Futures | 4604.62 | 4618.49 | 4601.57 | 4615.72 | 62074.0 |
| 2023-05-25 13:30:00 | ES | Futures | 4615.72 | 4620.43 | 4613.5 | 4619.04 | 58230.0 |
| 2023-05-25 14:00:00 | ES | Futures | 4618.77 | 4632.36 | 4616.82 | 4620.15 | 121543.0 |
| 2023-05-25 14:30:00 | ES | Futures | 4620.43 | 4620.98 | 4606.29 | 4609.34 | 90361.0 |
| 2023-05-25 15:00:00 | ES | Futures | 4609.34 | 4625.42 | 4608.78 | 4622.37 | 85435.0 |
| 2023-05-25 15:30:00 | ES | Futures | 4622.65 | 4626.81 | 4614.05 | 4615.16 | 160608.0 |
| 2023-05-25 16:00:00 | ES | Futures | 4614.88 | 4616.82 | 4612.66 | 4614.61 | 49121.0 |
| 2023-05-25 16:30:00 | ES | Futures | 4614.33 | 4615.44 | 4612.94 | 4613.77 | 17129.0 |
| 2023-05-25 18:00:00 | ES | Futures | 4611.83 | 4614.88 | 4607.67 | 4612.11 | 4830.0 |
| 2023-05-25 18:30:00 | ES | Futures | 4612.11 | 4612.39 | 4608.5 | 4610.72 | 2468.0 |
| 2023-05-25 19:00:00 | ES | Futures | 4610.72 | 4611.55 | 4606.56 | 4607.67 | 3194.0 |
| 2023-05-25 19:30:00 | ES | Futures | 4607.67 | 4608.23 | 4606.29 | 4606.84 | 2391.0 |
| 2023-05-25 20:00:00 | ES | Futures | 4607.12 | 4608.5 | 4605.18 | 4607.95 | 4262.0 |
| 2023-05-25 20:30:00 | ES | Futures | 4608.23 | 4609.06 | 4606.01 | 4609.06 | 2642.0 |
| 2023-05-25 21:00:00 | ES | Futures | 4608.78 | 4609.89 | 4599.63 | 4602.12 | 6171.0 |
| 2023-05-25 21:30:00 | ES | Futures | 4602.12 | 4607.67 | 4601.85 | 4607.39 | 3826.0 |
| 2023-05-25 22:00:00 | ES | Futures | 4607.67 | 4609.34 | 4606.01 | 4606.29 | 3289.0 |
| 2023-05-25 22:30:00 | ES | Futures | 4606.56 | 4606.84 | 4604.34 | 4605.45 | 2016.0 |
| 2023-05-25 23:00:00 | ES | Futures | 4605.73 | 4608.23 | 4605.73 | 4608.23 | 2071.0 |
| 2023-05-25 23:30:00 | ES | Futures | 4607.95 | 4607.95 | 4604.34 | 4605.45 | 2179.0 |
| 2023-05-25 00:00:00 | NQ | Futures | 15583.68 | 15590.44 | 15583.11 | 15586.49 | 882.0 |
| 2023-05-25 00:30:00 | NQ | Futures | 15586.49 | 15587.34 | 15577.2 | 15578.89 | 1049.0 |
| 2023-05-25 01:00:00 | NQ | Futures | 15578.89 | 15586.77 | 15572.7 | 15581.71 | 1844.0 |
| 2023-05-25 01:30:00 | NQ | Futures | 15580.86 | 15591.0 | 15576.36 | 15577.77 | 2288.0 |
> showing 50 of 3,827 rows — these rows as CSV