PREVIEW / futures_1hour / 2024-05-26
file: by_date/futures_1hour/2024/2024-05-26.parquet size: 17 KB rows: 368
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-05-26 18:00:00 | ES | Futures | 5647.35 | 5650.0 | 5646.55 | 5647.62 | 2596.0 |
| 2024-05-26 19:00:00 | ES | Futures | 5647.35 | 5647.35 | 5640.45 | 5640.98 | 3881.0 |
| 2024-05-26 20:00:00 | ES | Futures | 5641.25 | 5643.37 | 5639.92 | 5642.04 | 3428.0 |
| 2024-05-26 21:00:00 | ES | Futures | 5642.04 | 5644.43 | 5640.72 | 5643.9 | 3438.0 |
| 2024-05-26 22:00:00 | ES | Futures | 5643.9 | 5644.17 | 5637.53 | 5641.25 | 3283.0 |
| 2024-05-26 23:00:00 | ES | Futures | 5641.51 | 5643.1 | 5641.51 | 5641.78 | 1253.0 |
| 2024-05-26 18:00:00 | NQ | Futures | 20196.29 | 20208.86 | 20189.87 | 20196.82 | 2443.0 |
| 2024-05-26 19:00:00 | NQ | Futures | 20196.02 | 20196.02 | 20155.09 | 20155.36 | 3809.0 |
| 2024-05-26 20:00:00 | NQ | Futures | 20155.63 | 20170.07 | 20152.15 | 20166.86 | 2368.0 |
| 2024-05-26 21:00:00 | NQ | Futures | 20167.13 | 20174.89 | 20162.58 | 20172.21 | 1670.0 |
| 2024-05-26 22:00:00 | NQ | Futures | 20172.75 | 20173.28 | 20155.36 | 20169.54 | 1732.0 |
| 2024-05-26 23:00:00 | NQ | Futures | 20170.87 | 20177.03 | 20170.07 | 20170.61 | 1019.0 |
| 2024-05-26 18:00:00 | YM | Futures | 41579.4 | 41585.8 | 41556.1 | 41560.3 | 506.0 |
| 2024-05-26 19:00:00 | YM | Futures | 41560.3 | 41560.3 | 41522.1 | 41532.7 | 495.0 |
| 2024-05-26 20:00:00 | YM | Futures | 41532.7 | 41548.7 | 41527.4 | 41542.3 | 888.0 |
| 2024-05-26 21:00:00 | YM | Futures | 41543.4 | 41556.1 | 41507.3 | 41554.0 | 2142.0 |
| 2024-05-26 22:00:00 | YM | Futures | 41555.0 | 41558.2 | 41508.3 | 41529.5 | 765.0 |
| 2024-05-26 23:00:00 | YM | Futures | 41530.6 | 41541.2 | 41530.6 | 41532.7 | 224.0 |
| 2024-05-26 18:00:00 | CL | Futures | 66.25 | 66.28 | 66.15 | 66.27 | 1034.0 |
| 2024-05-26 19:00:00 | CL | Futures | 66.27 | 66.28 | 66.2 | 66.27 | 777.0 |
| 2024-05-26 20:00:00 | CL | Futures | 66.28 | 66.33 | 66.26 | 66.28 | 1258.0 |
| 2024-05-26 21:00:00 | CL | Futures | 66.29 | 66.33 | 66.2 | 66.32 | 2266.0 |
| 2024-05-26 22:00:00 | CL | Futures | 66.32 | 66.42 | 66.28 | 66.34 | 1407.0 |
| 2024-05-26 23:00:00 | CL | Futures | 66.34 | 66.44 | 66.33 | 66.39 | 983.0 |
| 2024-05-26 18:00:00 | GC | Futures | 2534.1 | 2539.3 | 2530.9 | 2538.5 | 1126.0 |
| 2024-05-26 19:00:00 | GC | Futures | 2538.7 | 2538.8 | 2535.2 | 2535.6 | 202.0 |
| 2024-05-26 20:00:00 | GC | Futures | 2535.3 | 2535.6 | 2532.7 | 2534.6 | 294.0 |
| 2024-05-26 21:00:00 | GC | Futures | 2534.5 | 2538.9 | 2532.8 | 2538.2 | 1020.0 |
| 2024-05-26 22:00:00 | GC | Futures | 2538.0 | 2545.4 | 2537.2 | 2544.9 | 778.0 |
| 2024-05-26 23:00:00 | GC | Futures | 2545.3 | 2546.4 | 2542.2 | 2544.9 | 560.0 |
| 2024-05-26 18:00:00 | ZN | Futures | 109.631692 | 109.647439 | 109.615945 | 109.631692 | 6944.0 |
| 2024-05-26 19:00:00 | ZN | Futures | 109.647439 | 109.663186 | 109.631692 | 109.663186 | 11412.0 |
| 2024-05-26 20:00:00 | ZN | Futures | 109.663186 | 109.694681 | 109.647439 | 109.663186 | 9440.0 |
| 2024-05-26 21:00:00 | ZN | Futures | 109.663186 | 109.694681 | 109.647439 | 109.647439 | 8120.0 |
| 2024-05-26 22:00:00 | ZN | Futures | 109.647439 | 109.663186 | 109.631692 | 109.631692 | 5401.0 |
| 2024-05-26 23:00:00 | ZN | Futures | 109.647439 | 109.663186 | 109.631692 | 109.647439 | 7594.0 |
> showing 36 of 368 rows — these rows as CSV