PREVIEW / futures_1hour / 2025-01-05
file: by_date/futures_1hour/2025/2025-01-05.parquet size: 20 KB rows: 443
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-01-05 18:00:00 | ES | Futures | 6147.42 | 6148.96 | 6138.71 | 6143.58 | 8159.0 |
| 2025-01-05 19:00:00 | ES | Futures | 6143.83 | 6146.14 | 6134.6 | 6138.19 | 8839.0 |
| 2025-01-05 20:00:00 | ES | Futures | 6138.19 | 6139.99 | 6133.83 | 6136.91 | 4754.0 |
| 2025-01-05 21:00:00 | ES | Futures | 6137.17 | 6140.76 | 6133.32 | 6138.71 | 6220.0 |
| 2025-01-05 22:00:00 | ES | Futures | 6138.71 | 6139.73 | 6136.14 | 6137.42 | 2917.0 |
| 2025-01-05 23:00:00 | ES | Futures | 6137.17 | 6141.01 | 6136.91 | 6140.24 | 2645.0 |
| 2025-01-05 18:00:00 | NQ | Futures | 22165.01 | 22177.88 | 22133.62 | 22156.78 | 4698.0 |
| 2025-01-05 19:00:00 | NQ | Futures | 22158.32 | 22169.13 | 22109.43 | 22127.44 | 4538.0 |
| 2025-01-05 20:00:00 | NQ | Futures | 22127.7 | 22139.02 | 22113.8 | 22132.33 | 3782.0 |
| 2025-01-05 21:00:00 | NQ | Futures | 22131.56 | 22151.12 | 22114.57 | 22141.59 | 4529.0 |
| 2025-01-05 22:00:00 | NQ | Futures | 22142.37 | 22149.83 | 22132.84 | 22140.56 | 2242.0 |
| 2025-01-05 23:00:00 | NQ | Futures | 22141.08 | 22156.52 | 22135.93 | 22155.49 | 1694.0 |
| 2025-01-05 18:00:00 | YM | Futures | 44283.1 | 44305.8 | 44250.2 | 44274.9 | 642.0 |
| 2025-01-05 19:00:00 | YM | Futures | 44279.0 | 44294.5 | 44225.5 | 44246.1 | 796.0 |
| 2025-01-05 20:00:00 | YM | Futures | 44245.1 | 44255.4 | 44215.2 | 44229.6 | 456.0 |
| 2025-01-05 21:00:00 | YM | Futures | 44227.6 | 44244.0 | 44208.0 | 44234.8 | 541.0 |
| 2025-01-05 22:00:00 | YM | Futures | 44233.7 | 44235.8 | 44218.3 | 44219.3 | 238.0 |
| 2025-01-05 23:00:00 | YM | Futures | 44219.3 | 44242.0 | 44218.3 | 44231.7 | 277.0 |
| 2025-01-05 18:00:00 | CL | Futures | 67.26 | 67.47 | 67.18 | 67.38 | 2613.0 |
| 2025-01-05 19:00:00 | CL | Futures | 67.38 | 67.42 | 67.14 | 67.16 | 1531.0 |
| 2025-01-05 20:00:00 | CL | Futures | 67.17 | 67.57 | 67.17 | 67.33 | 3170.0 |
| 2025-01-05 21:00:00 | CL | Futures | 67.34 | 67.34 | 67.16 | 67.18 | 1969.0 |
| 2025-01-05 22:00:00 | CL | Futures | 67.19 | 67.2 | 67.03 | 67.04 | 1258.0 |
| 2025-01-05 23:00:00 | CL | Futures | 67.04 | 67.1 | 66.88 | 66.89 | 2435.0 |
| 2025-01-05 18:00:00 | GC | Futures | 2767.9 | 2770.5 | 2766.7 | 2768.8 | 1982.0 |
| 2025-01-05 19:00:00 | GC | Futures | 2768.8 | 2771.3 | 2766.3 | 2771.1 | 1798.0 |
| 2025-01-05 20:00:00 | GC | Futures | 2771.3 | 2776.5 | 2769.0 | 2769.4 | 4407.0 |
| 2025-01-05 21:00:00 | GC | Futures | 2769.5 | 2773.7 | 2767.7 | 2772.5 | 2221.0 |
| 2025-01-05 22:00:00 | GC | Futures | 2772.5 | 2773.2 | 2766.3 | 2767.3 | 2381.0 |
| 2025-01-05 23:00:00 | GC | Futures | 2767.3 | 2768.1 | 2760.0 | 2761.7 | 4915.0 |
| 2025-01-05 18:00:00 | ZN | Futures | 108.65479 | 108.65479 | 108.52972 | 108.545354 | 20180.0 |
| 2025-01-05 19:00:00 | ZN | Futures | 108.560988 | 108.560988 | 108.435917 | 108.514086 | 54455.0 |
| 2025-01-05 20:00:00 | ZN | Futures | 108.514086 | 108.52972 | 108.482819 | 108.498453 | 12663.0 |
| 2025-01-05 21:00:00 | ZN | Futures | 108.482819 | 108.52972 | 108.482819 | 108.514086 | 15383.0 |
| 2025-01-05 22:00:00 | ZN | Futures | 108.52972 | 108.560988 | 108.498453 | 108.560988 | 11369.0 |
| 2025-01-05 23:00:00 | ZN | Futures | 108.560988 | 108.576621 | 108.545354 | 108.576621 | 12489.0 |
> showing 36 of 443 rows — these rows as CSV