PREVIEW / futures_1hour / 2025-05-18
file: by_date/futures_1hour/2025/2025-05-18.parquet size: 20 KB rows: 446
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 |
|---|---|---|---|---|---|---|---|
| 2025-05-18 18:00:00 | ES | Futures | 6026.08 | 6036.75 | 6015.67 | 6034.98 | 17011.0 |
| 2025-05-18 19:00:00 | ES | Futures | 6035.23 | 6044.12 | 6031.42 | 6036.5 | 6878.0 |
| 2025-05-18 20:00:00 | ES | Futures | 6036.75 | 6037.26 | 6018.97 | 6027.35 | 13165.0 |
| 2025-05-18 21:00:00 | ES | Futures | 6027.61 | 6031.42 | 6023.29 | 6024.56 | 7918.0 |
| 2025-05-18 22:00:00 | ES | Futures | 6024.56 | 6030.91 | 6021.26 | 6021.26 | 5832.0 |
| 2025-05-18 23:00:00 | ES | Futures | 6021.26 | 6022.27 | 6005.25 | 6007.79 | 8500.0 |
| 2025-05-18 18:00:00 | NQ | Futures | 21707.37 | 21772.56 | 21679.86 | 21767.72 | 12339.0 |
| 2025-05-18 19:00:00 | NQ | Futures | 21768.48 | 21816.61 | 21753.2 | 21779.18 | 6002.0 |
| 2025-05-18 20:00:00 | NQ | Futures | 21779.69 | 21780.96 | 21660.51 | 21698.71 | 12616.0 |
| 2025-05-18 21:00:00 | NQ | Futures | 21698.96 | 21705.58 | 21669.17 | 21671.46 | 6119.0 |
| 2025-05-18 22:00:00 | NQ | Futures | 21671.21 | 21696.67 | 21656.18 | 21659.49 | 5973.0 |
| 2025-05-18 23:00:00 | NQ | Futures | 21659.75 | 21661.02 | 21590.48 | 21607.03 | 7358.0 |
| 2025-05-18 18:00:00 | YM | Futures | 43710.8 | 43750.9 | 43595.5 | 43722.1 | 1247.0 |
| 2025-05-18 19:00:00 | YM | Futures | 43719.0 | 43768.4 | 43698.4 | 43718.0 | 543.0 |
| 2025-05-18 20:00:00 | YM | Futures | 43721.1 | 43735.5 | 43679.9 | 43725.2 | 1192.0 |
| 2025-05-18 21:00:00 | YM | Futures | 43726.2 | 43773.6 | 43721.1 | 43746.8 | 680.0 |
| 2025-05-18 22:00:00 | YM | Futures | 43740.6 | 43787.0 | 43725.2 | 43730.3 | 509.0 |
| 2025-05-18 23:00:00 | YM | Futures | 43727.3 | 43736.5 | 43634.6 | 43642.9 | 942.0 |
| 2025-05-18 18:00:00 | CL | Futures | 58.3 | 58.73 | 57.58 | 58.4 | 4589.0 |
| 2025-05-18 19:00:00 | CL | Futures | 58.39 | 58.43 | 58.2 | 58.38 | 1168.0 |
| 2025-05-18 20:00:00 | CL | Futures | 58.39 | 58.4 | 58.23 | 58.29 | 1470.0 |
| 2025-05-18 21:00:00 | CL | Futures | 58.29 | 58.34 | 58.05 | 58.09 | 1784.0 |
| 2025-05-18 22:00:00 | CL | Futures | 58.09 | 58.24 | 58.06 | 58.15 | 897.0 |
| 2025-05-18 23:00:00 | CL | Futures | 58.15 | 58.16 | 58.01 | 58.04 | 1266.0 |
| 2025-05-18 18:00:00 | GC | Futures | 3326.4 | 3351.1 | 3318.4 | 3349.4 | 10415.0 |
| 2025-05-18 19:00:00 | GC | Futures | 3349.6 | 3355.3 | 3336.2 | 3345.4 | 8160.0 |
| 2025-05-18 20:00:00 | GC | Futures | 3345.7 | 3360.4 | 3343.7 | 3356.4 | 7424.0 |
| 2025-05-18 21:00:00 | GC | Futures | 3356.0 | 3356.7 | 3324.4 | 3328.5 | 13310.0 |
| 2025-05-18 22:00:00 | GC | Futures | 3328.3 | 3339.5 | 3327.0 | 3338.1 | 6733.0 |
| 2025-05-18 23:00:00 | GC | Futures | 3338.1 | 3340.4 | 3316.4 | 3321.1 | 6486.0 |
| 2025-05-18 18:00:00 | ZN | Futures | 110.030802 | 110.202725 | 109.999543 | 110.187096 | 30412.0 |
| 2025-05-18 19:00:00 | ZN | Futures | 110.187096 | 110.233984 | 110.140208 | 110.171467 | 11101.0 |
| 2025-05-18 20:00:00 | ZN | Futures | 110.155837 | 110.280872 | 110.155837 | 110.187096 | 25467.0 |
| 2025-05-18 21:00:00 | ZN | Futures | 110.202725 | 110.233984 | 110.155837 | 110.171467 | 15041.0 |
| 2025-05-18 22:00:00 | ZN | Futures | 110.187096 | 110.202725 | 110.07769 | 110.09332 | 25055.0 |
| 2025-05-18 23:00:00 | ZN | Futures | 110.09332 | 110.09332 | 109.952655 | 109.999543 | 29107.0 |
> showing 36 of 446 rows — these rows as CSV