PREVIEW / etf_30min / 2000-02-09
file: by_date/etf_30min/2000/2000-02-09.parquet size: 10 KB rows: 229
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-09 09:30:00 | SPY | ETF | 144.4688 | 144.4688 | 143.4375 | 143.6875 | 538900.0 |
| 2000-02-09 10:00:00 | SPY | ETF | 143.7188 | 144.2812 | 143.4375 | 144.0625 | 251600.0 |
| 2000-02-09 10:30:00 | SPY | ETF | 144.0625 | 144.2812 | 143.9062 | 143.9375 | 358000.0 |
| 2000-02-09 11:00:00 | SPY | ETF | 144.125 | 144.2812 | 143.4375 | 143.6875 | 310900.0 |
| 2000-02-09 11:30:00 | SPY | ETF | 143.625 | 143.75 | 142.7812 | 142.8438 | 1081400.0 |
| 2000-02-09 12:00:00 | SPY | ETF | 142.8125 | 143.0 | 142.4062 | 142.875 | 680600.0 |
| 2000-02-09 12:30:00 | SPY | ETF | 142.9375 | 143.0312 | 142.5312 | 142.5312 | 529600.0 |
| 2000-02-09 13:00:00 | SPY | ETF | 142.625 | 143.125 | 142.3438 | 142.5312 | 304800.0 |
| 2000-02-09 13:30:00 | SPY | ETF | 142.6562 | 142.9062 | 142.1875 | 142.3125 | 448800.0 |
| 2000-02-09 14:00:00 | SPY | ETF | 142.4062 | 142.9062 | 142.2812 | 142.7812 | 244700.0 |
| 2000-02-09 14:30:00 | SPY | ETF | 142.875 | 143.125 | 142.375 | 142.875 | 952700.0 |
| 2000-02-09 15:00:00 | SPY | ETF | 142.8125 | 142.875 | 141.875 | 142.0625 | 1105100.0 |
| 2000-02-09 15:30:00 | SPY | ETF | 142.0 | 142.2188 | 141.375 | 141.4062 | 952100.0 |
| 2000-02-09 16:00:00 | SPY | ETF | 141.4375 | 141.5625 | 141.25 | 141.2812 | 561700.0 |
| 2000-02-09 09:30:00 | QQQ | ETF | 102.0625 | 102.0625 | 101.0156 | 101.4062 | 4151200.0 |
| 2000-02-09 10:00:00 | QQQ | ETF | 101.3438 | 102.1875 | 101.125 | 101.9531 | 2710600.0 |
| 2000-02-09 10:30:00 | QQQ | ETF | 101.875 | 102.0938 | 101.6406 | 101.9688 | 1047800.0 |
| 2000-02-09 11:00:00 | QQQ | ETF | 101.9688 | 102.1875 | 101.2812 | 101.5 | 1247400.0 |
| 2000-02-09 11:30:00 | QQQ | ETF | 101.5469 | 101.5625 | 100.3438 | 100.5 | 2586200.0 |
| 2000-02-09 12:00:00 | QQQ | ETF | 100.4688 | 100.5312 | 99.5 | 100.0625 | 2689400.0 |
| 2000-02-09 12:30:00 | QQQ | ETF | 100.0938 | 100.375 | 99.6875 | 100.0 | 1682400.0 |
| 2000-02-09 13:00:00 | QQQ | ETF | 99.9375 | 100.6875 | 99.875 | 100.0625 | 722400.0 |
| 2000-02-09 13:30:00 | QQQ | ETF | 100.0156 | 100.4375 | 99.75 | 99.75 | 1182600.0 |
| 2000-02-09 14:00:00 | QQQ | ETF | 99.75 | 100.6719 | 99.6875 | 100.5156 | 1191800.0 |
| 2000-02-09 14:30:00 | QQQ | ETF | 100.5 | 100.75 | 100.0 | 100.6875 | 2171800.0 |
| 2000-02-09 15:00:00 | QQQ | ETF | 100.625 | 100.7188 | 99.5 | 99.6719 | 1760000.0 |
| 2000-02-09 15:30:00 | QQQ | ETF | 99.875 | 100.1875 | 99.375 | 99.375 | 2422400.0 |
| 2000-02-09 16:00:00 | QQQ | ETF | 99.375 | 99.5 | 98.75 | 98.9375 | 1453200.0 |
| 2000-02-09 16:30:00 | QQQ | ETF | 99.0 | 99.0 | 98.875 | 99.0 | 7200.0 |
| 2000-02-09 18:00:00 | QQQ | ETF | 99.0 | 99.0 | 99.0 | 99.0 | 200.0 |
| 2000-02-09 09:30:00 | DIA | ETF | 109.1875 | 109.375 | 108.5 | 108.875 | 97700.0 |
| 2000-02-09 10:00:00 | DIA | ETF | 108.75 | 109.2812 | 108.5938 | 109.125 | 54600.0 |
| 2000-02-09 10:30:00 | DIA | ETF | 109.0625 | 109.2188 | 109.0 | 109.2188 | 17000.0 |
| 2000-02-09 11:00:00 | DIA | ETF | 109.0312 | 109.25 | 108.625 | 108.7812 | 40000.0 |
| 2000-02-09 11:30:00 | DIA | ETF | 108.8125 | 108.8125 | 108.25 | 108.2812 | 22700.0 |
| 2000-02-09 12:00:00 | DIA | ETF | 108.25 | 108.4688 | 108.0312 | 108.4688 | 78400.0 |
| 2000-02-09 12:30:00 | DIA | ETF | 108.4375 | 108.5 | 108.1875 | 108.2188 | 34300.0 |
| 2000-02-09 13:00:00 | DIA | ETF | 108.1875 | 108.5312 | 108.125 | 108.1875 | 17400.0 |
| 2000-02-09 13:30:00 | DIA | ETF | 108.3125 | 108.3438 | 107.75 | 107.875 | 228200.0 |
| 2000-02-09 14:00:00 | DIA | ETF | 107.875 | 108.375 | 107.8125 | 108.1562 | 44500.0 |
| 2000-02-09 14:30:00 | DIA | ETF | 108.375 | 108.5 | 107.9375 | 108.2188 | 16000.0 |
| 2000-02-09 15:00:00 | DIA | ETF | 108.25 | 108.25 | 107.5 | 107.8438 | 30300.0 |
| 2000-02-09 15:30:00 | DIA | ETF | 107.6875 | 107.7188 | 107.0625 | 107.0625 | 84600.0 |
| 2000-02-09 16:00:00 | DIA | ETF | 107.1875 | 107.1875 | 106.7812 | 106.9062 | 51800.0 |
> showing 44 of 229 rows — these rows as CSV