PREVIEW / etf_30min / 2000-03-02
file: by_date/etf_30min/2000/2000-03-02.parquet size: 10 KB rows: 217
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-03-02 09:30:00 | SPY | ETF | 138.6875 | 138.7188 | 137.8438 | 137.9688 | 1543200.0 |
| 2000-03-02 10:00:00 | SPY | ETF | 138.0938 | 138.9062 | 137.9375 | 138.4375 | 308900.0 |
| 2000-03-02 10:30:00 | SPY | ETF | 138.25 | 138.7812 | 138.1875 | 138.7188 | 232100.0 |
| 2000-03-02 11:00:00 | SPY | ETF | 138.625 | 138.9688 | 138.4688 | 138.9688 | 443600.0 |
| 2000-03-02 11:30:00 | SPY | ETF | 138.75 | 138.875 | 138.1562 | 138.625 | 601900.0 |
| 2000-03-02 12:00:00 | SPY | ETF | 138.5 | 138.625 | 138.0938 | 138.3438 | 112200.0 |
| 2000-03-02 12:30:00 | SPY | ETF | 138.375 | 138.5 | 137.6875 | 137.7812 | 995500.0 |
| 2000-03-02 13:00:00 | SPY | ETF | 137.875 | 138.0 | 137.3438 | 138.0 | 722500.0 |
| 2000-03-02 13:30:00 | SPY | ETF | 138.0 | 138.125 | 137.6562 | 137.875 | 92700.0 |
| 2000-03-02 14:00:00 | SPY | ETF | 137.8125 | 138.5938 | 137.75 | 138.5938 | 392900.0 |
| 2000-03-02 14:30:00 | SPY | ETF | 138.625 | 138.9688 | 138.4062 | 138.4688 | 321300.0 |
| 2000-03-02 15:00:00 | SPY | ETF | 138.5625 | 139.125 | 138.375 | 138.9375 | 1023800.0 |
| 2000-03-02 15:30:00 | SPY | ETF | 139.0 | 139.0625 | 138.5 | 138.7188 | 500100.0 |
| 2000-03-02 16:00:00 | SPY | ETF | 138.5312 | 138.7812 | 138.5 | 138.5312 | 198200.0 |
| 2000-03-02 09:30:00 | QQQ | ETF | 108.0625 | 108.125 | 106.5625 | 106.875 | 4215400.0 |
| 2000-03-02 10:00:00 | QQQ | ETF | 106.875 | 107.75 | 106.75 | 107.375 | 2876200.0 |
| 2000-03-02 10:30:00 | QQQ | ETF | 107.375 | 108.1875 | 107.0625 | 107.9062 | 1915600.0 |
| 2000-03-02 11:00:00 | QQQ | ETF | 108.0 | 108.1875 | 107.625 | 108.1875 | 1434200.0 |
| 2000-03-02 11:30:00 | QQQ | ETF | 108.125 | 108.1562 | 107.0312 | 107.3125 | 2763400.0 |
| 2000-03-02 12:00:00 | QQQ | ETF | 107.3125 | 107.375 | 106.625 | 106.75 | 1605200.0 |
| 2000-03-02 12:30:00 | QQQ | ETF | 106.625 | 107.1875 | 105.375 | 105.375 | 3333000.0 |
| 2000-03-02 13:00:00 | QQQ | ETF | 105.375 | 105.875 | 104.75 | 105.5625 | 2241600.0 |
| 2000-03-02 13:30:00 | QQQ | ETF | 105.5938 | 106.1094 | 105.3125 | 105.75 | 1933000.0 |
| 2000-03-02 14:00:00 | QQQ | ETF | 105.6875 | 106.8594 | 105.5 | 106.6875 | 2593800.0 |
| 2000-03-02 14:30:00 | QQQ | ETF | 106.625 | 107.1562 | 106.25 | 106.2812 | 1426000.0 |
| 2000-03-02 15:00:00 | QQQ | ETF | 106.2812 | 106.9844 | 105.8125 | 106.5 | 2476200.0 |
| 2000-03-02 15:30:00 | QQQ | ETF | 106.5 | 106.7188 | 105.6875 | 105.875 | 2410600.0 |
| 2000-03-02 16:00:00 | QQQ | ETF | 105.875 | 105.875 | 105.0625 | 105.125 | 1330800.0 |
| 2000-03-02 09:30:00 | DIA | ETF | 101.4688 | 101.9688 | 101.375 | 101.5 | 102200.0 |
| 2000-03-02 10:00:00 | DIA | ETF | 101.5 | 102.1562 | 101.5 | 101.9688 | 35300.0 |
| 2000-03-02 10:30:00 | DIA | ETF | 101.9062 | 102.1562 | 101.75 | 101.875 | 34300.0 |
| 2000-03-02 11:00:00 | DIA | ETF | 101.875 | 102.125 | 101.75 | 102.125 | 9100.0 |
| 2000-03-02 11:30:00 | DIA | ETF | 101.9375 | 102.0938 | 101.5312 | 101.6875 | 17700.0 |
| 2000-03-02 12:00:00 | DIA | ETF | 101.6875 | 101.875 | 101.5 | 101.6875 | 44600.0 |
| 2000-03-02 12:30:00 | DIA | ETF | 101.625 | 101.75 | 101.125 | 101.2188 | 39500.0 |
| 2000-03-02 13:00:00 | DIA | ETF | 101.125 | 101.5312 | 101.0 | 101.375 | 94800.0 |
| 2000-03-02 13:30:00 | DIA | ETF | 101.5938 | 101.625 | 101.25 | 101.4688 | 30200.0 |
| 2000-03-02 14:00:00 | DIA | ETF | 101.3125 | 101.7812 | 101.25 | 101.7188 | 44500.0 |
| 2000-03-02 14:30:00 | DIA | ETF | 101.7812 | 101.8438 | 101.5 | 101.5312 | 16000.0 |
| 2000-03-02 15:00:00 | DIA | ETF | 101.7188 | 102.25 | 101.5 | 102.0 | 58800.0 |
| 2000-03-02 15:30:00 | DIA | ETF | 102.0625 | 102.0938 | 101.625 | 101.7812 | 41400.0 |
| 2000-03-02 16:00:00 | DIA | ETF | 101.7812 | 101.7812 | 101.6562 | 101.6875 | 6600.0 |
> showing 42 of 217 rows — these rows as CSV