PREVIEW / futures_1hour / 2024-08-18
file: by_date/futures_1hour/2024/2024-08-18.parquet size: 19 KB rows: 436
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-08-18 18:00:00 | ES | Futures | 5855.69 | 5865.92 | 5853.07 | 5856.74 | 13778.0 |
| 2024-08-18 19:00:00 | ES | Futures | 5857.0 | 5861.46 | 5852.55 | 5857.27 | 7640.0 |
| 2024-08-18 20:00:00 | ES | Futures | 5857.27 | 5861.72 | 5853.86 | 5859.1 | 9151.0 |
| 2024-08-18 21:00:00 | ES | Futures | 5859.1 | 5859.63 | 5854.91 | 5859.1 | 4977.0 |
| 2024-08-18 22:00:00 | ES | Futures | 5858.84 | 5860.68 | 5857.53 | 5859.36 | 3017.0 |
| 2024-08-18 23:00:00 | ES | Futures | 5859.63 | 5864.08 | 5855.96 | 5857.79 | 5473.0 |
| 2024-08-18 18:00:00 | NQ | Futures | 20726.85 | 20774.1 | 20711.54 | 20745.59 | 5112.0 |
| 2024-08-18 19:00:00 | NQ | Futures | 20746.91 | 20773.84 | 20721.31 | 20746.65 | 3120.0 |
| 2024-08-18 20:00:00 | NQ | Futures | 20747.97 | 20769.88 | 20725.0 | 20753.78 | 3310.0 |
| 2024-08-18 21:00:00 | NQ | Futures | 20752.46 | 20763.28 | 20734.77 | 20756.94 | 2670.0 |
| 2024-08-18 22:00:00 | NQ | Futures | 20755.1 | 20766.98 | 20749.02 | 20761.7 | 1371.0 |
| 2024-08-18 23:00:00 | NQ | Futures | 20761.17 | 20789.15 | 20738.2 | 20744.8 | 3329.0 |
| 2024-08-18 18:00:00 | YM | Futures | 42888.6 | 42933.8 | 42880.2 | 42888.6 | 1133.0 |
| 2024-08-18 19:00:00 | YM | Futures | 42889.7 | 42922.2 | 42889.7 | 42915.9 | 1251.0 |
| 2024-08-18 20:00:00 | YM | Futures | 42919.1 | 42938.0 | 42892.8 | 42918.0 | 1260.0 |
| 2024-08-18 21:00:00 | YM | Futures | 42918.0 | 42918.0 | 42887.6 | 42910.7 | 1088.0 |
| 2024-08-18 22:00:00 | YM | Futures | 42910.7 | 42915.9 | 42891.8 | 42894.9 | 650.0 |
| 2024-08-18 23:00:00 | YM | Futures | 42893.9 | 42913.8 | 42878.1 | 42884.4 | 761.0 |
| 2024-08-18 18:00:00 | CL | Futures | 66.84 | 66.99 | 66.51 | 66.51 | 2284.0 |
| 2024-08-18 19:00:00 | CL | Futures | 66.52 | 66.65 | 66.52 | 66.64 | 729.0 |
| 2024-08-18 20:00:00 | CL | Futures | 66.64 | 66.8 | 66.58 | 66.64 | 1972.0 |
| 2024-08-18 21:00:00 | CL | Futures | 66.64 | 66.93 | 66.53 | 66.88 | 2521.0 |
| 2024-08-18 22:00:00 | CL | Futures | 66.88 | 66.95 | 66.71 | 66.76 | 1416.0 |
| 2024-08-18 23:00:00 | CL | Futures | 66.76 | 66.87 | 66.7 | 66.78 | 1196.0 |
| 2024-08-18 18:00:00 | GC | Futures | 2684.7 | 2685.0 | 2675.5 | 2678.3 | 5497.0 |
| 2024-08-18 19:00:00 | GC | Futures | 2678.3 | 2680.4 | 2676.8 | 2679.9 | 1218.0 |
| 2024-08-18 20:00:00 | GC | Futures | 2680.0 | 2680.4 | 2673.5 | 2675.5 | 4770.0 |
| 2024-08-18 21:00:00 | GC | Futures | 2675.7 | 2679.8 | 2667.9 | 2671.4 | 10613.0 |
| 2024-08-18 22:00:00 | GC | Futures | 2671.3 | 2677.7 | 2669.0 | 2677.2 | 5463.0 |
| 2024-08-18 23:00:00 | GC | Futures | 2676.8 | 2679.6 | 2673.8 | 2676.6 | 4654.0 |
| 2024-08-18 18:00:00 | ZN | Futures | 113.732796 | 113.748507 | 113.63853 | 113.654241 | 15802.0 |
| 2024-08-18 19:00:00 | ZN | Futures | 113.654241 | 113.654241 | 113.591396 | 113.591396 | 10509.0 |
| 2024-08-18 20:00:00 | ZN | Futures | 113.607107 | 113.717085 | 113.591396 | 113.717085 | 17186.0 |
| 2024-08-18 21:00:00 | ZN | Futures | 113.717085 | 113.732796 | 113.669952 | 113.701374 | 11827.0 |
| 2024-08-18 22:00:00 | ZN | Futures | 113.701374 | 113.732796 | 113.685663 | 113.701374 | 6605.0 |
| 2024-08-18 23:00:00 | ZN | Futures | 113.701374 | 113.748507 | 113.701374 | 113.748507 | 9666.0 |
> showing 36 of 436 rows — these rows as CSV