PREVIEW / etf_1hour / 2000-02-17
file: by_date/etf_1hour/2000/2000-02-17.parquet size: 8 KB rows: 130
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-17 09:00:00 | SPY | ETF | 140.4375 | 140.4375 | 139.8438 | 139.9375 | 437000.0 |
| 2000-02-17 10:00:00 | SPY | ETF | 139.875 | 139.9375 | 138.3438 | 138.9375 | 1676100.0 |
| 2000-02-17 11:00:00 | SPY | ETF | 139.0 | 139.3438 | 138.2188 | 138.375 | 1287800.0 |
| 2000-02-17 12:00:00 | SPY | ETF | 138.3125 | 139.125 | 138.3125 | 139.0312 | 474800.0 |
| 2000-02-17 13:00:00 | SPY | ETF | 139.1562 | 140.125 | 139.1562 | 139.5312 | 963400.0 |
| 2000-02-17 14:00:00 | SPY | ETF | 139.625 | 139.6562 | 138.8125 | 139.0 | 1054400.0 |
| 2000-02-17 15:00:00 | SPY | ETF | 138.9375 | 139.3125 | 138.2812 | 139.0625 | 1113400.0 |
| 2000-02-17 16:00:00 | SPY | ETF | 139.0312 | 139.0625 | 138.2812 | 138.2812 | 558200.0 |
| 2000-02-17 09:00:00 | QQQ | ETF | 101.1875 | 101.5 | 100.875 | 101.1875 | 2690600.0 |
| 2000-02-17 10:00:00 | QQQ | ETF | 101.125 | 101.3594 | 99.625 | 101.125 | 7697600.0 |
| 2000-02-17 11:00:00 | QQQ | ETF | 101.1406 | 101.4375 | 100.1875 | 100.4375 | 3447800.0 |
| 2000-02-17 12:00:00 | QQQ | ETF | 100.4062 | 101.5 | 100.3125 | 101.4375 | 1820000.0 |
| 2000-02-17 13:00:00 | QQQ | ETF | 101.5 | 103.25 | 101.4844 | 102.3438 | 5946000.0 |
| 2000-02-17 14:00:00 | QQQ | ETF | 102.4375 | 102.8594 | 102.0625 | 102.3125 | 3118800.0 |
| 2000-02-17 15:00:00 | QQQ | ETF | 102.4375 | 103.25 | 101.75 | 103.125 | 4143200.0 |
| 2000-02-17 16:00:00 | QQQ | ETF | 103.25 | 103.25 | 102.0 | 102.125 | 925400.0 |
| 2000-02-17 17:00:00 | QQQ | ETF | 102.0625 | 102.1875 | 101.875 | 102.0625 | 9000.0 |
| 2000-02-17 18:00:00 | QQQ | ETF | 102.0625 | 102.125 | 102.0625 | 102.125 | 800.0 |
| 2000-02-17 09:00:00 | DIA | ETF | 106.7812 | 106.8438 | 106.3125 | 106.4688 | 134600.0 |
| 2000-02-17 10:00:00 | DIA | ETF | 106.3125 | 106.3125 | 105.1562 | 105.4688 | 504300.0 |
| 2000-02-17 11:00:00 | DIA | ETF | 105.4688 | 105.5938 | 104.6562 | 104.6562 | 103100.0 |
| 2000-02-17 12:00:00 | DIA | ETF | 104.8438 | 105.5 | 104.6875 | 105.5 | 47700.0 |
| 2000-02-17 13:00:00 | DIA | ETF | 105.5312 | 106.2188 | 105.5 | 105.75 | 102200.0 |
| 2000-02-17 14:00:00 | DIA | ETF | 105.8125 | 105.875 | 105.0625 | 105.2812 | 89900.0 |
| 2000-02-17 15:00:00 | DIA | ETF | 105.125 | 105.375 | 104.75 | 105.1875 | 97500.0 |
| 2000-02-17 16:00:00 | DIA | ETF | 105.0625 | 105.0625 | 104.75 | 104.7812 | 32400.0 |
> showing 26 of 130 rows — these rows as CSV