PREVIEW / etf_1hour / 2000-05-02
file: by_date/etf_1hour/2000/2000-05-02.parquet size: 8 KB rows: 129
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-05-02 09:00:00 | SPY | ETF | 145.5 | 146.4688 | 145.5 | 146.375 | 901800.0 |
| 2000-05-02 10:00:00 | SPY | ETF | 146.25 | 146.625 | 145.75 | 145.9688 | 745800.0 |
| 2000-05-02 11:00:00 | SPY | ETF | 146.0938 | 146.625 | 145.875 | 146.4375 | 501200.0 |
| 2000-05-02 12:00:00 | SPY | ETF | 146.4688 | 147.125 | 146.2188 | 146.5625 | 1490900.0 |
| 2000-05-02 13:00:00 | SPY | ETF | 146.4688 | 146.8438 | 146.1875 | 146.3125 | 899800.0 |
| 2000-05-02 14:00:00 | SPY | ETF | 146.125 | 146.2188 | 145.25 | 145.25 | 1573200.0 |
| 2000-05-02 15:00:00 | SPY | ETF | 145.4375 | 145.9375 | 144.5 | 144.625 | 2173900.0 |
| 2000-05-02 16:00:00 | SPY | ETF | 144.5625 | 144.6875 | 144.125 | 144.1562 | 783700.0 |
| 2000-05-02 17:00:00 | SPY | ETF | 144.125 | 144.125 | 144.125 | 144.125 | 700.0 |
| 2000-05-02 09:00:00 | QQQ | ETF | 94.875 | 95.25 | 94.0312 | 95.0 | 2800600.0 |
| 2000-05-02 10:00:00 | QQQ | ETF | 95.1875 | 95.375 | 94.1875 | 94.625 | 2770700.0 |
| 2000-05-02 11:00:00 | QQQ | ETF | 94.5625 | 95.125 | 94.25 | 94.7812 | 1366200.0 |
| 2000-05-02 12:00:00 | QQQ | ETF | 94.75 | 95.625 | 94.5625 | 95.0625 | 2634500.0 |
| 2000-05-02 13:00:00 | QQQ | ETF | 95.0625 | 95.25 | 94.5625 | 94.5625 | 1211700.0 |
| 2000-05-02 14:00:00 | QQQ | ETF | 94.5625 | 94.6875 | 92.6875 | 92.75 | 3256200.0 |
| 2000-05-02 15:00:00 | QQQ | ETF | 92.75 | 93.6875 | 90.5 | 90.5 | 5503700.0 |
| 2000-05-02 16:00:00 | QQQ | ETF | 90.625 | 90.75 | 90.0 | 90.0 | 689500.0 |
| 2000-05-02 17:00:00 | QQQ | ETF | 90.0 | 90.25 | 89.75 | 90.0 | 3000.0 |
| 2000-05-02 18:00:00 | QQQ | ETF | 90.5 | 90.5 | 90.0 | 90.125 | 1500.0 |
| 2000-05-02 09:00:00 | DIA | ETF | 107.5 | 107.625 | 106.8125 | 107.625 | 121200.0 |
| 2000-05-02 10:00:00 | DIA | ETF | 107.5 | 107.75 | 107.1562 | 107.375 | 97200.0 |
| 2000-05-02 11:00:00 | DIA | ETF | 107.5938 | 107.8438 | 107.4375 | 107.625 | 47900.0 |
| 2000-05-02 12:00:00 | DIA | ETF | 107.625 | 108.2188 | 107.625 | 108.0312 | 102400.0 |
| 2000-05-02 13:00:00 | DIA | ETF | 108.0 | 108.125 | 107.5625 | 107.5625 | 33000.0 |
| 2000-05-02 14:00:00 | DIA | ETF | 107.5 | 107.6562 | 107.0625 | 107.3125 | 66800.0 |
| 2000-05-02 15:00:00 | DIA | ETF | 107.3125 | 107.6562 | 107.0625 | 107.25 | 110800.0 |
| 2000-05-02 16:00:00 | DIA | ETF | 107.3438 | 107.3438 | 106.9375 | 107.0625 | 80500.0 |
> showing 27 of 129 rows — these rows as CSV