PREVIEW / futures_30min / 2022-07-25
file: by_date/futures_30min/2022/2022-07-25.parquet size: 110 KB rows: 3,868
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 |
|---|---|---|---|---|---|---|---|
| 2022-07-25 00:00:00 | ES | Futures | 4488.44 | 4488.44 | 4485.6 | 4487.87 | 1190.0 |
| 2022-07-25 00:30:00 | ES | Futures | 4487.59 | 4490.14 | 4486.74 | 4486.74 | 1717.0 |
| 2022-07-25 01:00:00 | ES | Futures | 4487.02 | 4488.15 | 4483.62 | 4485.04 | 2086.0 |
| 2022-07-25 01:30:00 | ES | Futures | 4485.32 | 4486.45 | 4481.07 | 4484.19 | 2503.0 |
| 2022-07-25 02:00:00 | ES | Futures | 4484.47 | 4490.14 | 4481.92 | 4482.77 | 4093.0 |
| 2022-07-25 02:30:00 | ES | Futures | 4482.77 | 4489.0 | 4482.2 | 4488.72 | 3308.0 |
| 2022-07-25 03:00:00 | ES | Futures | 4488.72 | 4493.25 | 4478.24 | 4486.45 | 13321.0 |
| 2022-07-25 03:30:00 | ES | Futures | 4486.17 | 4491.55 | 4482.49 | 4486.45 | 4381.0 |
| 2022-07-25 04:00:00 | ES | Futures | 4486.74 | 4496.37 | 4485.6 | 4494.1 | 7290.0 |
| 2022-07-25 04:30:00 | ES | Futures | 4494.1 | 4504.3 | 4493.25 | 4501.18 | 6798.0 |
| 2022-07-25 05:00:00 | ES | Futures | 4501.18 | 4509.4 | 4500.62 | 4506.0 | 8030.0 |
| 2022-07-25 05:30:00 | ES | Futures | 4506.28 | 4515.06 | 4505.72 | 4514.5 | 6681.0 |
| 2022-07-25 06:00:00 | ES | Futures | 4514.5 | 4515.91 | 4510.25 | 4514.21 | 5678.0 |
| 2022-07-25 06:30:00 | ES | Futures | 4513.93 | 4517.05 | 4511.38 | 4517.05 | 5981.0 |
| 2022-07-25 07:00:00 | ES | Futures | 4517.05 | 4519.6 | 4511.95 | 4517.05 | 7041.0 |
| 2022-07-25 07:30:00 | ES | Futures | 4517.05 | 4519.6 | 4509.12 | 4512.51 | 10766.0 |
| 2022-07-25 08:00:00 | ES | Futures | 4512.51 | 4515.91 | 4511.67 | 4512.23 | 9185.0 |
| 2022-07-25 08:30:00 | ES | Futures | 4512.51 | 4513.36 | 4504.58 | 4507.42 | 13974.0 |
| 2022-07-25 09:00:00 | ES | Futures | 4507.42 | 4509.68 | 4499.48 | 4499.77 | 16185.0 |
| 2022-07-25 09:30:00 | ES | Futures | 4499.77 | 4503.45 | 4480.51 | 4497.22 | 170363.0 |
| 2022-07-25 10:00:00 | ES | Futures | 4497.5 | 4501.47 | 4476.82 | 4487.59 | 164246.0 |
| 2022-07-25 10:30:00 | ES | Futures | 4487.59 | 4499.48 | 4478.52 | 4494.1 | 109136.0 |
| 2022-07-25 11:00:00 | ES | Futures | 4494.1 | 4500.05 | 4483.34 | 4498.92 | 94213.0 |
| 2022-07-25 11:30:00 | ES | Futures | 4498.92 | 4506.28 | 4497.5 | 4501.75 | 72881.0 |
| 2022-07-25 12:00:00 | ES | Futures | 4502.03 | 4504.58 | 4488.15 | 4494.95 | 59380.0 |
| 2022-07-25 12:30:00 | ES | Futures | 4494.95 | 4508.55 | 4494.39 | 4500.62 | 65753.0 |
| 2022-07-25 13:00:00 | ES | Futures | 4500.9 | 4506.85 | 4496.37 | 4496.65 | 49932.0 |
| 2022-07-25 13:30:00 | ES | Futures | 4496.37 | 4498.35 | 4485.32 | 4485.6 | 62905.0 |
| 2022-07-25 14:00:00 | ES | Futures | 4485.89 | 4488.72 | 4480.79 | 4483.05 | 61922.0 |
| 2022-07-25 14:30:00 | ES | Futures | 4483.34 | 4488.44 | 4476.26 | 4477.96 | 75416.0 |
| 2022-07-25 15:00:00 | ES | Futures | 4477.96 | 4482.77 | 4471.16 | 4475.69 | 82912.0 |
| 2022-07-25 15:30:00 | ES | Futures | 4475.97 | 4500.9 | 4474.27 | 4498.35 | 152551.0 |
| 2022-07-25 16:00:00 | ES | Futures | 4498.35 | 4504.87 | 4489.0 | 4489.85 | 54548.0 |
| 2022-07-25 16:30:00 | ES | Futures | 4489.85 | 4492.12 | 4488.15 | 4489.57 | 9494.0 |
| 2022-07-25 18:00:00 | ES | Futures | 4485.89 | 4486.45 | 4481.07 | 4483.05 | 4073.0 |
| 2022-07-25 18:30:00 | ES | Futures | 4482.77 | 4486.74 | 4482.2 | 4485.04 | 2453.0 |
| 2022-07-25 19:00:00 | ES | Futures | 4485.04 | 4485.89 | 4479.66 | 4480.79 | 1797.0 |
| 2022-07-25 19:30:00 | ES | Futures | 4480.79 | 4482.77 | 4479.66 | 4482.49 | 3172.0 |
| 2022-07-25 20:00:00 | ES | Futures | 4482.77 | 4484.75 | 4478.52 | 4481.35 | 5003.0 |
| 2022-07-25 20:30:00 | ES | Futures | 4481.35 | 4481.64 | 4475.69 | 4478.52 | 4102.0 |
| 2022-07-25 21:00:00 | ES | Futures | 4478.24 | 4486.74 | 4478.24 | 4485.89 | 3879.0 |
| 2022-07-25 21:30:00 | ES | Futures | 4486.17 | 4487.02 | 4481.35 | 4482.49 | 3435.0 |
| 2022-07-25 22:00:00 | ES | Futures | 4482.49 | 4484.47 | 4479.66 | 4483.62 | 2264.0 |
| 2022-07-25 22:30:00 | ES | Futures | 4483.62 | 4489.57 | 4481.92 | 4486.45 | 3260.0 |
| 2022-07-25 23:00:00 | ES | Futures | 4486.74 | 4489.0 | 4485.89 | 4487.87 | 1889.0 |
| 2022-07-25 23:30:00 | ES | Futures | 4487.87 | 4488.44 | 4484.47 | 4486.45 | 1572.0 |
| 2022-07-25 00:00:00 | NQ | Futures | 14365.06 | 14369.4 | 14358.98 | 14367.08 | 561.0 |
| 2022-07-25 00:30:00 | NQ | Futures | 14367.08 | 14377.49 | 14364.19 | 14365.35 | 914.0 |
| 2022-07-25 01:00:00 | NQ | Futures | 14364.77 | 14369.11 | 14352.04 | 14356.67 | 1054.0 |
| 2022-07-25 01:30:00 | NQ | Futures | 14356.96 | 14361.59 | 14341.05 | 14354.93 | 1488.0 |
> showing 50 of 3,868 rows — these rows as CSV