PREVIEW / futures_30min / 2024-07-07
file: by_date/futures_30min/2024/2024-07-07.parquet size: 29 KB rows: 798
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.46 | 5397.0 |
| 2024-07-07 18:30:00 | ES | Futures | 5888.46 | 5889.25 | 5887.42 | 5888.2 | 845.0 |
| 2024-07-07 19:00:00 | ES | Futures | 5888.2 | 5889.51 | 5887.42 | 5888.46 | 865.0 |
| 2024-07-07 19:30:00 | ES | Futures | 5888.2 | 5888.73 | 5885.32 | 5885.84 | 1885.0 |
| 2024-07-07 20:00:00 | ES | Futures | 5885.58 | 5888.2 | 5884.27 | 5887.15 | 3848.0 |
| 2024-07-07 20:30:00 | ES | Futures | 5887.15 | 5887.15 | 5884.53 | 5885.32 | 1659.0 |
| 2024-07-07 21:00:00 | ES | Futures | 5885.32 | 5887.68 | 5883.75 | 5887.68 | 3087.0 |
| 2024-07-07 21:30:00 | ES | Futures | 5887.68 | 5887.94 | 5886.37 | 5886.63 | 2285.0 |
| 2024-07-07 22:00:00 | ES | Futures | 5886.63 | 5888.46 | 5885.84 | 5887.94 | 1584.0 |
| 2024-07-07 22:30:00 | ES | Futures | 5887.94 | 5888.2 | 5887.15 | 5887.68 | 1014.0 |
| 2024-07-07 23:00:00 | ES | Futures | 5887.68 | 5888.46 | 5886.63 | 5887.15 | 1248.0 |
| 2024-07-07 23:30:00 | ES | Futures | 5887.42 | 5888.46 | 5887.15 | 5887.42 | 690.0 |
| 2024-07-07 18:00:00 | NQ | Futures | 21743.18 | 21771.16 | 21732.36 | 21755.59 | 3995.0 |
| 2024-07-07 18:30:00 | NQ | Futures | 21755.85 | 21759.29 | 21749.52 | 21752.16 | 1321.0 |
| 2024-07-07 19:00:00 | NQ | Futures | 21752.16 | 21761.4 | 21748.99 | 21752.95 | 1040.0 |
| 2024-07-07 19:30:00 | NQ | Futures | 21753.74 | 21754.53 | 21738.17 | 21742.39 | 1830.0 |
| 2024-07-07 20:00:00 | NQ | Futures | 21742.13 | 21751.63 | 21735.0 | 21747.14 | 1993.0 |
| 2024-07-07 20:30:00 | NQ | Futures | 21747.41 | 21747.41 | 21735.0 | 21739.75 | 1137.0 |
| 2024-07-07 21:00:00 | NQ | Futures | 21739.22 | 21749.78 | 21730.25 | 21748.2 | 1849.0 |
| 2024-07-07 21:30:00 | NQ | Futures | 21747.93 | 21753.48 | 21744.24 | 21746.09 | 1375.0 |
| 2024-07-07 22:00:00 | NQ | Futures | 21745.82 | 21755.06 | 21742.39 | 21752.42 | 1201.0 |
| 2024-07-07 22:30:00 | NQ | Futures | 21752.16 | 21754.27 | 21747.41 | 21750.57 | 760.0 |
| 2024-07-07 23:00:00 | NQ | Futures | 21750.05 | 21752.95 | 21743.97 | 21747.41 | 1103.0 |
| 2024-07-07 23:30:00 | NQ | Futures | 21747.93 | 21752.69 | 21746.35 | 21750.05 | 732.0 |
| 2024-07-07 18:00:00 | YM | Futures | 41682.4 | 41684.5 | 41641.4 | 41663.5 | 657.0 |
| 2024-07-07 18:30:00 | YM | Futures | 41661.4 | 41670.8 | 41651.9 | 41655.1 | 214.0 |
| 2024-07-07 19:00:00 | YM | Futures | 41655.1 | 41663.5 | 41647.7 | 41660.3 | 202.0 |
| 2024-07-07 19:30:00 | YM | Futures | 41661.4 | 41661.4 | 41643.5 | 41644.5 | 213.0 |
| 2024-07-07 20:00:00 | YM | Futures | 41643.5 | 41657.2 | 41638.2 | 41650.9 | 630.0 |
| 2024-07-07 20:30:00 | YM | Futures | 41651.9 | 41656.1 | 41629.8 | 41631.9 | 324.0 |
| 2024-07-07 21:00:00 | YM | Futures | 41631.9 | 41648.7 | 41621.4 | 41647.7 | 471.0 |
| 2024-07-07 21:30:00 | YM | Futures | 41647.7 | 41654.0 | 41642.4 | 41646.6 | 240.0 |
| 2024-07-07 22:00:00 | YM | Futures | 41645.6 | 41653.0 | 41640.3 | 41644.5 | 274.0 |
| 2024-07-07 22:30:00 | YM | Futures | 41643.5 | 41645.6 | 41638.2 | 41643.5 | 247.0 |
| 2024-07-07 23:00:00 | YM | Futures | 41643.5 | 41653.0 | 41642.4 | 41648.7 | 146.0 |
| 2024-07-07 23:30:00 | YM | Futures | 41649.8 | 41651.9 | 41643.5 | 41645.6 | 115.0 |
| 2024-07-07 18:00:00 | CL | Futures | 71.11 | 71.16 | 70.83 | 71.05 | 2748.0 |
| 2024-07-07 18:30:00 | CL | Futures | 71.06 | 71.26 | 71.0 | 71.17 | 1367.0 |
| 2024-07-07 19:00:00 | CL | Futures | 71.17 | 71.23 | 71.11 | 71.17 | 392.0 |
| 2024-07-07 19:30:00 | CL | Futures | 71.17 | 71.17 | 71.1 | 71.16 | 418.0 |
| 2024-07-07 20:00:00 | CL | Futures | 71.16 | 71.17 | 71.03 | 71.1 | 727.0 |
| 2024-07-07 20:30:00 | CL | Futures | 71.1 | 71.1 | 70.87 | 70.89 | 1093.0 |
| 2024-07-07 21:00:00 | CL | Futures | 70.88 | 70.96 | 70.77 | 70.88 | 2211.0 |
| 2024-07-07 21:30:00 | CL | Futures | 70.88 | 70.88 | 70.74 | 70.78 | 1407.0 |
| 2024-07-07 22:00:00 | CL | Futures | 70.78 | 70.9 | 70.75 | 70.87 | 972.0 |
| 2024-07-07 22:30:00 | CL | Futures | 70.88 | 70.92 | 70.79 | 70.82 | 654.0 |
| 2024-07-07 23:00:00 | CL | Futures | 70.81 | 70.89 | 70.77 | 70.88 | 433.0 |
| 2024-07-07 23:30:00 | CL | Futures | 70.89 | 71.01 | 70.89 | 70.94 | 760.0 |
| 2024-07-07 18:00:00 | GC | Futures | 2573.1 | 2575.5 | 2571.1 | 2572.5 | 2502.0 |
| 2024-07-07 18:30:00 | GC | Futures | 2572.4 | 2573.0 | 2569.7 | 2570.2 | 996.0 |
> showing 50 of 798 rows — these rows as CSV