PREVIEW / etf_1hour / 2000-02-07
file: by_date/etf_1hour/2000/2000-02-07.parquet size: 8 KB rows: 127
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-07 09:00:00 | SPY | ETF | 142.5625 | 142.7188 | 142.0 | 142.0 | 649200.0 |
| 2000-02-07 10:00:00 | SPY | ETF | 142.0 | 142.5938 | 141.8125 | 142.125 | 599300.0 |
| 2000-02-07 11:00:00 | SPY | ETF | 141.7812 | 142.5 | 141.7812 | 142.2188 | 414900.0 |
| 2000-02-07 12:00:00 | SPY | ETF | 142.0625 | 142.3125 | 141.6562 | 141.875 | 379000.0 |
| 2000-02-07 13:00:00 | SPY | ETF | 141.9688 | 142.1875 | 141.625 | 141.875 | 1204600.0 |
| 2000-02-07 14:00:00 | SPY | ETF | 141.875 | 142.0938 | 141.4375 | 141.9688 | 1207600.0 |
| 2000-02-07 15:00:00 | SPY | ETF | 142.1562 | 142.7812 | 141.7188 | 142.7188 | 1087000.0 |
| 2000-02-07 16:00:00 | SPY | ETF | 142.5312 | 142.6562 | 142.3125 | 142.375 | 256400.0 |
| 2000-02-07 09:00:00 | QQQ | ETF | 97.25 | 97.375 | 96.25 | 96.4375 | 2579000.0 |
| 2000-02-07 10:00:00 | QQQ | ETF | 96.625 | 97.625 | 96.375 | 96.875 | 3404600.0 |
| 2000-02-07 11:00:00 | QQQ | ETF | 96.9062 | 97.375 | 96.5625 | 97.0469 | 1531400.0 |
| 2000-02-07 12:00:00 | QQQ | ETF | 97.0625 | 97.125 | 96.625 | 96.8594 | 1127000.0 |
| 2000-02-07 13:00:00 | QQQ | ETF | 96.8594 | 97.1562 | 96.5 | 96.7812 | 1322600.0 |
| 2000-02-07 14:00:00 | QQQ | ETF | 96.75 | 97.1094 | 96.3125 | 96.9062 | 1896800.0 |
| 2000-02-07 15:00:00 | QQQ | ETF | 97.0 | 98.25 | 96.6875 | 98.25 | 5175400.0 |
| 2000-02-07 16:00:00 | QQQ | ETF | 98.2344 | 98.5 | 98.0 | 98.25 | 642600.0 |
| 2000-02-07 17:00:00 | QQQ | ETF | 98.4062 | 98.5 | 98.4062 | 98.5 | 10200.0 |
| 2000-02-07 18:00:00 | QQQ | ETF | 98.625 | 98.625 | 98.5 | 98.5 | 800.0 |
| 2000-02-07 09:00:00 | DIA | ETF | 109.1562 | 109.4688 | 108.8125 | 108.9688 | 118700.0 |
| 2000-02-07 10:00:00 | DIA | ETF | 108.875 | 109.2812 | 108.625 | 108.625 | 115400.0 |
| 2000-02-07 11:00:00 | DIA | ETF | 108.5312 | 109.25 | 108.5312 | 108.8125 | 28900.0 |
| 2000-02-07 12:00:00 | DIA | ETF | 109.0625 | 109.0625 | 108.5 | 108.625 | 46400.0 |
| 2000-02-07 13:00:00 | DIA | ETF | 108.8125 | 109.0312 | 108.375 | 108.7812 | 36100.0 |
| 2000-02-07 14:00:00 | DIA | ETF | 108.75 | 108.9375 | 108.5 | 108.875 | 41900.0 |
| 2000-02-07 15:00:00 | DIA | ETF | 108.9375 | 109.2812 | 108.6875 | 109.0 | 166400.0 |
| 2000-02-07 16:00:00 | DIA | ETF | 109.0312 | 109.0312 | 108.7188 | 108.75 | 62600.0 |
> showing 26 of 127 rows — these rows as CSV