PREVIEW / futures_1hour / 2022-10-31
file: by_date/futures_1hour/2022/2022-10-31.parquet size: 69 KB rows: 2,108
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-31 00:00:00 | ES | Futures | 4406.28 | 4407.69 | 4401.77 | 4402.61 | 4466.0 |
| 2022-10-31 01:00:00 | ES | Futures | 4402.61 | 4407.97 | 4400.08 | 4402.9 | 6891.0 |
| 2022-10-31 02:00:00 | ES | Futures | 4402.9 | 4404.87 | 4396.98 | 4400.08 | 7912.0 |
| 2022-10-31 03:00:00 | ES | Futures | 4400.08 | 4404.59 | 4393.88 | 4404.02 | 11027.0 |
| 2022-10-31 04:00:00 | ES | Futures | 4404.31 | 4404.59 | 4379.5 | 4384.29 | 25946.0 |
| 2022-10-31 05:00:00 | ES | Futures | 4384.57 | 4392.47 | 4380.63 | 4387.67 | 15857.0 |
| 2022-10-31 06:00:00 | ES | Futures | 4387.67 | 4390.77 | 4383.45 | 4389.93 | 11990.0 |
| 2022-10-31 07:00:00 | ES | Futures | 4389.65 | 4400.36 | 4389.65 | 4391.9 | 23899.0 |
| 2022-10-31 08:00:00 | ES | Futures | 4392.18 | 4393.03 | 4381.19 | 4385.7 | 39176.0 |
| 2022-10-31 09:00:00 | ES | Futures | 4385.7 | 4391.62 | 4368.79 | 4368.79 | 241082.0 |
| 2022-10-31 10:00:00 | ES | Futures | 4369.07 | 4385.14 | 4366.25 | 4376.4 | 237856.0 |
| 2022-10-31 11:00:00 | ES | Futures | 4376.4 | 4402.61 | 4375.27 | 4387.11 | 216979.0 |
| 2022-10-31 12:00:00 | ES | Futures | 4387.11 | 4397.54 | 4372.17 | 4377.81 | 191803.0 |
| 2022-10-31 13:00:00 | ES | Futures | 4378.09 | 4393.03 | 4372.45 | 4387.11 | 145698.0 |
| 2022-10-31 14:00:00 | ES | Futures | 4386.83 | 4394.72 | 4380.91 | 4385.42 | 144027.0 |
| 2022-10-31 15:00:00 | ES | Futures | 4385.42 | 4392.18 | 4369.63 | 4378.09 | 414502.0 |
| 2022-10-31 16:00:00 | ES | Futures | 4378.09 | 4382.88 | 4374.71 | 4378.09 | 78968.0 |
| 2022-10-31 18:00:00 | ES | Futures | 4379.5 | 4383.73 | 4376.12 | 4381.19 | 7109.0 |
| 2022-10-31 19:00:00 | ES | Futures | 4381.19 | 4387.96 | 4381.19 | 4384.57 | 8980.0 |
| 2022-10-31 20:00:00 | ES | Futures | 4384.57 | 4390.21 | 4382.88 | 4386.55 | 10705.0 |
| 2022-10-31 21:00:00 | ES | Futures | 4386.55 | 4393.03 | 4385.7 | 4392.47 | 8790.0 |
| 2022-10-31 22:00:00 | ES | Futures | 4392.18 | 4397.54 | 4391.34 | 4396.69 | 8134.0 |
| 2022-10-31 23:00:00 | ES | Futures | 4396.98 | 4398.39 | 4391.34 | 4394.72 | 7722.0 |
| 2022-10-31 00:00:00 | NQ | Futures | 13296.29 | 13302.04 | 13279.63 | 13282.79 | 2079.0 |
| 2022-10-31 01:00:00 | NQ | Futures | 13282.79 | 13300.6 | 13266.41 | 13276.47 | 3016.0 |
| 2022-10-31 02:00:00 | NQ | Futures | 13277.33 | 13282.79 | 13256.07 | 13265.26 | 3911.0 |
| 2022-10-31 03:00:00 | NQ | Futures | 13265.26 | 13288.82 | 13246.01 | 13287.96 | 5289.0 |
| 2022-10-31 04:00:00 | NQ | Futures | 13289.4 | 13289.97 | 13198.31 | 13216.13 | 12808.0 |
| 2022-10-31 05:00:00 | NQ | Futures | 13215.27 | 13242.28 | 13204.06 | 13224.17 | 6960.0 |
| 2022-10-31 06:00:00 | NQ | Futures | 13224.75 | 13237.1 | 13210.38 | 13234.23 | 6109.0 |
| 2022-10-31 07:00:00 | NQ | Futures | 13233.37 | 13269.28 | 13233.08 | 13243.14 | 10637.0 |
| 2022-10-31 08:00:00 | NQ | Futures | 13243.42 | 13245.72 | 13205.21 | 13221.88 | 14711.0 |
| 2022-10-31 09:00:00 | NQ | Futures | 13222.16 | 13242.85 | 13117.0 | 13128.21 | 94365.0 |
| 2022-10-31 10:00:00 | NQ | Futures | 13128.49 | 13163.26 | 13064.42 | 13116.43 | 86766.0 |
| 2022-10-31 11:00:00 | NQ | Futures | 13116.43 | 13216.99 | 13109.53 | 13170.44 | 70235.0 |
| 2022-10-31 12:00:00 | NQ | Futures | 13170.44 | 13232.22 | 13130.22 | 13154.64 | 59123.0 |
| 2022-10-31 13:00:00 | NQ | Futures | 13155.5 | 13213.83 | 13132.8 | 13186.25 | 43235.0 |
| 2022-10-31 14:00:00 | NQ | Futures | 13185.39 | 13215.55 | 13161.25 | 13180.79 | 48919.0 |
| 2022-10-31 15:00:00 | NQ | Futures | 13180.5 | 13196.88 | 13121.02 | 13157.51 | 84535.0 |
| 2022-10-31 16:00:00 | NQ | Futures | 13158.09 | 13182.22 | 13144.3 | 13162.69 | 15201.0 |
| 2022-10-31 18:00:00 | NQ | Futures | 13165.27 | 13179.93 | 13155.79 | 13173.03 | 2590.0 |
| 2022-10-31 19:00:00 | NQ | Futures | 13173.6 | 13193.72 | 13173.03 | 13181.08 | 2803.0 |
| 2022-10-31 20:00:00 | NQ | Futures | 13181.65 | 13210.38 | 13174.75 | 13197.45 | 4747.0 |
| 2022-10-31 21:00:00 | NQ | Futures | 13197.45 | 13211.24 | 13194.29 | 13210.1 | 4193.0 |
| 2022-10-31 22:00:00 | NQ | Futures | 13210.1 | 13216.99 | 13199.75 | 13215.84 | 4564.0 |
| 2022-10-31 23:00:00 | NQ | Futures | 13216.13 | 13216.99 | 13194.87 | 13205.5 | 3372.0 |
| 2022-10-31 00:00:00 | YM | Futures | 36903.5 | 36918.1 | 36881.1 | 36890.1 | 664.0 |
| 2022-10-31 01:00:00 | YM | Futures | 36886.7 | 36924.9 | 36873.2 | 36893.4 | 955.0 |
| 2022-10-31 02:00:00 | YM | Futures | 36893.4 | 36906.9 | 36850.8 | 36871.0 | 1053.0 |
| 2022-10-31 03:00:00 | YM | Futures | 36872.1 | 36899.0 | 36832.8 | 36894.6 | 1948.0 |
> showing 50 of 2,108 rows — these rows as CSV