PREVIEW / futures_1hour / 2024-06-02
file: by_date/futures_1hour/2024/2024-06-02.parquet size: 19 KB rows: 433
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-06-02 18:00:00 | ES | Futures | 5623.74 | 5628.78 | 5613.92 | 5620.82 | 14678.0 |
| 2024-06-02 19:00:00 | ES | Futures | 5620.55 | 5628.51 | 5619.76 | 5626.66 | 9892.0 |
| 2024-06-02 20:00:00 | ES | Futures | 5626.39 | 5635.94 | 5626.13 | 5631.96 | 14909.0 |
| 2024-06-02 21:00:00 | ES | Futures | 5631.96 | 5634.35 | 5626.92 | 5629.31 | 9240.0 |
| 2024-06-02 22:00:00 | ES | Futures | 5629.31 | 5633.55 | 5629.31 | 5633.02 | 5341.0 |
| 2024-06-02 23:00:00 | ES | Futures | 5633.02 | 5634.62 | 5630.64 | 5632.49 | 5569.0 |
| 2024-06-02 18:00:00 | NQ | Futures | 19891.87 | 19900.69 | 19837.3 | 19867.52 | 7767.0 |
| 2024-06-02 19:00:00 | NQ | Futures | 19866.99 | 19901.23 | 19862.44 | 19893.74 | 4156.0 |
| 2024-06-02 20:00:00 | NQ | Futures | 19893.47 | 19950.45 | 19892.67 | 19937.34 | 7792.0 |
| 2024-06-02 21:00:00 | NQ | Futures | 19937.61 | 19948.31 | 19920.22 | 19932.26 | 4413.0 |
| 2024-06-02 22:00:00 | NQ | Futures | 19932.53 | 19954.2 | 19931.73 | 19950.18 | 3412.0 |
| 2024-06-02 23:00:00 | NQ | Futures | 19950.45 | 19959.55 | 19940.82 | 19947.51 | 2835.0 |
| 2024-06-02 18:00:00 | YM | Futures | 41219.5 | 41251.4 | 41161.1 | 41211.0 | 2263.0 |
| 2024-06-02 19:00:00 | YM | Futures | 41210.0 | 41254.6 | 41204.7 | 41240.8 | 1210.0 |
| 2024-06-02 20:00:00 | YM | Futures | 41240.8 | 41300.2 | 41239.7 | 41285.4 | 2021.0 |
| 2024-06-02 21:00:00 | YM | Futures | 41285.4 | 41298.1 | 41254.6 | 41265.2 | 1410.0 |
| 2024-06-02 22:00:00 | YM | Futures | 41266.2 | 41291.7 | 41263.1 | 41287.5 | 1011.0 |
| 2024-06-02 23:00:00 | YM | Futures | 41287.5 | 41298.1 | 41273.7 | 41282.2 | 781.0 |
| 2024-06-02 18:00:00 | CL | Futures | 65.53 | 65.66 | 65.04 | 65.3 | 6432.0 |
| 2024-06-02 19:00:00 | CL | Futures | 65.3 | 65.38 | 65.21 | 65.36 | 1362.0 |
| 2024-06-02 20:00:00 | CL | Futures | 65.37 | 65.59 | 65.3 | 65.58 | 2204.0 |
| 2024-06-02 21:00:00 | CL | Futures | 65.59 | 65.99 | 65.57 | 65.86 | 5376.0 |
| 2024-06-02 22:00:00 | CL | Futures | 65.87 | 66.0 | 65.85 | 65.86 | 1682.0 |
| 2024-06-02 23:00:00 | CL | Futures | 65.86 | 65.86 | 65.5 | 65.52 | 2205.0 |
| 2024-06-02 18:00:00 | GC | Futures | 2521.4 | 2523.3 | 2516.6 | 2519.9 | 4005.0 |
| 2024-06-02 19:00:00 | GC | Futures | 2520.0 | 2520.2 | 2517.3 | 2519.3 | 1333.0 |
| 2024-06-02 20:00:00 | GC | Futures | 2519.5 | 2521.0 | 2517.2 | 2520.7 | 2020.0 |
| 2024-06-02 21:00:00 | GC | Futures | 2520.5 | 2525.0 | 2519.6 | 2524.6 | 4697.0 |
| 2024-06-02 22:00:00 | GC | Futures | 2524.5 | 2524.9 | 2518.5 | 2519.9 | 2990.0 |
| 2024-06-02 23:00:00 | GC | Futures | 2519.8 | 2521.7 | 2513.3 | 2514.6 | 4045.0 |
| 2024-06-02 18:00:00 | ZN | Futures | 109.458473 | 109.458473 | 109.442726 | 109.442726 | 37.0 |
| 2024-06-02 19:00:00 | ZN | Futures | 109.47422 | 109.521462 | 109.458473 | 109.505715 | 5.0 |
| 2024-06-02 20:00:00 | ZN | Futures | 109.47422 | 109.489968 | 109.442726 | 109.489968 | 6.0 |
| 2024-06-02 21:00:00 | ZN | Futures | 109.489968 | 109.521462 | 109.489968 | 109.521462 | 16.0 |
| 2024-06-02 22:00:00 | ZN | Futures | 109.47422 | 109.47422 | 109.47422 | 109.47422 | 7.0 |
| 2024-06-02 23:00:00 | ZN | Futures | 109.489968 | 109.489968 | 109.489968 | 109.489968 | 30.0 |
> showing 36 of 433 rows — these rows as CSV