PREVIEW / etf_1hour / 2000-12-15
file: by_date/etf_1hour/2000/2000-12-15.parquet size: 10 KB rows: 199
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-12-15 09:00:00 | SPY | ETF | 133.125 | 133.125 | 131.9375 | 132.1875 | 1544900.0 |
| 2000-12-15 10:00:00 | SPY | ETF | 132.3438 | 132.3438 | 131.125 | 131.7812 | 1097100.0 |
| 2000-12-15 11:00:00 | SPY | ETF | 131.875 | 131.9375 | 131.0938 | 131.0938 | 1086900.0 |
| 2000-12-15 12:00:00 | SPY | ETF | 131.1875 | 131.25 | 130.5625 | 131.0938 | 696700.0 |
| 2000-12-15 13:00:00 | SPY | ETF | 131.0938 | 131.4062 | 130.7812 | 130.8125 | 830500.0 |
| 2000-12-15 14:00:00 | SPY | ETF | 130.8438 | 132.2188 | 130.8125 | 131.875 | 1040600.0 |
| 2000-12-15 15:00:00 | SPY | ETF | 131.9375 | 133.125 | 131.0625 | 131.4375 | 1727700.0 |
| 2000-12-15 16:00:00 | SPY | ETF | 131.3125 | 131.4688 | 130.75 | 131.0 | 591900.0 |
| 2000-12-15 09:00:00 | QQQ | ETF | 64.25 | 64.875 | 63.375 | 63.7188 | 7274700.0 |
| 2000-12-15 10:00:00 | QQQ | ETF | 63.75 | 64.0 | 62.9375 | 63.9375 | 9849600.0 |
| 2000-12-15 11:00:00 | QQQ | ETF | 63.9375 | 64.3125 | 63.0 | 63.1875 | 5546300.0 |
| 2000-12-15 12:00:00 | QQQ | ETF | 63.25 | 63.375 | 62.625 | 63.125 | 5772300.0 |
| 2000-12-15 13:00:00 | QQQ | ETF | 63.125 | 63.5 | 62.625 | 62.75 | 5043000.0 |
| 2000-12-15 14:00:00 | QQQ | ETF | 62.75 | 64.2188 | 62.5625 | 63.7812 | 7035100.0 |
| 2000-12-15 15:00:00 | QQQ | ETF | 63.625 | 65.625 | 63.375 | 63.8125 | 13798100.0 |
| 2000-12-15 16:00:00 | QQQ | ETF | 63.6875 | 64.375 | 63.625 | 64.0625 | 2319900.0 |
| 2000-12-15 17:00:00 | QQQ | ETF | 64.0625 | 64.375 | 63.9375 | 64.375 | 22700.0 |
| 2000-12-15 18:00:00 | QQQ | ETF | 64.375 | 64.5 | 64.3125 | 64.375 | 7300.0 |
| 2000-12-15 09:00:00 | IWM | ETF | 45.3438 | 45.6562 | 45.3281 | 45.3281 | 12000.0 |
| 2000-12-15 10:00:00 | IWM | ETF | 45.3438 | 45.5156 | 45.125 | 45.125 | 48200.0 |
| 2000-12-15 11:00:00 | IWM | ETF | 45.25 | 45.375 | 45.0 | 45.0 | 62000.0 |
| 2000-12-15 12:00:00 | IWM | ETF | 45.0625 | 45.1562 | 45.0312 | 45.1562 | 33800.0 |
| 2000-12-15 13:00:00 | IWM | ETF | 45.125 | 45.2812 | 45.0312 | 45.0312 | 29000.0 |
| 2000-12-15 14:00:00 | IWM | ETF | 45.1719 | 45.5312 | 45.1719 | 45.5 | 72600.0 |
| 2000-12-15 15:00:00 | IWM | ETF | 45.5 | 45.7031 | 45.4375 | 45.4375 | 58400.0 |
| 2000-12-15 16:00:00 | IWM | ETF | 45.625 | 45.625 | 45.625 | 45.625 | 10000.0 |
| 2000-12-15 09:00:00 | DIA | ETF | 105.75 | 106.25 | 105.25 | 105.4375 | 175300.0 |
| 2000-12-15 10:00:00 | DIA | ETF | 105.4375 | 105.75 | 104.7812 | 105.1875 | 316500.0 |
| 2000-12-15 11:00:00 | DIA | ETF | 105.0625 | 105.5 | 104.6562 | 104.875 | 277300.0 |
| 2000-12-15 12:00:00 | DIA | ETF | 104.875 | 105.0 | 104.5 | 104.625 | 67300.0 |
| 2000-12-15 13:00:00 | DIA | ETF | 104.75 | 105.0625 | 104.5 | 104.5 | 74400.0 |
| 2000-12-15 14:00:00 | DIA | ETF | 104.75 | 105.25 | 104.5 | 105.0 | 155400.0 |
| 2000-12-15 15:00:00 | DIA | ETF | 105.1875 | 105.75 | 104.25 | 104.5625 | 259100.0 |
| 2000-12-15 16:00:00 | DIA | ETF | 104.5938 | 104.5938 | 103.75 | 103.75 | 35100.0 |
> showing 34 of 199 rows — these rows as CSV