PREVIEW / etf_1hour / 2000-04-14
file: by_date/etf_1hour/2000/2000-04-14.parquet size: 9 KB rows: 137
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-04-14 09:00:00 | SPY | ETF | 142.625 | 142.7188 | 140.4375 | 142.625 | 2715500.0 |
| 2000-04-14 10:00:00 | SPY | ETF | 142.375 | 142.8125 | 140.5625 | 142.0625 | 2077300.0 |
| 2000-04-14 11:00:00 | SPY | ETF | 141.8125 | 141.9375 | 138.7812 | 139.0 | 1937800.0 |
| 2000-04-14 12:00:00 | SPY | ETF | 138.9375 | 140.3438 | 138.25 | 139.4062 | 3104500.0 |
| 2000-04-14 13:00:00 | SPY | ETF | 139.3125 | 140.8125 | 138.375 | 139.25 | 3135700.0 |
| 2000-04-14 14:00:00 | SPY | ETF | 139.2188 | 139.5 | 136.25 | 137.2188 | 2542400.0 |
| 2000-04-14 15:00:00 | SPY | ETF | 137.25 | 137.625 | 133.625 | 135.8125 | 3978600.0 |
| 2000-04-14 16:00:00 | SPY | ETF | 135.25 | 136.2812 | 135.25 | 135.5625 | 659200.0 |
| 2000-04-14 17:00:00 | SPY | ETF | 138.3438 | 138.375 | 136.0 | 136.0 | 2675200.0 |
| 2000-04-14 09:00:00 | QQQ | ETF | 86.0625 | 88.5 | 84.0 | 87.8125 | 10028700.0 |
| 2000-04-14 10:00:00 | QQQ | ETF | 87.875 | 88.0625 | 85.125 | 86.5 | 7121200.0 |
| 2000-04-14 11:00:00 | QQQ | ETF | 86.5 | 86.5 | 82.125 | 82.25 | 9190800.0 |
| 2000-04-14 12:00:00 | QQQ | ETF | 82.125 | 85.25 | 81.0 | 83.75 | 6421500.0 |
| 2000-04-14 13:00:00 | QQQ | ETF | 83.6875 | 86.75 | 83.125 | 84.5 | 6525400.0 |
| 2000-04-14 14:00:00 | QQQ | ETF | 84.5 | 84.7812 | 81.5 | 82.1875 | 7416800.0 |
| 2000-04-14 15:00:00 | QQQ | ETF | 82.0 | 82.5625 | 78.0 | 80.25 | 11250200.0 |
| 2000-04-14 16:00:00 | QQQ | ETF | 80.25 | 81.0 | 79.5 | 79.6875 | 1309000.0 |
| 2000-04-14 17:00:00 | QQQ | ETF | 79.6875 | 80.0625 | 79.6875 | 79.6875 | 10600.0 |
| 2000-04-14 18:00:00 | QQQ | ETF | 79.75 | 80.375 | 79.75 | 80.375 | 2600.0 |
| 2000-04-14 09:00:00 | DIA | ETF | 107.4375 | 108.1875 | 106.3125 | 108.1562 | 490300.0 |
| 2000-04-14 10:00:00 | DIA | ETF | 108.0 | 108.25 | 106.6875 | 107.6562 | 364600.0 |
| 2000-04-14 11:00:00 | DIA | ETF | 107.6562 | 107.6562 | 105.6562 | 105.6562 | 866800.0 |
| 2000-04-14 12:00:00 | DIA | ETF | 105.5625 | 106.625 | 105.2812 | 106.0625 | 314700.0 |
| 2000-04-14 13:00:00 | DIA | ETF | 106.0 | 106.8438 | 105.0312 | 105.75 | 449300.0 |
| 2000-04-14 14:00:00 | DIA | ETF | 105.7812 | 105.7812 | 103.6875 | 104.25 | 558600.0 |
| 2000-04-14 15:00:00 | DIA | ETF | 103.9375 | 104.625 | 101.5 | 103.1875 | 1380500.0 |
| 2000-04-14 16:00:00 | DIA | ETF | 103.0312 | 103.375 | 102.5 | 102.5 | 78100.0 |
> showing 27 of 137 rows — these rows as CSV