PREVIEW / futures_1hour / 2023-04-02
file: by_date/futures_1hour/2023/2023-04-02.parquet size: 20 KB rows: 432
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-04-02 18:00:00 | ES | Futures | 4578.55 | 4587.43 | 4576.61 | 4586.32 | 19299.0 |
| 2023-04-02 19:00:00 | ES | Futures | 4586.32 | 4587.43 | 4581.05 | 4583.26 | 8988.0 |
| 2023-04-02 20:00:00 | ES | Futures | 4582.99 | 4583.26 | 4573.83 | 4581.32 | 19046.0 |
| 2023-04-02 21:00:00 | ES | Futures | 4581.32 | 4583.82 | 4574.39 | 4576.33 | 12503.0 |
| 2023-04-02 22:00:00 | ES | Futures | 4576.05 | 4578.0 | 4574.67 | 4576.33 | 6922.0 |
| 2023-04-02 23:00:00 | ES | Futures | 4576.33 | 4579.94 | 4574.67 | 4575.78 | 5811.0 |
| 2023-04-02 18:00:00 | NQ | Futures | 14935.82 | 14951.03 | 14905.42 | 14931.88 | 11167.0 |
| 2023-04-02 19:00:00 | NQ | Futures | 14931.32 | 14936.95 | 14907.39 | 14910.77 | 3888.0 |
| 2023-04-02 20:00:00 | NQ | Futures | 14910.77 | 14911.33 | 14866.0 | 14892.75 | 9197.0 |
| 2023-04-02 21:00:00 | NQ | Futures | 14892.47 | 14907.11 | 14866.56 | 14880.64 | 6471.0 |
| 2023-04-02 22:00:00 | NQ | Futures | 14880.36 | 14888.24 | 14872.19 | 14881.2 | 2847.0 |
| 2023-04-02 23:00:00 | NQ | Futures | 14881.2 | 14899.22 | 14880.36 | 14884.02 | 3211.0 |
| 2023-04-02 18:00:00 | YM | Futures | 36962.6 | 37042.2 | 36957.1 | 37032.3 | 3090.0 |
| 2023-04-02 19:00:00 | YM | Futures | 37032.3 | 37042.2 | 37005.7 | 37019.0 | 1168.0 |
| 2023-04-02 20:00:00 | YM | Futures | 37017.9 | 37033.4 | 36963.7 | 37028.9 | 2571.0 |
| 2023-04-02 21:00:00 | YM | Futures | 37028.9 | 37041.1 | 36980.3 | 36986.9 | 1348.0 |
| 2023-04-02 22:00:00 | YM | Futures | 36985.8 | 37000.2 | 36978.1 | 36989.1 | 818.0 |
| 2023-04-02 23:00:00 | YM | Futures | 36990.3 | 37006.8 | 36973.7 | 36978.1 | 889.0 |
| 2023-04-02 18:00:00 | CL | Futures | 64.96 | 66.25 | 64.72 | 65.67 | 34319.0 |
| 2023-04-02 19:00:00 | CL | Futures | 65.67 | 65.71 | 65.26 | 65.29 | 8876.0 |
| 2023-04-02 20:00:00 | CL | Futures | 65.3 | 65.33 | 64.94 | 65.02 | 8656.0 |
| 2023-04-02 21:00:00 | CL | Futures | 65.02 | 65.02 | 64.48 | 64.77 | 14639.0 |
| 2023-04-02 22:00:00 | CL | Futures | 64.78 | 64.86 | 64.53 | 64.61 | 4702.0 |
| 2023-04-02 23:00:00 | CL | Futures | 64.61 | 64.84 | 64.61 | 64.79 | 2909.0 |
| 2023-04-02 18:00:00 | GC | Futures | 2288.5 | 2290.8 | 2273.6 | 2276.4 | 5834.0 |
| 2023-04-02 19:00:00 | GC | Futures | 2276.3 | 2276.4 | 2269.6 | 2270.1 | 3462.0 |
| 2023-04-02 20:00:00 | GC | Futures | 2270.1 | 2278.0 | 2269.8 | 2276.1 | 4922.0 |
| 2023-04-02 21:00:00 | GC | Futures | 2276.1 | 2279.1 | 2271.1 | 2273.3 | 4457.0 |
| 2023-04-02 22:00:00 | GC | Futures | 2273.3 | 2273.6 | 2263.8 | 2264.1 | 5868.0 |
| 2023-04-02 23:00:00 | GC | Futures | 2264.2 | 2265.6 | 2260.8 | 2263.3 | 5077.0 |
| 2023-04-02 18:00:00 | ZN | Futures | 117.867678 | 117.931788 | 117.515068 | 117.64329 | 48584.0 |
| 2023-04-02 19:00:00 | ZN | Futures | 117.659318 | 117.739456 | 117.611234 | 117.691373 | 9661.0 |
| 2023-04-02 20:00:00 | ZN | Futures | 117.691373 | 117.803567 | 117.659318 | 117.787539 | 17388.0 |
| 2023-04-02 21:00:00 | ZN | Futures | 117.771511 | 117.803567 | 117.659318 | 117.723428 | 15538.0 |
| 2023-04-02 22:00:00 | ZN | Futures | 117.723428 | 117.739456 | 117.659318 | 117.659318 | 6433.0 |
| 2023-04-02 23:00:00 | ZN | Futures | 117.659318 | 117.723428 | 117.659318 | 117.707401 | 9932.0 |
> showing 36 of 432 rows — these rows as CSV