PREVIEW / futures_1hour / 2024-04-12
file: by_date/futures_1hour/2024/2024-04-12.parquet size: 58 KB rows: 1,667
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-04-12 00:00:00 | ES | Futures | 5565.11 | 5566.97 | 5564.58 | 5565.11 | 2704.0 |
| 2024-04-12 01:00:00 | ES | Futures | 5565.11 | 5566.97 | 5564.05 | 5564.31 | 4451.0 |
| 2024-04-12 02:00:00 | ES | Futures | 5564.31 | 5569.88 | 5562.72 | 5567.5 | 10705.0 |
| 2024-04-12 03:00:00 | ES | Futures | 5567.5 | 5569.88 | 5563.52 | 5565.9 | 18743.0 |
| 2024-04-12 04:00:00 | ES | Futures | 5565.9 | 5568.56 | 5559.8 | 5560.33 | 18234.0 |
| 2024-04-12 05:00:00 | ES | Futures | 5560.33 | 5561.13 | 5553.7 | 5556.35 | 19644.0 |
| 2024-04-12 06:00:00 | ES | Futures | 5556.35 | 5556.88 | 5533.54 | 5539.37 | 36817.0 |
| 2024-04-12 07:00:00 | ES | Futures | 5539.37 | 5552.64 | 5536.46 | 5549.19 | 36438.0 |
| 2024-04-12 08:00:00 | ES | Futures | 5548.93 | 5553.7 | 5520.54 | 5521.33 | 77636.0 |
| 2024-04-12 09:00:00 | ES | Futures | 5521.6 | 5538.05 | 5512.05 | 5532.74 | 222146.0 |
| 2024-04-12 10:00:00 | ES | Futures | 5533.01 | 5533.01 | 5496.66 | 5499.85 | 285377.0 |
| 2024-04-12 11:00:00 | ES | Futures | 5499.85 | 5518.95 | 5498.52 | 5511.78 | 171804.0 |
| 2024-04-12 12:00:00 | ES | Futures | 5512.05 | 5513.38 | 5480.48 | 5481.27 | 223328.0 |
| 2024-04-12 13:00:00 | ES | Futures | 5481.01 | 5488.44 | 5467.48 | 5480.21 | 215510.0 |
| 2024-04-12 14:00:00 | ES | Futures | 5480.21 | 5490.56 | 5470.13 | 5470.93 | 173824.0 |
| 2024-04-12 15:00:00 | ES | Futures | 5470.93 | 5485.52 | 5465.09 | 5483.93 | 298070.0 |
| 2024-04-12 16:00:00 | ES | Futures | 5483.93 | 5487.38 | 5482.34 | 5482.6 | 63190.0 |
| 2024-04-12 00:00:00 | NQ | Futures | 19782.73 | 19788.34 | 19778.45 | 19780.85 | 1375.0 |
| 2024-04-12 01:00:00 | NQ | Futures | 19780.59 | 19790.48 | 19777.91 | 19782.73 | 2142.0 |
| 2024-04-12 02:00:00 | NQ | Futures | 19783.26 | 19803.59 | 19774.17 | 19792.62 | 6793.0 |
| 2024-04-12 03:00:00 | NQ | Futures | 19792.36 | 19796.37 | 19758.92 | 19762.4 | 9445.0 |
| 2024-04-12 04:00:00 | NQ | Futures | 19762.4 | 19775.77 | 19734.31 | 19735.11 | 11503.0 |
| 2024-04-12 05:00:00 | NQ | Futures | 19735.11 | 19737.52 | 19699.26 | 19715.05 | 12528.0 |
| 2024-04-12 06:00:00 | NQ | Futures | 19715.05 | 19716.65 | 19645.5 | 19670.64 | 16634.0 |
| 2024-04-12 07:00:00 | NQ | Futures | 19670.91 | 19719.86 | 19662.62 | 19701.4 | 16241.0 |
| 2024-04-12 08:00:00 | NQ | Futures | 19702.47 | 19719.59 | 19594.4 | 19600.82 | 35547.0 |
| 2024-04-12 09:00:00 | NQ | Futures | 19600.82 | 19627.57 | 19554.28 | 19621.96 | 101372.0 |
| 2024-04-12 10:00:00 | NQ | Futures | 19621.96 | 19626.24 | 19467.07 | 19472.15 | 130586.0 |
| 2024-04-12 11:00:00 | NQ | Futures | 19472.42 | 19571.93 | 19467.61 | 19533.95 | 74173.0 |
| 2024-04-12 12:00:00 | NQ | Futures | 19533.95 | 19547.05 | 19417.85 | 19429.89 | 84829.0 |
| 2024-04-12 13:00:00 | NQ | Futures | 19430.16 | 19467.61 | 19392.97 | 19433.37 | 74743.0 |
| 2024-04-12 14:00:00 | NQ | Futures | 19433.37 | 19461.72 | 19400.73 | 19403.94 | 64015.0 |
| 2024-04-12 15:00:00 | NQ | Futures | 19404.21 | 19472.69 | 19388.96 | 19453.43 | 97268.0 |
| 2024-04-12 16:00:00 | NQ | Futures | 19453.96 | 19469.75 | 19440.32 | 19444.87 | 16159.0 |
| 2024-04-12 00:00:00 | YM | Futures | 41152.6 | 41168.6 | 41149.5 | 41158.0 | 541.0 |
| 2024-04-12 01:00:00 | YM | Futures | 41159.0 | 41169.6 | 41151.6 | 41154.8 | 696.0 |
| 2024-04-12 02:00:00 | YM | Futures | 41154.8 | 41190.9 | 41145.2 | 41173.9 | 1864.0 |
| 2024-04-12 03:00:00 | YM | Futures | 41174.9 | 41215.3 | 41169.6 | 41211.0 | 3776.0 |
| 2024-04-12 04:00:00 | YM | Futures | 41210.0 | 41232.3 | 41160.1 | 41177.1 | 3756.0 |
| 2024-04-12 05:00:00 | YM | Futures | 41177.1 | 41188.7 | 41142.0 | 41153.7 | 2186.0 |
| 2024-04-12 06:00:00 | YM | Futures | 41154.8 | 41162.2 | 40958.4 | 41000.8 | 8728.0 |
| 2024-04-12 07:00:00 | YM | Futures | 41000.8 | 41075.1 | 40963.7 | 41053.9 | 5568.0 |
| 2024-04-12 08:00:00 | YM | Futures | 41051.8 | 41076.2 | 40829.9 | 40833.1 | 8264.0 |
| 2024-04-12 09:00:00 | YM | Futures | 40832.0 | 40935.0 | 40756.6 | 40896.8 | 27741.0 |
| 2024-04-12 10:00:00 | YM | Futures | 40891.5 | 40905.3 | 40665.3 | 40694.0 | 28060.0 |
| 2024-04-12 11:00:00 | YM | Futures | 40694.0 | 40826.7 | 40682.3 | 40784.2 | 15448.0 |
| 2024-04-12 12:00:00 | YM | Futures | 40784.2 | 40799.1 | 40592.1 | 40593.1 | 16958.0 |
| 2024-04-12 13:00:00 | YM | Futures | 40593.1 | 40626.0 | 40487.0 | 40565.5 | 16731.0 |
| 2024-04-12 14:00:00 | YM | Futures | 40565.5 | 40642.0 | 40523.1 | 40530.5 | 13276.0 |
| 2024-04-12 15:00:00 | YM | Futures | 40530.5 | 40614.4 | 40484.8 | 40605.9 | 20952.0 |
> showing 50 of 1,667 rows — these rows as CSV