PREVIEW / etf_1hour / 2000-03-28
file: by_date/etf_1hour/2000/2000-03-28.parquet size: 8 KB rows: 126
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-28 09:00:00 | SPY | ETF | 151.25 | 152.5 | 151.25 | 152.1875 | 1428900.0 |
| 2000-03-28 10:00:00 | SPY | ETF | 152.25 | 152.9688 | 151.0 | 152.8125 | 1412700.0 |
| 2000-03-28 11:00:00 | SPY | ETF | 152.8125 | 152.9688 | 152.2188 | 152.25 | 684300.0 |
| 2000-03-28 12:00:00 | SPY | ETF | 152.2188 | 152.4688 | 151.5 | 151.7188 | 331900.0 |
| 2000-03-28 13:00:00 | SPY | ETF | 151.6562 | 152.5 | 151.6562 | 152.1875 | 502100.0 |
| 2000-03-28 14:00:00 | SPY | ETF | 152.2188 | 152.5938 | 151.6875 | 152.0312 | 397500.0 |
| 2000-03-28 15:00:00 | SPY | ETF | 152.125 | 152.25 | 150.7812 | 151.0 | 977700.0 |
| 2000-03-28 16:00:00 | SPY | ETF | 151.0 | 151.1562 | 150.5938 | 151.0625 | 517200.0 |
| 2000-03-28 17:00:00 | SPY | ETF | 151.0625 | 151.0625 | 151.0625 | 151.0625 | 100.0 |
| 2000-03-28 09:00:00 | QQQ | ETF | 116.9688 | 117.8125 | 116.25 | 117.125 | 2859400.0 |
| 2000-03-28 10:00:00 | QQQ | ETF | 117.125 | 117.25 | 114.625 | 117.1875 | 5132100.0 |
| 2000-03-28 11:00:00 | QQQ | ETF | 117.1562 | 117.3125 | 116.0 | 116.5625 | 1749900.0 |
| 2000-03-28 12:00:00 | QQQ | ETF | 116.5 | 116.875 | 115.625 | 116.1875 | 1715100.0 |
| 2000-03-28 13:00:00 | QQQ | ETF | 116.2188 | 117.0312 | 116.0 | 116.5625 | 1208600.0 |
| 2000-03-28 14:00:00 | QQQ | ETF | 116.5625 | 116.9375 | 115.75 | 116.3438 | 1707600.0 |
| 2000-03-28 15:00:00 | QQQ | ETF | 116.375 | 116.5938 | 114.5312 | 114.9375 | 3270500.0 |
| 2000-03-28 16:00:00 | QQQ | ETF | 114.9375 | 115.0 | 114.375 | 115.0 | 613100.0 |
| 2000-03-28 17:00:00 | QQQ | ETF | 115.0 | 115.0 | 114.6875 | 114.75 | 2100.0 |
| 2000-03-28 18:00:00 | QQQ | ETF | 114.75 | 114.75 | 114.75 | 114.75 | 100.0 |
| 2000-03-28 09:00:00 | DIA | ETF | 109.125 | 110.4688 | 109.125 | 110.1562 | 304800.0 |
| 2000-03-28 10:00:00 | DIA | ETF | 110.1875 | 110.9375 | 109.5625 | 110.875 | 639700.0 |
| 2000-03-28 11:00:00 | DIA | ETF | 110.9375 | 110.9688 | 110.5 | 110.625 | 73800.0 |
| 2000-03-28 12:00:00 | DIA | ETF | 110.75 | 110.75 | 109.9375 | 110.1562 | 143500.0 |
| 2000-03-28 13:00:00 | DIA | ETF | 110.25 | 110.625 | 110.0312 | 110.25 | 36800.0 |
| 2000-03-28 14:00:00 | DIA | ETF | 110.0938 | 110.5625 | 109.875 | 110.125 | 71900.0 |
| 2000-03-28 15:00:00 | DIA | ETF | 110.125 | 110.1562 | 109.375 | 109.375 | 224900.0 |
| 2000-03-28 16:00:00 | DIA | ETF | 109.375 | 109.5 | 109.1562 | 109.375 | 72800.0 |
> showing 27 of 126 rows — these rows as CSV