PREVIEW / etf_1hour / 2000-10-27
file: by_date/etf_1hour/2000/2000-10-27.parquet size: 10 KB rows: 179
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-10-27 09:00:00 | SPY | ETF | 137.875 | 138.3438 | 136.875 | 137.25 | 1758000.0 |
| 2000-10-27 10:00:00 | SPY | ETF | 137.1875 | 138.0 | 136.7812 | 137.0312 | 783500.0 |
| 2000-10-27 11:00:00 | SPY | ETF | 136.8438 | 138.5 | 136.625 | 138.4375 | 932300.0 |
| 2000-10-27 12:00:00 | SPY | ETF | 138.375 | 138.4375 | 137.5312 | 137.9375 | 592800.0 |
| 2000-10-27 13:00:00 | SPY | ETF | 137.7812 | 138.75 | 137.6875 | 138.625 | 913300.0 |
| 2000-10-27 14:00:00 | SPY | ETF | 138.625 | 138.8438 | 137.5312 | 138.0938 | 1367700.0 |
| 2000-10-27 15:00:00 | SPY | ETF | 138.0938 | 138.5938 | 137.5 | 138.375 | 1524000.0 |
| 2000-10-27 16:00:00 | SPY | ETF | 138.4375 | 139.2812 | 138.4375 | 139.2812 | 1048600.0 |
| 2000-10-27 09:00:00 | QQQ | ETF | 80.8438 | 81.8438 | 80.1875 | 80.3125 | 7272700.0 |
| 2000-10-27 10:00:00 | QQQ | ETF | 80.4375 | 81.0 | 77.75 | 78.0 | 9523500.0 |
| 2000-10-27 11:00:00 | QQQ | ETF | 77.875 | 80.625 | 77.4688 | 80.1875 | 9024500.0 |
| 2000-10-27 12:00:00 | QQQ | ETF | 80.25 | 80.3125 | 78.5 | 79.375 | 4843400.0 |
| 2000-10-27 13:00:00 | QQQ | ETF | 79.4375 | 81.2812 | 79.25 | 80.8438 | 5212400.0 |
| 2000-10-27 14:00:00 | QQQ | ETF | 80.875 | 81.0 | 78.625 | 79.4062 | 6751200.0 |
| 2000-10-27 15:00:00 | QQQ | ETF | 79.375 | 80.125 | 78.25 | 79.125 | 6132200.0 |
| 2000-10-27 16:00:00 | QQQ | ETF | 79.125 | 80.75 | 79.0312 | 79.625 | 500100.0 |
| 2000-10-27 17:00:00 | QQQ | ETF | 79.75 | 79.75 | 79.3125 | 79.5 | 2200.0 |
| 2000-10-27 18:00:00 | QQQ | ETF | 79.25 | 79.5 | 79.25 | 79.5 | 2000.0 |
| 2000-10-27 09:00:00 | IWM | ETF | 47.625 | 48.1562 | 47.625 | 47.9688 | 24800.0 |
| 2000-10-27 10:00:00 | IWM | ETF | 48.2344 | 48.25 | 47.875 | 47.875 | 60600.0 |
| 2000-10-27 11:00:00 | IWM | ETF | 47.7812 | 48.0312 | 47.7656 | 48.0312 | 26000.0 |
| 2000-10-27 12:00:00 | IWM | ETF | 48.1094 | 48.1562 | 48.0938 | 48.1562 | 9000.0 |
| 2000-10-27 14:00:00 | IWM | ETF | 48.25 | 48.25 | 48.0625 | 48.0938 | 6400.0 |
| 2000-10-27 15:00:00 | IWM | ETF | 48.1562 | 48.1562 | 48.0312 | 48.0312 | 11600.0 |
| 2000-10-27 09:00:00 | DIA | ETF | 104.3125 | 104.4375 | 103.875 | 103.875 | 177400.0 |
| 2000-10-27 10:00:00 | DIA | ETF | 103.875 | 104.5625 | 103.75 | 104.125 | 162400.0 |
| 2000-10-27 11:00:00 | DIA | ETF | 104.2188 | 105.4375 | 104.0312 | 105.4375 | 434200.0 |
| 2000-10-27 12:00:00 | DIA | ETF | 105.3125 | 105.4375 | 104.9375 | 105.1562 | 73100.0 |
| 2000-10-27 13:00:00 | DIA | ETF | 105.0625 | 105.625 | 105.0625 | 105.625 | 163500.0 |
| 2000-10-27 14:00:00 | DIA | ETF | 105.5938 | 105.9062 | 105.1562 | 105.625 | 244900.0 |
| 2000-10-27 15:00:00 | DIA | ETF | 105.625 | 105.7812 | 105.1875 | 105.7812 | 225800.0 |
| 2000-10-27 16:00:00 | DIA | ETF | 105.7812 | 106.4062 | 105.7188 | 106.1875 | 71900.0 |
> showing 32 of 179 rows — these rows as CSV