PREVIEW / etf_1hour / 2000-04-28
file: by_date/etf_1hour/2000/2000-04-28.parquet size: 8 KB rows: 122
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-04-28 09:00:00 | SPY | ETF | 147.0 | 147.8438 | 146.375 | 146.625 | 2002300.0 |
| 2000-04-28 10:00:00 | SPY | ETF | 146.6562 | 146.8125 | 145.375 | 145.75 | 1942200.0 |
| 2000-04-28 11:00:00 | SPY | ETF | 145.625 | 146.2188 | 145.375 | 145.5625 | 819200.0 |
| 2000-04-28 12:00:00 | SPY | ETF | 145.5625 | 145.75 | 145.0625 | 145.5312 | 261200.0 |
| 2000-04-28 13:00:00 | SPY | ETF | 145.5 | 146.1875 | 145.3125 | 145.7812 | 679000.0 |
| 2000-04-28 14:00:00 | SPY | ETF | 145.5938 | 146.2188 | 145.3438 | 145.875 | 961800.0 |
| 2000-04-28 15:00:00 | SPY | ETF | 145.875 | 146.0 | 145.0625 | 145.2188 | 1371200.0 |
| 2000-04-28 16:00:00 | SPY | ETF | 145.1875 | 145.625 | 145.0938 | 145.0938 | 573900.0 |
| 2000-04-28 09:00:00 | QQQ | ETF | 93.5625 | 94.25 | 92.6875 | 93.125 | 4348300.0 |
| 2000-04-28 10:00:00 | QQQ | ETF | 93.0625 | 93.625 | 92.5 | 92.75 | 4709300.0 |
| 2000-04-28 11:00:00 | QQQ | ETF | 92.625 | 93.4375 | 92.375 | 93.1875 | 2454000.0 |
| 2000-04-28 12:00:00 | QQQ | ETF | 93.1875 | 93.375 | 92.5625 | 93.125 | 1245100.0 |
| 2000-04-28 13:00:00 | QQQ | ETF | 93.1875 | 94.125 | 93.125 | 93.625 | 2295000.0 |
| 2000-04-28 14:00:00 | QQQ | ETF | 93.5625 | 94.75 | 93.5 | 94.125 | 2200700.0 |
| 2000-04-28 15:00:00 | QQQ | ETF | 94.125 | 94.375 | 92.8125 | 94.25 | 6016400.0 |
| 2000-04-28 16:00:00 | QQQ | ETF | 94.25 | 94.75 | 93.8125 | 93.8125 | 1501000.0 |
| 2000-04-28 17:00:00 | QQQ | ETF | 94.3125 | 94.75 | 94.25 | 94.625 | 4000.0 |
| 2000-04-28 18:00:00 | QQQ | ETF | 94.75 | 94.75 | 94.75 | 94.75 | 100.0 |
| 2000-04-28 09:00:00 | DIA | ETF | 109.375 | 109.5 | 108.25 | 108.3125 | 226400.0 |
| 2000-04-28 10:00:00 | DIA | ETF | 108.3125 | 108.5625 | 107.5625 | 107.7188 | 124500.0 |
| 2000-04-28 11:00:00 | DIA | ETF | 107.6875 | 108.125 | 107.5 | 107.6562 | 186300.0 |
| 2000-04-28 12:00:00 | DIA | ETF | 107.5625 | 107.9062 | 107.4062 | 107.8125 | 46100.0 |
| 2000-04-28 13:00:00 | DIA | ETF | 107.75 | 108.375 | 107.5625 | 107.625 | 75300.0 |
| 2000-04-28 14:00:00 | DIA | ETF | 107.625 | 108.0625 | 107.1875 | 107.5625 | 189300.0 |
| 2000-04-28 15:00:00 | DIA | ETF | 107.5625 | 107.875 | 107.0 | 107.3125 | 265500.0 |
| 2000-04-28 16:00:00 | DIA | ETF | 107.375 | 107.6562 | 107.2812 | 107.5625 | 38500.0 |
> showing 26 of 122 rows — these rows as CSV