PREVIEW / futures_1hour / 2022-10-17
file: by_date/futures_1hour/2022/2022-10-17.parquet size: 68 KB rows: 2,056
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-10-17 00:00:00 | ES | Futures | 4073.08 | 4075.9 | 4070.54 | 4075.05 | 8676.0 |
| 2022-10-17 01:00:00 | ES | Futures | 4074.77 | 4090.28 | 4074.49 | 4086.61 | 17627.0 |
| 2022-10-17 02:00:00 | ES | Futures | 4086.61 | 4091.97 | 4083.51 | 4086.89 | 25816.0 |
| 2022-10-17 03:00:00 | ES | Futures | 4086.89 | 4104.37 | 4077.87 | 4099.01 | 37833.0 |
| 2022-10-17 04:00:00 | ES | Futures | 4099.01 | 4100.42 | 4085.48 | 4093.38 | 15916.0 |
| 2022-10-17 05:00:00 | ES | Futures | 4093.66 | 4103.53 | 4090.56 | 4102.4 | 11663.0 |
| 2022-10-17 06:00:00 | ES | Futures | 4102.12 | 4113.67 | 4099.58 | 4108.04 | 18756.0 |
| 2022-10-17 07:00:00 | ES | Futures | 4108.04 | 4110.57 | 4100.42 | 4105.78 | 18300.0 |
| 2022-10-17 08:00:00 | ES | Futures | 4105.78 | 4116.21 | 4097.61 | 4114.24 | 53513.0 |
| 2022-10-17 09:00:00 | ES | Futures | 4114.24 | 4167.8 | 4114.24 | 4150.32 | 317177.0 |
| 2022-10-17 10:00:00 | ES | Futures | 4150.6 | 4174.84 | 4139.33 | 4145.53 | 337320.0 |
| 2022-10-17 11:00:00 | ES | Futures | 4145.81 | 4169.21 | 4136.22 | 4162.16 | 185640.0 |
| 2022-10-17 12:00:00 | ES | Futures | 4162.44 | 4170.33 | 4151.17 | 4157.65 | 151012.0 |
| 2022-10-17 13:00:00 | ES | Futures | 4157.93 | 4171.46 | 4151.17 | 4168.36 | 121542.0 |
| 2022-10-17 14:00:00 | ES | Futures | 4168.36 | 4174.56 | 4155.11 | 4161.31 | 145924.0 |
| 2022-10-17 15:00:00 | ES | Futures | 4161.31 | 4170.05 | 4154.27 | 4160.75 | 285191.0 |
| 2022-10-17 16:00:00 | ES | Futures | 4161.03 | 4174.56 | 4159.06 | 4171.46 | 63836.0 |
| 2022-10-17 18:00:00 | ES | Futures | 4179.07 | 4191.19 | 4178.79 | 4186.97 | 15168.0 |
| 2022-10-17 19:00:00 | ES | Futures | 4186.97 | 4197.4 | 4186.4 | 4194.58 | 13705.0 |
| 2022-10-17 20:00:00 | ES | Futures | 4194.29 | 4195.14 | 4188.38 | 4193.17 | 12795.0 |
| 2022-10-17 21:00:00 | ES | Futures | 4193.17 | 4194.86 | 4185.84 | 4187.53 | 11057.0 |
| 2022-10-17 22:00:00 | ES | Futures | 4187.81 | 4187.81 | 4184.15 | 4186.68 | 7076.0 |
| 2022-10-17 23:00:00 | ES | Futures | 4186.68 | 4225.87 | 4186.4 | 4219.95 | 31689.0 |
| 2022-10-17 00:00:00 | NQ | Futures | 12394.66 | 12403.28 | 12384.9 | 12400.12 | 7832.0 |
| 2022-10-17 01:00:00 | NQ | Futures | 12398.69 | 12470.23 | 12397.25 | 12458.45 | 12850.0 |
| 2022-10-17 02:00:00 | NQ | Futures | 12457.3 | 12474.25 | 12439.2 | 12455.29 | 12064.0 |
| 2022-10-17 03:00:00 | NQ | Futures | 12454.72 | 12529.13 | 12424.55 | 12504.71 | 18829.0 |
| 2022-10-17 04:00:00 | NQ | Futures | 12505.57 | 12508.73 | 12457.01 | 12485.46 | 9796.0 |
| 2022-10-17 05:00:00 | NQ | Futures | 12484.6 | 12514.48 | 12476.84 | 12507.58 | 6633.0 |
| 2022-10-17 06:00:00 | NQ | Futures | 12506.43 | 12546.66 | 12496.38 | 12532.58 | 10349.0 |
| 2022-10-17 07:00:00 | NQ | Futures | 12531.43 | 12539.48 | 12502.12 | 12529.13 | 8930.0 |
| 2022-10-17 08:00:00 | NQ | Futures | 12527.98 | 12585.16 | 12499.25 | 12578.27 | 23615.0 |
| 2022-10-17 09:00:00 | NQ | Futures | 12578.55 | 12776.81 | 12578.27 | 12726.81 | 113630.0 |
| 2022-10-17 10:00:00 | NQ | Futures | 12727.39 | 12795.48 | 12673.66 | 12695.49 | 100519.0 |
| 2022-10-17 11:00:00 | NQ | Futures | 12696.36 | 12800.94 | 12668.2 | 12774.22 | 64654.0 |
| 2022-10-17 12:00:00 | NQ | Futures | 12774.22 | 12794.33 | 12731.12 | 12751.52 | 45880.0 |
| 2022-10-17 13:00:00 | NQ | Futures | 12752.1 | 12800.08 | 12731.12 | 12789.45 | 32964.0 |
| 2022-10-17 14:00:00 | NQ | Futures | 12790.02 | 12810.42 | 12754.11 | 12773.07 | 37490.0 |
| 2022-10-17 15:00:00 | NQ | Futures | 12773.07 | 12801.52 | 12743.77 | 12770.2 | 69976.0 |
| 2022-10-17 16:00:00 | NQ | Futures | 12769.91 | 12810.42 | 12761.29 | 12796.35 | 18223.0 |
| 2022-10-17 18:00:00 | NQ | Futures | 12827.66 | 12868.18 | 12826.23 | 12855.82 | 8655.0 |
| 2022-10-17 19:00:00 | NQ | Futures | 12855.82 | 12893.75 | 12852.66 | 12885.13 | 5841.0 |
| 2022-10-17 20:00:00 | NQ | Futures | 12884.84 | 12892.89 | 12863.58 | 12878.23 | 4828.0 |
| 2022-10-17 21:00:00 | NQ | Futures | 12877.95 | 12888.86 | 12858.12 | 12865.88 | 5222.0 |
| 2022-10-17 22:00:00 | NQ | Futures | 12866.45 | 12866.45 | 12848.93 | 12858.41 | 3526.0 |
| 2022-10-17 23:00:00 | NQ | Futures | 12858.7 | 13005.52 | 12857.83 | 12984.26 | 13560.0 |
| 2022-10-17 00:00:00 | YM | Futures | 33474.0 | 33491.9 | 33457.2 | 33484.1 | 613.0 |
| 2022-10-17 01:00:00 | YM | Futures | 33483.0 | 33571.6 | 33480.7 | 33551.4 | 1717.0 |
| 2022-10-17 02:00:00 | YM | Futures | 33550.3 | 33587.3 | 33532.3 | 33552.5 | 2403.0 |
| 2022-10-17 03:00:00 | YM | Futures | 33552.5 | 33668.1 | 33487.5 | 33626.6 | 4590.0 |
> showing 50 of 2,056 rows — these rows as CSV