PREVIEW / futures_1hour / 2024-01-05
file: by_date/futures_1hour/2024/2024-01-05.parquet size: 57 KB rows: 1,660
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-05 00:00:00 | ES | Futures | 5083.88 | 5084.42 | 5081.2 | 5082.0 | 3540.0 |
| 2024-01-05 01:00:00 | ES | Futures | 5081.73 | 5083.61 | 5073.68 | 5076.9 | 8916.0 |
| 2024-01-05 02:00:00 | ES | Futures | 5076.9 | 5079.85 | 5073.14 | 5073.95 | 7906.0 |
| 2024-01-05 03:00:00 | ES | Futures | 5074.21 | 5080.12 | 5073.68 | 5074.48 | 15222.0 |
| 2024-01-05 04:00:00 | ES | Futures | 5074.48 | 5076.36 | 5068.3 | 5069.11 | 19321.0 |
| 2024-01-05 05:00:00 | ES | Futures | 5069.11 | 5071.8 | 5064.28 | 5069.38 | 16094.0 |
| 2024-01-05 06:00:00 | ES | Futures | 5069.11 | 5070.99 | 5061.59 | 5068.04 | 16682.0 |
| 2024-01-05 07:00:00 | ES | Futures | 5068.04 | 5071.53 | 5065.08 | 5067.23 | 20953.0 |
| 2024-01-05 08:00:00 | ES | Futures | 5066.96 | 5075.29 | 5051.65 | 5070.72 | 147732.0 |
| 2024-01-05 09:00:00 | ES | Futures | 5070.72 | 5094.09 | 5070.18 | 5088.99 | 244190.0 |
| 2024-01-05 10:00:00 | ES | Futures | 5089.25 | 5113.97 | 5088.99 | 5110.74 | 276881.0 |
| 2024-01-05 11:00:00 | ES | Futures | 5111.01 | 5114.23 | 5094.09 | 5095.97 | 168000.0 |
| 2024-01-05 12:00:00 | ES | Futures | 5095.7 | 5096.51 | 5077.71 | 5082.54 | 151942.0 |
| 2024-01-05 13:00:00 | ES | Futures | 5082.27 | 5095.16 | 5072.87 | 5091.4 | 140099.0 |
| 2024-01-05 14:00:00 | ES | Futures | 5091.67 | 5098.39 | 5072.87 | 5074.75 | 138924.0 |
| 2024-01-05 15:00:00 | ES | Futures | 5074.75 | 5091.4 | 5070.72 | 5087.64 | 218183.0 |
| 2024-01-05 16:00:00 | ES | Futures | 5087.64 | 5090.87 | 5086.3 | 5087.64 | 44302.0 |
| 2024-01-05 00:00:00 | NQ | Futures | 17836.92 | 17839.36 | 17819.02 | 17822.01 | 3359.0 |
| 2024-01-05 01:00:00 | NQ | Futures | 17822.28 | 17828.51 | 17792.44 | 17804.11 | 5411.0 |
| 2024-01-05 02:00:00 | NQ | Futures | 17804.38 | 17815.5 | 17790.55 | 17792.17 | 4977.0 |
| 2024-01-05 03:00:00 | NQ | Futures | 17792.17 | 17833.13 | 17789.19 | 17801.12 | 8054.0 |
| 2024-01-05 04:00:00 | NQ | Futures | 17801.12 | 17813.33 | 17781.05 | 17787.83 | 8048.0 |
| 2024-01-05 05:00:00 | NQ | Futures | 17787.83 | 17796.24 | 17760.44 | 17775.36 | 7180.0 |
| 2024-01-05 06:00:00 | NQ | Futures | 17775.63 | 17785.66 | 17755.83 | 17778.88 | 6671.0 |
| 2024-01-05 07:00:00 | NQ | Futures | 17778.88 | 17794.61 | 17770.48 | 17782.68 | 7229.0 |
| 2024-01-05 08:00:00 | NQ | Futures | 17782.41 | 17820.11 | 17719.76 | 17790.82 | 59151.0 |
| 2024-01-05 09:00:00 | NQ | Futures | 17791.63 | 17894.69 | 17788.92 | 17868.65 | 91342.0 |
| 2024-01-05 10:00:00 | NQ | Futures | 17870.01 | 17973.88 | 17870.01 | 17968.73 | 93794.0 |
| 2024-01-05 11:00:00 | NQ | Futures | 17968.73 | 17983.37 | 17893.33 | 17917.47 | 67839.0 |
| 2024-01-05 12:00:00 | NQ | Futures | 17917.47 | 17920.18 | 17843.7 | 17866.21 | 57527.0 |
| 2024-01-05 13:00:00 | NQ | Futures | 17865.67 | 17905.81 | 17823.9 | 17887.1 | 58236.0 |
| 2024-01-05 14:00:00 | NQ | Futures | 17887.64 | 17910.15 | 17811.43 | 17817.4 | 51861.0 |
| 2024-01-05 15:00:00 | NQ | Futures | 17817.94 | 17869.47 | 17795.16 | 17860.25 | 64141.0 |
| 2024-01-05 16:00:00 | NQ | Futures | 17860.52 | 17866.21 | 17852.38 | 17861.6 | 9818.0 |
| 2024-01-05 00:00:00 | YM | Futures | 40532.5 | 40534.6 | 40520.7 | 40522.8 | 560.0 |
| 2024-01-05 01:00:00 | YM | Futures | 40521.7 | 40532.5 | 40468.0 | 40487.4 | 1119.0 |
| 2024-01-05 02:00:00 | YM | Futures | 40488.4 | 40514.2 | 40466.9 | 40479.8 | 1504.0 |
| 2024-01-05 03:00:00 | YM | Futures | 40478.8 | 40506.7 | 40465.9 | 40475.5 | 2077.0 |
| 2024-01-05 04:00:00 | YM | Futures | 40472.3 | 40474.5 | 40405.7 | 40413.2 | 3300.0 |
| 2024-01-05 05:00:00 | YM | Futures | 40414.3 | 40433.7 | 40389.6 | 40429.4 | 2326.0 |
| 2024-01-05 06:00:00 | YM | Futures | 40429.4 | 40440.1 | 40372.4 | 40413.2 | 2066.0 |
| 2024-01-05 07:00:00 | YM | Futures | 40414.3 | 40441.2 | 40390.7 | 40404.7 | 2651.0 |
| 2024-01-05 08:00:00 | YM | Futures | 40404.7 | 40457.3 | 40282.2 | 40428.3 | 15630.0 |
| 2024-01-05 09:00:00 | YM | Futures | 40429.4 | 40540.0 | 40420.8 | 40508.8 | 24183.0 |
| 2024-01-05 10:00:00 | YM | Futures | 40508.8 | 40688.2 | 40508.8 | 40619.5 | 24076.0 |
| 2024-01-05 11:00:00 | YM | Futures | 40616.2 | 40641.0 | 40493.8 | 40497.0 | 11420.0 |
| 2024-01-05 12:00:00 | YM | Futures | 40495.9 | 40500.2 | 40373.5 | 40406.8 | 13656.0 |
| 2024-01-05 13:00:00 | YM | Futures | 40404.7 | 40557.2 | 40355.2 | 40527.1 | 12757.0 |
| 2024-01-05 14:00:00 | YM | Futures | 40529.2 | 40581.9 | 40419.7 | 40432.6 | 11006.0 |
| 2024-01-05 15:00:00 | YM | Futures | 40432.6 | 40556.1 | 40413.2 | 40519.6 | 13686.0 |
> showing 50 of 1,660 rows — these rows as CSV