PREVIEW / etf_1hour / 2000-01-25
file: by_date/etf_1hour/2000/2000-01-25.parquet size: 8 KB rows: 134
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-25 09:00:00 | SPY | ETF | 140.5 | 140.75 | 139.7812 | 140.75 | 1155600.0 |
| 2000-01-25 10:00:00 | SPY | ETF | 140.75 | 141.4688 | 140.1562 | 140.6875 | 2105600.0 |
| 2000-01-25 11:00:00 | SPY | ETF | 140.6875 | 141.4688 | 140.5 | 140.5625 | 520400.0 |
| 2000-01-25 12:00:00 | SPY | ETF | 140.5312 | 141.0 | 139.75 | 139.9375 | 1745400.0 |
| 2000-01-25 13:00:00 | SPY | ETF | 140.0 | 140.4062 | 139.0 | 139.0938 | 1271100.0 |
| 2000-01-25 14:00:00 | SPY | ETF | 139.0 | 140.625 | 139.0 | 140.125 | 1807500.0 |
| 2000-01-25 15:00:00 | SPY | ETF | 140.1875 | 141.625 | 139.7812 | 141.0 | 755600.0 |
| 2000-01-25 16:00:00 | SPY | ETF | 141.1875 | 141.9375 | 140.75 | 141.9375 | 568100.0 |
| 2000-01-25 09:00:00 | QQQ | ETF | 91.875 | 91.9688 | 89.4062 | 91.0 | 5562600.0 |
| 2000-01-25 10:00:00 | QQQ | ETF | 91.0 | 92.5 | 90.5625 | 91.5 | 6014800.0 |
| 2000-01-25 11:00:00 | QQQ | ETF | 91.5 | 92.5 | 91.3438 | 91.4844 | 2533600.0 |
| 2000-01-25 12:00:00 | QQQ | ETF | 91.5312 | 92.1875 | 90.75 | 91.25 | 2914600.0 |
| 2000-01-25 13:00:00 | QQQ | ETF | 91.1406 | 91.6875 | 89.75 | 90.0625 | 3548600.0 |
| 2000-01-25 14:00:00 | QQQ | ETF | 89.75 | 92.1875 | 89.625 | 91.75 | 5194800.0 |
| 2000-01-25 15:00:00 | QQQ | ETF | 91.8125 | 93.875 | 91.25 | 93.625 | 6529200.0 |
| 2000-01-25 16:00:00 | QQQ | ETF | 93.7031 | 94.1094 | 93.0 | 93.125 | 867000.0 |
| 2000-01-25 17:00:00 | QQQ | ETF | 93.1562 | 93.1562 | 93.0 | 93.0 | 7200.0 |
| 2000-01-25 09:00:00 | DIA | ETF | 110.5938 | 110.75 | 110.0625 | 110.5312 | 252700.0 |
| 2000-01-25 10:00:00 | DIA | ETF | 110.625 | 110.875 | 109.7188 | 110.1875 | 205700.0 |
| 2000-01-25 11:00:00 | DIA | ETF | 110.1875 | 110.6562 | 109.8125 | 109.9375 | 121300.0 |
| 2000-01-25 12:00:00 | DIA | ETF | 109.9375 | 110.1562 | 109.25 | 109.5625 | 113600.0 |
| 2000-01-25 13:00:00 | DIA | ETF | 109.625 | 109.875 | 108.75 | 108.75 | 267700.0 |
| 2000-01-25 14:00:00 | DIA | ETF | 108.75 | 110.125 | 108.75 | 109.9062 | 291800.0 |
| 2000-01-25 15:00:00 | DIA | ETF | 109.9062 | 110.7812 | 109.4375 | 110.375 | 395900.0 |
| 2000-01-25 16:00:00 | DIA | ETF | 110.3438 | 110.3438 | 110.0938 | 110.3438 | 57600.0 |
> showing 25 of 134 rows — these rows as CSV