PREVIEW / etf_1hour / 2000-03-02
file: by_date/etf_1hour/2000/2000-03-02.parquet size: 8 KB rows: 128
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-03-02 09:00:00 | SPY | ETF | 138.6875 | 138.7188 | 137.8438 | 137.9688 | 1543200.0 |
| 2000-03-02 10:00:00 | SPY | ETF | 138.0938 | 138.9062 | 137.9375 | 138.7188 | 541000.0 |
| 2000-03-02 11:00:00 | SPY | ETF | 138.625 | 138.9688 | 138.1562 | 138.625 | 1045500.0 |
| 2000-03-02 12:00:00 | SPY | ETF | 138.5 | 138.625 | 137.6875 | 137.7812 | 1107700.0 |
| 2000-03-02 13:00:00 | SPY | ETF | 137.875 | 138.125 | 137.3438 | 137.875 | 815200.0 |
| 2000-03-02 14:00:00 | SPY | ETF | 137.8125 | 138.9688 | 137.75 | 138.4688 | 714200.0 |
| 2000-03-02 15:00:00 | SPY | ETF | 138.5625 | 139.125 | 138.375 | 138.7188 | 1523900.0 |
| 2000-03-02 16:00:00 | SPY | ETF | 138.5312 | 138.7812 | 138.5 | 138.5312 | 198200.0 |
| 2000-03-02 09:00:00 | QQQ | ETF | 108.0625 | 108.125 | 106.5625 | 106.875 | 4215400.0 |
| 2000-03-02 10:00:00 | QQQ | ETF | 106.875 | 108.1875 | 106.75 | 107.9062 | 4791800.0 |
| 2000-03-02 11:00:00 | QQQ | ETF | 108.0 | 108.1875 | 107.0312 | 107.3125 | 4197600.0 |
| 2000-03-02 12:00:00 | QQQ | ETF | 107.3125 | 107.375 | 105.375 | 105.375 | 4938200.0 |
| 2000-03-02 13:00:00 | QQQ | ETF | 105.375 | 106.1094 | 104.75 | 105.75 | 4174600.0 |
| 2000-03-02 14:00:00 | QQQ | ETF | 105.6875 | 107.1562 | 105.5 | 106.2812 | 4019800.0 |
| 2000-03-02 15:00:00 | QQQ | ETF | 106.2812 | 106.9844 | 105.6875 | 105.875 | 4886800.0 |
| 2000-03-02 16:00:00 | QQQ | ETF | 105.875 | 105.875 | 105.0625 | 105.125 | 1330800.0 |
| 2000-03-02 09:00:00 | DIA | ETF | 101.4688 | 101.9688 | 101.375 | 101.5 | 102200.0 |
| 2000-03-02 10:00:00 | DIA | ETF | 101.5 | 102.1562 | 101.5 | 101.875 | 69600.0 |
| 2000-03-02 11:00:00 | DIA | ETF | 101.875 | 102.125 | 101.5312 | 101.6875 | 26800.0 |
| 2000-03-02 12:00:00 | DIA | ETF | 101.6875 | 101.875 | 101.125 | 101.2188 | 84100.0 |
| 2000-03-02 13:00:00 | DIA | ETF | 101.125 | 101.625 | 101.0 | 101.4688 | 125000.0 |
| 2000-03-02 14:00:00 | DIA | ETF | 101.3125 | 101.8438 | 101.25 | 101.5312 | 60500.0 |
| 2000-03-02 15:00:00 | DIA | ETF | 101.7188 | 102.25 | 101.5 | 101.7812 | 100200.0 |
| 2000-03-02 16:00:00 | DIA | ETF | 101.7812 | 101.7812 | 101.6562 | 101.6875 | 6600.0 |
> showing 24 of 128 rows — these rows as CSV