PREVIEW / etf_30min / 2000-10-19
file: by_date/etf_30min/2000/2000-10-19.parquet size: 12 KB rows: 291
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 |
|---|---|---|---|---|---|---|---|
| 2000-10-19 09:30:00 | SPY | ETF | 136.8438 | 137.125 | 136.4375 | 136.9688 | 1619800.0 |
| 2000-10-19 10:00:00 | SPY | ETF | 136.9375 | 137.1875 | 136.625 | 136.875 | 548600.0 |
| 2000-10-19 10:30:00 | SPY | ETF | 137.0312 | 137.7812 | 136.9688 | 137.2188 | 583100.0 |
| 2000-10-19 11:00:00 | SPY | ETF | 137.1562 | 138.0312 | 137.0312 | 137.6562 | 703600.0 |
| 2000-10-19 11:30:00 | SPY | ETF | 137.875 | 138.0938 | 137.5 | 137.5 | 470500.0 |
| 2000-10-19 12:00:00 | SPY | ETF | 137.5 | 138.3125 | 137.4688 | 138.125 | 374000.0 |
| 2000-10-19 12:30:00 | SPY | ETF | 138.0938 | 138.375 | 137.9062 | 138.0938 | 711300.0 |
| 2000-10-19 13:00:00 | SPY | ETF | 138.125 | 138.4688 | 137.9688 | 138.4688 | 237500.0 |
| 2000-10-19 13:30:00 | SPY | ETF | 138.375 | 138.4688 | 137.875 | 138.0 | 329100.0 |
| 2000-10-19 14:00:00 | SPY | ETF | 137.875 | 138.625 | 137.875 | 138.4688 | 309400.0 |
| 2000-10-19 14:30:00 | SPY | ETF | 138.4688 | 139.125 | 138.4062 | 138.9062 | 311700.0 |
| 2000-10-19 15:00:00 | SPY | ETF | 139.0625 | 139.3125 | 138.6562 | 139.2188 | 365000.0 |
| 2000-10-19 15:30:00 | SPY | ETF | 139.0938 | 139.4375 | 138.625 | 139.0312 | 1267700.0 |
| 2000-10-19 16:00:00 | SPY | ETF | 139.1562 | 139.3125 | 138.875 | 139.3125 | 480200.0 |
| 2000-10-19 16:30:00 | SPY | ETF | 139.0625 | 139.125 | 139.0625 | 139.125 | 200.0 |
| 2000-10-19 09:30:00 | QQQ | ETF | 82.375 | 83.0 | 81.4375 | 82.125 | 10784700.0 |
| 2000-10-19 10:00:00 | QQQ | ETF | 82.0625 | 82.9375 | 81.625 | 82.1562 | 3619800.0 |
| 2000-10-19 10:30:00 | QQQ | ETF | 82.1875 | 83.125 | 82.0 | 82.5625 | 2896000.0 |
| 2000-10-19 11:00:00 | QQQ | ETF | 82.5625 | 83.8125 | 82.375 | 83.5625 | 2711600.0 |
| 2000-10-19 11:30:00 | QQQ | ETF | 83.6875 | 83.875 | 82.875 | 82.875 | 2282000.0 |
| 2000-10-19 12:00:00 | QQQ | ETF | 82.875 | 83.75 | 82.8125 | 83.5938 | 1407000.0 |
| 2000-10-19 12:30:00 | QQQ | ETF | 83.5625 | 83.75 | 83.375 | 83.6875 | 1170300.0 |
| 2000-10-19 13:00:00 | QQQ | ETF | 83.6875 | 84.0 | 83.5 | 83.9688 | 1145300.0 |
| 2000-10-19 13:30:00 | QQQ | ETF | 84.0 | 84.3125 | 82.875 | 82.875 | 2805700.0 |
| 2000-10-19 14:00:00 | QQQ | ETF | 83.0 | 83.875 | 82.875 | 83.75 | 2146800.0 |
| 2000-10-19 14:30:00 | QQQ | ETF | 83.6875 | 84.6875 | 83.625 | 84.625 | 2992700.0 |
| 2000-10-19 15:00:00 | QQQ | ETF | 84.625 | 85.0 | 84.375 | 84.875 | 2818000.0 |
| 2000-10-19 15:30:00 | QQQ | ETF | 84.875 | 85.0 | 83.7188 | 84.8125 | 3810400.0 |
| 2000-10-19 16:00:00 | QQQ | ETF | 84.875 | 85.4375 | 84.6875 | 85.0625 | 703600.0 |
| 2000-10-19 16:30:00 | QQQ | ETF | 85.0 | 85.5 | 83.8125 | 85.0625 | 58900.0 |
| 2000-10-19 17:00:00 | QQQ | ETF | 84.9375 | 85.5 | 84.9375 | 85.0 | 9300.0 |
| 2000-10-19 17:30:00 | QQQ | ETF | 85.0625 | 85.5 | 85.0625 | 85.5 | 12800.0 |
| 2000-10-19 18:00:00 | QQQ | ETF | 85.5 | 85.5 | 85.25 | 85.5 | 6100.0 |
| 2000-10-19 09:30:00 | IWM | ETF | 47.2812 | 47.5781 | 47.2812 | 47.5781 | 10000.0 |
| 2000-10-19 10:00:00 | IWM | ETF | 47.375 | 47.6562 | 47.375 | 47.625 | 6000.0 |
| 2000-10-19 10:30:00 | IWM | ETF | 47.625 | 47.7188 | 47.625 | 47.7188 | 17200.0 |
| 2000-10-19 11:30:00 | IWM | ETF | 47.7812 | 47.7812 | 47.6875 | 47.75 | 3800.0 |
| 2000-10-19 12:00:00 | IWM | ETF | 47.75 | 47.75 | 47.75 | 47.75 | 3400.0 |
| 2000-10-19 13:00:00 | IWM | ETF | 47.8125 | 47.8125 | 47.8125 | 47.8125 | 3200.0 |
| 2000-10-19 13:30:00 | IWM | ETF | 47.9062 | 47.9688 | 47.7188 | 47.7188 | 94400.0 |
| 2000-10-19 14:00:00 | IWM | ETF | 47.625 | 47.8438 | 47.625 | 47.8438 | 1000.0 |
| 2000-10-19 14:30:00 | IWM | ETF | 48.0 | 48.0 | 48.0 | 48.0 | 400.0 |
| 2000-10-19 15:00:00 | IWM | ETF | 47.875 | 47.9688 | 47.875 | 47.9688 | 4400.0 |
| 2000-10-19 15:30:00 | IWM | ETF | 48.0938 | 48.0938 | 47.9688 | 47.9688 | 5200.0 |
| 2000-10-19 09:30:00 | DIA | ETF | 101.25 | 101.5 | 100.875 | 101.1562 | 239700.0 |
| 2000-10-19 10:00:00 | DIA | ETF | 101.1562 | 101.2812 | 100.75 | 101.0938 | 191800.0 |
| 2000-10-19 10:30:00 | DIA | ETF | 100.9062 | 101.2188 | 100.8125 | 100.875 | 37300.0 |
| 2000-10-19 11:00:00 | DIA | ETF | 100.75 | 101.375 | 100.6562 | 101.0 | 58100.0 |
| 2000-10-19 11:30:00 | DIA | ETF | 100.875 | 101.0625 | 100.875 | 100.9375 | 30200.0 |
| 2000-10-19 12:00:00 | DIA | ETF | 100.9375 | 101.1562 | 100.875 | 101.0 | 9600.0 |
> showing 50 of 291 rows — these rows as CSV