PREVIEW / etf_1hour / 2000-02-15
file: by_date/etf_1hour/2000/2000-02-15.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-15 09:00:00 | SPY | ETF | 139.25 | 139.5 | 138.6562 | 139.125 | 536100.0 |
| 2000-02-15 10:00:00 | SPY | ETF | 139.125 | 139.1875 | 138.2188 | 139.0625 | 2113100.0 |
| 2000-02-15 11:00:00 | SPY | ETF | 138.9375 | 139.0938 | 137.7812 | 138.5 | 1330100.0 |
| 2000-02-15 12:00:00 | SPY | ETF | 138.5 | 139.25 | 138.3125 | 138.9062 | 566000.0 |
| 2000-02-15 13:00:00 | SPY | ETF | 139.0 | 139.375 | 138.875 | 139.0 | 525300.0 |
| 2000-02-15 14:00:00 | SPY | ETF | 139.0 | 140.6562 | 138.9062 | 140.4688 | 2402500.0 |
| 2000-02-15 15:00:00 | SPY | ETF | 140.4375 | 141.2188 | 140.1562 | 140.75 | 2191100.0 |
| 2000-02-15 16:00:00 | SPY | ETF | 140.75 | 141.0938 | 140.4375 | 141.0938 | 1270800.0 |
| 2000-02-15 09:00:00 | QQQ | ETF | 98.9375 | 99.375 | 98.1562 | 98.375 | 2072000.0 |
| 2000-02-15 10:00:00 | QQQ | ETF | 98.4062 | 98.5625 | 96.75 | 97.5625 | 6122200.0 |
| 2000-02-15 11:00:00 | QQQ | ETF | 97.5312 | 97.5312 | 95.875 | 96.6562 | 4491600.0 |
| 2000-02-15 12:00:00 | QQQ | ETF | 96.6875 | 97.5625 | 96.375 | 97.2812 | 3408200.0 |
| 2000-02-15 13:00:00 | QQQ | ETF | 97.1875 | 97.6875 | 96.7656 | 96.8125 | 1841800.0 |
| 2000-02-15 14:00:00 | QQQ | ETF | 96.8125 | 99.75 | 96.8125 | 99.5 | 5579800.0 |
| 2000-02-15 15:00:00 | QQQ | ETF | 99.5625 | 100.625 | 99.0625 | 99.875 | 6213400.0 |
| 2000-02-15 16:00:00 | QQQ | ETF | 99.8438 | 100.3438 | 99.6562 | 100.25 | 688200.0 |
| 2000-02-15 17:00:00 | QQQ | ETF | 100.4688 | 100.4688 | 100.4688 | 100.4688 | 200.0 |
| 2000-02-15 09:00:00 | DIA | ETF | 105.5938 | 105.75 | 105.25 | 105.75 | 129800.0 |
| 2000-02-15 10:00:00 | DIA | ETF | 105.7812 | 106.0 | 105.25 | 106.0 | 196700.0 |
| 2000-02-15 11:00:00 | DIA | ETF | 105.9062 | 105.9688 | 105.0312 | 105.6562 | 173900.0 |
| 2000-02-15 12:00:00 | DIA | ETF | 105.75 | 106.25 | 105.5 | 105.875 | 80600.0 |
| 2000-02-15 13:00:00 | DIA | ETF | 106.0 | 106.5 | 105.875 | 106.25 | 122500.0 |
| 2000-02-15 14:00:00 | DIA | ETF | 106.25 | 107.3125 | 106.25 | 107.0938 | 310200.0 |
| 2000-02-15 15:00:00 | DIA | ETF | 107.25 | 107.875 | 107.125 | 107.4688 | 337800.0 |
| 2000-02-15 16:00:00 | DIA | ETF | 107.4688 | 107.4688 | 107.375 | 107.4375 | 8000.0 |
> showing 25 of 130 rows — these rows as CSV