PREVIEW / futures_30min / 2022-11-03
file: by_date/futures_30min/2022/2022-11-03.parquet size: 116 KB rows: 3,978
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-03 00:00:00 | ES | Futures | 4259.13 | 4261.95 | 4258.85 | 4259.41 | 2918.0 |
| 2022-11-03 00:30:00 | ES | Futures | 4259.69 | 4261.1 | 4255.75 | 4257.72 | 3560.0 |
| 2022-11-03 01:00:00 | ES | Futures | 4257.72 | 4263.64 | 4256.88 | 4262.51 | 3858.0 |
| 2022-11-03 01:30:00 | ES | Futures | 4262.51 | 4265.05 | 4257.72 | 4258.0 | 3315.0 |
| 2022-11-03 02:00:00 | ES | Futures | 4258.0 | 4258.85 | 4247.85 | 4250.67 | 7626.0 |
| 2022-11-03 02:30:00 | ES | Futures | 4250.67 | 4257.44 | 4250.39 | 4253.21 | 4167.0 |
| 2022-11-03 03:00:00 | ES | Futures | 4252.93 | 4259.13 | 4241.93 | 4243.91 | 13077.0 |
| 2022-11-03 03:30:00 | ES | Futures | 4243.91 | 4250.39 | 4242.22 | 4250.11 | 9238.0 |
| 2022-11-03 04:00:00 | ES | Futures | 4250.11 | 4257.72 | 4240.24 | 4243.06 | 23192.0 |
| 2022-11-03 04:30:00 | ES | Futures | 4242.78 | 4245.88 | 4236.58 | 4243.34 | 16871.0 |
| 2022-11-03 05:00:00 | ES | Futures | 4243.06 | 4248.7 | 4237.99 | 4245.32 | 11196.0 |
| 2022-11-03 05:30:00 | ES | Futures | 4245.6 | 4246.16 | 4233.2 | 4241.09 | 11817.0 |
| 2022-11-03 06:00:00 | ES | Futures | 4241.09 | 4244.19 | 4225.3 | 4226.15 | 15380.0 |
| 2022-11-03 06:30:00 | ES | Futures | 4226.15 | 4227.84 | 4219.1 | 4224.46 | 17181.0 |
| 2022-11-03 07:00:00 | ES | Futures | 4224.18 | 4225.58 | 4217.97 | 4219.67 | 15688.0 |
| 2022-11-03 07:30:00 | ES | Futures | 4219.67 | 4223.33 | 4211.77 | 4216.0 | 19111.0 |
| 2022-11-03 08:00:00 | ES | Futures | 4216.0 | 4225.3 | 4212.9 | 4216.0 | 23725.0 |
| 2022-11-03 08:30:00 | ES | Futures | 4215.72 | 4219.67 | 4202.75 | 4204.16 | 32588.0 |
| 2022-11-03 09:00:00 | ES | Futures | 4204.16 | 4212.34 | 4201.62 | 4208.11 | 38179.0 |
| 2022-11-03 09:30:00 | ES | Futures | 4208.11 | 4216.56 | 4179.92 | 4181.61 | 238457.0 |
| 2022-11-03 10:00:00 | ES | Futures | 4181.61 | 4222.77 | 4176.82 | 4220.23 | 212403.0 |
| 2022-11-03 10:30:00 | ES | Futures | 4220.23 | 4231.5 | 4203.88 | 4230.1 | 135967.0 |
| 2022-11-03 11:00:00 | ES | Futures | 4230.1 | 4232.63 | 4210.08 | 4210.08 | 117073.0 |
| 2022-11-03 11:30:00 | ES | Futures | 4210.08 | 4221.92 | 4202.19 | 4210.08 | 96948.0 |
| 2022-11-03 12:00:00 | ES | Futures | 4210.36 | 4230.94 | 4206.13 | 4225.58 | 87673.0 |
| 2022-11-03 12:30:00 | ES | Futures | 4225.58 | 4237.99 | 4216.85 | 4234.04 | 79602.0 |
| 2022-11-03 13:00:00 | ES | Futures | 4234.04 | 4236.3 | 4220.23 | 4223.61 | 60677.0 |
| 2022-11-03 13:30:00 | ES | Futures | 4223.33 | 4226.15 | 4215.72 | 4216.0 | 51529.0 |
| 2022-11-03 14:00:00 | ES | Futures | 4216.28 | 4229.81 | 4211.49 | 4227.84 | 58684.0 |
| 2022-11-03 14:30:00 | ES | Futures | 4228.12 | 4232.07 | 4219.95 | 4230.66 | 59660.0 |
| 2022-11-03 15:00:00 | ES | Futures | 4230.66 | 4231.5 | 4222.2 | 4227.28 | 62202.0 |
| 2022-11-03 15:30:00 | ES | Futures | 4227.28 | 4230.66 | 4201.06 | 4201.62 | 156230.0 |
| 2022-11-03 16:00:00 | ES | Futures | 4201.62 | 4207.54 | 4200.78 | 4204.72 | 51493.0 |
| 2022-11-03 16:30:00 | ES | Futures | 4204.72 | 4205.57 | 4199.65 | 4200.78 | 8573.0 |
| 2022-11-03 18:00:00 | ES | Futures | 4199.09 | 4200.21 | 4189.78 | 4196.27 | 8420.0 |
| 2022-11-03 18:30:00 | ES | Futures | 4196.27 | 4197.96 | 4194.01 | 4195.14 | 2654.0 |
| 2022-11-03 19:00:00 | ES | Futures | 4195.42 | 4197.11 | 4194.01 | 4195.99 | 2368.0 |
| 2022-11-03 19:30:00 | ES | Futures | 4195.7 | 4196.55 | 4192.32 | 4195.7 | 2913.0 |
| 2022-11-03 20:00:00 | ES | Futures | 4195.7 | 4203.03 | 4195.7 | 4198.81 | 6034.0 |
| 2022-11-03 20:30:00 | ES | Futures | 4198.81 | 4201.34 | 4197.96 | 4200.5 | 3125.0 |
| 2022-11-03 21:00:00 | ES | Futures | 4200.78 | 4201.34 | 4194.86 | 4196.27 | 5119.0 |
| 2022-11-03 21:30:00 | ES | Futures | 4196.27 | 4202.75 | 4196.27 | 4202.47 | 5295.0 |
| 2022-11-03 22:00:00 | ES | Futures | 4202.47 | 4204.16 | 4200.5 | 4204.16 | 3697.0 |
| 2022-11-03 22:30:00 | ES | Futures | 4204.16 | 4204.44 | 4200.21 | 4202.47 | 3997.0 |
| 2022-11-03 23:00:00 | ES | Futures | 4202.19 | 4204.16 | 4200.5 | 4203.6 | 3384.0 |
| 2022-11-03 23:30:00 | ES | Futures | 4203.88 | 4204.16 | 4202.19 | 4203.88 | 2741.0 |
| 2022-11-03 00:00:00 | NQ | Futures | 12619.35 | 12627.4 | 12615.33 | 12618.2 | 1702.0 |
| 2022-11-03 00:30:00 | NQ | Futures | 12618.2 | 12623.66 | 12606.71 | 12614.76 | 1570.0 |
| 2022-11-03 01:00:00 | NQ | Futures | 12615.62 | 12633.43 | 12611.88 | 12628.26 | 1880.0 |
| 2022-11-03 01:30:00 | NQ | Futures | 12628.55 | 12637.74 | 12611.88 | 12614.76 | 2348.0 |
> showing 50 of 3,978 rows — these rows as CSV