PREVIEW / futures_1hour / 2023-01-13
file: by_date/futures_1hour/2023/2023-01-13.parquet size: 57 KB rows: 1,632
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 |
|---|---|---|---|---|---|---|---|
| 2023-01-13 00:00:00 | ES | Futures | 4467.55 | 4468.11 | 4465.04 | 4467.55 | 4439.0 |
| 2023-01-13 01:00:00 | ES | Futures | 4467.27 | 4471.19 | 4466.16 | 4470.35 | 5173.0 |
| 2023-01-13 02:00:00 | ES | Futures | 4470.35 | 4475.1 | 4468.39 | 4474.26 | 8796.0 |
| 2023-01-13 03:00:00 | ES | Futures | 4474.54 | 4476.78 | 4466.16 | 4475.38 | 23081.0 |
| 2023-01-13 04:00:00 | ES | Futures | 4475.38 | 4479.58 | 4470.63 | 4477.62 | 17380.0 |
| 2023-01-13 05:00:00 | ES | Futures | 4477.9 | 4480.14 | 4474.54 | 4477.06 | 11721.0 |
| 2023-01-13 06:00:00 | ES | Futures | 4476.78 | 4476.78 | 4458.61 | 4460.28 | 32993.0 |
| 2023-01-13 07:00:00 | ES | Futures | 4460.28 | 4463.64 | 4436.24 | 4437.08 | 49268.0 |
| 2023-01-13 08:00:00 | ES | Futures | 4437.36 | 4440.71 | 4430.93 | 4436.24 | 58705.0 |
| 2023-01-13 09:00:00 | ES | Futures | 4436.52 | 4456.93 | 4431.2 | 4451.62 | 204669.0 |
| 2023-01-13 10:00:00 | ES | Futures | 4451.62 | 4474.54 | 4446.3 | 4469.79 | 240202.0 |
| 2023-01-13 11:00:00 | ES | Futures | 4470.07 | 4472.31 | 4456.93 | 4463.36 | 151951.0 |
| 2023-01-13 12:00:00 | ES | Futures | 4463.36 | 4475.1 | 4462.24 | 4473.43 | 95284.0 |
| 2023-01-13 13:00:00 | ES | Futures | 4473.7 | 4484.61 | 4466.71 | 4482.65 | 99130.0 |
| 2023-01-13 14:00:00 | ES | Futures | 4482.65 | 4486.57 | 4478.74 | 4484.33 | 93394.0 |
| 2023-01-13 15:00:00 | ES | Futures | 4484.61 | 4500.83 | 4483.77 | 4493.56 | 214852.0 |
| 2023-01-13 16:00:00 | ES | Futures | 4493.56 | 4496.07 | 4489.64 | 4494.95 | 58017.0 |
| 2023-01-13 00:00:00 | NQ | Futures | 13077.05 | 13079.61 | 13066.53 | 13076.77 | 2380.0 |
| 2023-01-13 01:00:00 | NQ | Futures | 13077.34 | 13098.39 | 13074.21 | 13094.41 | 3613.0 |
| 2023-01-13 02:00:00 | NQ | Futures | 13095.26 | 13116.6 | 13087.3 | 13114.61 | 4433.0 |
| 2023-01-13 03:00:00 | NQ | Futures | 13116.03 | 13118.59 | 13087.01 | 13114.89 | 8263.0 |
| 2023-01-13 04:00:00 | NQ | Futures | 13114.89 | 13118.59 | 13079.33 | 13108.63 | 7904.0 |
| 2023-01-13 05:00:00 | NQ | Futures | 13108.92 | 13125.99 | 13095.83 | 13102.09 | 5257.0 |
| 2023-01-13 06:00:00 | NQ | Futures | 13101.52 | 13102.66 | 13040.64 | 13057.42 | 11935.0 |
| 2023-01-13 07:00:00 | NQ | Futures | 13057.42 | 13067.38 | 12978.62 | 12987.44 | 17054.0 |
| 2023-01-13 08:00:00 | NQ | Futures | 12988.01 | 13000.53 | 12966.39 | 12978.9 | 21006.0 |
| 2023-01-13 09:00:00 | NQ | Futures | 12979.19 | 13060.84 | 12960.41 | 13038.93 | 77840.0 |
| 2023-01-13 10:00:00 | NQ | Futures | 13038.36 | 13130.25 | 13019.02 | 13105.79 | 73896.0 |
| 2023-01-13 11:00:00 | NQ | Futures | 13106.36 | 13116.03 | 13034.38 | 13068.8 | 56070.0 |
| 2023-01-13 12:00:00 | NQ | Futures | 13069.37 | 13119.16 | 13064.25 | 13115.75 | 32227.0 |
| 2023-01-13 13:00:00 | NQ | Futures | 13115.75 | 13164.39 | 13092.13 | 13156.14 | 34463.0 |
| 2023-01-13 14:00:00 | NQ | Futures | 13155.86 | 13176.34 | 13141.92 | 13161.83 | 29207.0 |
| 2023-01-13 15:00:00 | NQ | Futures | 13162.12 | 13222.72 | 13158.42 | 13209.34 | 58709.0 |
| 2023-01-13 16:00:00 | NQ | Futures | 13209.34 | 13213.04 | 13185.16 | 13202.23 | 11446.0 |
| 2023-01-13 00:00:00 | YM | Futures | 38164.1 | 38170.8 | 38147.4 | 38165.2 | 1120.0 |
| 2023-01-13 01:00:00 | YM | Futures | 38166.3 | 38188.6 | 38158.5 | 38173.0 | 1023.0 |
| 2023-01-13 02:00:00 | YM | Futures | 38174.1 | 38200.8 | 38164.1 | 38197.5 | 1546.0 |
| 2023-01-13 03:00:00 | YM | Futures | 38198.6 | 38226.5 | 38144.0 | 38219.8 | 2325.0 |
| 2023-01-13 04:00:00 | YM | Futures | 38219.8 | 38269.9 | 38205.3 | 38257.7 | 1925.0 |
| 2023-01-13 05:00:00 | YM | Futures | 38255.4 | 38276.6 | 38219.8 | 38271.0 | 2376.0 |
| 2023-01-13 06:00:00 | YM | Futures | 38271.0 | 38282.2 | 38112.8 | 38129.5 | 7516.0 |
| 2023-01-13 07:00:00 | YM | Futures | 38130.6 | 38155.2 | 37937.9 | 37946.8 | 6521.0 |
| 2023-01-13 08:00:00 | YM | Futures | 37949.0 | 37974.7 | 37905.6 | 37936.8 | 6223.0 |
| 2023-01-13 09:00:00 | YM | Futures | 37935.7 | 38148.5 | 37888.9 | 38118.4 | 28684.0 |
| 2023-01-13 10:00:00 | YM | Futures | 38109.5 | 38296.7 | 38074.9 | 38268.8 | 25318.0 |
| 2023-01-13 11:00:00 | YM | Futures | 38269.9 | 38315.6 | 38214.2 | 38230.9 | 15805.0 |
| 2023-01-13 12:00:00 | YM | Futures | 38230.9 | 38276.6 | 38217.6 | 38247.6 | 8591.0 |
| 2023-01-13 13:00:00 | YM | Futures | 38251.0 | 38312.3 | 38176.3 | 38285.5 | 9772.0 |
| 2023-01-13 14:00:00 | YM | Futures | 38285.5 | 38306.7 | 38234.3 | 38272.1 | 7626.0 |
| 2023-01-13 15:00:00 | YM | Futures | 38273.3 | 38399.2 | 38266.6 | 38344.6 | 16064.0 |
> showing 50 of 1,632 rows — these rows as CSV