PREVIEW / etf_30min / 2000-05-19
file: by_date/etf_30min/2000/2000-05-19.parquet size: 9 KB rows: 206
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-05-19 09:30:00 | SPY | ETF | 142.5625 | 143.2188 | 142.1562 | 142.25 | 824800.0 |
| 2000-05-19 10:00:00 | SPY | ETF | 142.375 | 142.4062 | 141.2812 | 141.5 | 659900.0 |
| 2000-05-19 10:30:00 | SPY | ETF | 141.625 | 141.9062 | 141.375 | 141.6875 | 323500.0 |
| 2000-05-19 11:00:00 | SPY | ETF | 141.5938 | 141.9375 | 141.0625 | 141.6875 | 477700.0 |
| 2000-05-19 11:30:00 | SPY | ETF | 141.6875 | 142.0938 | 141.375 | 141.5 | 328900.0 |
| 2000-05-19 12:00:00 | SPY | ETF | 141.5625 | 141.5938 | 141.25 | 141.25 | 219100.0 |
| 2000-05-19 12:30:00 | SPY | ETF | 141.25 | 141.7188 | 141.1562 | 141.1562 | 291900.0 |
| 2000-05-19 13:00:00 | SPY | ETF | 141.375 | 141.5625 | 141.0 | 141.0 | 257700.0 |
| 2000-05-19 13:30:00 | SPY | ETF | 141.0 | 141.0312 | 140.5 | 141.0 | 233300.0 |
| 2000-05-19 14:00:00 | SPY | ETF | 141.0938 | 141.1562 | 140.4062 | 140.75 | 556500.0 |
| 2000-05-19 14:30:00 | SPY | ETF | 140.75 | 141.75 | 140.75 | 141.625 | 443300.0 |
| 2000-05-19 15:00:00 | SPY | ETF | 141.5 | 141.625 | 140.875 | 141.2812 | 395700.0 |
| 2000-05-19 15:30:00 | SPY | ETF | 141.2812 | 141.875 | 140.6875 | 140.875 | 687800.0 |
| 2000-05-19 16:00:00 | SPY | ETF | 140.8438 | 141.3125 | 140.8125 | 141.125 | 796600.0 |
| 2000-05-19 09:30:00 | QQQ | ETF | 83.75 | 85.0 | 83.25 | 83.625 | 3469600.0 |
| 2000-05-19 10:00:00 | QQQ | ETF | 83.625 | 83.75 | 82.6875 | 83.0625 | 2902600.0 |
| 2000-05-19 10:30:00 | QQQ | ETF | 82.9375 | 83.3438 | 82.5625 | 82.5625 | 1858600.0 |
| 2000-05-19 11:00:00 | QQQ | ETF | 82.625 | 83.0312 | 82.0312 | 82.75 | 2524400.0 |
| 2000-05-19 11:30:00 | QQQ | ETF | 82.6875 | 83.2812 | 82.5625 | 82.75 | 1141300.0 |
| 2000-05-19 12:00:00 | QQQ | ETF | 82.8125 | 82.8125 | 82.25 | 82.375 | 804500.0 |
| 2000-05-19 12:30:00 | QQQ | ETF | 82.25 | 82.7188 | 82.1875 | 82.3125 | 1026500.0 |
| 2000-05-19 13:00:00 | QQQ | ETF | 82.375 | 82.5625 | 81.75 | 81.75 | 1523900.0 |
| 2000-05-19 13:30:00 | QQQ | ETF | 81.75 | 82.0 | 81.375 | 81.9375 | 2414200.0 |
| 2000-05-19 14:00:00 | QQQ | ETF | 82.0 | 82.25 | 81.5 | 82.0 | 1401600.0 |
| 2000-05-19 14:30:00 | QQQ | ETF | 82.0 | 83.25 | 81.8125 | 83.0 | 3186700.0 |
| 2000-05-19 15:00:00 | QQQ | ETF | 82.9375 | 83.0 | 82.0 | 82.375 | 1734200.0 |
| 2000-05-19 15:30:00 | QQQ | ETF | 82.25 | 82.875 | 81.3125 | 81.5938 | 2824400.0 |
| 2000-05-19 16:00:00 | QQQ | ETF | 81.375 | 81.9375 | 81.3125 | 81.5 | 1278100.0 |
| 2000-05-19 16:30:00 | QQQ | ETF | 81.5625 | 81.75 | 81.5 | 81.6875 | 25700.0 |
| 2000-05-19 09:30:00 | DIA | ETF | 106.5625 | 107.0312 | 106.5 | 106.6875 | 227200.0 |
| 2000-05-19 10:00:00 | DIA | ETF | 106.5625 | 106.7188 | 106.0312 | 106.375 | 188200.0 |
| 2000-05-19 10:30:00 | DIA | ETF | 106.2812 | 106.5 | 106.125 | 106.375 | 62900.0 |
| 2000-05-19 11:00:00 | DIA | ETF | 106.375 | 106.6562 | 106.125 | 106.375 | 110000.0 |
| 2000-05-19 11:30:00 | DIA | ETF | 106.375 | 106.8125 | 106.375 | 106.4375 | 56000.0 |
| 2000-05-19 12:00:00 | DIA | ETF | 106.3125 | 106.375 | 106.125 | 106.2812 | 31300.0 |
| 2000-05-19 12:30:00 | DIA | ETF | 106.3125 | 106.5312 | 106.0938 | 106.0938 | 96200.0 |
| 2000-05-19 13:00:00 | DIA | ETF | 106.0938 | 106.4062 | 105.9375 | 105.9375 | 112000.0 |
| 2000-05-19 13:30:00 | DIA | ETF | 105.9375 | 106.1562 | 105.625 | 106.1562 | 79800.0 |
| 2000-05-19 14:00:00 | DIA | ETF | 106.1562 | 106.25 | 105.5 | 105.7188 | 48600.0 |
| 2000-05-19 14:30:00 | DIA | ETF | 105.9375 | 106.1875 | 105.7188 | 106.1875 | 51100.0 |
| 2000-05-19 15:00:00 | DIA | ETF | 106.2188 | 106.3125 | 105.7812 | 106.0312 | 117900.0 |
| 2000-05-19 15:30:00 | DIA | ETF | 106.125 | 106.5 | 105.75 | 105.9375 | 89600.0 |
| 2000-05-19 16:00:00 | DIA | ETF | 106.1562 | 106.625 | 105.9375 | 106.5625 | 98400.0 |
> showing 43 of 206 rows — these rows as CSV