PREVIEW / futures_1hour / 2022-11-30
file: by_date/futures_1hour/2022/2022-11-30.parquet size: 69 KB rows: 2,079
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-11-30 00:00:00 | ES | Futures | 4473.65 | 4476.47 | 4470.83 | 4471.11 | 6233.0 |
| 2022-11-30 01:00:00 | ES | Futures | 4471.11 | 4475.06 | 4470.83 | 4473.09 | 5309.0 |
| 2022-11-30 02:00:00 | ES | Futures | 4473.09 | 4477.88 | 4472.24 | 4475.34 | 10640.0 |
| 2022-11-30 03:00:00 | ES | Futures | 4475.06 | 4482.11 | 4472.24 | 4476.19 | 20587.0 |
| 2022-11-30 04:00:00 | ES | Futures | 4476.19 | 4485.21 | 4473.37 | 4476.47 | 19314.0 |
| 2022-11-30 05:00:00 | ES | Futures | 4476.47 | 4479.85 | 4473.09 | 4473.65 | 10898.0 |
| 2022-11-30 06:00:00 | ES | Futures | 4473.65 | 4479.01 | 4471.68 | 4477.32 | 8148.0 |
| 2022-11-30 07:00:00 | ES | Futures | 4477.6 | 4479.01 | 4473.65 | 4474.78 | 13989.0 |
| 2022-11-30 08:00:00 | ES | Futures | 4474.78 | 4487.75 | 4463.22 | 4463.79 | 61228.0 |
| 2022-11-30 09:00:00 | ES | Futures | 4463.5 | 4477.03 | 4461.53 | 4464.91 | 160156.0 |
| 2022-11-30 10:00:00 | ES | Futures | 4465.48 | 4467.73 | 4449.97 | 4453.92 | 189318.0 |
| 2022-11-30 11:00:00 | ES | Futures | 4454.2 | 4469.7 | 4448.84 | 4464.91 | 139033.0 |
| 2022-11-30 12:00:00 | ES | Futures | 4464.91 | 4467.17 | 4445.74 | 4454.2 | 153224.0 |
| 2022-11-30 13:00:00 | ES | Futures | 4453.92 | 4519.88 | 4452.23 | 4516.22 | 320557.0 |
| 2022-11-30 14:00:00 | ES | Futures | 4516.5 | 4559.91 | 4515.94 | 4556.81 | 397503.0 |
| 2022-11-30 15:00:00 | ES | Futures | 4556.81 | 4604.45 | 4554.55 | 4603.32 | 597103.0 |
| 2022-11-30 16:00:00 | ES | Futures | 4603.32 | 4615.73 | 4595.99 | 4615.16 | 203095.0 |
| 2022-11-30 18:00:00 | ES | Futures | 4616.85 | 4618.54 | 4607.83 | 4612.91 | 16860.0 |
| 2022-11-30 19:00:00 | ES | Futures | 4612.62 | 4616.01 | 4608.4 | 4609.52 | 17056.0 |
| 2022-11-30 20:00:00 | ES | Futures | 4609.52 | 4612.91 | 4605.3 | 4606.42 | 20022.0 |
| 2022-11-30 21:00:00 | ES | Futures | 4606.42 | 4607.55 | 4601.91 | 4604.45 | 12672.0 |
| 2022-11-30 22:00:00 | ES | Futures | 4604.45 | 4608.96 | 4601.07 | 4608.11 | 11855.0 |
| 2022-11-30 23:00:00 | ES | Futures | 4608.11 | 4613.19 | 4606.71 | 4610.37 | 6910.0 |
| 2022-11-30 00:00:00 | NQ | Futures | 13263.54 | 13271.3 | 13254.63 | 13255.49 | 2516.0 |
| 2022-11-30 01:00:00 | NQ | Futures | 13255.49 | 13262.68 | 13249.46 | 13254.34 | 2355.0 |
| 2022-11-30 02:00:00 | NQ | Futures | 13254.34 | 13274.17 | 13252.33 | 13264.97 | 4672.0 |
| 2022-11-30 03:00:00 | NQ | Futures | 13264.11 | 13300.89 | 13259.52 | 13291.98 | 9406.0 |
| 2022-11-30 04:00:00 | NQ | Futures | 13292.84 | 13316.41 | 13274.74 | 13288.53 | 8942.0 |
| 2022-11-30 05:00:00 | NQ | Futures | 13287.67 | 13304.63 | 13280.2 | 13287.67 | 5831.0 |
| 2022-11-30 06:00:00 | NQ | Futures | 13287.1 | 13305.77 | 13275.89 | 13301.75 | 4205.0 |
| 2022-11-30 07:00:00 | NQ | Futures | 13301.75 | 13304.05 | 13282.79 | 13285.37 | 5466.0 |
| 2022-11-30 08:00:00 | NQ | Futures | 13285.66 | 13329.34 | 13236.53 | 13239.69 | 28207.0 |
| 2022-11-30 09:00:00 | NQ | Futures | 13239.69 | 13310.66 | 13235.67 | 13291.41 | 63628.0 |
| 2022-11-30 10:00:00 | NQ | Futures | 13292.27 | 13307.21 | 13239.11 | 13250.03 | 70356.0 |
| 2022-11-30 11:00:00 | NQ | Futures | 13250.9 | 13304.05 | 13226.47 | 13285.09 | 52582.0 |
| 2022-11-30 12:00:00 | NQ | Futures | 13285.37 | 13293.71 | 13214.69 | 13252.33 | 53886.0 |
| 2022-11-30 13:00:00 | NQ | Futures | 13252.33 | 13524.14 | 13249.75 | 13508.63 | 119065.0 |
| 2022-11-30 14:00:00 | NQ | Futures | 13508.91 | 13713.49 | 13506.04 | 13674.7 | 135307.0 |
| 2022-11-30 15:00:00 | NQ | Futures | 13674.99 | 13853.42 | 13661.2 | 13850.83 | 127300.0 |
| 2022-11-30 16:00:00 | NQ | Futures | 13850.54 | 13881.86 | 13823.82 | 13880.14 | 36740.0 |
| 2022-11-30 18:00:00 | NQ | Futures | 13882.72 | 13890.48 | 13859.74 | 13876.12 | 6006.0 |
| 2022-11-30 19:00:00 | NQ | Futures | 13875.25 | 13884.74 | 13859.45 | 13864.91 | 5394.0 |
| 2022-11-30 20:00:00 | NQ | Futures | 13864.62 | 13871.23 | 13846.23 | 13848.25 | 5631.0 |
| 2022-11-30 21:00:00 | NQ | Futures | 13847.96 | 13852.27 | 13826.98 | 13835.03 | 4935.0 |
| 2022-11-30 22:00:00 | NQ | Futures | 13835.03 | 13850.83 | 13822.67 | 13847.67 | 3760.0 |
| 2022-11-30 23:00:00 | NQ | Futures | 13847.67 | 13868.65 | 13843.65 | 13859.74 | 2814.0 |
| 2022-11-30 00:00:00 | YM | Futures | 38040.4 | 38059.4 | 38022.4 | 38023.5 | 827.0 |
| 2022-11-30 01:00:00 | YM | Futures | 38024.6 | 38058.3 | 38023.5 | 38047.1 | 1135.0 |
| 2022-11-30 02:00:00 | YM | Futures | 38046.0 | 38075.1 | 38040.4 | 38058.3 | 2346.0 |
| 2022-11-30 03:00:00 | YM | Futures | 38056.1 | 38094.2 | 38016.8 | 38041.5 | 3512.0 |
> showing 50 of 2,079 rows — these rows as CSV