PREVIEW / etf_30min / 2000-10-05
file: by_date/etf_30min/2000/2000-10-05.parquet size: 11 KB rows: 277
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-05 09:30:00 | SPY | ETF | 143.4062 | 144.625 | 143.4062 | 144.375 | 479400.0 |
| 2000-10-05 10:00:00 | SPY | ETF | 144.3125 | 144.5625 | 143.875 | 144.0625 | 441200.0 |
| 2000-10-05 10:30:00 | SPY | ETF | 144.0625 | 144.625 | 143.6562 | 143.9062 | 463000.0 |
| 2000-10-05 11:00:00 | SPY | ETF | 143.875 | 144.3125 | 143.6875 | 143.8438 | 161800.0 |
| 2000-10-05 11:30:00 | SPY | ETF | 143.6875 | 144.0 | 143.3125 | 143.375 | 336500.0 |
| 2000-10-05 12:00:00 | SPY | ETF | 143.3125 | 143.875 | 143.3125 | 143.5938 | 337600.0 |
| 2000-10-05 12:30:00 | SPY | ETF | 143.625 | 144.1562 | 143.625 | 144.1562 | 285200.0 |
| 2000-10-05 13:00:00 | SPY | ETF | 144.125 | 144.125 | 143.7812 | 143.9688 | 40800.0 |
| 2000-10-05 13:30:00 | SPY | ETF | 144.0 | 144.5 | 143.8125 | 144.3125 | 124200.0 |
| 2000-10-05 14:00:00 | SPY | ETF | 144.2812 | 144.8438 | 144.125 | 144.25 | 349900.0 |
| 2000-10-05 14:30:00 | SPY | ETF | 144.375 | 144.375 | 143.6562 | 143.6562 | 358100.0 |
| 2000-10-05 15:00:00 | SPY | ETF | 143.6875 | 144.1875 | 143.6875 | 144.1875 | 165500.0 |
| 2000-10-05 15:30:00 | SPY | ETF | 144.0312 | 144.4062 | 143.75 | 143.875 | 362200.0 |
| 2000-10-05 16:00:00 | SPY | ETF | 143.875 | 144.1875 | 143.8438 | 144.1875 | 630600.0 |
| 2000-10-05 09:30:00 | QQQ | ETF | 85.25 | 86.7188 | 84.6875 | 86.7188 | 4626300.0 |
| 2000-10-05 10:00:00 | QQQ | ETF | 86.5625 | 87.1875 | 85.75 | 86.1562 | 2287900.0 |
| 2000-10-05 10:30:00 | QQQ | ETF | 86.25 | 86.75 | 85.375 | 85.5938 | 2462500.0 |
| 2000-10-05 11:00:00 | QQQ | ETF | 85.625 | 86.125 | 85.125 | 85.2812 | 1608000.0 |
| 2000-10-05 11:30:00 | QQQ | ETF | 85.25 | 85.6875 | 84.875 | 84.875 | 1386200.0 |
| 2000-10-05 12:00:00 | QQQ | ETF | 84.875 | 85.7188 | 84.75 | 85.3125 | 1268900.0 |
| 2000-10-05 12:30:00 | QQQ | ETF | 85.3125 | 86.0625 | 85.3125 | 85.875 | 962400.0 |
| 2000-10-05 13:00:00 | QQQ | ETF | 85.9688 | 86.0 | 85.25 | 85.4062 | 616600.0 |
| 2000-10-05 13:30:00 | QQQ | ETF | 85.3125 | 86.25 | 85.25 | 86.1875 | 1526900.0 |
| 2000-10-05 14:00:00 | QQQ | ETF | 86.0625 | 86.5 | 85.5 | 85.6875 | 1447400.0 |
| 2000-10-05 14:30:00 | QQQ | ETF | 85.7188 | 85.7812 | 84.5625 | 84.5625 | 1710700.0 |
| 2000-10-05 15:00:00 | QQQ | ETF | 84.7188 | 85.6562 | 84.625 | 85.5 | 1453400.0 |
| 2000-10-05 15:30:00 | QQQ | ETF | 85.4688 | 86.0 | 85.375 | 85.5 | 1421300.0 |
| 2000-10-05 16:00:00 | QQQ | ETF | 85.5 | 85.875 | 85.4062 | 85.8438 | 528400.0 |
| 2000-10-05 16:30:00 | QQQ | ETF | 85.8438 | 85.9375 | 85.8125 | 85.9375 | 3500.0 |
| 2000-10-05 17:00:00 | QQQ | ETF | 85.875 | 86.0 | 85.875 | 86.0 | 7300.0 |
| 2000-10-05 17:30:00 | QQQ | ETF | 85.9375 | 86.0 | 85.9375 | 86.0 | 600.0 |
| 2000-10-05 18:00:00 | QQQ | ETF | 86.0 | 86.0 | 86.0 | 86.0 | 700.0 |
| 2000-10-05 09:30:00 | IWM | ETF | 50.625 | 50.625 | 50.5938 | 50.5938 | 4000.0 |
| 2000-10-05 10:00:00 | IWM | ETF | 50.8125 | 50.8125 | 50.8125 | 50.8125 | 14000.0 |
| 2000-10-05 10:30:00 | IWM | ETF | 50.75 | 50.75 | 50.75 | 50.75 | 70000.0 |
| 2000-10-05 11:00:00 | IWM | ETF | 50.6875 | 50.6875 | 50.6875 | 50.6875 | 1800.0 |
| 2000-10-05 11:30:00 | IWM | ETF | 50.5781 | 50.5781 | 50.4375 | 50.4375 | 800.0 |
| 2000-10-05 12:00:00 | IWM | ETF | 50.3125 | 50.3125 | 50.3125 | 50.3125 | 200.0 |
| 2000-10-05 12:30:00 | IWM | ETF | 50.5625 | 50.5625 | 50.5 | 50.5 | 3600.0 |
| 2000-10-05 14:00:00 | IWM | ETF | 50.375 | 50.4688 | 50.375 | 50.4688 | 2000.0 |
| 2000-10-05 15:00:00 | IWM | ETF | 50.4375 | 50.5312 | 50.4375 | 50.5 | 60800.0 |
| 2000-10-05 15:30:00 | IWM | ETF | 50.375 | 50.375 | 50.25 | 50.25 | 142200.0 |
| 2000-10-05 16:00:00 | IWM | ETF | 50.0938 | 50.2188 | 50.0312 | 50.0625 | 109400.0 |
| 2000-10-05 09:30:00 | DIA | ETF | 107.9375 | 108.5625 | 107.875 | 108.0625 | 85900.0 |
| 2000-10-05 10:00:00 | DIA | ETF | 108.0312 | 108.3125 | 107.625 | 107.7812 | 177300.0 |
| 2000-10-05 10:30:00 | DIA | ETF | 107.875 | 108.0625 | 107.5625 | 107.625 | 51600.0 |
| 2000-10-05 11:00:00 | DIA | ETF | 107.625 | 107.9375 | 107.5625 | 107.5625 | 45900.0 |
| 2000-10-05 11:30:00 | DIA | ETF | 107.5625 | 107.75 | 107.4375 | 107.5 | 26900.0 |
| 2000-10-05 12:00:00 | DIA | ETF | 107.4375 | 107.625 | 107.3125 | 107.5625 | 46600.0 |
| 2000-10-05 12:30:00 | DIA | ETF | 107.5938 | 107.7812 | 107.5938 | 107.7812 | 16100.0 |
> showing 50 of 277 rows — these rows as CSV