PREVIEW / futures_1hour / 2022-06-23
file: by_date/futures_1hour/2022/2022-06-23.parquet size: 70 KB rows: 2,071
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-06-23 00:00:00 | ES | Futures | 4250.49 | 4263.52 | 4245.96 | 4257.85 | 8215.0 |
| 2022-06-23 01:00:00 | ES | Futures | 4257.85 | 4268.33 | 4256.72 | 4261.25 | 9323.0 |
| 2022-06-23 02:00:00 | ES | Futures | 4261.25 | 4262.39 | 4253.6 | 4258.42 | 11891.0 |
| 2022-06-23 03:00:00 | ES | Futures | 4258.7 | 4258.99 | 4232.08 | 4238.31 | 26385.0 |
| 2022-06-23 04:00:00 | ES | Futures | 4238.31 | 4270.6 | 4235.19 | 4256.44 | 24635.0 |
| 2022-06-23 05:00:00 | ES | Futures | 4256.44 | 4278.82 | 4255.87 | 4274.85 | 15956.0 |
| 2022-06-23 06:00:00 | ES | Futures | 4274.57 | 4298.36 | 4273.43 | 4296.1 | 19735.0 |
| 2022-06-23 07:00:00 | ES | Futures | 4296.38 | 4302.33 | 4289.58 | 4295.53 | 22653.0 |
| 2022-06-23 08:00:00 | ES | Futures | 4295.25 | 4296.1 | 4275.42 | 4283.06 | 30539.0 |
| 2022-06-23 09:00:00 | ES | Futures | 4283.06 | 4296.1 | 4266.07 | 4291.28 | 212309.0 |
| 2022-06-23 10:00:00 | ES | Futures | 4291.28 | 4304.31 | 4272.3 | 4300.91 | 232507.0 |
| 2022-06-23 11:00:00 | ES | Futures | 4301.19 | 4305.44 | 4269.18 | 4270.88 | 165273.0 |
| 2022-06-23 12:00:00 | ES | Futures | 4270.88 | 4273.15 | 4246.52 | 4252.19 | 167019.0 |
| 2022-06-23 13:00:00 | ES | Futures | 4252.19 | 4268.05 | 4244.26 | 4266.35 | 133602.0 |
| 2022-06-23 14:00:00 | ES | Futures | 4266.64 | 4285.61 | 4262.95 | 4281.65 | 128819.0 |
| 2022-06-23 15:00:00 | ES | Futures | 4281.65 | 4312.24 | 4276.55 | 4304.31 | 230998.0 |
| 2022-06-23 16:00:00 | ES | Futures | 4304.03 | 4304.59 | 4285.33 | 4287.88 | 55915.0 |
| 2022-06-23 18:00:00 | ES | Futures | 4289.01 | 4295.53 | 4286.75 | 4293.83 | 6409.0 |
| 2022-06-23 19:00:00 | ES | Futures | 4294.11 | 4297.51 | 4287.31 | 4288.45 | 4297.0 |
| 2022-06-23 20:00:00 | ES | Futures | 4288.45 | 4300.91 | 4284.48 | 4299.49 | 10199.0 |
| 2022-06-23 21:00:00 | ES | Futures | 4299.21 | 4319.32 | 4296.38 | 4316.77 | 14535.0 |
| 2022-06-23 22:00:00 | ES | Futures | 4316.77 | 4332.35 | 4313.66 | 4330.09 | 13798.0 |
| 2022-06-23 23:00:00 | ES | Futures | 4330.09 | 4331.79 | 4322.44 | 4323.29 | 7940.0 |
| 2022-06-23 00:00:00 | NQ | Futures | 13335.94 | 13390.03 | 13318.88 | 13370.65 | 5148.0 |
| 2022-06-23 01:00:00 | NQ | Futures | 13369.79 | 13408.54 | 13364.58 | 13386.27 | 4322.0 |
| 2022-06-23 02:00:00 | NQ | Futures | 13383.67 | 13389.74 | 13354.75 | 13376.15 | 4920.0 |
| 2022-06-23 03:00:00 | NQ | Futures | 13376.15 | 13377.6 | 13287.64 | 13332.18 | 13789.0 |
| 2022-06-23 04:00:00 | NQ | Futures | 13331.32 | 13450.48 | 13312.23 | 13407.39 | 14587.0 |
| 2022-06-23 05:00:00 | NQ | Futures | 13407.39 | 13479.7 | 13404.49 | 13465.52 | 10005.0 |
| 2022-06-23 06:00:00 | NQ | Futures | 13464.37 | 13539.28 | 13457.43 | 13530.89 | 11266.0 |
| 2022-06-23 07:00:00 | NQ | Futures | 13532.05 | 13542.17 | 13500.81 | 13512.67 | 12977.0 |
| 2022-06-23 08:00:00 | NQ | Futures | 13512.09 | 13515.85 | 13433.42 | 13471.02 | 17720.0 |
| 2022-06-23 09:00:00 | NQ | Futures | 13471.02 | 13517.3 | 13354.75 | 13474.2 | 99837.0 |
| 2022-06-23 10:00:00 | NQ | Futures | 13473.62 | 13573.12 | 13413.46 | 13562.13 | 96913.0 |
| 2022-06-23 11:00:00 | NQ | Futures | 13562.42 | 13587.29 | 13475.07 | 13480.28 | 61052.0 |
| 2022-06-23 12:00:00 | NQ | Futures | 13480.28 | 13486.06 | 13382.8 | 13397.84 | 62275.0 |
| 2022-06-23 13:00:00 | NQ | Futures | 13398.42 | 13447.3 | 13359.37 | 13442.38 | 45400.0 |
| 2022-06-23 14:00:00 | NQ | Futures | 13442.38 | 13514.69 | 13426.77 | 13499.36 | 39875.0 |
| 2022-06-23 15:00:00 | NQ | Futures | 13500.23 | 13613.61 | 13479.12 | 13574.86 | 67589.0 |
| 2022-06-23 16:00:00 | NQ | Futures | 13574.86 | 13575.72 | 13514.69 | 13522.5 | 14539.0 |
| 2022-06-23 18:00:00 | NQ | Futures | 13522.21 | 13553.74 | 13521.64 | 13547.67 | 3391.0 |
| 2022-06-23 19:00:00 | NQ | Futures | 13547.38 | 13563.58 | 13525.97 | 13531.18 | 2956.0 |
| 2022-06-23 20:00:00 | NQ | Futures | 13532.05 | 13579.77 | 13518.74 | 13571.39 | 5063.0 |
| 2022-06-23 21:00:00 | NQ | Futures | 13571.1 | 13637.33 | 13563.58 | 13631.84 | 7872.0 |
| 2022-06-23 22:00:00 | NQ | Futures | 13632.7 | 13692.0 | 13622.29 | 13684.77 | 7878.0 |
| 2022-06-23 23:00:00 | NQ | Futures | 13684.77 | 13701.25 | 13664.23 | 13667.7 | 5900.0 |
| 2022-06-23 00:00:00 | YM | Futures | 34287.0 | 34376.1 | 34262.2 | 34337.8 | 1617.0 |
| 2022-06-23 01:00:00 | YM | Futures | 34338.9 | 34406.6 | 34328.7 | 34355.8 | 1821.0 |
| 2022-06-23 02:00:00 | YM | Futures | 34353.5 | 34361.4 | 34307.3 | 34332.1 | 2295.0 |
| 2022-06-23 03:00:00 | YM | Futures | 34337.8 | 34341.1 | 34129.0 | 34155.0 | 6056.0 |
> showing 50 of 2,071 rows — these rows as CSV