PREVIEW / futures_30min / 2024-08-18
file: by_date/futures_30min/2024/2024-08-18.parquet size: 29 KB rows: 823
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 | 5857.0 | 10341.0 |
| 2024-08-18 18:30:00 | ES | Futures | 5857.27 | 5859.1 | 5855.17 | 5856.74 | 3437.0 |
| 2024-08-18 19:00:00 | ES | Futures | 5857.0 | 5861.46 | 5856.22 | 5860.41 | 2418.0 |
| 2024-08-18 19:30:00 | ES | Futures | 5860.68 | 5861.2 | 5852.55 | 5857.27 | 5222.0 |
| 2024-08-18 20:00:00 | ES | Futures | 5857.27 | 5860.15 | 5853.86 | 5859.89 | 4351.0 |
| 2024-08-18 20:30:00 | ES | Futures | 5859.63 | 5861.72 | 5858.05 | 5859.1 | 4800.0 |
| 2024-08-18 21:00:00 | ES | Futures | 5859.1 | 5859.63 | 5854.91 | 5856.48 | 3281.0 |
| 2024-08-18 21:30:00 | ES | Futures | 5856.48 | 5859.36 | 5855.96 | 5859.1 | 1696.0 |
| 2024-08-18 22:00:00 | ES | Futures | 5858.84 | 5860.68 | 5858.32 | 5859.89 | 1896.0 |
| 2024-08-18 22:30:00 | ES | Futures | 5859.89 | 5860.41 | 5857.53 | 5859.36 | 1121.0 |
| 2024-08-18 23:00:00 | ES | Futures | 5859.63 | 5861.46 | 5859.63 | 5860.68 | 1547.0 |
| 2024-08-18 23:30:00 | ES | Futures | 5860.68 | 5864.08 | 5855.96 | 5857.79 | 3926.0 |
| 2024-08-18 18:00:00 | NQ | Futures | 20726.85 | 20774.1 | 20711.54 | 20736.35 | 3833.0 |
| 2024-08-18 18:30:00 | NQ | Futures | 20736.35 | 20754.3 | 20728.96 | 20745.59 | 1279.0 |
| 2024-08-18 19:00:00 | NQ | Futures | 20746.91 | 20773.05 | 20741.37 | 20766.98 | 1199.0 |
| 2024-08-18 19:30:00 | NQ | Futures | 20766.45 | 20773.84 | 20721.31 | 20746.65 | 1921.0 |
| 2024-08-18 20:00:00 | NQ | Futures | 20747.97 | 20765.39 | 20725.0 | 20759.58 | 1905.0 |
| 2024-08-18 20:30:00 | NQ | Futures | 20759.58 | 20769.88 | 20747.97 | 20753.78 | 1405.0 |
| 2024-08-18 21:00:00 | NQ | Futures | 20752.46 | 20763.28 | 20734.77 | 20742.69 | 1491.0 |
| 2024-08-18 21:30:00 | NQ | Futures | 20742.69 | 20758.0 | 20738.47 | 20756.94 | 1179.0 |
| 2024-08-18 22:00:00 | NQ | Futures | 20755.1 | 20762.49 | 20751.4 | 20760.64 | 730.0 |
| 2024-08-18 22:30:00 | NQ | Futures | 20760.38 | 20766.98 | 20749.02 | 20761.7 | 641.0 |
| 2024-08-18 23:00:00 | NQ | Futures | 20761.17 | 20770.41 | 20754.83 | 20766.98 | 828.0 |
| 2024-08-18 23:30:00 | NQ | Futures | 20766.18 | 20789.15 | 20738.2 | 20744.8 | 2501.0 |
| 2024-08-18 18:00:00 | YM | Futures | 42888.6 | 42933.8 | 42880.2 | 42897.0 | 819.0 |
| 2024-08-18 18:30:00 | YM | Futures | 42899.1 | 42903.3 | 42884.4 | 42888.6 | 314.0 |
| 2024-08-18 19:00:00 | YM | Futures | 42889.7 | 42919.1 | 42889.7 | 42914.9 | 341.0 |
| 2024-08-18 19:30:00 | YM | Futures | 42915.9 | 42922.2 | 42890.7 | 42915.9 | 910.0 |
| 2024-08-18 20:00:00 | YM | Futures | 42919.1 | 42924.3 | 42892.8 | 42923.3 | 612.0 |
| 2024-08-18 20:30:00 | YM | Futures | 42922.2 | 42938.0 | 42910.7 | 42918.0 | 648.0 |
| 2024-08-18 21:00:00 | YM | Futures | 42918.0 | 42918.0 | 42887.6 | 42897.0 | 649.0 |
| 2024-08-18 21:30:00 | YM | Futures | 42897.0 | 42910.7 | 42892.8 | 42910.7 | 439.0 |
| 2024-08-18 22:00:00 | YM | Futures | 42910.7 | 42915.9 | 42903.3 | 42906.5 | 370.0 |
| 2024-08-18 22:30:00 | YM | Futures | 42904.4 | 42904.4 | 42891.8 | 42894.9 | 280.0 |
| 2024-08-18 23:00:00 | YM | Futures | 42893.9 | 42907.5 | 42890.7 | 42905.4 | 202.0 |
| 2024-08-18 23:30:00 | YM | Futures | 42904.4 | 42913.8 | 42878.1 | 42884.4 | 559.0 |
| 2024-08-18 18:00:00 | CL | Futures | 66.84 | 66.99 | 66.59 | 66.65 | 1654.0 |
| 2024-08-18 18:30:00 | CL | Futures | 66.66 | 66.72 | 66.51 | 66.51 | 630.0 |
| 2024-08-18 19:00:00 | CL | Futures | 66.52 | 66.63 | 66.52 | 66.61 | 407.0 |
| 2024-08-18 19:30:00 | CL | Futures | 66.6 | 66.65 | 66.57 | 66.64 | 322.0 |
| 2024-08-18 20:00:00 | CL | Futures | 66.64 | 66.8 | 66.63 | 66.74 | 1240.0 |
| 2024-08-18 20:30:00 | CL | Futures | 66.74 | 66.8 | 66.58 | 66.64 | 732.0 |
| 2024-08-18 21:00:00 | CL | Futures | 66.64 | 66.73 | 66.55 | 66.56 | 1310.0 |
| 2024-08-18 21:30:00 | CL | Futures | 66.55 | 66.93 | 66.53 | 66.88 | 1211.0 |
| 2024-08-18 22:00:00 | CL | Futures | 66.88 | 66.95 | 66.84 | 66.9 | 724.0 |
| 2024-08-18 22:30:00 | CL | Futures | 66.89 | 66.89 | 66.71 | 66.76 | 692.0 |
| 2024-08-18 23:00:00 | CL | Futures | 66.76 | 66.87 | 66.74 | 66.8 | 564.0 |
| 2024-08-18 23:30:00 | CL | Futures | 66.8 | 66.84 | 66.7 | 66.78 | 632.0 |
| 2024-08-18 18:00:00 | GC | Futures | 2684.7 | 2685.0 | 2675.5 | 2677.7 | 4190.0 |
| 2024-08-18 18:30:00 | GC | Futures | 2677.7 | 2679.3 | 2676.5 | 2678.3 | 1307.0 |
> showing 50 of 823 rows — these rows as CSV