PREVIEW / etf_30min / 2000-04-28
file: by_date/etf_30min/2000/2000-04-28.parquet size: 9 KB rows: 199
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:30: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.75 | 146.5 | 908300.0 |
| 2000-04-28 10:30:00 | SPY | ETF | 146.625 | 146.625 | 145.375 | 145.75 | 1033900.0 |
| 2000-04-28 11:00:00 | SPY | ETF | 145.625 | 146.2188 | 145.375 | 145.4375 | 525700.0 |
| 2000-04-28 11:30:00 | SPY | ETF | 145.5 | 146.0 | 145.5 | 145.5625 | 293500.0 |
| 2000-04-28 12:00:00 | SPY | ETF | 145.5625 | 145.6875 | 145.0625 | 145.3125 | 167900.0 |
| 2000-04-28 12:30:00 | SPY | ETF | 145.4375 | 145.75 | 145.1562 | 145.5312 | 93300.0 |
| 2000-04-28 13:00:00 | SPY | ETF | 145.5 | 146.1875 | 145.3125 | 146.0625 | 316300.0 |
| 2000-04-28 13:30:00 | SPY | ETF | 145.9375 | 146.0625 | 145.4062 | 145.7812 | 362700.0 |
| 2000-04-28 14:00:00 | SPY | ETF | 145.5938 | 146.2188 | 145.5 | 145.875 | 364800.0 |
| 2000-04-28 14:30:00 | SPY | ETF | 145.7812 | 146.125 | 145.3438 | 145.875 | 597000.0 |
| 2000-04-28 15:00:00 | SPY | ETF | 145.875 | 145.9375 | 145.1562 | 145.625 | 527800.0 |
| 2000-04-28 15:30:00 | SPY | ETF | 145.6562 | 146.0 | 145.0625 | 145.2188 | 843400.0 |
| 2000-04-28 16:00:00 | SPY | ETF | 145.1875 | 145.625 | 145.0938 | 145.0938 | 573900.0 |
| 2000-04-28 09:30:00 | QQQ | ETF | 93.5625 | 94.25 | 92.6875 | 93.125 | 4348300.0 |
| 2000-04-28 10:00:00 | QQQ | ETF | 93.0625 | 93.5 | 92.5 | 93.375 | 2758800.0 |
| 2000-04-28 10:30:00 | QQQ | ETF | 93.4375 | 93.625 | 92.5 | 92.75 | 1950500.0 |
| 2000-04-28 11:00:00 | QQQ | ETF | 92.625 | 93.375 | 92.375 | 92.5 | 1477300.0 |
| 2000-04-28 11:30:00 | QQQ | ETF | 92.5 | 93.4375 | 92.5 | 93.1875 | 976700.0 |
| 2000-04-28 12:00:00 | QQQ | ETF | 93.1875 | 93.375 | 92.5625 | 93.0 | 824300.0 |
| 2000-04-28 12:30:00 | QQQ | ETF | 92.9062 | 93.25 | 92.625 | 93.125 | 420800.0 |
| 2000-04-28 13:00:00 | QQQ | ETF | 93.1875 | 94.125 | 93.125 | 94.0625 | 1398000.0 |
| 2000-04-28 13:30:00 | QQQ | ETF | 93.9375 | 94.0 | 93.1875 | 93.625 | 897000.0 |
| 2000-04-28 14:00:00 | QQQ | ETF | 93.5625 | 94.5 | 93.5 | 94.375 | 1316700.0 |
| 2000-04-28 14:30:00 | QQQ | ETF | 94.375 | 94.75 | 93.8125 | 94.125 | 884000.0 |
| 2000-04-28 15:00:00 | QQQ | ETF | 94.125 | 94.375 | 92.8125 | 93.25 | 1416600.0 |
| 2000-04-28 15:30:00 | QQQ | ETF | 93.25 | 94.25 | 92.875 | 94.25 | 4599800.0 |
| 2000-04-28 16:00:00 | QQQ | ETF | 94.25 | 94.75 | 93.875 | 94.625 | 1494000.0 |
| 2000-04-28 16:30:00 | QQQ | ETF | 94.0625 | 94.75 | 93.8125 | 93.8125 | 7000.0 |
| 2000-04-28 17:00:00 | QQQ | ETF | 94.3125 | 94.75 | 94.25 | 94.75 | 3000.0 |
| 2000-04-28 17:30:00 | QQQ | ETF | 94.75 | 94.75 | 94.625 | 94.625 | 1000.0 |
| 2000-04-28 18:00:00 | QQQ | ETF | 94.75 | 94.75 | 94.75 | 94.75 | 100.0 |
| 2000-04-28 09:30: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.75 | 108.4688 | 84400.0 |
| 2000-04-28 10:30:00 | DIA | ETF | 108.375 | 108.4688 | 107.5625 | 107.7188 | 40100.0 |
| 2000-04-28 11:00:00 | DIA | ETF | 107.6875 | 108.0938 | 107.5 | 107.5 | 111400.0 |
| 2000-04-28 11:30:00 | DIA | ETF | 107.625 | 108.125 | 107.625 | 107.6562 | 74900.0 |
| 2000-04-28 12:00:00 | DIA | ETF | 107.5625 | 107.8125 | 107.4062 | 107.7812 | 23900.0 |
| 2000-04-28 12:30:00 | DIA | ETF | 107.8438 | 107.9062 | 107.5625 | 107.8125 | 22200.0 |
| 2000-04-28 13:00:00 | DIA | ETF | 107.75 | 108.375 | 107.6875 | 108.1562 | 43800.0 |
| 2000-04-28 13:30:00 | DIA | ETF | 108.0625 | 108.2188 | 107.5625 | 107.625 | 31500.0 |
| 2000-04-28 14:00:00 | DIA | ETF | 107.625 | 108.0625 | 107.625 | 107.625 | 31800.0 |
| 2000-04-28 14:30:00 | DIA | ETF | 107.625 | 107.75 | 107.1875 | 107.5625 | 157500.0 |
| 2000-04-28 15:00:00 | DIA | ETF | 107.5625 | 107.7812 | 107.2812 | 107.4062 | 89700.0 |
| 2000-04-28 15:30:00 | DIA | ETF | 107.625 | 107.875 | 107.0 | 107.3125 | 175800.0 |
| 2000-04-28 16:00:00 | DIA | ETF | 107.375 | 107.6562 | 107.2812 | 107.5625 | 38500.0 |
> showing 46 of 199 rows — these rows as CSV