PREVIEW / futures_1hour / 2022-07-14
file: by_date/futures_1hour/2022/2022-07-14.parquet size: 70 KB rows: 2,061
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-07-14 00:00:00 | ES | Futures | 4307.14 | 4310.83 | 4304.31 | 4308.28 | 7236.0 |
| 2022-07-14 01:00:00 | ES | Futures | 4308.28 | 4310.83 | 4296.38 | 4297.8 | 8498.0 |
| 2022-07-14 02:00:00 | ES | Futures | 4298.08 | 4302.33 | 4288.73 | 4293.26 | 19605.0 |
| 2022-07-14 03:00:00 | ES | Futures | 4293.55 | 4297.8 | 4279.1 | 4280.23 | 26959.0 |
| 2022-07-14 04:00:00 | ES | Futures | 4280.23 | 4286.18 | 4255.02 | 4259.27 | 30494.0 |
| 2022-07-14 05:00:00 | ES | Futures | 4259.27 | 4269.75 | 4255.02 | 4268.9 | 16205.0 |
| 2022-07-14 06:00:00 | ES | Futures | 4268.9 | 4270.88 | 4249.07 | 4254.17 | 22965.0 |
| 2022-07-14 07:00:00 | ES | Futures | 4253.89 | 4261.54 | 4249.07 | 4250.49 | 37354.0 |
| 2022-07-14 08:00:00 | ES | Futures | 4250.49 | 4264.65 | 4240.01 | 4252.75 | 69436.0 |
| 2022-07-14 09:00:00 | ES | Futures | 4253.04 | 4257.85 | 4227.26 | 4234.06 | 253792.0 |
| 2022-07-14 10:00:00 | ES | Futures | 4234.34 | 4242.27 | 4219.33 | 4234.34 | 264922.0 |
| 2022-07-14 11:00:00 | ES | Futures | 4234.63 | 4276.83 | 4232.93 | 4273.15 | 276955.0 |
| 2022-07-14 12:00:00 | ES | Futures | 4272.87 | 4275.98 | 4243.69 | 4252.75 | 143185.0 |
| 2022-07-14 13:00:00 | ES | Futures | 4253.04 | 4274.28 | 4244.54 | 4272.02 | 135748.0 |
| 2022-07-14 14:00:00 | ES | Futures | 4272.02 | 4303.18 | 4270.6 | 4296.66 | 183812.0 |
| 2022-07-14 15:00:00 | ES | Futures | 4296.95 | 4305.73 | 4289.01 | 4299.21 | 238672.0 |
| 2022-07-14 16:00:00 | ES | Futures | 4299.21 | 4304.03 | 4298.36 | 4301.19 | 44913.0 |
| 2022-07-14 18:00:00 | ES | Futures | 4303.18 | 4315.07 | 4302.33 | 4310.54 | 8458.0 |
| 2022-07-14 19:00:00 | ES | Futures | 4310.54 | 4318.76 | 4309.41 | 4317.62 | 5429.0 |
| 2022-07-14 20:00:00 | ES | Futures | 4317.62 | 4319.04 | 4300.34 | 4301.76 | 12144.0 |
| 2022-07-14 21:00:00 | ES | Futures | 4301.48 | 4312.81 | 4298.93 | 4312.53 | 9972.0 |
| 2022-07-14 22:00:00 | ES | Futures | 4312.53 | 4314.79 | 4309.13 | 4314.22 | 7119.0 |
| 2022-07-14 23:00:00 | ES | Futures | 4314.22 | 4315.36 | 4306.86 | 4314.79 | 6896.0 |
| 2022-07-14 00:00:00 | NQ | Futures | 13590.19 | 13605.23 | 13579.48 | 13594.24 | 2914.0 |
| 2022-07-14 01:00:00 | NQ | Futures | 13594.24 | 13607.54 | 13547.38 | 13556.92 | 5583.0 |
| 2022-07-14 02:00:00 | NQ | Futures | 13557.5 | 13569.07 | 13528.29 | 13546.8 | 6760.0 |
| 2022-07-14 03:00:00 | NQ | Futures | 13547.09 | 13565.02 | 13499.65 | 13504.57 | 13945.0 |
| 2022-07-14 04:00:00 | NQ | Futures | 13505.44 | 13532.63 | 13421.85 | 13455.98 | 17196.0 |
| 2022-07-14 05:00:00 | NQ | Futures | 13454.82 | 13499.36 | 13440.36 | 13496.18 | 10865.0 |
| 2022-07-14 06:00:00 | NQ | Futures | 13496.47 | 13510.65 | 13457.71 | 13484.9 | 9945.0 |
| 2022-07-14 07:00:00 | NQ | Futures | 13484.61 | 13503.7 | 13455.4 | 13469.57 | 12907.0 |
| 2022-07-14 08:00:00 | NQ | Futures | 13468.71 | 13520.19 | 13426.48 | 13485.48 | 24377.0 |
| 2022-07-14 09:00:00 | NQ | Futures | 13486.06 | 13518.45 | 13359.95 | 13382.8 | 88684.0 |
| 2022-07-14 10:00:00 | NQ | Futures | 13382.22 | 13429.37 | 13318.01 | 13400.73 | 90054.0 |
| 2022-07-14 11:00:00 | NQ | Futures | 13401.31 | 13554.61 | 13397.55 | 13538.41 | 88149.0 |
| 2022-07-14 12:00:00 | NQ | Futures | 13538.99 | 13552.58 | 13445.28 | 13479.41 | 45476.0 |
| 2022-07-14 13:00:00 | NQ | Futures | 13480.85 | 13586.72 | 13455.69 | 13567.34 | 45722.0 |
| 2022-07-14 14:00:00 | NQ | Futures | 13567.63 | 13689.97 | 13560.68 | 13656.71 | 66677.0 |
| 2022-07-14 15:00:00 | NQ | Futures | 13657.29 | 13692.58 | 13608.12 | 13651.5 | 74642.0 |
| 2022-07-14 16:00:00 | NQ | Futures | 13651.5 | 13672.62 | 13644.56 | 13660.47 | 12945.0 |
| 2022-07-14 18:00:00 | NQ | Futures | 13664.23 | 13702.41 | 13662.78 | 13689.68 | 4606.0 |
| 2022-07-14 19:00:00 | NQ | Futures | 13689.97 | 13729.02 | 13685.92 | 13724.1 | 4138.0 |
| 2022-07-14 20:00:00 | NQ | Futures | 13723.81 | 13730.76 | 13662.78 | 13667.7 | 6098.0 |
| 2022-07-14 21:00:00 | NQ | Futures | 13667.7 | 13710.8 | 13655.55 | 13709.93 | 5759.0 |
| 2022-07-14 22:00:00 | NQ | Futures | 13709.35 | 13721.21 | 13700.68 | 13717.74 | 4442.0 |
| 2022-07-14 23:00:00 | NQ | Futures | 13717.74 | 13720.34 | 13684.48 | 13713.4 | 3730.0 |
| 2022-07-14 00:00:00 | YM | Futures | 34690.9 | 34709.0 | 34669.5 | 34692.1 | 719.0 |
| 2022-07-14 01:00:00 | YM | Futures | 34693.2 | 34712.4 | 34614.2 | 34618.7 | 970.0 |
| 2022-07-14 02:00:00 | YM | Futures | 34624.4 | 34658.2 | 34560.0 | 34586.0 | 2486.0 |
| 2022-07-14 03:00:00 | YM | Futures | 34589.4 | 34622.1 | 34490.1 | 34494.6 | 3925.0 |
> showing 50 of 2,061 rows — these rows as CSV