PREVIEW / futures_1hour / 2024-10-10
file: by_date/futures_1hour/2024/2024-10-10.parquet size: 67 KB rows: 2,093
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-10-10 00:00:00 | ES | Futures | 6064.54 | 6064.8 | 6062.47 | 6063.25 | 1578.0 |
| 2024-10-10 01:00:00 | ES | Futures | 6062.99 | 6064.8 | 6058.05 | 6058.31 | 4461.0 |
| 2024-10-10 02:00:00 | ES | Futures | 6058.31 | 6060.65 | 6055.2 | 6058.83 | 6852.0 |
| 2024-10-10 03:00:00 | ES | Futures | 6059.09 | 6060.91 | 6051.05 | 6052.6 | 14144.0 |
| 2024-10-10 04:00:00 | ES | Futures | 6052.35 | 6056.24 | 6050.27 | 6052.6 | 10506.0 |
| 2024-10-10 05:00:00 | ES | Futures | 6052.86 | 6056.24 | 6050.53 | 6055.98 | 8048.0 |
| 2024-10-10 06:00:00 | ES | Futures | 6055.98 | 6057.02 | 6051.05 | 6051.57 | 9767.0 |
| 2024-10-10 07:00:00 | ES | Futures | 6051.57 | 6057.02 | 6050.01 | 6057.02 | 16594.0 |
| 2024-10-10 08:00:00 | ES | Futures | 6056.76 | 6066.62 | 6036.25 | 6042.48 | 85258.0 |
| 2024-10-10 09:00:00 | ES | Futures | 6042.48 | 6052.6 | 6034.18 | 6043.0 | 145159.0 |
| 2024-10-10 10:00:00 | ES | Futures | 6043.0 | 6056.24 | 6040.15 | 6043.52 | 128923.0 |
| 2024-10-10 11:00:00 | ES | Futures | 6043.52 | 6059.61 | 6039.89 | 6059.35 | 84331.0 |
| 2024-10-10 12:00:00 | ES | Futures | 6059.35 | 6065.84 | 6046.9 | 6051.31 | 113885.0 |
| 2024-10-10 13:00:00 | ES | Futures | 6051.31 | 6056.5 | 6036.25 | 6051.57 | 112396.0 |
| 2024-10-10 14:00:00 | ES | Futures | 6051.57 | 6051.57 | 6032.88 | 6041.7 | 79264.0 |
| 2024-10-10 15:00:00 | ES | Futures | 6041.96 | 6055.2 | 6036.77 | 6050.79 | 157955.0 |
| 2024-10-10 16:00:00 | ES | Futures | 6050.79 | 6055.2 | 6048.71 | 6053.12 | 53843.0 |
| 2024-10-10 18:00:00 | ES | Futures | 6053.12 | 6054.68 | 6051.05 | 6052.86 | 3111.0 |
| 2024-10-10 19:00:00 | ES | Futures | 6053.12 | 6059.35 | 6053.12 | 6057.8 | 4007.0 |
| 2024-10-10 20:00:00 | ES | Futures | 6057.54 | 6060.13 | 6055.2 | 6055.72 | 5114.0 |
| 2024-10-10 21:00:00 | ES | Futures | 6055.72 | 6058.83 | 6054.94 | 6055.72 | 3549.0 |
| 2024-10-10 22:00:00 | ES | Futures | 6055.98 | 6056.76 | 6053.38 | 6054.94 | 2264.0 |
| 2024-10-10 23:00:00 | ES | Futures | 6054.94 | 6057.54 | 6053.38 | 6055.98 | 2730.0 |
| 2024-10-10 00:00:00 | NQ | Futures | 21363.5 | 21365.59 | 21355.93 | 21357.24 | 895.0 |
| 2024-10-10 01:00:00 | NQ | Futures | 21356.98 | 21367.68 | 21331.41 | 21335.32 | 2410.0 |
| 2024-10-10 02:00:00 | NQ | Futures | 21335.06 | 21348.37 | 21314.97 | 21339.5 | 3830.0 |
| 2024-10-10 03:00:00 | NQ | Futures | 21339.5 | 21345.5 | 21304.01 | 21314.19 | 5213.0 |
| 2024-10-10 04:00:00 | NQ | Futures | 21313.93 | 21324.36 | 21296.45 | 21309.49 | 4789.0 |
| 2024-10-10 05:00:00 | NQ | Futures | 21310.01 | 21327.49 | 21299.32 | 21323.32 | 4542.0 |
| 2024-10-10 06:00:00 | NQ | Futures | 21323.06 | 21325.93 | 21298.53 | 21300.62 | 3511.0 |
| 2024-10-10 07:00:00 | NQ | Futures | 21299.84 | 21331.93 | 21291.75 | 21329.32 | 5223.0 |
| 2024-10-10 08:00:00 | NQ | Futures | 21329.84 | 21372.37 | 21209.3 | 21250.26 | 34427.0 |
| 2024-10-10 09:00:00 | NQ | Futures | 21250.0 | 21280.01 | 21187.65 | 21246.09 | 69531.0 |
| 2024-10-10 10:00:00 | NQ | Futures | 21246.09 | 21311.32 | 21242.18 | 21271.92 | 64088.0 |
| 2024-10-10 11:00:00 | NQ | Futures | 21271.92 | 21371.33 | 21251.83 | 21368.98 | 43823.0 |
| 2024-10-10 12:00:00 | NQ | Futures | 21368.72 | 21403.42 | 21307.93 | 21330.89 | 53978.0 |
| 2024-10-10 13:00:00 | NQ | Futures | 21331.41 | 21366.89 | 21268.01 | 21338.19 | 47424.0 |
| 2024-10-10 14:00:00 | NQ | Futures | 21338.19 | 21338.98 | 21261.74 | 21310.54 | 33380.0 |
| 2024-10-10 15:00:00 | NQ | Futures | 21310.27 | 21335.84 | 21278.7 | 21320.97 | 44169.0 |
| 2024-10-10 16:00:00 | NQ | Futures | 21321.23 | 21333.5 | 21308.45 | 21324.89 | 8451.0 |
| 2024-10-10 18:00:00 | NQ | Futures | 21326.97 | 21332.19 | 21317.58 | 21327.23 | 1674.0 |
| 2024-10-10 19:00:00 | NQ | Futures | 21327.76 | 21358.02 | 21327.76 | 21344.98 | 3032.0 |
| 2024-10-10 20:00:00 | NQ | Futures | 21344.98 | 21356.98 | 21335.32 | 21340.28 | 2325.0 |
| 2024-10-10 21:00:00 | NQ | Futures | 21340.02 | 21356.98 | 21336.89 | 21343.67 | 2017.0 |
| 2024-10-10 22:00:00 | NQ | Futures | 21343.67 | 21351.24 | 21331.67 | 21341.58 | 1686.0 |
| 2024-10-10 23:00:00 | NQ | Futures | 21342.63 | 21361.67 | 21335.84 | 21347.85 | 2774.0 |
| 2024-10-10 00:00:00 | YM | Futures | 44576.5 | 44579.6 | 44566.1 | 44568.1 | 227.0 |
| 2024-10-10 01:00:00 | YM | Futures | 44567.1 | 44575.4 | 44536.9 | 44539.0 | 500.0 |
| 2024-10-10 02:00:00 | YM | Futures | 44536.9 | 44549.4 | 44518.2 | 44534.8 | 951.0 |
| 2024-10-10 03:00:00 | YM | Futures | 44533.8 | 44551.5 | 44481.8 | 44484.9 | 1103.0 |
> showing 50 of 2,093 rows — these rows as CSV