PREVIEW / futures_1hour / 2022-10-13
file: by_date/futures_1hour/2022/2022-10-13.parquet size: 71 KB rows: 2,091
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-13 00:00:00 | ES | Futures | 4052.22 | 4053.91 | 4049.12 | 4050.25 | 4300.0 |
| 2022-10-13 01:00:00 | ES | Futures | 4050.25 | 4055.6 | 4045.74 | 4046.58 | 8566.0 |
| 2022-10-13 02:00:00 | ES | Futures | 4046.3 | 4050.25 | 4043.48 | 4046.86 | 14076.0 |
| 2022-10-13 03:00:00 | ES | Futures | 4046.58 | 4057.01 | 4038.69 | 4053.07 | 26183.0 |
| 2022-10-13 04:00:00 | ES | Futures | 4053.07 | 4063.5 | 4048.27 | 4061.52 | 16769.0 |
| 2022-10-13 05:00:00 | ES | Futures | 4061.52 | 4071.95 | 4061.24 | 4064.34 | 18082.0 |
| 2022-10-13 06:00:00 | ES | Futures | 4064.06 | 4070.83 | 4061.52 | 4067.44 | 15893.0 |
| 2022-10-13 07:00:00 | ES | Futures | 4067.72 | 4095.91 | 4066.32 | 4085.2 | 58967.0 |
| 2022-10-13 08:00:00 | ES | Futures | 4085.48 | 4109.73 | 3954.12 | 3969.63 | 302022.0 |
| 2022-10-13 09:00:00 | ES | Futures | 3969.63 | 3998.38 | 3948.77 | 3991.9 | 426032.0 |
| 2022-10-13 10:00:00 | ES | Futures | 3992.18 | 4023.47 | 3985.98 | 4010.22 | 441823.0 |
| 2022-10-13 11:00:00 | ES | Futures | 4010.78 | 4144.4 | 4007.96 | 4116.21 | 659968.0 |
| 2022-10-13 12:00:00 | ES | Futures | 4116.21 | 4129.18 | 4094.79 | 4117.62 | 303931.0 |
| 2022-10-13 13:00:00 | ES | Futures | 4117.9 | 4158.21 | 4117.34 | 4147.22 | 217593.0 |
| 2022-10-13 14:00:00 | ES | Futures | 4147.22 | 4165.26 | 4129.46 | 4161.6 | 207747.0 |
| 2022-10-13 15:00:00 | ES | Futures | 4161.6 | 4169.49 | 4141.58 | 4151.73 | 364730.0 |
| 2022-10-13 16:00:00 | ES | Futures | 4152.01 | 4158.78 | 4147.5 | 4149.76 | 65288.0 |
| 2022-10-13 18:00:00 | ES | Futures | 4149.76 | 4156.24 | 4147.22 | 4152.86 | 8405.0 |
| 2022-10-13 19:00:00 | ES | Futures | 4152.86 | 4154.55 | 4148.91 | 4149.19 | 7104.0 |
| 2022-10-13 20:00:00 | ES | Futures | 4149.19 | 4151.17 | 4138.48 | 4148.35 | 19827.0 |
| 2022-10-13 21:00:00 | ES | Futures | 4148.63 | 4178.79 | 4146.09 | 4175.97 | 25515.0 |
| 2022-10-13 22:00:00 | ES | Futures | 4175.97 | 4184.15 | 4171.46 | 4175.13 | 16472.0 |
| 2022-10-13 23:00:00 | ES | Futures | 4175.13 | 4189.5 | 4172.87 | 4183.02 | 12905.0 |
| 2022-10-13 00:00:00 | NQ | Futures | 12470.52 | 12479.14 | 12455.0 | 12459.03 | 2408.0 |
| 2022-10-13 01:00:00 | NQ | Futures | 12460.75 | 12477.13 | 12441.21 | 12447.82 | 4941.0 |
| 2022-10-13 02:00:00 | NQ | Futures | 12446.96 | 12461.61 | 12436.61 | 12449.54 | 5876.0 |
| 2022-10-13 03:00:00 | NQ | Futures | 12449.26 | 12473.1 | 12416.21 | 12457.59 | 12106.0 |
| 2022-10-13 04:00:00 | NQ | Futures | 12457.59 | 12485.46 | 12439.49 | 12477.7 | 8985.0 |
| 2022-10-13 05:00:00 | NQ | Futures | 12477.99 | 12511.32 | 12476.26 | 12483.16 | 11091.0 |
| 2022-10-13 06:00:00 | NQ | Futures | 12482.87 | 12507.01 | 12475.12 | 12493.79 | 7591.0 |
| 2022-10-13 07:00:00 | NQ | Futures | 12494.08 | 12577.98 | 12486.61 | 12545.22 | 23971.0 |
| 2022-10-13 08:00:00 | NQ | Futures | 12545.51 | 12641.19 | 12069.99 | 12116.82 | 98444.0 |
| 2022-10-13 09:00:00 | NQ | Futures | 12115.96 | 12216.81 | 12050.16 | 12199.86 | 139920.0 |
| 2022-10-13 10:00:00 | NQ | Futures | 12200.14 | 12307.89 | 12178.88 | 12248.13 | 147201.0 |
| 2022-10-13 11:00:00 | NQ | Futures | 12248.7 | 12774.22 | 12231.75 | 12646.94 | 213537.0 |
| 2022-10-13 12:00:00 | NQ | Futures | 12646.94 | 12695.78 | 12543.79 | 12610.45 | 81145.0 |
| 2022-10-13 13:00:00 | NQ | Futures | 12611.31 | 12777.09 | 12611.31 | 12723.65 | 77067.0 |
| 2022-10-13 14:00:00 | NQ | Futures | 12723.65 | 12781.98 | 12650.1 | 12765.31 | 65887.0 |
| 2022-10-13 15:00:00 | NQ | Futures | 12765.31 | 12806.4 | 12703.83 | 12736.29 | 96180.0 |
| 2022-10-13 16:00:00 | NQ | Futures | 12735.72 | 12771.92 | 12712.16 | 12717.62 | 18143.0 |
| 2022-10-13 18:00:00 | NQ | Futures | 12716.76 | 12741.47 | 12708.71 | 12727.39 | 5661.0 |
| 2022-10-13 19:00:00 | NQ | Futures | 12727.96 | 12739.17 | 12715.89 | 12716.47 | 5442.0 |
| 2022-10-13 20:00:00 | NQ | Futures | 12716.18 | 12720.78 | 12667.34 | 12711.01 | 8999.0 |
| 2022-10-13 21:00:00 | NQ | Futures | 12710.72 | 12824.79 | 12703.54 | 12817.9 | 11969.0 |
| 2022-10-13 22:00:00 | NQ | Futures | 12818.18 | 12842.32 | 12797.21 | 12808.41 | 9044.0 |
| 2022-10-13 23:00:00 | NQ | Futures | 12808.7 | 12854.96 | 12794.33 | 12834.27 | 6233.0 |
| 2022-10-13 00:00:00 | YM | Futures | 32877.0 | 32887.1 | 32860.1 | 32861.2 | 398.0 |
| 2022-10-13 01:00:00 | YM | Futures | 32861.2 | 32911.7 | 32802.9 | 32841.0 | 2157.0 |
| 2022-10-13 02:00:00 | YM | Futures | 32838.8 | 32869.1 | 32815.2 | 32835.4 | 1492.0 |
| 2022-10-13 03:00:00 | YM | Futures | 32834.3 | 32937.6 | 32780.4 | 32900.5 | 3292.0 |
> showing 50 of 2,091 rows — these rows as CSV