PREVIEW / futures_1hour / 2022-10-11
file: by_date/futures_1hour/2022/2022-10-11.parquet size: 69 KB rows: 2,066
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-11 00:00:00 | ES | Futures | 4066.88 | 4070.83 | 4060.4 | 4064.62 | 8905.0 |
| 2022-10-11 01:00:00 | ES | Futures | 4064.62 | 4069.7 | 4061.8 | 4065.47 | 10426.0 |
| 2022-10-11 02:00:00 | ES | Futures | 4065.19 | 4076.75 | 4051.94 | 4054.76 | 22920.0 |
| 2022-10-11 03:00:00 | ES | Futures | 4054.76 | 4073.93 | 4042.07 | 4056.73 | 48733.0 |
| 2022-10-11 04:00:00 | ES | Futures | 4056.73 | 4069.7 | 4045.45 | 4049.97 | 29974.0 |
| 2022-10-11 05:00:00 | ES | Futures | 4049.97 | 4057.29 | 4044.89 | 4049.68 | 22203.0 |
| 2022-10-11 06:00:00 | ES | Futures | 4049.68 | 4060.4 | 4041.51 | 4059.83 | 28774.0 |
| 2022-10-11 07:00:00 | ES | Futures | 4059.83 | 4072.8 | 4058.99 | 4071.67 | 47155.0 |
| 2022-10-11 08:00:00 | ES | Futures | 4071.39 | 4091.12 | 4068.57 | 4075.62 | 64296.0 |
| 2022-10-11 09:00:00 | ES | Futures | 4075.62 | 4079.56 | 4044.89 | 4046.02 | 259087.0 |
| 2022-10-11 10:00:00 | ES | Futures | 4046.3 | 4069.98 | 4037.0 | 4056.73 | 332850.0 |
| 2022-10-11 11:00:00 | ES | Futures | 4057.01 | 4102.12 | 4055.89 | 4093.38 | 264348.0 |
| 2022-10-11 12:00:00 | ES | Futures | 4093.66 | 4119.31 | 4078.72 | 4109.44 | 223411.0 |
| 2022-10-11 13:00:00 | ES | Futures | 4109.44 | 4111.98 | 4094.5 | 4106.06 | 161497.0 |
| 2022-10-11 14:00:00 | ES | Futures | 4106.06 | 4108.88 | 4052.22 | 4054.19 | 255186.0 |
| 2022-10-11 15:00:00 | ES | Futures | 4054.48 | 4064.91 | 4035.59 | 4058.99 | 445661.0 |
| 2022-10-11 16:00:00 | ES | Futures | 4059.27 | 4069.42 | 4057.29 | 4068.57 | 49112.0 |
| 2022-10-11 18:00:00 | ES | Futures | 4067.16 | 4068.29 | 4060.4 | 4064.06 | 8067.0 |
| 2022-10-11 19:00:00 | ES | Futures | 4064.34 | 4067.44 | 4059.27 | 4064.91 | 6033.0 |
| 2022-10-11 20:00:00 | ES | Futures | 4064.91 | 4077.59 | 4055.04 | 4073.08 | 20681.0 |
| 2022-10-11 21:00:00 | ES | Futures | 4073.08 | 4075.05 | 4056.45 | 4062.93 | 14858.0 |
| 2022-10-11 22:00:00 | ES | Futures | 4062.93 | 4069.42 | 4057.01 | 4068.29 | 11736.0 |
| 2022-10-11 23:00:00 | ES | Futures | 4068.01 | 4070.54 | 4062.65 | 4064.91 | 7166.0 |
| 2022-10-11 00:00:00 | NQ | Futures | 12569.36 | 12581.71 | 12542.64 | 12557.58 | 4290.0 |
| 2022-10-11 01:00:00 | NQ | Futures | 12557.87 | 12573.96 | 12546.66 | 12559.01 | 4291.0 |
| 2022-10-11 02:00:00 | NQ | Futures | 12558.44 | 12600.68 | 12509.02 | 12518.5 | 12016.0 |
| 2022-10-11 03:00:00 | NQ | Futures | 12517.93 | 12594.07 | 12473.68 | 12538.04 | 24962.0 |
| 2022-10-11 04:00:00 | NQ | Futures | 12537.18 | 12581.43 | 12498.39 | 12515.34 | 15659.0 |
| 2022-10-11 05:00:00 | NQ | Futures | 12515.34 | 12534.88 | 12490.34 | 12508.73 | 13392.0 |
| 2022-10-11 06:00:00 | NQ | Futures | 12508.73 | 12543.79 | 12479.71 | 12542.35 | 13334.0 |
| 2022-10-11 07:00:00 | NQ | Futures | 12542.06 | 12572.52 | 12536.32 | 12569.36 | 14758.0 |
| 2022-10-11 08:00:00 | NQ | Futures | 12569.36 | 12631.71 | 12559.01 | 12576.54 | 24392.0 |
| 2022-10-11 09:00:00 | NQ | Futures | 12576.83 | 12583.72 | 12436.61 | 12439.49 | 102242.0 |
| 2022-10-11 10:00:00 | NQ | Futures | 12439.49 | 12529.13 | 12399.26 | 12465.63 | 119799.0 |
| 2022-10-11 11:00:00 | NQ | Futures | 12466.78 | 12637.45 | 12462.19 | 12598.38 | 101302.0 |
| 2022-10-11 12:00:00 | NQ | Futures | 12598.09 | 12687.74 | 12542.35 | 12638.32 | 73983.0 |
| 2022-10-11 13:00:00 | NQ | Futures | 12638.6 | 12652.68 | 12573.67 | 12612.17 | 54046.0 |
| 2022-10-11 14:00:00 | NQ | Futures | 12612.74 | 12625.39 | 12424.83 | 12433.74 | 75973.0 |
| 2022-10-11 15:00:00 | NQ | Futures | 12434.32 | 12481.44 | 12374.84 | 12463.05 | 114675.0 |
| 2022-10-11 16:00:00 | NQ | Futures | 12462.76 | 12506.72 | 12459.03 | 12505.0 | 17163.0 |
| 2022-10-11 18:00:00 | NQ | Futures | 12498.68 | 12501.84 | 12472.53 | 12482.3 | 3917.0 |
| 2022-10-11 19:00:00 | NQ | Futures | 12483.16 | 12494.65 | 12463.91 | 12486.9 | 3358.0 |
| 2022-10-11 20:00:00 | NQ | Futures | 12487.47 | 12536.6 | 12453.85 | 12518.5 | 9559.0 |
| 2022-10-11 21:00:00 | NQ | Futures | 12518.5 | 12525.4 | 12465.35 | 12487.18 | 6780.0 |
| 2022-10-11 22:00:00 | NQ | Futures | 12487.18 | 12507.58 | 12458.45 | 12502.12 | 6481.0 |
| 2022-10-11 23:00:00 | NQ | Futures | 12502.12 | 12512.76 | 12483.45 | 12490.63 | 3593.0 |
| 2022-10-11 00:00:00 | YM | Futures | 32662.6 | 32692.9 | 32621.1 | 32646.9 | 1296.0 |
| 2022-10-11 01:00:00 | YM | Futures | 32649.1 | 32686.2 | 32627.8 | 32660.4 | 1295.0 |
| 2022-10-11 02:00:00 | YM | Futures | 32655.9 | 32740.0 | 32566.1 | 32585.2 | 3248.0 |
| 2022-10-11 03:00:00 | YM | Futures | 32586.3 | 32712.0 | 32484.2 | 32588.5 | 6498.0 |
> showing 50 of 2,066 rows — these rows as CSV