PREVIEW / etf_1hour / 2000-02-23
file: by_date/etf_1hour/2000/2000-02-23.parquet size: 8 KB rows: 135
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-23 09:00:00 | SPY | ETF | 135.625 | 135.625 | 134.6562 | 135.0625 | 918500.0 |
| 2000-02-23 10:00:00 | SPY | ETF | 135.2188 | 135.75 | 134.8125 | 135.0625 | 888300.0 |
| 2000-02-23 11:00:00 | SPY | ETF | 135.0312 | 135.4375 | 134.5 | 135.3125 | 636300.0 |
| 2000-02-23 12:00:00 | SPY | ETF | 135.375 | 136.0312 | 135.125 | 135.5938 | 1257600.0 |
| 2000-02-23 13:00:00 | SPY | ETF | 135.5 | 136.7812 | 135.4375 | 136.625 | 2249100.0 |
| 2000-02-23 14:00:00 | SPY | ETF | 136.5938 | 137.125 | 136.25 | 136.625 | 2156800.0 |
| 2000-02-23 15:00:00 | SPY | ETF | 136.7188 | 137.4688 | 136.375 | 136.5 | 3400400.0 |
| 2000-02-23 16:00:00 | SPY | ETF | 136.5 | 136.625 | 136.2188 | 136.5625 | 515200.0 |
| 2000-02-23 09:00:00 | QQQ | ETF | 99.6719 | 100.0312 | 99.1562 | 99.75 | 3585400.0 |
| 2000-02-23 10:00:00 | QQQ | ETF | 99.75 | 100.6094 | 99.4375 | 100.25 | 3260600.0 |
| 2000-02-23 11:00:00 | QQQ | ETF | 100.2812 | 100.75 | 99.75 | 100.6406 | 2191200.0 |
| 2000-02-23 12:00:00 | QQQ | ETF | 100.7188 | 101.375 | 100.5625 | 101.3281 | 3309200.0 |
| 2000-02-23 13:00:00 | QQQ | ETF | 101.0781 | 102.6094 | 101.0 | 102.6094 | 3183600.0 |
| 2000-02-23 14:00:00 | QQQ | ETF | 102.6094 | 103.25 | 102.4375 | 103.1875 | 6498200.0 |
| 2000-02-23 15:00:00 | QQQ | ETF | 103.2031 | 104.9844 | 103.0 | 104.2188 | 9082800.0 |
| 2000-02-23 16:00:00 | QQQ | ETF | 104.2188 | 104.5 | 103.7031 | 104.125 | 948800.0 |
| 2000-02-23 17:00:00 | QQQ | ETF | 104.1562 | 104.375 | 104.1562 | 104.25 | 3200.0 |
| 2000-02-23 09:00:00 | DIA | ETF | 102.9688 | 103.0938 | 102.0625 | 102.375 | 246100.0 |
| 2000-02-23 10:00:00 | DIA | ETF | 102.4062 | 102.75 | 102.1562 | 102.3438 | 75400.0 |
| 2000-02-23 11:00:00 | DIA | ETF | 102.4688 | 102.4688 | 101.625 | 102.4062 | 251800.0 |
| 2000-02-23 12:00:00 | DIA | ETF | 102.3125 | 102.7812 | 102.25 | 102.375 | 158600.0 |
| 2000-02-23 13:00:00 | DIA | ETF | 102.2812 | 103.1875 | 102.125 | 103.1875 | 328200.0 |
| 2000-02-23 14:00:00 | DIA | ETF | 103.25 | 103.5 | 102.6875 | 103.0312 | 226300.0 |
| 2000-02-23 15:00:00 | DIA | ETF | 103.0625 | 103.4688 | 102.25 | 102.375 | 269600.0 |
| 2000-02-23 16:00:00 | DIA | ETF | 102.2812 | 102.2812 | 102.2188 | 102.25 | 1900.0 |
> showing 25 of 135 rows — these rows as CSV