PREVIEW / futures_1hour / 2024-07-07
file: by_date/futures_1hour/2024/2024-07-07.parquet size: 19 KB rows: 425
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-07-07 18:00:00 | ES | Futures | 5885.06 | 5891.35 | 5884.01 | 5888.2 | 6242.0 |
| 2024-07-07 19:00:00 | ES | Futures | 5888.2 | 5889.51 | 5885.32 | 5885.84 | 2750.0 |
| 2024-07-07 20:00:00 | ES | Futures | 5885.58 | 5888.2 | 5884.27 | 5885.32 | 5507.0 |
| 2024-07-07 21:00:00 | ES | Futures | 5885.32 | 5887.94 | 5883.75 | 5886.63 | 5372.0 |
| 2024-07-07 22:00:00 | ES | Futures | 5886.63 | 5888.46 | 5885.84 | 5887.68 | 2598.0 |
| 2024-07-07 23:00:00 | ES | Futures | 5887.68 | 5888.46 | 5886.63 | 5887.42 | 1938.0 |
| 2024-07-07 18:00:00 | NQ | Futures | 21743.18 | 21771.16 | 21732.36 | 21752.16 | 5316.0 |
| 2024-07-07 19:00:00 | NQ | Futures | 21752.16 | 21761.4 | 21738.17 | 21742.39 | 2870.0 |
| 2024-07-07 20:00:00 | NQ | Futures | 21742.13 | 21751.63 | 21735.0 | 21739.75 | 3130.0 |
| 2024-07-07 21:00:00 | NQ | Futures | 21739.22 | 21753.48 | 21730.25 | 21746.09 | 3224.0 |
| 2024-07-07 22:00:00 | NQ | Futures | 21745.82 | 21755.06 | 21742.39 | 21750.57 | 1961.0 |
| 2024-07-07 23:00:00 | NQ | Futures | 21750.05 | 21752.95 | 21743.97 | 21750.05 | 1835.0 |
| 2024-07-07 18:00:00 | YM | Futures | 41682.4 | 41684.5 | 41641.4 | 41655.1 | 871.0 |
| 2024-07-07 19:00:00 | YM | Futures | 41655.1 | 41663.5 | 41643.5 | 41644.5 | 415.0 |
| 2024-07-07 20:00:00 | YM | Futures | 41643.5 | 41657.2 | 41629.8 | 41631.9 | 954.0 |
| 2024-07-07 21:00:00 | YM | Futures | 41631.9 | 41654.0 | 41621.4 | 41646.6 | 711.0 |
| 2024-07-07 22:00:00 | YM | Futures | 41645.6 | 41653.0 | 41638.2 | 41643.5 | 521.0 |
| 2024-07-07 23:00:00 | YM | Futures | 41643.5 | 41653.0 | 41642.4 | 41645.6 | 261.0 |
| 2024-07-07 18:00:00 | CL | Futures | 71.11 | 71.26 | 70.83 | 71.17 | 4115.0 |
| 2024-07-07 19:00:00 | CL | Futures | 71.17 | 71.23 | 71.1 | 71.16 | 810.0 |
| 2024-07-07 20:00:00 | CL | Futures | 71.16 | 71.17 | 70.87 | 70.89 | 1820.0 |
| 2024-07-07 21:00:00 | CL | Futures | 70.88 | 70.96 | 70.74 | 70.78 | 3618.0 |
| 2024-07-07 22:00:00 | CL | Futures | 70.78 | 70.92 | 70.75 | 70.82 | 1626.0 |
| 2024-07-07 23:00:00 | CL | Futures | 70.81 | 71.01 | 70.77 | 70.94 | 1193.0 |
| 2024-07-07 18:00:00 | GC | Futures | 2573.1 | 2575.5 | 2569.7 | 2570.2 | 3498.0 |
| 2024-07-07 19:00:00 | GC | Futures | 2570.2 | 2572.1 | 2569.7 | 2571.0 | 1540.0 |
| 2024-07-07 20:00:00 | GC | Futures | 2571.1 | 2572.9 | 2569.4 | 2571.9 | 2405.0 |
| 2024-07-07 21:00:00 | GC | Futures | 2571.8 | 2576.5 | 2568.7 | 2571.5 | 6525.0 |
| 2024-07-07 22:00:00 | GC | Futures | 2571.4 | 2572.3 | 2565.7 | 2567.7 | 3202.0 |
| 2024-07-07 23:00:00 | GC | Futures | 2567.6 | 2569.1 | 2565.2 | 2567.7 | 2858.0 |
| 2024-07-07 18:00:00 | ZN | Futures | 111.171884 | 111.250439 | 111.093328 | 111.109039 | 11615.0 |
| 2024-07-07 19:00:00 | ZN | Futures | 111.109039 | 111.12475 | 111.077617 | 111.093328 | 8013.0 |
| 2024-07-07 20:00:00 | ZN | Futures | 111.109039 | 111.109039 | 110.999061 | 110.999061 | 38045.0 |
| 2024-07-07 21:00:00 | ZN | Futures | 111.014773 | 111.061906 | 110.967639 | 111.046195 | 26561.0 |
| 2024-07-07 22:00:00 | ZN | Futures | 111.046195 | 111.077617 | 111.014773 | 111.046195 | 17173.0 |
| 2024-07-07 23:00:00 | ZN | Futures | 111.046195 | 111.093328 | 111.030484 | 111.061906 | 6920.0 |
> showing 36 of 425 rows — these rows as CSV