PREVIEW / etf_1hour / 2000-01-28
file: by_date/etf_1hour/2000/2000-01-28.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-28 09:00:00 | SPY | ETF | 139.4375 | 139.875 | 138.4375 | 139.625 | 1235300.0 |
| 2000-01-28 10:00:00 | SPY | ETF | 139.5312 | 140.0625 | 138.5 | 138.8438 | 1181700.0 |
| 2000-01-28 11:00:00 | SPY | ETF | 138.6562 | 139.0938 | 138.0 | 138.0 | 1163900.0 |
| 2000-01-28 12:00:00 | SPY | ETF | 138.0625 | 138.1875 | 137.0 | 137.2188 | 1547800.0 |
| 2000-01-28 13:00:00 | SPY | ETF | 137.125 | 138.25 | 136.625 | 138.1875 | 1805000.0 |
| 2000-01-28 14:00:00 | SPY | ETF | 138.1875 | 138.375 | 137.125 | 137.4062 | 991200.0 |
| 2000-01-28 15:00:00 | SPY | ETF | 137.5625 | 137.625 | 135.5312 | 136.4688 | 2959800.0 |
| 2000-01-28 16:00:00 | SPY | ETF | 136.375 | 136.375 | 135.75 | 135.875 | 933100.0 |
| 2000-01-28 09:00:00 | QQQ | ETF | 90.0 | 90.4688 | 88.125 | 90.0156 | 4663200.0 |
| 2000-01-28 10:00:00 | QQQ | ETF | 90.0156 | 90.4375 | 88.7812 | 89.0312 | 4692400.0 |
| 2000-01-28 11:00:00 | QQQ | ETF | 89.0 | 89.0625 | 88.0156 | 88.0625 | 3271600.0 |
| 2000-01-28 12:00:00 | QQQ | ETF | 88.0312 | 88.1875 | 86.625 | 86.6562 | 5308000.0 |
| 2000-01-28 13:00:00 | QQQ | ETF | 86.625 | 87.75 | 86.1875 | 87.625 | 6114000.0 |
| 2000-01-28 14:00:00 | QQQ | ETF | 87.625 | 87.75 | 86.125 | 86.375 | 3643400.0 |
| 2000-01-28 15:00:00 | QQQ | ETF | 86.3906 | 86.75 | 84.75 | 86.125 | 6465000.0 |
| 2000-01-28 16:00:00 | QQQ | ETF | 86.25 | 86.3438 | 85.75 | 86.0 | 758000.0 |
| 2000-01-28 17:00:00 | QQQ | ETF | 86.0 | 86.125 | 85.75 | 86.0 | 1800.0 |
| 2000-01-28 09:00:00 | DIA | ETF | 109.8438 | 110.0625 | 109.0312 | 109.7812 | 137500.0 |
| 2000-01-28 10:00:00 | DIA | ETF | 109.7188 | 109.9688 | 109.25 | 109.3125 | 94600.0 |
| 2000-01-28 11:00:00 | DIA | ETF | 109.4062 | 109.6562 | 108.5938 | 109.0 | 80100.0 |
| 2000-01-28 12:00:00 | DIA | ETF | 109.0 | 109.0 | 108.125 | 108.4375 | 198600.0 |
| 2000-01-28 13:00:00 | DIA | ETF | 108.375 | 109.125 | 107.7188 | 109.0312 | 137400.0 |
| 2000-01-28 14:00:00 | DIA | ETF | 109.0625 | 109.1875 | 108.2812 | 108.625 | 262600.0 |
| 2000-01-28 15:00:00 | DIA | ETF | 108.7188 | 108.7188 | 107.25 | 107.8125 | 274700.0 |
| 2000-01-28 16:00:00 | DIA | ETF | 107.7812 | 107.7812 | 107.125 | 107.4062 | 66100.0 |
> showing 25 of 133 rows — these rows as CSV