PREVIEW / etf_30min / 2000-02-10
file: by_date/etf_30min/2000/2000-02-10.parquet size: 10 KB rows: 224
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-02-10 09:30:00 | SPY | ETF | 141.625 | 142.0 | 141.0312 | 141.2812 | 1061800.0 |
| 2000-02-10 10:00:00 | SPY | ETF | 141.2812 | 142.1875 | 141.1875 | 141.8438 | 663600.0 |
| 2000-02-10 10:30:00 | SPY | ETF | 141.9375 | 141.9375 | 141.0625 | 141.125 | 500900.0 |
| 2000-02-10 11:00:00 | SPY | ETF | 141.125 | 141.9062 | 141.0 | 141.8125 | 350300.0 |
| 2000-02-10 11:30:00 | SPY | ETF | 141.8125 | 142.1562 | 141.5938 | 141.8125 | 517400.0 |
| 2000-02-10 12:00:00 | SPY | ETF | 141.75 | 142.375 | 141.6562 | 142.1875 | 273200.0 |
| 2000-02-10 12:30:00 | SPY | ETF | 142.0312 | 142.5625 | 142.0312 | 142.2812 | 113800.0 |
| 2000-02-10 13:00:00 | SPY | ETF | 142.1875 | 142.375 | 142.0 | 142.1875 | 232700.0 |
| 2000-02-10 13:30:00 | SPY | ETF | 142.0 | 142.0 | 141.375 | 141.9062 | 663900.0 |
| 2000-02-10 14:00:00 | SPY | ETF | 141.8125 | 142.0 | 141.375 | 141.5 | 205200.0 |
| 2000-02-10 14:30:00 | SPY | ETF | 141.5 | 141.625 | 140.875 | 141.3125 | 828500.0 |
| 2000-02-10 15:00:00 | SPY | ETF | 141.25 | 141.375 | 140.875 | 141.125 | 446200.0 |
| 2000-02-10 15:30:00 | SPY | ETF | 141.125 | 142.0 | 141.125 | 141.875 | 540200.0 |
| 2000-02-10 16:00:00 | SPY | ETF | 141.875 | 141.9062 | 141.375 | 141.5625 | 215700.0 |
| 2000-02-10 09:30:00 | QQQ | ETF | 99.8125 | 99.8125 | 98.5469 | 99.0938 | 4041400.0 |
| 2000-02-10 10:00:00 | QQQ | ETF | 98.9062 | 100.2188 | 98.875 | 100.0625 | 2979600.0 |
| 2000-02-10 10:30:00 | QQQ | ETF | 100.0625 | 100.0625 | 99.2812 | 99.375 | 1216800.0 |
| 2000-02-10 11:00:00 | QQQ | ETF | 99.375 | 100.125 | 99.25 | 100.125 | 1593200.0 |
| 2000-02-10 11:30:00 | QQQ | ETF | 100.0938 | 100.625 | 100.0156 | 100.4062 | 1317400.0 |
| 2000-02-10 12:00:00 | QQQ | ETF | 100.4375 | 101.25 | 100.375 | 101.1875 | 1263600.0 |
| 2000-02-10 12:30:00 | QQQ | ETF | 101.0312 | 101.6875 | 101.0312 | 101.375 | 1876400.0 |
| 2000-02-10 13:00:00 | QQQ | ETF | 101.375 | 101.4375 | 100.9375 | 101.0312 | 827000.0 |
| 2000-02-10 13:30:00 | QQQ | ETF | 101.0625 | 101.125 | 100.5 | 101.0625 | 2223600.0 |
| 2000-02-10 14:00:00 | QQQ | ETF | 101.0938 | 101.25 | 100.5625 | 100.7812 | 1233200.0 |
| 2000-02-10 14:30:00 | QQQ | ETF | 100.8125 | 101.0 | 100.0 | 100.5 | 2654800.0 |
| 2000-02-10 15:00:00 | QQQ | ETF | 100.5 | 100.8438 | 100.1562 | 100.75 | 1594600.0 |
| 2000-02-10 15:30:00 | QQQ | ETF | 100.625 | 102.1562 | 100.625 | 102.0312 | 2823400.0 |
| 2000-02-10 16:00:00 | QQQ | ETF | 102.125 | 102.25 | 101.875 | 102.0625 | 477400.0 |
| 2000-02-10 16:30:00 | QQQ | ETF | 102.0312 | 102.1875 | 102.0312 | 102.1875 | 1400.0 |
| 2000-02-10 17:30:00 | QQQ | ETF | 102.25 | 102.25 | 102.25 | 102.25 | 200.0 |
| 2000-02-10 18:00:00 | QQQ | ETF | 102.25 | 102.25 | 102.25 | 102.25 | 1000.0 |
| 2000-02-10 09:30:00 | DIA | ETF | 107.25 | 107.375 | 106.5 | 107.0 | 99000.0 |
| 2000-02-10 10:00:00 | DIA | ETF | 107.0 | 107.3438 | 106.75 | 107.125 | 129700.0 |
| 2000-02-10 10:30:00 | DIA | ETF | 107.25 | 107.25 | 106.5625 | 106.75 | 59900.0 |
| 2000-02-10 11:00:00 | DIA | ETF | 106.8438 | 107.2188 | 106.5938 | 106.8125 | 97600.0 |
| 2000-02-10 11:30:00 | DIA | ETF | 107.0938 | 107.25 | 106.8438 | 107.0625 | 25400.0 |
| 2000-02-10 12:00:00 | DIA | ETF | 107.0312 | 107.375 | 106.875 | 107.1562 | 72700.0 |
| 2000-02-10 12:30:00 | DIA | ETF | 107.0938 | 107.5938 | 107.0938 | 107.2812 | 37300.0 |
| 2000-02-10 13:00:00 | DIA | ETF | 107.2812 | 107.2812 | 106.9062 | 107.0312 | 26400.0 |
| 2000-02-10 13:30:00 | DIA | ETF | 106.875 | 106.9375 | 106.375 | 106.6562 | 125800.0 |
| 2000-02-10 14:00:00 | DIA | ETF | 106.875 | 106.9375 | 106.5625 | 106.6875 | 104200.0 |
| 2000-02-10 14:30:00 | DIA | ETF | 106.8438 | 106.9062 | 106.2812 | 106.5312 | 52700.0 |
| 2000-02-10 15:00:00 | DIA | ETF | 106.5 | 106.5625 | 106.0312 | 106.1562 | 165000.0 |
| 2000-02-10 15:30:00 | DIA | ETF | 106.25 | 106.6562 | 106.0938 | 106.625 | 99300.0 |
| 2000-02-10 16:00:00 | DIA | ETF | 106.5938 | 106.5938 | 106.125 | 106.1875 | 49300.0 |
| 2000-02-10 16:30:00 | DIA | ETF | 107.0 | 107.0 | 107.0 | 107.0 | 200.0 |
> showing 46 of 224 rows — these rows as CSV