PREVIEW / futures_30min / 2022-11-04
file: by_date/futures_30min/2022/2022-11-04.parquet size: 102 KB rows: 3,288
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-11-04 00:00:00 | ES | Futures | 4203.88 | 4207.83 | 4202.75 | 4204.72 | 4649.0 |
| 2022-11-04 00:30:00 | ES | Futures | 4204.72 | 4215.15 | 4204.44 | 4213.46 | 9258.0 |
| 2022-11-04 01:00:00 | ES | Futures | 4213.46 | 4217.41 | 4210.93 | 4214.87 | 7536.0 |
| 2022-11-04 01:30:00 | ES | Futures | 4214.87 | 4216.0 | 4210.64 | 4210.64 | 4287.0 |
| 2022-11-04 02:00:00 | ES | Futures | 4210.93 | 4218.26 | 4210.08 | 4216.56 | 5100.0 |
| 2022-11-04 02:30:00 | ES | Futures | 4216.56 | 4228.4 | 4214.03 | 4224.18 | 11803.0 |
| 2022-11-04 03:00:00 | ES | Futures | 4223.89 | 4226.99 | 4212.05 | 4213.75 | 6942.0 |
| 2022-11-04 03:30:00 | ES | Futures | 4213.18 | 4219.95 | 4207.83 | 4210.93 | 10089.0 |
| 2022-11-04 04:00:00 | ES | Futures | 4210.64 | 4222.77 | 4208.67 | 4216.0 | 14676.0 |
| 2022-11-04 04:30:00 | ES | Futures | 4215.72 | 4224.18 | 4212.05 | 4223.61 | 10632.0 |
| 2022-11-04 05:00:00 | ES | Futures | 4223.33 | 4236.86 | 4221.36 | 4231.79 | 23775.0 |
| 2022-11-04 05:30:00 | ES | Futures | 4231.5 | 4233.48 | 4229.25 | 4230.66 | 8408.0 |
| 2022-11-04 06:00:00 | ES | Futures | 4230.38 | 4234.61 | 4226.43 | 4232.63 | 9866.0 |
| 2022-11-04 06:30:00 | ES | Futures | 4232.63 | 4240.81 | 4232.63 | 4237.42 | 10767.0 |
| 2022-11-04 07:00:00 | ES | Futures | 4237.42 | 4246.73 | 4232.63 | 4233.48 | 21866.0 |
| 2022-11-04 07:30:00 | ES | Futures | 4233.48 | 4239.68 | 4230.66 | 4238.83 | 13216.0 |
| 2022-11-04 08:00:00 | ES | Futures | 4238.83 | 4238.83 | 4223.05 | 4227.56 | 24835.0 |
| 2022-11-04 08:30:00 | ES | Futures | 4227.28 | 4256.31 | 4184.43 | 4254.06 | 126368.0 |
| 2022-11-04 09:00:00 | ES | Futures | 4254.34 | 4270.41 | 4253.49 | 4269.56 | 75688.0 |
| 2022-11-04 09:30:00 | ES | Futures | 4269.28 | 4273.51 | 4215.15 | 4247.85 | 274395.0 |
| 2022-11-04 10:00:00 | ES | Futures | 4247.85 | 4281.96 | 4243.34 | 4277.17 | 213960.0 |
| 2022-11-04 10:30:00 | ES | Futures | 4277.17 | 4290.98 | 4262.79 | 4267.59 | 158290.0 |
| 2022-11-04 11:00:00 | ES | Futures | 4267.59 | 4274.35 | 4236.3 | 4238.27 | 137213.0 |
| 2022-11-04 11:30:00 | ES | Futures | 4238.27 | 4245.32 | 4198.81 | 4201.06 | 167746.0 |
| 2022-11-04 12:00:00 | ES | Futures | 4201.06 | 4223.89 | 4190.63 | 4220.79 | 165699.0 |
| 2022-11-04 12:30:00 | ES | Futures | 4220.79 | 4223.33 | 4197.4 | 4204.16 | 111910.0 |
| 2022-11-04 13:00:00 | ES | Futures | 4204.44 | 4213.46 | 4191.19 | 4202.47 | 104978.0 |
| 2022-11-04 13:30:00 | ES | Futures | 4202.75 | 4208.11 | 4195.42 | 4198.52 | 67783.0 |
| 2022-11-04 14:00:00 | ES | Futures | 4198.24 | 4218.82 | 4189.22 | 4215.15 | 91057.0 |
| 2022-11-04 14:30:00 | ES | Futures | 4215.15 | 4237.42 | 4210.93 | 4234.61 | 101262.0 |
| 2022-11-04 15:00:00 | ES | Futures | 4234.61 | 4249.55 | 4230.38 | 4241.37 | 108839.0 |
| 2022-11-04 15:30:00 | ES | Futures | 4241.37 | 4263.92 | 4235.45 | 4262.51 | 209492.0 |
| 2022-11-04 16:00:00 | ES | Futures | 4262.51 | 4268.15 | 4255.47 | 4258.0 | 57380.0 |
| 2022-11-04 16:30:00 | ES | Futures | 4258.0 | 4258.28 | 4251.24 | 4254.06 | 8142.0 |
| 2022-11-04 00:00:00 | NQ | Futures | 12349.84 | 12368.23 | 12346.39 | 12359.04 | 1674.0 |
| 2022-11-04 00:30:00 | NQ | Futures | 12359.04 | 12391.5 | 12358.17 | 12384.61 | 3524.0 |
| 2022-11-04 01:00:00 | NQ | Futures | 12384.32 | 12404.72 | 12378.57 | 12395.24 | 3270.0 |
| 2022-11-04 01:30:00 | NQ | Futures | 12395.81 | 12399.26 | 12376.56 | 12378.86 | 2213.0 |
| 2022-11-04 02:00:00 | NQ | Futures | 12380.3 | 12403.57 | 12375.13 | 12398.69 | 2063.0 |
| 2022-11-04 02:30:00 | NQ | Futures | 12398.4 | 12445.81 | 12390.64 | 12428.86 | 5612.0 |
| 2022-11-04 03:00:00 | NQ | Futures | 12428.57 | 12439.77 | 12383.17 | 12389.78 | 5455.0 |
| 2022-11-04 03:30:00 | NQ | Futures | 12389.2 | 12409.61 | 12355.01 | 12363.35 | 7165.0 |
| 2022-11-04 04:00:00 | NQ | Futures | 12363.35 | 12399.55 | 12354.44 | 12376.85 | 6822.0 |
| 2022-11-04 04:30:00 | NQ | Futures | 12376.28 | 12400.41 | 12363.06 | 12398.4 | 4668.0 |
| 2022-11-04 05:00:00 | NQ | Futures | 12399.26 | 12448.68 | 12393.8 | 12424.55 | 9886.0 |
| 2022-11-04 05:30:00 | NQ | Futures | 12424.83 | 12430.01 | 12413.05 | 12418.22 | 4276.0 |
| 2022-11-04 06:00:00 | NQ | Futures | 12418.22 | 12434.6 | 12404.15 | 12423.4 | 4645.0 |
| 2022-11-04 06:30:00 | NQ | Futures | 12423.4 | 12445.23 | 12422.53 | 12433.74 | 3829.0 |
| 2022-11-04 07:00:00 | NQ | Futures | 12434.03 | 12463.34 | 12416.5 | 12423.68 | 8919.0 |
| 2022-11-04 07:30:00 | NQ | Futures | 12422.53 | 12437.76 | 12410.18 | 12432.02 | 5036.0 |
> showing 50 of 3,288 rows — these rows as CSV