PREVIEW / futures_1hour / 2023-05-21
file: by_date/futures_1hour/2023/2023-05-21.parquet size: 18 KB rows: 391
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 |
|---|---|---|---|---|---|---|---|
| 2023-05-21 18:00:00 | ES | Futures | 4647.33 | 4656.21 | 4644.56 | 4655.65 | 9730.0 |
| 2023-05-21 19:00:00 | ES | Futures | 4655.65 | 4660.92 | 4655.38 | 4659.81 | 5807.0 |
| 2023-05-21 20:00:00 | ES | Futures | 4659.81 | 4663.7 | 4658.15 | 4661.48 | 7539.0 |
| 2023-05-21 21:00:00 | ES | Futures | 4661.48 | 4662.87 | 4658.15 | 4659.54 | 6638.0 |
| 2023-05-21 22:00:00 | ES | Futures | 4659.54 | 4660.65 | 4657.6 | 4660.09 | 5376.0 |
| 2023-05-21 23:00:00 | ES | Futures | 4660.37 | 4663.97 | 4659.54 | 4663.7 | 4268.0 |
| 2023-05-21 18:00:00 | NQ | Futures | 15547.92 | 15589.87 | 15535.25 | 15583.4 | 5795.0 |
| 2023-05-21 19:00:00 | NQ | Futures | 15584.24 | 15604.79 | 15581.71 | 15601.7 | 3347.0 |
| 2023-05-21 20:00:00 | NQ | Futures | 15601.7 | 15612.11 | 15594.66 | 15606.77 | 4308.0 |
| 2023-05-21 21:00:00 | NQ | Futures | 15607.05 | 15617.18 | 15600.01 | 15607.33 | 3961.0 |
| 2023-05-21 22:00:00 | NQ | Futures | 15607.89 | 15613.8 | 15600.85 | 15611.55 | 2436.0 |
| 2023-05-21 23:00:00 | NQ | Futures | 15611.55 | 15625.07 | 15610.99 | 15621.69 | 2631.0 |
| 2023-05-21 18:00:00 | YM | Futures | 36930.6 | 36959.3 | 36888.6 | 36959.3 | 1036.0 |
| 2023-05-21 19:00:00 | YM | Futures | 36959.3 | 36992.5 | 36958.2 | 36989.1 | 911.0 |
| 2023-05-21 20:00:00 | YM | Futures | 36988.0 | 37013.5 | 36974.8 | 37003.5 | 1079.0 |
| 2023-05-21 21:00:00 | YM | Futures | 37003.5 | 37006.8 | 36971.5 | 36982.5 | 860.0 |
| 2023-05-21 22:00:00 | YM | Futures | 36979.2 | 36984.7 | 36962.6 | 36979.2 | 659.0 |
| 2023-05-21 23:00:00 | YM | Futures | 36980.3 | 36999.1 | 36972.6 | 36999.1 | 575.0 |
| 2023-05-21 18:00:00 | CL | Futures | 58.47 | 58.55 | 58.31 | 58.33 | 1385.0 |
| 2023-05-21 19:00:00 | CL | Futures | 58.33 | 58.44 | 58.31 | 58.44 | 667.0 |
| 2023-05-21 20:00:00 | CL | Futures | 58.44 | 58.48 | 58.35 | 58.4 | 958.0 |
| 2023-05-21 21:00:00 | CL | Futures | 58.4 | 58.5 | 57.83 | 57.94 | 8110.0 |
| 2023-05-21 22:00:00 | CL | Futures | 57.93 | 58.03 | 57.85 | 57.88 | 2938.0 |
| 2023-05-21 23:00:00 | CL | Futures | 57.88 | 57.93 | 57.68 | 57.74 | 3261.0 |
| 2023-05-21 18:00:00 | GC | Futures | 2276.3 | 2280.9 | 2276.3 | 2279.5 | 1930.0 |
| 2023-05-21 19:00:00 | GC | Futures | 2279.6 | 2281.1 | 2278.5 | 2280.5 | 982.0 |
| 2023-05-21 20:00:00 | GC | Futures | 2280.6 | 2281.0 | 2277.6 | 2280.6 | 1829.0 |
| 2023-05-21 21:00:00 | GC | Futures | 2280.7 | 2282.1 | 2277.3 | 2279.3 | 5283.0 |
| 2023-05-21 22:00:00 | GC | Futures | 2279.3 | 2279.3 | 2274.9 | 2277.0 | 3577.0 |
| 2023-05-21 23:00:00 | GC | Futures | 2276.9 | 2278.3 | 2275.3 | 2276.7 | 1303.0 |
| 2023-05-21 18:00:00 | ZN | Futures | 116.649573 | 116.713683 | 116.553407 | 116.697656 | 14709.0 |
| 2023-05-21 19:00:00 | ZN | Futures | 116.697656 | 116.729711 | 116.6656 | 116.6656 | 6907.0 |
| 2023-05-21 20:00:00 | ZN | Futures | 116.681628 | 116.713683 | 116.633545 | 116.697656 | 14772.0 |
| 2023-05-21 21:00:00 | ZN | Futures | 116.697656 | 116.793822 | 116.697656 | 116.777794 | 20941.0 |
| 2023-05-21 22:00:00 | ZN | Futures | 116.793822 | 116.793822 | 116.745739 | 116.793822 | 11538.0 |
| 2023-05-21 23:00:00 | ZN | Futures | 116.777794 | 116.793822 | 116.761767 | 116.793822 | 4698.0 |
> showing 36 of 391 rows — these rows as CSV