PREVIEW / etf_1hour / 2000-05-04
file: by_date/etf_1hour/2000/2000-05-04.parquet size: 8 KB rows: 118
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-04 09:00:00 | SPY | ETF | 142.0 | 142.2188 | 141.0312 | 141.8125 | 792900.0 |
| 2000-05-04 10:00:00 | SPY | ETF | 141.7812 | 142.3438 | 141.1562 | 141.3125 | 1509300.0 |
| 2000-05-04 11:00:00 | SPY | ETF | 141.4375 | 141.9375 | 140.9688 | 141.125 | 493600.0 |
| 2000-05-04 12:00:00 | SPY | ETF | 141.125 | 141.6875 | 140.875 | 141.625 | 362100.0 |
| 2000-05-04 13:00:00 | SPY | ETF | 141.6875 | 141.7188 | 141.0625 | 141.25 | 280400.0 |
| 2000-05-04 14:00:00 | SPY | ETF | 141.0938 | 141.3438 | 140.75 | 141.1875 | 406200.0 |
| 2000-05-04 15:00:00 | SPY | ETF | 141.0625 | 142.1875 | 140.875 | 141.3125 | 1750700.0 |
| 2000-05-04 16:00:00 | SPY | ETF | 141.4375 | 141.8125 | 141.0312 | 141.8125 | 352100.0 |
| 2000-05-04 09:00:00 | QQQ | ETF | 89.0 | 89.75 | 87.625 | 89.5 | 2968000.0 |
| 2000-05-04 10:00:00 | QQQ | ETF | 89.75 | 90.75 | 88.75 | 88.9375 | 4381300.0 |
| 2000-05-04 11:00:00 | QQQ | ETF | 88.9375 | 89.625 | 88.25 | 88.25 | 1699400.0 |
| 2000-05-04 12:00:00 | QQQ | ETF | 88.25 | 88.9375 | 87.75 | 88.875 | 2036700.0 |
| 2000-05-04 13:00:00 | QQQ | ETF | 88.8125 | 88.9688 | 88.125 | 88.375 | 761900.0 |
| 2000-05-04 14:00:00 | QQQ | ETF | 88.5 | 88.875 | 87.8125 | 88.375 | 1312200.0 |
| 2000-05-04 15:00:00 | QQQ | ETF | 88.5 | 90.0 | 88.125 | 89.125 | 3679700.0 |
| 2000-05-04 16:00:00 | QQQ | ETF | 89.0625 | 89.25 | 88.625 | 89.125 | 827100.0 |
| 2000-05-04 17:00:00 | QQQ | ETF | 89.125 | 89.375 | 89.0625 | 89.375 | 1800.0 |
| 2000-05-04 18:00:00 | QQQ | ETF | 89.125 | 89.3125 | 88.875 | 89.3125 | 1100.0 |
| 2000-05-04 09:00:00 | DIA | ETF | 105.2812 | 105.2812 | 104.25 | 105.0 | 274500.0 |
| 2000-05-04 10:00:00 | DIA | ETF | 105.0312 | 105.0625 | 103.7812 | 104.3438 | 179500.0 |
| 2000-05-04 11:00:00 | DIA | ETF | 104.375 | 104.6562 | 104.125 | 104.1875 | 88700.0 |
| 2000-05-04 12:00:00 | DIA | ETF | 104.1875 | 104.875 | 104.0312 | 104.875 | 88900.0 |
| 2000-05-04 13:00:00 | DIA | ETF | 104.7188 | 104.9375 | 104.2188 | 104.5625 | 82700.0 |
| 2000-05-04 14:00:00 | DIA | ETF | 104.5 | 104.5938 | 103.7812 | 104.4688 | 115100.0 |
| 2000-05-04 15:00:00 | DIA | ETF | 104.25 | 104.75 | 103.9375 | 104.0 | 281200.0 |
| 2000-05-04 16:00:00 | DIA | ETF | 104.125 | 104.4375 | 103.9375 | 104.3125 | 41300.0 |
> showing 26 of 118 rows — these rows as CSV