PREVIEW / futures_1hour / 2024-02-25
file: by_date/futures_1hour/2024/2024-02-25.parquet size: 19 KB rows: 425
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-02-25 18:00:00 | ES | Futures | 5473.88 | 5480.59 | 5471.46 | 5478.44 | 8730.0 |
| 2024-02-25 19:00:00 | ES | Futures | 5478.17 | 5478.71 | 5466.89 | 5467.7 | 12199.0 |
| 2024-02-25 20:00:00 | ES | Futures | 5467.97 | 5473.07 | 5465.55 | 5468.77 | 9825.0 |
| 2024-02-25 21:00:00 | ES | Futures | 5468.77 | 5473.34 | 5467.7 | 5470.38 | 5989.0 |
| 2024-02-25 22:00:00 | ES | Futures | 5470.12 | 5470.92 | 5468.5 | 5469.58 | 3418.0 |
| 2024-02-25 23:00:00 | ES | Futures | 5469.58 | 5470.38 | 5467.97 | 5470.12 | 2583.0 |
| 2024-02-25 18:00:00 | NQ | Futures | 19485.04 | 19514.06 | 19464.43 | 19507.82 | 5451.0 |
| 2024-02-25 19:00:00 | NQ | Futures | 19507.55 | 19509.99 | 19442.19 | 19450.32 | 7981.0 |
| 2024-02-25 20:00:00 | NQ | Futures | 19450.32 | 19480.7 | 19442.73 | 19461.71 | 6393.0 |
| 2024-02-25 21:00:00 | NQ | Futures | 19461.17 | 19488.56 | 19456.56 | 19475.55 | 3626.0 |
| 2024-02-25 22:00:00 | NQ | Futures | 19475.28 | 19477.99 | 19465.78 | 19470.66 | 2065.0 |
| 2024-02-25 23:00:00 | NQ | Futures | 19470.94 | 19476.63 | 19460.09 | 19471.75 | 2132.0 |
| 2024-02-25 18:00:00 | YM | Futures | 42089.9 | 42089.9 | 42050.1 | 42072.7 | 1196.0 |
| 2024-02-25 19:00:00 | YM | Futures | 42071.6 | 42074.8 | 42011.5 | 42021.1 | 1574.0 |
| 2024-02-25 20:00:00 | YM | Futures | 42020.1 | 42050.1 | 42001.8 | 42021.1 | 1057.0 |
| 2024-02-25 21:00:00 | YM | Futures | 42021.1 | 42043.7 | 42014.7 | 42027.6 | 652.0 |
| 2024-02-25 22:00:00 | YM | Futures | 42027.6 | 42038.3 | 42020.1 | 42029.7 | 471.0 |
| 2024-02-25 23:00:00 | YM | Futures | 42030.8 | 42039.4 | 42022.2 | 42037.3 | 447.0 |
| 2024-02-25 18:00:00 | CL | Futures | 63.94 | 64.18 | 63.93 | 63.98 | 2602.0 |
| 2024-02-25 19:00:00 | CL | Futures | 63.97 | 63.98 | 63.78 | 63.8 | 2597.0 |
| 2024-02-25 20:00:00 | CL | Futures | 63.8 | 63.85 | 63.68 | 63.69 | 3138.0 |
| 2024-02-25 21:00:00 | CL | Futures | 63.69 | 63.78 | 63.68 | 63.74 | 1135.0 |
| 2024-02-25 22:00:00 | CL | Futures | 63.73 | 63.76 | 63.65 | 63.66 | 1237.0 |
| 2024-02-25 23:00:00 | CL | Futures | 63.66 | 63.77 | 63.66 | 63.74 | 687.0 |
| 2024-02-25 18:00:00 | GC | Futures | 2240.6 | 2241.3 | 2238.3 | 2239.8 | 2900.0 |
| 2024-02-25 19:00:00 | GC | Futures | 2239.9 | 2239.9 | 2235.5 | 2236.0 | 4233.0 |
| 2024-02-25 20:00:00 | GC | Futures | 2236.1 | 2240.2 | 2235.5 | 2237.2 | 5207.0 |
| 2024-02-25 21:00:00 | GC | Futures | 2237.3 | 2238.0 | 2236.3 | 2236.6 | 2046.0 |
| 2024-02-25 22:00:00 | GC | Futures | 2236.5 | 2238.3 | 2236.4 | 2238.1 | 1170.0 |
| 2024-02-25 23:00:00 | GC | Futures | 2238.1 | 2238.8 | 2237.7 | 2238.0 | 1232.0 |
| 2024-02-25 18:00:00 | ZN | Futures | 111.340777 | 111.388298 | 111.324937 | 111.372458 | 16904.0 |
| 2024-02-25 19:00:00 | ZN | Futures | 111.372458 | 111.57838 | 111.356617 | 111.5467 | 33101.0 |
| 2024-02-25 20:00:00 | ZN | Futures | 111.5467 | 111.59422 | 111.53086 | 111.57838 | 12943.0 |
| 2024-02-25 21:00:00 | ZN | Futures | 111.57838 | 111.57838 | 111.499179 | 111.515019 | 13696.0 |
| 2024-02-25 22:00:00 | ZN | Futures | 111.515019 | 111.5467 | 111.515019 | 111.53086 | 4212.0 |
| 2024-02-25 23:00:00 | ZN | Futures | 111.53086 | 111.56254 | 111.53086 | 111.53086 | 8811.0 |
> showing 36 of 425 rows — these rows as CSV