PREVIEW / futures_30min / 2023-04-19
file: by_date/futures_30min/2023/2023-04-19.parquet size: 106 KB rows: 3,826
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-04-19 00:00:00 | ES | Futures | 4631.52 | 4631.8 | 4630.41 | 4631.25 | 867.0 |
| 2023-04-19 00:30:00 | ES | Futures | 4631.25 | 4631.25 | 4630.41 | 4630.69 | 821.0 |
| 2023-04-19 01:00:00 | ES | Futures | 4630.69 | 4631.25 | 4629.31 | 4629.58 | 2415.0 |
| 2023-04-19 01:30:00 | ES | Futures | 4629.86 | 4630.41 | 4629.03 | 4629.31 | 2432.0 |
| 2023-04-19 02:00:00 | ES | Futures | 4629.31 | 4629.86 | 4619.6 | 4621.82 | 9988.0 |
| 2023-04-19 02:30:00 | ES | Futures | 4621.82 | 4625.15 | 4621.82 | 4623.2 | 4057.0 |
| 2023-04-19 03:00:00 | ES | Futures | 4623.2 | 4624.87 | 4620.71 | 4623.48 | 9752.0 |
| 2023-04-19 03:30:00 | ES | Futures | 4623.48 | 4624.31 | 4618.21 | 4622.65 | 7540.0 |
| 2023-04-19 04:00:00 | ES | Futures | 4622.37 | 4623.76 | 4613.22 | 4618.21 | 10109.0 |
| 2023-04-19 04:30:00 | ES | Futures | 4618.49 | 4619.6 | 4616.55 | 4617.66 | 5356.0 |
| 2023-04-19 05:00:00 | ES | Futures | 4617.38 | 4617.38 | 4609.89 | 4613.22 | 11435.0 |
| 2023-04-19 05:30:00 | ES | Futures | 4613.22 | 4614.05 | 4607.12 | 4609.06 | 8545.0 |
| 2023-04-19 06:00:00 | ES | Futures | 4609.06 | 4612.11 | 4607.67 | 4612.11 | 5802.0 |
| 2023-04-19 06:30:00 | ES | Futures | 4612.39 | 4614.61 | 4609.06 | 4614.33 | 7593.0 |
| 2023-04-19 07:00:00 | ES | Futures | 4614.33 | 4614.61 | 4611.0 | 4613.77 | 9864.0 |
| 2023-04-19 07:30:00 | ES | Futures | 4614.05 | 4617.1 | 4610.45 | 4611.83 | 14127.0 |
| 2023-04-19 08:00:00 | ES | Futures | 4611.83 | 4612.11 | 4606.84 | 4611.28 | 17086.0 |
| 2023-04-19 08:30:00 | ES | Futures | 4611.0 | 4611.28 | 4604.62 | 4607.67 | 16686.0 |
| 2023-04-19 09:00:00 | ES | Futures | 4607.67 | 4614.05 | 4607.67 | 4613.22 | 25869.0 |
| 2023-04-19 09:30:00 | ES | Futures | 4613.5 | 4618.77 | 4612.66 | 4614.05 | 154121.0 |
| 2023-04-19 10:00:00 | ES | Futures | 4614.33 | 4622.93 | 4613.22 | 4621.82 | 104967.0 |
| 2023-04-19 10:30:00 | ES | Futures | 4621.82 | 4628.75 | 4620.43 | 4625.42 | 94588.0 |
| 2023-04-19 11:00:00 | ES | Futures | 4625.7 | 4628.75 | 4622.65 | 4625.42 | 79439.0 |
| 2023-04-19 11:30:00 | ES | Futures | 4625.15 | 4630.97 | 4621.54 | 4630.14 | 66133.0 |
| 2023-04-19 12:00:00 | ES | Futures | 4630.14 | 4632.91 | 4627.92 | 4632.36 | 49074.0 |
| 2023-04-19 12:30:00 | ES | Futures | 4632.36 | 4635.68 | 4631.8 | 4633.74 | 45153.0 |
| 2023-04-19 13:00:00 | ES | Futures | 4634.02 | 4638.46 | 4631.25 | 4636.52 | 67165.0 |
| 2023-04-19 13:30:00 | ES | Futures | 4636.52 | 4640.12 | 4633.47 | 4639.29 | 46871.0 |
| 2023-04-19 14:00:00 | ES | Futures | 4639.57 | 4645.67 | 4635.96 | 4639.57 | 73562.0 |
| 2023-04-19 14:30:00 | ES | Futures | 4639.84 | 4640.68 | 4635.13 | 4639.57 | 47605.0 |
| 2023-04-19 15:00:00 | ES | Futures | 4639.57 | 4642.34 | 4636.52 | 4639.01 | 47438.0 |
| 2023-04-19 15:30:00 | ES | Futures | 4639.01 | 4640.68 | 4629.03 | 4635.68 | 120899.0 |
| 2023-04-19 16:00:00 | ES | Futures | 4635.41 | 4635.96 | 4629.03 | 4631.8 | 44823.0 |
| 2023-04-19 16:30:00 | ES | Futures | 4631.8 | 4632.08 | 4629.58 | 4630.14 | 13147.0 |
| 2023-04-19 18:00:00 | ES | Futures | 4628.75 | 4629.58 | 4624.04 | 4625.7 | 4282.0 |
| 2023-04-19 18:30:00 | ES | Futures | 4625.7 | 4625.7 | 4623.48 | 4625.15 | 2496.0 |
| 2023-04-19 19:00:00 | ES | Futures | 4624.87 | 4625.7 | 4623.2 | 4624.87 | 2159.0 |
| 2023-04-19 19:30:00 | ES | Futures | 4624.59 | 4624.59 | 4620.98 | 4621.82 | 3338.0 |
| 2023-04-19 20:00:00 | ES | Futures | 4622.09 | 4626.25 | 4621.54 | 4625.42 | 4558.0 |
| 2023-04-19 20:30:00 | ES | Futures | 4625.7 | 4626.25 | 4624.04 | 4625.42 | 2072.0 |
| 2023-04-19 21:00:00 | ES | Futures | 4625.42 | 4626.25 | 4623.76 | 4624.59 | 2463.0 |
| 2023-04-19 21:30:00 | ES | Futures | 4624.87 | 4628.47 | 4624.59 | 4627.64 | 4830.0 |
| 2023-04-19 22:00:00 | ES | Futures | 4627.36 | 4630.14 | 4625.42 | 4625.98 | 3692.0 |
| 2023-04-19 22:30:00 | ES | Futures | 4626.25 | 4626.25 | 4623.76 | 4624.87 | 2421.0 |
| 2023-04-19 23:00:00 | ES | Futures | 4624.59 | 4624.87 | 4622.93 | 4624.59 | 2096.0 |
| 2023-04-19 23:30:00 | ES | Futures | 4624.31 | 4627.36 | 4624.31 | 4627.09 | 2183.0 |
| 2023-04-19 00:00:00 | NQ | Futures | 14833.34 | 14833.9 | 14826.58 | 14830.52 | 778.0 |
| 2023-04-19 00:30:00 | NQ | Futures | 14830.52 | 14831.93 | 14824.33 | 14826.02 | 705.0 |
| 2023-04-19 01:00:00 | NQ | Futures | 14826.02 | 14829.12 | 14818.7 | 14822.08 | 1526.0 |
| 2023-04-19 01:30:00 | NQ | Futures | 14822.08 | 14824.33 | 14816.16 | 14817.01 | 1266.0 |
> showing 50 of 3,826 rows — these rows as CSV