PREVIEW / etf_1hour / 2000-09-15
file: by_date/etf_1hour/2000/2000-09-15.parquet size: 9 KB rows: 160
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-09-15 09:00:00 | SPY | ETF | 148.1875 | 148.1875 | 147.6875 | 148.0312 | 488700.0 |
| 2000-09-15 10:00:00 | SPY | ETF | 148.0 | 148.25 | 147.2188 | 147.6562 | 407600.0 |
| 2000-09-15 11:00:00 | SPY | ETF | 147.6562 | 147.7812 | 147.2812 | 147.625 | 656200.0 |
| 2000-09-15 12:00:00 | SPY | ETF | 147.625 | 147.7188 | 147.3125 | 147.5625 | 239900.0 |
| 2000-09-15 13:00:00 | SPY | ETF | 147.625 | 147.6562 | 146.9375 | 147.0312 | 404000.0 |
| 2000-09-15 14:00:00 | SPY | ETF | 147.0625 | 147.1562 | 146.25 | 146.75 | 766200.0 |
| 2000-09-15 15:00:00 | SPY | ETF | 146.75 | 146.9062 | 146.0312 | 146.75 | 857200.0 |
| 2000-09-15 16:00:00 | SPY | ETF | 146.75 | 146.75 | 146.0 | 146.0 | 263500.0 |
| 2000-09-15 09:00:00 | QQQ | ETF | 93.125 | 93.625 | 92.375 | 93.3438 | 4161600.0 |
| 2000-09-15 10:00:00 | QQQ | ETF | 93.375 | 93.4375 | 91.375 | 92.125 | 4306700.0 |
| 2000-09-15 11:00:00 | QQQ | ETF | 92.1875 | 92.8125 | 91.75 | 92.4375 | 2559100.0 |
| 2000-09-15 12:00:00 | QQQ | ETF | 92.4375 | 92.6562 | 91.9375 | 92.2188 | 1705200.0 |
| 2000-09-15 13:00:00 | QQQ | ETF | 92.1875 | 92.375 | 91.25 | 91.5 | 2176800.0 |
| 2000-09-15 14:00:00 | QQQ | ETF | 91.4375 | 91.6875 | 90.6875 | 91.5312 | 3553500.0 |
| 2000-09-15 15:00:00 | QQQ | ETF | 91.5625 | 91.8125 | 90.75 | 91.5625 | 5238800.0 |
| 2000-09-15 16:00:00 | QQQ | ETF | 91.625 | 91.6875 | 91.1875 | 91.1875 | 1102000.0 |
| 2000-09-15 17:00:00 | QQQ | ETF | 91.3125 | 91.3125 | 91.25 | 91.3125 | 2800.0 |
| 2000-09-15 18:00:00 | QQQ | ETF | 91.3125 | 91.3125 | 91.3125 | 91.3125 | 1100.0 |
| 2000-09-15 09:00:00 | IWM | ETF | 53.625 | 53.625 | 53.625 | 53.625 | 2800.0 |
| 2000-09-15 10:00:00 | IWM | ETF | 53.6875 | 53.6875 | 53.25 | 53.25 | 4000.0 |
| 2000-09-15 11:00:00 | IWM | ETF | 53.4375 | 53.4375 | 53.4375 | 53.4375 | 1200.0 |
| 2000-09-15 12:00:00 | IWM | ETF | 53.4375 | 53.4375 | 53.4062 | 53.4062 | 19200.0 |
| 2000-09-15 13:00:00 | IWM | ETF | 53.4688 | 53.4688 | 53.4688 | 53.4688 | 1000.0 |
| 2000-09-15 14:00:00 | IWM | ETF | 53.3906 | 53.3906 | 53.3906 | 53.3906 | 200.0 |
| 2000-09-15 15:00:00 | IWM | ETF | 53.2812 | 53.3906 | 52.9062 | 52.9062 | 13200.0 |
| 2000-09-15 16:00:00 | IWM | ETF | 52.8125 | 52.9062 | 52.8125 | 52.9062 | 23000.0 |
| 2000-09-15 09:00:00 | DIA | ETF | 110.7812 | 111.0 | 110.6562 | 110.8125 | 49000.0 |
| 2000-09-15 10:00:00 | DIA | ETF | 110.8438 | 110.875 | 110.5 | 110.6875 | 32000.0 |
| 2000-09-15 11:00:00 | DIA | ETF | 110.6875 | 110.9062 | 110.5 | 110.6562 | 57000.0 |
| 2000-09-15 12:00:00 | DIA | ETF | 110.5938 | 110.6875 | 110.4688 | 110.5625 | 22800.0 |
| 2000-09-15 13:00:00 | DIA | ETF | 110.625 | 110.625 | 110.125 | 110.125 | 21500.0 |
| 2000-09-15 14:00:00 | DIA | ETF | 110.25 | 110.25 | 109.375 | 109.6875 | 121700.0 |
| 2000-09-15 15:00:00 | DIA | ETF | 109.75 | 109.9375 | 109.1875 | 109.5 | 114700.0 |
| 2000-09-15 16:00:00 | DIA | ETF | 109.5312 | 109.5625 | 108.9688 | 109.0 | 31700.0 |
> showing 34 of 160 rows — these rows as CSV