PREVIEW / futures_1hour / 2024-01-19
file: by_date/futures_1hour/2024/2024-01-19.parquet size: 56 KB rows: 1,662
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-19 00:00:00 | ES | Futures | 5172.52 | 5173.86 | 5169.29 | 5169.83 | 3891.0 |
| 2024-01-19 01:00:00 | ES | Futures | 5169.56 | 5173.86 | 5169.56 | 5172.52 | 5717.0 |
| 2024-01-19 02:00:00 | ES | Futures | 5172.52 | 5181.11 | 5171.17 | 5179.5 | 14824.0 |
| 2024-01-19 03:00:00 | ES | Futures | 5179.77 | 5183.53 | 5176.01 | 5182.99 | 19931.0 |
| 2024-01-19 04:00:00 | ES | Futures | 5182.99 | 5191.05 | 5182.46 | 5188.9 | 27832.0 |
| 2024-01-19 05:00:00 | ES | Futures | 5188.9 | 5191.86 | 5185.68 | 5189.98 | 14019.0 |
| 2024-01-19 06:00:00 | ES | Futures | 5189.71 | 5195.35 | 5188.9 | 5194.27 | 18414.0 |
| 2024-01-19 07:00:00 | ES | Futures | 5194.01 | 5195.62 | 5188.63 | 5194.81 | 21969.0 |
| 2024-01-19 08:00:00 | ES | Futures | 5194.81 | 5201.26 | 5189.17 | 5190.51 | 48197.0 |
| 2024-01-19 09:00:00 | ES | Futures | 5190.51 | 5191.59 | 5173.05 | 5183.26 | 233112.0 |
| 2024-01-19 10:00:00 | ES | Futures | 5183.53 | 5191.32 | 5173.59 | 5187.56 | 252836.0 |
| 2024-01-19 11:00:00 | ES | Futures | 5187.83 | 5199.11 | 5184.87 | 5194.54 | 193411.0 |
| 2024-01-19 12:00:00 | ES | Futures | 5194.54 | 5209.05 | 5187.83 | 5208.78 | 177130.0 |
| 2024-01-19 13:00:00 | ES | Futures | 5209.05 | 5225.43 | 5203.67 | 5225.16 | 155402.0 |
| 2024-01-19 14:00:00 | ES | Futures | 5225.43 | 5236.71 | 5221.13 | 5230.8 | 193131.0 |
| 2024-01-19 15:00:00 | ES | Futures | 5231.07 | 5234.56 | 5226.24 | 5232.95 | 234715.0 |
| 2024-01-19 16:00:00 | ES | Futures | 5232.95 | 5236.71 | 5229.46 | 5231.88 | 101875.0 |
| 2024-01-19 00:00:00 | NQ | Futures | 18625.59 | 18632.91 | 18602.26 | 18604.43 | 3441.0 |
| 2024-01-19 01:00:00 | NQ | Futures | 18604.43 | 18622.88 | 18603.62 | 18619.35 | 4117.0 |
| 2024-01-19 02:00:00 | NQ | Futures | 18619.62 | 18649.45 | 18607.15 | 18643.22 | 10210.0 |
| 2024-01-19 03:00:00 | NQ | Futures | 18642.13 | 18670.88 | 18624.5 | 18669.79 | 11117.0 |
| 2024-01-19 04:00:00 | NQ | Futures | 18669.52 | 18698.81 | 18660.57 | 18687.42 | 14339.0 |
| 2024-01-19 05:00:00 | NQ | Futures | 18687.42 | 18707.49 | 18673.59 | 18697.19 | 7502.0 |
| 2024-01-19 06:00:00 | NQ | Futures | 18697.46 | 18717.26 | 18689.86 | 18710.2 | 9144.0 |
| 2024-01-19 07:00:00 | NQ | Futures | 18709.12 | 18712.65 | 18670.07 | 18700.17 | 13465.0 |
| 2024-01-19 08:00:00 | NQ | Futures | 18700.44 | 18718.88 | 18677.39 | 18680.64 | 19399.0 |
| 2024-01-19 09:00:00 | NQ | Futures | 18680.64 | 18687.97 | 18622.33 | 18668.17 | 90598.0 |
| 2024-01-19 10:00:00 | NQ | Futures | 18669.79 | 18703.7 | 18625.32 | 18687.42 | 109807.0 |
| 2024-01-19 11:00:00 | NQ | Futures | 18687.97 | 18735.97 | 18672.78 | 18730.54 | 81015.0 |
| 2024-01-19 12:00:00 | NQ | Futures | 18730.82 | 18794.82 | 18698.54 | 18794.55 | 80101.0 |
| 2024-01-19 13:00:00 | NQ | Futures | 18794.55 | 18871.03 | 18774.21 | 18870.76 | 69360.0 |
| 2024-01-19 14:00:00 | NQ | Futures | 18871.03 | 18916.59 | 18860.18 | 18907.37 | 85299.0 |
| 2024-01-19 15:00:00 | NQ | Futures | 18907.64 | 18927.98 | 18893.54 | 18922.02 | 82429.0 |
| 2024-01-19 16:00:00 | NQ | Futures | 18922.02 | 18953.2 | 18915.24 | 18943.98 | 19082.0 |
| 2024-01-19 00:00:00 | YM | Futures | 40412.2 | 40420.8 | 40391.8 | 40395.0 | 563.0 |
| 2024-01-19 01:00:00 | YM | Futures | 40393.9 | 40424.0 | 40393.9 | 40416.5 | 946.0 |
| 2024-01-19 02:00:00 | YM | Futures | 40416.5 | 40483.1 | 40411.1 | 40464.8 | 2438.0 |
| 2024-01-19 03:00:00 | YM | Futures | 40463.7 | 40482.0 | 40437.9 | 40478.8 | 2465.0 |
| 2024-01-19 04:00:00 | YM | Futures | 40477.7 | 40540.0 | 40476.6 | 40529.2 | 3018.0 |
| 2024-01-19 05:00:00 | YM | Futures | 40529.2 | 40533.5 | 40497.0 | 40528.2 | 1765.0 |
| 2024-01-19 06:00:00 | YM | Futures | 40527.1 | 40596.9 | 40520.7 | 40590.5 | 4658.0 |
| 2024-01-19 07:00:00 | YM | Futures | 40587.2 | 40641.0 | 40585.1 | 40635.6 | 7190.0 |
| 2024-01-19 08:00:00 | YM | Futures | 40637.7 | 40704.3 | 40628.1 | 40639.9 | 8230.0 |
| 2024-01-19 09:00:00 | YM | Futures | 40638.8 | 40647.4 | 40420.8 | 40519.6 | 27040.0 |
| 2024-01-19 10:00:00 | YM | Futures | 40516.4 | 40591.5 | 40453.0 | 40579.7 | 18734.0 |
| 2024-01-19 11:00:00 | YM | Futures | 40579.7 | 40652.8 | 40550.7 | 40587.2 | 13609.0 |
| 2024-01-19 12:00:00 | YM | Futures | 40587.2 | 40709.7 | 40551.8 | 40706.5 | 14228.0 |
| 2024-01-19 13:00:00 | YM | Futures | 40707.5 | 40844.0 | 40673.2 | 40838.6 | 13957.0 |
| 2024-01-19 14:00:00 | YM | Futures | 40839.7 | 40957.8 | 40824.6 | 40894.4 | 17794.0 |
| 2024-01-19 15:00:00 | YM | Futures | 40895.5 | 40913.8 | 40837.5 | 40868.7 | 15192.0 |
> showing 50 of 1,662 rows — these rows as CSV