PREVIEW / etf_30min / 2000-09-08
file: by_date/etf_30min/2000/2000-09-08.parquet size: 11 KB rows: 281
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-09-08 09:30:00 | SPY | ETF | 150.2812 | 150.4375 | 150.0938 | 150.25 | 439500.0 |
| 2000-09-08 10:00:00 | SPY | ETF | 150.25 | 150.5 | 149.8438 | 149.8438 | 256500.0 |
| 2000-09-08 10:30:00 | SPY | ETF | 149.9688 | 150.0 | 149.5 | 149.5625 | 437200.0 |
| 2000-09-08 11:00:00 | SPY | ETF | 149.5625 | 149.875 | 149.3125 | 149.8438 | 410400.0 |
| 2000-09-08 11:30:00 | SPY | ETF | 149.75 | 150.0 | 149.625 | 149.7812 | 144700.0 |
| 2000-09-08 12:00:00 | SPY | ETF | 149.8438 | 150.1875 | 149.6562 | 150.0938 | 51800.0 |
| 2000-09-08 12:30:00 | SPY | ETF | 150.0625 | 150.3438 | 150.0312 | 150.0625 | 78100.0 |
| 2000-09-08 13:00:00 | SPY | ETF | 150.0312 | 150.1875 | 149.875 | 150.125 | 66700.0 |
| 2000-09-08 13:30:00 | SPY | ETF | 150.0625 | 150.4688 | 150.0625 | 150.125 | 54000.0 |
| 2000-09-08 14:00:00 | SPY | ETF | 150.125 | 150.1562 | 149.75 | 149.75 | 104400.0 |
| 2000-09-08 14:30:00 | SPY | ETF | 149.9688 | 150.0 | 149.6562 | 149.6562 | 294900.0 |
| 2000-09-08 15:00:00 | SPY | ETF | 149.7188 | 150.125 | 149.5625 | 149.9688 | 213500.0 |
| 2000-09-08 15:30:00 | SPY | ETF | 150.0312 | 150.125 | 149.625 | 149.7188 | 485800.0 |
| 2000-09-08 16:00:00 | SPY | ETF | 149.75 | 149.875 | 149.6562 | 149.8125 | 453500.0 |
| 2000-09-08 09:30:00 | QQQ | ETF | 97.75 | 98.0 | 96.5625 | 96.7188 | 2649000.0 |
| 2000-09-08 10:00:00 | QQQ | ETF | 96.7188 | 97.0312 | 96.0625 | 96.0625 | 2891600.0 |
| 2000-09-08 10:30:00 | QQQ | ETF | 96.0625 | 96.2188 | 95.3125 | 95.5 | 3061400.0 |
| 2000-09-08 11:00:00 | QQQ | ETF | 95.5 | 96.5 | 95.2812 | 96.375 | 2028400.0 |
| 2000-09-08 11:30:00 | QQQ | ETF | 96.4375 | 96.8438 | 96.125 | 96.3125 | 1795100.0 |
| 2000-09-08 12:00:00 | QQQ | ETF | 96.25 | 96.9688 | 96.1875 | 96.9375 | 670500.0 |
| 2000-09-08 12:30:00 | QQQ | ETF | 96.875 | 97.2188 | 96.75 | 96.75 | 976900.0 |
| 2000-09-08 13:00:00 | QQQ | ETF | 96.8125 | 96.875 | 96.5 | 96.75 | 730100.0 |
| 2000-09-08 13:30:00 | QQQ | ETF | 96.75 | 97.0625 | 96.4375 | 96.4688 | 901900.0 |
| 2000-09-08 14:00:00 | QQQ | ETF | 96.4375 | 96.5625 | 95.8125 | 96.0 | 901200.0 |
| 2000-09-08 14:30:00 | QQQ | ETF | 96.0938 | 96.25 | 95.5625 | 95.625 | 939600.0 |
| 2000-09-08 15:00:00 | QQQ | ETF | 95.625 | 96.1875 | 95.5625 | 95.9375 | 1528800.0 |
| 2000-09-08 15:30:00 | QQQ | ETF | 96.0 | 96.0 | 95.1875 | 95.3125 | 2950900.0 |
| 2000-09-08 16:00:00 | QQQ | ETF | 95.3125 | 95.375 | 94.75 | 94.75 | 1407400.0 |
| 2000-09-08 16:30:00 | QQQ | ETF | 94.875 | 95.125 | 94.875 | 95.0625 | 4400.0 |
| 2000-09-08 17:00:00 | QQQ | ETF | 95.0625 | 95.125 | 95.0 | 95.0625 | 7400.0 |
| 2000-09-08 17:30:00 | QQQ | ETF | 95.1875 | 95.1875 | 95.1875 | 95.1875 | 600.0 |
| 2000-09-08 18:00:00 | QQQ | ETF | 95.1875 | 95.1875 | 95.0625 | 95.125 | 2000.0 |
| 2000-09-08 09:30:00 | IWM | ETF | 54.0938 | 54.0938 | 54.0938 | 54.0938 | 200.0 |
| 2000-09-08 10:00:00 | IWM | ETF | 54.2188 | 54.2188 | 54.0469 | 54.0469 | 1200.0 |
| 2000-09-08 10:30:00 | IWM | ETF | 53.9062 | 53.9062 | 53.9062 | 53.9062 | 200.0 |
| 2000-09-08 11:00:00 | IWM | ETF | 53.8125 | 53.875 | 53.7812 | 53.8438 | 7400.0 |
| 2000-09-08 12:00:00 | IWM | ETF | 54.0938 | 54.0938 | 54.0938 | 54.0938 | 200.0 |
| 2000-09-08 12:30:00 | IWM | ETF | 54.1719 | 54.1719 | 54.1719 | 54.1719 | 200.0 |
| 2000-09-08 13:30:00 | IWM | ETF | 54.1562 | 54.1562 | 54.1562 | 54.1562 | 1000.0 |
| 2000-09-08 15:00:00 | IWM | ETF | 54.0625 | 54.0625 | 54.0625 | 54.0625 | 3800.0 |
| 2000-09-08 15:30:00 | IWM | ETF | 53.8906 | 54.0 | 53.7656 | 53.7656 | 113400.0 |
| 2000-09-08 16:00:00 | IWM | ETF | 53.4531 | 53.6094 | 53.4375 | 53.4375 | 1000.0 |
| 2000-09-08 09:30:00 | DIA | ETF | 112.25 | 112.6875 | 112.1875 | 112.3125 | 92500.0 |
| 2000-09-08 10:00:00 | DIA | ETF | 112.3438 | 112.7812 | 112.1875 | 112.1875 | 73800.0 |
| 2000-09-08 10:30:00 | DIA | ETF | 112.2812 | 112.4062 | 112.125 | 112.125 | 40800.0 |
| 2000-09-08 11:00:00 | DIA | ETF | 112.125 | 112.2188 | 111.875 | 112.0 | 13300.0 |
| 2000-09-08 11:30:00 | DIA | ETF | 112.125 | 112.2188 | 112.0 | 112.125 | 4300.0 |
| 2000-09-08 12:00:00 | DIA | ETF | 112.1562 | 112.3438 | 112.0 | 112.3125 | 8300.0 |
| 2000-09-08 12:30:00 | DIA | ETF | 112.3125 | 112.3438 | 112.1875 | 112.25 | 3500.0 |
| 2000-09-08 13:00:00 | DIA | ETF | 112.25 | 112.3125 | 112.0 | 112.1562 | 3800.0 |
> showing 50 of 281 rows — these rows as CSV