PREVIEW / etf_30min / 2000-02-11
file: by_date/etf_30min/2000/2000-02-11.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-02-11 09:30:00 | SPY | ETF | 141.8438 | 141.9375 | 140.9375 | 141.2188 | 844900.0 |
| 2000-02-11 10:00:00 | SPY | ETF | 141.3125 | 141.4688 | 140.25 | 140.625 | 1353800.0 |
| 2000-02-11 10:30:00 | SPY | ETF | 140.625 | 140.9375 | 140.4375 | 140.625 | 198100.0 |
| 2000-02-11 11:00:00 | SPY | ETF | 140.7188 | 140.8438 | 140.3125 | 140.75 | 561400.0 |
| 2000-02-11 11:30:00 | SPY | ETF | 140.8125 | 141.4375 | 140.8125 | 140.9062 | 127800.0 |
| 2000-02-11 12:00:00 | SPY | ETF | 140.9688 | 141.1562 | 140.5 | 140.9062 | 101600.0 |
| 2000-02-11 12:30:00 | SPY | ETF | 140.9375 | 141.0938 | 140.625 | 140.7188 | 365100.0 |
| 2000-02-11 13:00:00 | SPY | ETF | 140.75 | 140.7812 | 140.25 | 140.6875 | 61100.0 |
| 2000-02-11 13:30:00 | SPY | ETF | 140.5312 | 140.8438 | 140.25 | 140.4375 | 165300.0 |
| 2000-02-11 14:00:00 | SPY | ETF | 140.25 | 140.3125 | 139.5 | 139.75 | 1031500.0 |
| 2000-02-11 14:30:00 | SPY | ETF | 139.625 | 140.0 | 139.0625 | 139.4062 | 948100.0 |
| 2000-02-11 15:00:00 | SPY | ETF | 139.4375 | 139.5 | 138.0312 | 138.5625 | 1110900.0 |
| 2000-02-11 15:30:00 | SPY | ETF | 138.5625 | 139.5 | 138.1875 | 139.1875 | 1202900.0 |
| 2000-02-11 16:00:00 | SPY | ETF | 139.125 | 139.5 | 139.0 | 139.1875 | 1517000.0 |
| 2000-02-11 17:00:00 | SPY | ETF | 139.1875 | 139.1875 | 138.6875 | 138.6875 | 800.0 |
| 2000-02-11 17:30:00 | SPY | ETF | 138.6875 | 138.6875 | 138.6875 | 138.6875 | 200.0 |
| 2000-02-11 09:30:00 | QQQ | ETF | 102.0625 | 102.0625 | 101.1562 | 101.3125 | 1942200.0 |
| 2000-02-11 10:00:00 | QQQ | ETF | 101.25 | 101.625 | 100.0625 | 100.5 | 1963600.0 |
| 2000-02-11 10:30:00 | QQQ | ETF | 100.5 | 100.875 | 100.3125 | 100.5625 | 1708800.0 |
| 2000-02-11 11:00:00 | QQQ | ETF | 100.7188 | 100.7344 | 99.6875 | 100.375 | 2440800.0 |
| 2000-02-11 11:30:00 | QQQ | ETF | 100.3125 | 101.1562 | 100.2188 | 100.625 | 1585600.0 |
| 2000-02-11 12:00:00 | QQQ | ETF | 100.75 | 101.0 | 100.4062 | 101.0 | 882600.0 |
| 2000-02-11 12:30:00 | QQQ | ETF | 101.0 | 101.125 | 100.8125 | 100.8125 | 966400.0 |
| 2000-02-11 13:00:00 | QQQ | ETF | 100.9375 | 101.0625 | 100.4688 | 100.75 | 946000.0 |
| 2000-02-11 13:30:00 | QQQ | ETF | 100.8125 | 100.9062 | 100.25 | 100.4375 | 992600.0 |
| 2000-02-11 14:00:00 | QQQ | ETF | 100.4062 | 100.4375 | 99.5156 | 99.8125 | 1654000.0 |
| 2000-02-11 14:30:00 | QQQ | ETF | 99.8125 | 100.0938 | 99.375 | 99.7188 | 1802200.0 |
| 2000-02-11 15:00:00 | QQQ | ETF | 99.7344 | 99.75 | 98.0 | 98.6875 | 3626000.0 |
| 2000-02-11 15:30:00 | QQQ | ETF | 98.625 | 99.8906 | 98.625 | 99.2188 | 2854200.0 |
| 2000-02-11 16:00:00 | QQQ | ETF | 99.3438 | 99.4375 | 98.875 | 99.0625 | 1302600.0 |
| 2000-02-11 16:30:00 | QQQ | ETF | 99.1875 | 99.1875 | 99.0 | 99.1875 | 4600.0 |
| 2000-02-11 17:00:00 | QQQ | ETF | 99.0 | 99.1875 | 99.0 | 99.1875 | 600.0 |
| 2000-02-11 18:00:00 | QQQ | ETF | 99.875 | 99.875 | 99.875 | 99.875 | 200.0 |
| 2000-02-11 09:30:00 | DIA | ETF | 106.5625 | 106.5625 | 106.125 | 106.3125 | 469200.0 |
| 2000-02-11 10:00:00 | DIA | ETF | 106.1875 | 106.4375 | 105.75 | 105.8125 | 152800.0 |
| 2000-02-11 10:30:00 | DIA | ETF | 105.9375 | 106.125 | 105.6562 | 106.0 | 87200.0 |
| 2000-02-11 11:00:00 | DIA | ETF | 106.0312 | 106.125 | 105.625 | 105.9688 | 166700.0 |
| 2000-02-11 11:30:00 | DIA | ETF | 105.9688 | 106.375 | 105.9375 | 105.9375 | 100100.0 |
| 2000-02-11 12:00:00 | DIA | ETF | 106.0938 | 106.125 | 105.75 | 106.125 | 30900.0 |
| 2000-02-11 12:30:00 | DIA | ETF | 106.1562 | 106.1562 | 105.875 | 105.9375 | 13700.0 |
| 2000-02-11 13:00:00 | DIA | ETF | 105.875 | 105.9375 | 105.5938 | 105.8438 | 67300.0 |
| 2000-02-11 13:30:00 | DIA | ETF | 105.75 | 105.8438 | 105.375 | 105.5 | 44400.0 |
| 2000-02-11 14:00:00 | DIA | ETF | 105.7188 | 105.7188 | 104.7812 | 105.0 | 172800.0 |
| 2000-02-11 14:30:00 | DIA | ETF | 104.9688 | 105.1562 | 104.375 | 104.7812 | 185200.0 |
| 2000-02-11 15:00:00 | DIA | ETF | 104.6562 | 104.8125 | 103.625 | 104.125 | 372800.0 |
| 2000-02-11 15:30:00 | DIA | ETF | 104.125 | 104.7188 | 103.75 | 104.375 | 234000.0 |
| 2000-02-11 16:00:00 | DIA | ETF | 104.375 | 104.5938 | 104.25 | 104.5 | 43900.0 |
> showing 47 of 217 rows — these rows as CSV