PREVIEW / etf_1hour / 2000-01-26
file: by_date/etf_1hour/2000/2000-01-26.parquet size: 8 KB rows: 133
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-01-26 09:00:00 | SPY | ETF | 141.0 | 141.375 | 140.4688 | 141.375 | 384800.0 |
| 2000-01-26 10:00:00 | SPY | ETF | 141.375 | 141.5312 | 140.75 | 140.875 | 422900.0 |
| 2000-01-26 11:00:00 | SPY | ETF | 140.75 | 140.875 | 140.0938 | 140.6875 | 917400.0 |
| 2000-01-26 12:00:00 | SPY | ETF | 140.6875 | 140.7812 | 140.5 | 140.75 | 545700.0 |
| 2000-01-26 13:00:00 | SPY | ETF | 140.6562 | 141.2188 | 140.5938 | 140.9062 | 638800.0 |
| 2000-01-26 14:00:00 | SPY | ETF | 141.0938 | 141.5 | 140.5312 | 140.875 | 1139900.0 |
| 2000-01-26 15:00:00 | SPY | ETF | 140.8438 | 141.125 | 140.2812 | 140.6562 | 683200.0 |
| 2000-01-26 16:00:00 | SPY | ETF | 140.5938 | 141.0 | 140.5312 | 140.8125 | 421600.0 |
| 2000-01-26 09:00:00 | QQQ | ETF | 93.25 | 93.3125 | 92.25 | 93.0781 | 2555800.0 |
| 2000-01-26 10:00:00 | QQQ | ETF | 93.1875 | 93.2656 | 92.0625 | 92.0938 | 3328600.0 |
| 2000-01-26 11:00:00 | QQQ | ETF | 92.25 | 92.625 | 91.0 | 92.5156 | 2630600.0 |
| 2000-01-26 12:00:00 | QQQ | ETF | 92.5156 | 92.5625 | 91.8125 | 92.0938 | 1954200.0 |
| 2000-01-26 13:00:00 | QQQ | ETF | 92.0 | 92.7344 | 91.9375 | 92.2812 | 3605400.0 |
| 2000-01-26 14:00:00 | QQQ | ETF | 92.2812 | 93.25 | 91.625 | 91.9219 | 3475000.0 |
| 2000-01-26 15:00:00 | QQQ | ETF | 91.9219 | 92.0625 | 90.25 | 90.5312 | 4416200.0 |
| 2000-01-26 16:00:00 | QQQ | ETF | 90.5 | 90.7969 | 89.0 | 89.0 | 583600.0 |
| 2000-01-26 17:00:00 | QQQ | ETF | 89.5312 | 89.75 | 89.3125 | 89.5 | 42600.0 |
| 2000-01-26 18:00:00 | QQQ | ETF | 89.5 | 89.5 | 89.25 | 89.25 | 2800.0 |
| 2000-01-26 09:00:00 | DIA | ETF | 110.2188 | 111.1562 | 110.1875 | 111.1562 | 114400.0 |
| 2000-01-26 10:00:00 | DIA | ETF | 111.1562 | 111.375 | 110.8438 | 110.8438 | 108900.0 |
| 2000-01-26 11:00:00 | DIA | ETF | 110.9375 | 110.9375 | 110.4062 | 110.8438 | 202800.0 |
| 2000-01-26 12:00:00 | DIA | ETF | 110.8125 | 110.8125 | 110.4688 | 110.5938 | 18400.0 |
| 2000-01-26 13:00:00 | DIA | ETF | 110.625 | 110.9375 | 110.5938 | 110.7812 | 39600.0 |
| 2000-01-26 14:00:00 | DIA | ETF | 110.5938 | 111.0 | 110.2188 | 110.6562 | 89300.0 |
| 2000-01-26 15:00:00 | DIA | ETF | 110.5 | 110.7812 | 110.25 | 110.5 | 195400.0 |
| 2000-01-26 16:00:00 | DIA | ETF | 110.375 | 110.4688 | 110.125 | 110.4688 | 232500.0 |
> showing 26 of 133 rows — these rows as CSV