PREVIEW / futures_1hour / 2022-10-05
file: by_date/futures_1hour/2022/2022-10-05.parquet size: 71 KB rows: 2,097
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-05 00:00:00 | ES | Futures | 4268.71 | 4269.28 | 4264.49 | 4265.33 | 5512.0 |
| 2022-10-05 01:00:00 | ES | Futures | 4265.33 | 4271.82 | 4265.33 | 4271.25 | 8492.0 |
| 2022-10-05 02:00:00 | ES | Futures | 4271.25 | 4272.1 | 4265.05 | 4266.46 | 15672.0 |
| 2022-10-05 03:00:00 | ES | Futures | 4266.46 | 4270.41 | 4258.28 | 4259.69 | 31599.0 |
| 2022-10-05 04:00:00 | ES | Futures | 4259.41 | 4262.79 | 4245.32 | 4256.31 | 37655.0 |
| 2022-10-05 05:00:00 | ES | Futures | 4256.31 | 4259.13 | 4243.34 | 4246.73 | 20856.0 |
| 2022-10-05 06:00:00 | ES | Futures | 4247.01 | 4260.54 | 4245.6 | 4260.26 | 20026.0 |
| 2022-10-05 07:00:00 | ES | Futures | 4260.54 | 4261.39 | 4246.73 | 4250.96 | 36031.0 |
| 2022-10-05 08:00:00 | ES | Futures | 4250.96 | 4254.06 | 4241.93 | 4245.6 | 56735.0 |
| 2022-10-05 09:00:00 | ES | Futures | 4245.32 | 4259.13 | 4236.3 | 4246.73 | 231981.0 |
| 2022-10-05 10:00:00 | ES | Futures | 4246.73 | 4249.26 | 4210.36 | 4215.44 | 348733.0 |
| 2022-10-05 11:00:00 | ES | Futures | 4215.44 | 4239.12 | 4213.75 | 4234.32 | 185151.0 |
| 2022-10-05 12:00:00 | ES | Futures | 4234.61 | 4268.43 | 4225.3 | 4259.98 | 198437.0 |
| 2022-10-05 13:00:00 | ES | Futures | 4259.98 | 4285.91 | 4258.28 | 4266.18 | 191836.0 |
| 2022-10-05 14:00:00 | ES | Futures | 4266.18 | 4288.17 | 4264.77 | 4287.04 | 160488.0 |
| 2022-10-05 15:00:00 | ES | Futures | 4287.32 | 4307.33 | 4273.51 | 4281.4 | 344179.0 |
| 2022-10-05 16:00:00 | ES | Futures | 4281.4 | 4288.73 | 4279.14 | 4279.99 | 61260.0 |
| 2022-10-05 18:00:00 | ES | Futures | 4279.99 | 4286.19 | 4274.92 | 4284.78 | 8225.0 |
| 2022-10-05 19:00:00 | ES | Futures | 4284.5 | 4299.72 | 4281.68 | 4297.47 | 9968.0 |
| 2022-10-05 20:00:00 | ES | Futures | 4297.75 | 4306.77 | 4294.09 | 4301.13 | 16626.0 |
| 2022-10-05 21:00:00 | ES | Futures | 4301.41 | 4303.67 | 4290.42 | 4298.03 | 14713.0 |
| 2022-10-05 22:00:00 | ES | Futures | 4297.75 | 4301.7 | 4293.8 | 4298.31 | 7270.0 |
| 2022-10-05 23:00:00 | ES | Futures | 4298.6 | 4305.64 | 4297.47 | 4298.88 | 6858.0 |
| 2022-10-05 00:00:00 | NQ | Futures | 13315.83 | 13318.42 | 13298.3 | 13301.75 | 2678.0 |
| 2022-10-05 01:00:00 | NQ | Futures | 13301.75 | 13326.17 | 13301.75 | 13323.88 | 4315.0 |
| 2022-10-05 02:00:00 | NQ | Futures | 13323.88 | 13327.32 | 13299.17 | 13306.35 | 6217.0 |
| 2022-10-05 03:00:00 | NQ | Futures | 13306.06 | 13324.74 | 13277.33 | 13292.27 | 17086.0 |
| 2022-10-05 04:00:00 | NQ | Futures | 13293.42 | 13304.91 | 13227.33 | 13275.89 | 20447.0 |
| 2022-10-05 05:00:00 | NQ | Futures | 13274.74 | 13288.25 | 13234.23 | 13250.9 | 10534.0 |
| 2022-10-05 06:00:00 | NQ | Futures | 13250.9 | 13293.42 | 13247.73 | 13292.56 | 9129.0 |
| 2022-10-05 07:00:00 | NQ | Futures | 13293.42 | 13295.14 | 13250.32 | 13262.39 | 12907.0 |
| 2022-10-05 08:00:00 | NQ | Futures | 13263.25 | 13271.01 | 13220.73 | 13231.93 | 22429.0 |
| 2022-10-05 09:00:00 | NQ | Futures | 13231.07 | 13261.81 | 13177.05 | 13209.52 | 89625.0 |
| 2022-10-05 10:00:00 | NQ | Futures | 13209.23 | 13218.14 | 13063.56 | 13081.09 | 112338.0 |
| 2022-10-05 11:00:00 | NQ | Futures | 13080.8 | 13170.44 | 13074.19 | 13164.12 | 66463.0 |
| 2022-10-05 12:00:00 | NQ | Futures | 13164.7 | 13294.86 | 13131.66 | 13265.55 | 70495.0 |
| 2022-10-05 13:00:00 | NQ | Futures | 13265.55 | 13361.52 | 13260.66 | 13293.42 | 59020.0 |
| 2022-10-05 14:00:00 | NQ | Futures | 13293.42 | 13387.66 | 13285.09 | 13383.64 | 49971.0 |
| 2022-10-05 15:00:00 | NQ | Futures | 13384.21 | 13459.49 | 13345.43 | 13373.87 | 89292.0 |
| 2022-10-05 16:00:00 | NQ | Futures | 13373.87 | 13406.34 | 13364.1 | 13364.1 | 17063.0 |
| 2022-10-05 18:00:00 | NQ | Futures | 13364.1 | 13395.13 | 13350.31 | 13390.25 | 4883.0 |
| 2022-10-05 19:00:00 | NQ | Futures | 13389.96 | 13446.85 | 13380.48 | 13445.7 | 6170.0 |
| 2022-10-05 20:00:00 | NQ | Futures | 13445.7 | 13481.04 | 13429.04 | 13454.61 | 9099.0 |
| 2022-10-05 21:00:00 | NQ | Futures | 13454.61 | 13462.37 | 13410.07 | 13435.93 | 9285.0 |
| 2022-10-05 22:00:00 | NQ | Futures | 13435.65 | 13446.56 | 13416.68 | 13436.22 | 4582.0 |
| 2022-10-05 23:00:00 | NQ | Futures | 13437.66 | 13462.37 | 13434.21 | 13441.11 | 3586.0 |
| 2022-10-05 00:00:00 | YM | Futures | 33927.4 | 33930.7 | 33901.6 | 33912.8 | 557.0 |
| 2022-10-05 01:00:00 | YM | Futures | 33910.5 | 33954.3 | 33910.5 | 33948.7 | 841.0 |
| 2022-10-05 02:00:00 | YM | Futures | 33947.6 | 33962.2 | 33908.3 | 33922.9 | 1582.0 |
| 2022-10-05 03:00:00 | YM | Futures | 33924.0 | 33942.0 | 33845.4 | 33849.9 | 3268.0 |
> showing 50 of 2,097 rows — these rows as CSV