PREVIEW / futures_1hour / 2023-12-28
file: by_date/futures_1hour/2023/2023-12-28.parquet size: 65 KB rows: 2,077
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-12-28 00:00:00 | ES | Futures | 5198.57 | 5200.45 | 5198.57 | 5199.91 | 3443.0 |
| 2023-12-28 01:00:00 | ES | Futures | 5199.91 | 5200.99 | 5198.84 | 5200.45 | 3301.0 |
| 2023-12-28 02:00:00 | ES | Futures | 5200.72 | 5201.26 | 5199.11 | 5199.91 | 4095.0 |
| 2023-12-28 03:00:00 | ES | Futures | 5199.91 | 5200.18 | 5193.74 | 5194.01 | 11156.0 |
| 2023-12-28 04:00:00 | ES | Futures | 5194.01 | 5194.81 | 5192.39 | 5193.2 | 8801.0 |
| 2023-12-28 05:00:00 | ES | Futures | 5193.47 | 5195.62 | 5190.51 | 5191.59 | 10294.0 |
| 2023-12-28 06:00:00 | ES | Futures | 5191.59 | 5194.54 | 5190.51 | 5192.39 | 8396.0 |
| 2023-12-28 07:00:00 | ES | Futures | 5192.66 | 5195.08 | 5191.59 | 5193.2 | 7829.0 |
| 2023-12-28 08:00:00 | ES | Futures | 5193.2 | 5195.62 | 5188.63 | 5188.63 | 19147.0 |
| 2023-12-28 09:00:00 | ES | Futures | 5188.9 | 5197.23 | 5188.1 | 5195.35 | 109319.0 |
| 2023-12-28 10:00:00 | ES | Futures | 5195.08 | 5199.11 | 5191.05 | 5194.27 | 108468.0 |
| 2023-12-28 11:00:00 | ES | Futures | 5194.27 | 5195.08 | 5189.17 | 5192.12 | 84030.0 |
| 2023-12-28 12:00:00 | ES | Futures | 5192.12 | 5198.3 | 5191.32 | 5196.96 | 55985.0 |
| 2023-12-28 13:00:00 | ES | Futures | 5196.96 | 5199.65 | 5187.56 | 5194.01 | 98213.0 |
| 2023-12-28 14:00:00 | ES | Futures | 5194.01 | 5199.65 | 5193.74 | 5196.15 | 62165.0 |
| 2023-12-28 15:00:00 | ES | Futures | 5196.42 | 5198.03 | 5187.02 | 5192.39 | 187262.0 |
| 2023-12-28 16:00:00 | ES | Futures | 5192.66 | 5194.81 | 5191.32 | 5192.93 | 36267.0 |
| 2023-12-28 18:00:00 | ES | Futures | 5194.27 | 5195.35 | 5191.86 | 5194.81 | 4893.0 |
| 2023-12-28 19:00:00 | ES | Futures | 5194.81 | 5195.62 | 5193.74 | 5195.08 | 4299.0 |
| 2023-12-28 20:00:00 | ES | Futures | 5195.08 | 5195.62 | 5192.39 | 5194.27 | 4926.0 |
| 2023-12-28 21:00:00 | ES | Futures | 5194.01 | 5196.15 | 5193.74 | 5195.08 | 3487.0 |
| 2023-12-28 22:00:00 | ES | Futures | 5194.81 | 5196.69 | 5194.81 | 5195.62 | 2991.0 |
| 2023-12-28 23:00:00 | ES | Futures | 5195.62 | 5196.42 | 5194.01 | 5194.81 | 2951.0 |
| 2023-12-28 00:00:00 | NQ | Futures | 18595.48 | 18601.99 | 18594.94 | 18601.72 | 2042.0 |
| 2023-12-28 01:00:00 | NQ | Futures | 18601.45 | 18607.15 | 18599.01 | 18605.25 | 2197.0 |
| 2023-12-28 02:00:00 | NQ | Futures | 18605.79 | 18611.49 | 18602.81 | 18609.32 | 2853.0 |
| 2023-12-28 03:00:00 | NQ | Futures | 18609.86 | 18613.93 | 18599.82 | 18603.08 | 4866.0 |
| 2023-12-28 04:00:00 | NQ | Futures | 18603.35 | 18611.49 | 18599.28 | 18601.72 | 4317.0 |
| 2023-12-28 05:00:00 | NQ | Futures | 18602.26 | 18611.49 | 18600.37 | 18602.26 | 3301.0 |
| 2023-12-28 06:00:00 | NQ | Futures | 18601.99 | 18608.5 | 18598.47 | 18604.16 | 3064.0 |
| 2023-12-28 07:00:00 | NQ | Futures | 18604.16 | 18617.72 | 18601.45 | 18608.77 | 5301.0 |
| 2023-12-28 08:00:00 | NQ | Futures | 18609.04 | 18621.25 | 18596.3 | 18596.57 | 9681.0 |
| 2023-12-28 09:00:00 | NQ | Futures | 18596.84 | 18614.47 | 18566.47 | 18577.04 | 51984.0 |
| 2023-12-28 10:00:00 | NQ | Futures | 18577.04 | 18598.74 | 18553.45 | 18582.2 | 54968.0 |
| 2023-12-28 11:00:00 | NQ | Futures | 18582.47 | 18583.01 | 18555.35 | 18564.3 | 38521.0 |
| 2023-12-28 12:00:00 | NQ | Futures | 18564.57 | 18586.81 | 18560.23 | 18584.09 | 27193.0 |
| 2023-12-28 13:00:00 | NQ | Futures | 18584.36 | 18591.14 | 18542.6 | 18566.47 | 39393.0 |
| 2023-12-28 14:00:00 | NQ | Futures | 18567.28 | 18581.92 | 18561.58 | 18567.28 | 22603.0 |
| 2023-12-28 15:00:00 | NQ | Futures | 18567.28 | 18568.09 | 18526.33 | 18540.43 | 52878.0 |
| 2023-12-28 16:00:00 | NQ | Futures | 18540.7 | 18552.63 | 18535.01 | 18539.07 | 9022.0 |
| 2023-12-28 18:00:00 | NQ | Futures | 18539.89 | 18552.36 | 18532.29 | 18551.01 | 2833.0 |
| 2023-12-28 19:00:00 | NQ | Futures | 18551.01 | 18559.96 | 18547.21 | 18559.96 | 2948.0 |
| 2023-12-28 20:00:00 | NQ | Futures | 18559.41 | 18560.23 | 18547.21 | 18551.28 | 3147.0 |
| 2023-12-28 21:00:00 | NQ | Futures | 18550.74 | 18555.62 | 18546.94 | 18547.48 | 2273.0 |
| 2023-12-28 22:00:00 | NQ | Futures | 18546.94 | 18554.26 | 18546.12 | 18550.74 | 1496.0 |
| 2023-12-28 23:00:00 | NQ | Futures | 18551.01 | 18553.45 | 18536.9 | 18542.6 | 2685.0 |
| 2023-12-28 00:00:00 | YM | Futures | 40825.7 | 40845.0 | 40825.7 | 40837.5 | 506.0 |
| 2023-12-28 01:00:00 | YM | Futures | 40837.5 | 40839.7 | 40828.9 | 40835.4 | 362.0 |
| 2023-12-28 02:00:00 | YM | Futures | 40835.4 | 40837.5 | 40820.3 | 40826.8 | 823.0 |
| 2023-12-28 03:00:00 | YM | Futures | 40827.8 | 40831.1 | 40774.1 | 40775.2 | 1866.0 |
> showing 50 of 2,077 rows — these rows as CSV