PREVIEW / futures_1hour / 2022-05-18
file: by_date/futures_1hour/2022/2022-05-18.parquet size: 71 KB rows: 2,079
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-05-18 00:00:00 | ES | Futures | 4617.52 | 4622.63 | 4614.97 | 4616.67 | 5927.0 |
| 2022-05-18 01:00:00 | ES | Futures | 4616.96 | 4628.01 | 4616.39 | 4626.88 | 8670.0 |
| 2022-05-18 02:00:00 | ES | Futures | 4626.88 | 4629.43 | 4617.24 | 4618.37 | 8671.0 |
| 2022-05-18 03:00:00 | ES | Futures | 4618.66 | 4619.79 | 4608.17 | 4613.27 | 18710.0 |
| 2022-05-18 04:00:00 | ES | Futures | 4613.56 | 4618.37 | 4608.74 | 4614.69 | 10862.0 |
| 2022-05-18 05:00:00 | ES | Futures | 4614.41 | 4624.04 | 4611.86 | 4623.76 | 9354.0 |
| 2022-05-18 06:00:00 | ES | Futures | 4624.04 | 4626.88 | 4608.74 | 4610.72 | 18430.0 |
| 2022-05-18 07:00:00 | ES | Futures | 4610.72 | 4612.99 | 4592.01 | 4593.15 | 35841.0 |
| 2022-05-18 08:00:00 | ES | Futures | 4593.43 | 4604.77 | 4578.13 | 4578.69 | 45528.0 |
| 2022-05-18 09:00:00 | ES | Futures | 4578.98 | 4583.51 | 4548.65 | 4552.05 | 213391.0 |
| 2022-05-18 10:00:00 | ES | Futures | 4551.77 | 4562.54 | 4538.16 | 4546.95 | 243090.0 |
| 2022-05-18 11:00:00 | ES | Futures | 4547.23 | 4547.51 | 4496.21 | 4498.76 | 252600.0 |
| 2022-05-18 12:00:00 | ES | Futures | 4498.76 | 4506.42 | 4484.31 | 4505.28 | 206940.0 |
| 2022-05-18 13:00:00 | ES | Futures | 4505.0 | 4505.28 | 4452.85 | 4459.36 | 209371.0 |
| 2022-05-18 14:00:00 | ES | Futures | 4459.08 | 4469.29 | 4441.22 | 4444.63 | 220770.0 |
| 2022-05-18 15:00:00 | ES | Futures | 4444.34 | 4456.25 | 4430.74 | 4448.59 | 441059.0 |
| 2022-05-18 16:00:00 | ES | Futures | 4448.59 | 4452.85 | 4427.9 | 4437.54 | 108165.0 |
| 2022-05-18 18:00:00 | ES | Futures | 4440.37 | 4444.06 | 4435.84 | 4441.22 | 9396.0 |
| 2022-05-18 19:00:00 | ES | Futures | 4441.51 | 4442.64 | 4419.4 | 4419.97 | 13874.0 |
| 2022-05-18 20:00:00 | ES | Futures | 4419.68 | 4434.14 | 4415.43 | 4427.34 | 16141.0 |
| 2022-05-18 21:00:00 | ES | Futures | 4427.62 | 4433.0 | 4417.7 | 4426.2 | 14216.0 |
| 2022-05-18 22:00:00 | ES | Futures | 4426.49 | 4446.04 | 4425.64 | 4445.48 | 15437.0 |
| 2022-05-18 23:00:00 | ES | Futures | 4445.19 | 4459.36 | 4444.34 | 4455.4 | 25759.0 |
| 2022-05-18 00:00:00 | NQ | Futures | 14499.91 | 14519.63 | 14484.83 | 14491.79 | 3490.0 |
| 2022-05-18 01:00:00 | NQ | Futures | 14492.08 | 14535.29 | 14489.76 | 14531.52 | 4741.0 |
| 2022-05-18 02:00:00 | NQ | Futures | 14532.1 | 14545.15 | 14504.84 | 14508.9 | 4488.0 |
| 2022-05-18 03:00:00 | NQ | Futures | 14508.9 | 14516.44 | 14466.28 | 14489.18 | 10170.0 |
| 2022-05-18 04:00:00 | NQ | Futures | 14489.18 | 14502.52 | 14451.78 | 14475.55 | 8197.0 |
| 2022-05-18 05:00:00 | NQ | Futures | 14475.55 | 14512.38 | 14465.7 | 14511.51 | 4870.0 |
| 2022-05-18 06:00:00 | NQ | Futures | 14512.67 | 14526.59 | 14457.58 | 14478.16 | 8591.0 |
| 2022-05-18 07:00:00 | NQ | Futures | 14478.45 | 14486.28 | 14392.62 | 14399.58 | 16812.0 |
| 2022-05-18 08:00:00 | NQ | Futures | 14401.32 | 14437.86 | 14340.72 | 14344.2 | 22062.0 |
| 2022-05-18 09:00:00 | NQ | Futures | 14343.33 | 14382.47 | 14254.88 | 14266.19 | 83576.0 |
| 2022-05-18 10:00:00 | NQ | Futures | 14266.19 | 14336.66 | 14220.38 | 14269.96 | 87445.0 |
| 2022-05-18 11:00:00 | NQ | Futures | 14269.96 | 14271.12 | 14049.58 | 14056.83 | 96428.0 |
| 2022-05-18 12:00:00 | NQ | Futures | 14057.41 | 14075.1 | 13984.34 | 14072.78 | 70070.0 |
| 2022-05-18 13:00:00 | NQ | Futures | 14072.49 | 14073.65 | 13868.64 | 13892.12 | 68446.0 |
| 2022-05-18 14:00:00 | NQ | Futures | 13892.12 | 13929.24 | 13823.11 | 13835.87 | 71641.0 |
| 2022-05-18 15:00:00 | NQ | Futures | 13835.58 | 13895.02 | 13788.31 | 13850.08 | 106880.0 |
| 2022-05-18 16:00:00 | NQ | Futures | 13850.08 | 13863.13 | 13759.61 | 13794.11 | 31392.0 |
| 2022-05-18 18:00:00 | NQ | Futures | 13810.93 | 13832.97 | 13785.41 | 13812.09 | 5321.0 |
| 2022-05-18 19:00:00 | NQ | Futures | 13810.64 | 13814.7 | 13712.63 | 13717.56 | 7688.0 |
| 2022-05-18 20:00:00 | NQ | Futures | 13717.27 | 13772.94 | 13695.23 | 13750.91 | 6969.0 |
| 2022-05-18 21:00:00 | NQ | Futures | 13751.49 | 13772.36 | 13712.05 | 13742.79 | 5682.0 |
| 2022-05-18 22:00:00 | NQ | Futures | 13743.08 | 13816.73 | 13736.12 | 13814.7 | 6160.0 |
| 2022-05-18 23:00:00 | NQ | Futures | 13814.7 | 13864.87 | 13809.77 | 13847.47 | 10279.0 |
| 2022-05-18 00:00:00 | YM | Futures | 36652.9 | 36691.2 | 36641.6 | 36657.4 | 783.0 |
| 2022-05-18 01:00:00 | YM | Futures | 36658.5 | 36731.8 | 36656.3 | 36725.1 | 948.0 |
| 2022-05-18 02:00:00 | YM | Futures | 36727.3 | 36740.8 | 36649.5 | 36658.5 | 1410.0 |
| 2022-05-18 03:00:00 | YM | Futures | 36658.5 | 36669.8 | 36584.1 | 36621.3 | 4224.0 |
> showing 50 of 2,079 rows — these rows as CSV