PREVIEW / etf_1hour / 2000-05-22
file: by_date/etf_1hour/2000/2000-05-22.parquet size: 8 KB rows: 137
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-22 09:00:00 | SPY | ETF | 141.25 | 141.4688 | 140.0 | 140.125 | 1638300.0 |
| 2000-05-22 10:00:00 | SPY | ETF | 140.125 | 140.2812 | 137.375 | 138.0312 | 2414100.0 |
| 2000-05-22 11:00:00 | SPY | ETF | 138.1875 | 139.0 | 137.1875 | 137.6562 | 1098100.0 |
| 2000-05-22 12:00:00 | SPY | ETF | 137.75 | 138.5938 | 137.5 | 138.1875 | 408600.0 |
| 2000-05-22 13:00:00 | SPY | ETF | 138.4062 | 138.5 | 137.25 | 137.5625 | 1199600.0 |
| 2000-05-22 14:00:00 | SPY | ETF | 137.625 | 139.125 | 137.0 | 138.625 | 867500.0 |
| 2000-05-22 15:00:00 | SPY | ETF | 138.625 | 140.75 | 138.5 | 140.4062 | 2239700.0 |
| 2000-05-22 16:00:00 | SPY | ETF | 140.25 | 140.4062 | 140.0 | 140.0625 | 632200.0 |
| 2000-05-22 09:00:00 | QQQ | ETF | 81.625 | 81.625 | 78.875 | 78.875 | 5317200.0 |
| 2000-05-22 10:00:00 | QQQ | ETF | 78.9375 | 79.25 | 75.5625 | 77.3125 | 10626200.0 |
| 2000-05-22 11:00:00 | QQQ | ETF | 77.375 | 78.625 | 76.0625 | 77.0625 | 5416100.0 |
| 2000-05-22 12:00:00 | QQQ | ETF | 77.0625 | 78.0625 | 76.5 | 77.75 | 3075600.0 |
| 2000-05-22 13:00:00 | QQQ | ETF | 77.625 | 77.9062 | 76.1875 | 76.5 | 2707400.0 |
| 2000-05-22 14:00:00 | QQQ | ETF | 76.5 | 79.0 | 76.0 | 78.125 | 5358600.0 |
| 2000-05-22 15:00:00 | QQQ | ETF | 78.125 | 81.875 | 77.875 | 81.625 | 10269000.0 |
| 2000-05-22 16:00:00 | QQQ | ETF | 81.5 | 82.25 | 81.5 | 82.25 | 610500.0 |
| 2000-05-22 17:00:00 | QQQ | ETF | 82.0 | 82.0 | 81.625 | 81.625 | 4000.0 |
| 2000-05-22 18:00:00 | QQQ | ETF | 81.875 | 82.0 | 81.625 | 81.625 | 1300.0 |
| 2000-05-22 09:00:00 | DIA | ETF | 106.125 | 106.3438 | 105.3438 | 105.5312 | 143400.0 |
| 2000-05-22 10:00:00 | DIA | ETF | 105.5 | 105.9375 | 104.0625 | 104.3438 | 220700.0 |
| 2000-05-22 11:00:00 | DIA | ETF | 104.5625 | 104.7188 | 103.8438 | 104.0312 | 140800.0 |
| 2000-05-22 12:00:00 | DIA | ETF | 104.0312 | 104.5625 | 103.875 | 104.4062 | 151800.0 |
| 2000-05-22 13:00:00 | DIA | ETF | 104.4375 | 104.5 | 103.7812 | 103.7812 | 183400.0 |
| 2000-05-22 14:00:00 | DIA | ETF | 103.875 | 104.8125 | 103.625 | 104.5625 | 112800.0 |
| 2000-05-22 15:00:00 | DIA | ETF | 104.4375 | 105.5938 | 104.3438 | 105.4375 | 255300.0 |
| 2000-05-22 16:00:00 | DIA | ETF | 105.5 | 105.5312 | 105.2812 | 105.5312 | 24900.0 |
> showing 26 of 137 rows — these rows as CSV