PREVIEW / futures_1hour / 2024-01-08
file: by_date/futures_1hour/2024/2024-01-08.parquet size: 69 KB rows: 2,100
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 |
|---|---|---|---|---|---|---|---|
| 2024-01-08 00:00:00 | ES | Futures | 5084.42 | 5085.76 | 5081.2 | 5082.27 | 4054.0 |
| 2024-01-08 01:00:00 | ES | Futures | 5082.27 | 5084.69 | 5079.85 | 5080.93 | 4523.0 |
| 2024-01-08 02:00:00 | ES | Futures | 5080.66 | 5086.3 | 5080.66 | 5081.47 | 7304.0 |
| 2024-01-08 03:00:00 | ES | Futures | 5081.73 | 5087.91 | 5078.51 | 5080.93 | 17211.0 |
| 2024-01-08 04:00:00 | ES | Futures | 5081.2 | 5081.2 | 5065.89 | 5076.36 | 25513.0 |
| 2024-01-08 05:00:00 | ES | Futures | 5076.09 | 5080.93 | 5075.02 | 5075.83 | 12450.0 |
| 2024-01-08 06:00:00 | ES | Futures | 5075.83 | 5084.96 | 5072.06 | 5083.08 | 16577.0 |
| 2024-01-08 07:00:00 | ES | Futures | 5083.08 | 5087.91 | 5080.93 | 5087.37 | 17900.0 |
| 2024-01-08 08:00:00 | ES | Futures | 5087.37 | 5091.94 | 5084.69 | 5087.11 | 28515.0 |
| 2024-01-08 09:00:00 | ES | Futures | 5087.37 | 5106.18 | 5084.69 | 5105.64 | 186706.0 |
| 2024-01-08 10:00:00 | ES | Futures | 5105.37 | 5116.65 | 5101.34 | 5112.62 | 168899.0 |
| 2024-01-08 11:00:00 | ES | Futures | 5112.62 | 5118.26 | 5108.06 | 5117.99 | 115372.0 |
| 2024-01-08 12:00:00 | ES | Futures | 5117.99 | 5126.32 | 5114.5 | 5124.71 | 99503.0 |
| 2024-01-08 13:00:00 | ES | Futures | 5124.71 | 5131.42 | 5122.02 | 5130.62 | 74155.0 |
| 2024-01-08 14:00:00 | ES | Futures | 5130.62 | 5152.64 | 5129.54 | 5149.96 | 151395.0 |
| 2024-01-08 15:00:00 | ES | Futures | 5149.69 | 5160.43 | 5145.66 | 5158.55 | 274627.0 |
| 2024-01-08 16:00:00 | ES | Futures | 5158.28 | 5158.55 | 5153.99 | 5154.79 | 98788.0 |
| 2024-01-08 18:00:00 | ES | Futures | 5154.52 | 5155.6 | 5152.64 | 5153.99 | 5367.0 |
| 2024-01-08 19:00:00 | ES | Futures | 5153.99 | 5155.6 | 5153.18 | 5153.99 | 4541.0 |
| 2024-01-08 20:00:00 | ES | Futures | 5153.99 | 5154.79 | 5152.37 | 5153.99 | 6088.0 |
| 2024-01-08 21:00:00 | ES | Futures | 5153.99 | 5155.6 | 5153.18 | 5154.52 | 5260.0 |
| 2024-01-08 22:00:00 | ES | Futures | 5154.52 | 5155.06 | 5153.18 | 5154.25 | 2691.0 |
| 2024-01-08 23:00:00 | ES | Futures | 5154.25 | 5154.25 | 5151.3 | 5152.64 | 4095.0 |
| 2024-01-08 00:00:00 | NQ | Futures | 17843.43 | 17850.75 | 17830.41 | 17836.11 | 3228.0 |
| 2024-01-08 01:00:00 | NQ | Futures | 17835.84 | 17848.31 | 17825.8 | 17832.85 | 3462.0 |
| 2024-01-08 02:00:00 | NQ | Futures | 17833.4 | 17858.35 | 17831.23 | 17837.46 | 4703.0 |
| 2024-01-08 03:00:00 | NQ | Futures | 17838.28 | 17850.75 | 17816.04 | 17817.67 | 7441.0 |
| 2024-01-08 04:00:00 | NQ | Futures | 17818.75 | 17832.58 | 17767.49 | 17813.06 | 10931.0 |
| 2024-01-08 05:00:00 | NQ | Futures | 17812.78 | 17839.09 | 17812.51 | 17817.4 | 6004.0 |
| 2024-01-08 06:00:00 | NQ | Futures | 17817.67 | 17864.04 | 17801.94 | 17854.82 | 11275.0 |
| 2024-01-08 07:00:00 | NQ | Futures | 17854.55 | 17884.65 | 17847.77 | 17883.03 | 9753.0 |
| 2024-01-08 08:00:00 | NQ | Futures | 17882.48 | 17897.13 | 17866.48 | 17875.16 | 13371.0 |
| 2024-01-08 09:00:00 | NQ | Futures | 17874.89 | 18044.39 | 17869.47 | 18038.97 | 94666.0 |
| 2024-01-08 10:00:00 | NQ | Futures | 18038.97 | 18085.35 | 18021.88 | 18070.97 | 78651.0 |
| 2024-01-08 11:00:00 | NQ | Futures | 18071.24 | 18094.03 | 18051.72 | 18091.86 | 58991.0 |
| 2024-01-08 12:00:00 | NQ | Futures | 18092.13 | 18136.88 | 18088.87 | 18134.98 | 47658.0 |
| 2024-01-08 13:00:00 | NQ | Futures | 18134.71 | 18162.91 | 18123.04 | 18161.56 | 29386.0 |
| 2024-01-08 14:00:00 | NQ | Futures | 18161.56 | 18217.97 | 18150.98 | 18208.47 | 44056.0 |
| 2024-01-08 15:00:00 | NQ | Futures | 18208.2 | 18237.22 | 18193.29 | 18226.37 | 72422.0 |
| 2024-01-08 16:00:00 | NQ | Futures | 18226.37 | 18231.53 | 18210.64 | 18212.27 | 16423.0 |
| 2024-01-08 18:00:00 | NQ | Futures | 18212.0 | 18214.98 | 18203.86 | 18209.02 | 3038.0 |
| 2024-01-08 19:00:00 | NQ | Futures | 18209.02 | 18217.97 | 18206.58 | 18211.46 | 3020.0 |
| 2024-01-08 20:00:00 | NQ | Futures | 18210.64 | 18216.34 | 18206.03 | 18213.08 | 3365.0 |
| 2024-01-08 21:00:00 | NQ | Futures | 18213.08 | 18220.68 | 18209.83 | 18219.05 | 3171.0 |
| 2024-01-08 22:00:00 | NQ | Futures | 18219.05 | 18220.68 | 18209.83 | 18213.63 | 1805.0 |
| 2024-01-08 23:00:00 | NQ | Futures | 18213.36 | 18213.63 | 18200.07 | 18204.95 | 2620.0 |
| 2024-01-08 00:00:00 | YM | Futures | 40372.4 | 40378.9 | 40360.6 | 40367.1 | 653.0 |
| 2024-01-08 01:00:00 | YM | Futures | 40368.1 | 40383.2 | 40352.0 | 40352.0 | 1266.0 |
| 2024-01-08 02:00:00 | YM | Futures | 40352.0 | 40379.9 | 40348.8 | 40350.9 | 1836.0 |
| 2024-01-08 03:00:00 | YM | Futures | 40352.0 | 40414.3 | 40339.1 | 40374.6 | 3666.0 |
> showing 50 of 2,100 rows — these rows as CSV