PREVIEW / etf_1hour / 2000-09-08
file: by_date/etf_1hour/2000/2000-09-08.parquet size: 9 KB rows: 175
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-08 09:00:00 | SPY | ETF | 150.2812 | 150.4375 | 150.0938 | 150.25 | 439500.0 |
| 2000-09-08 10:00:00 | SPY | ETF | 150.25 | 150.5 | 149.5 | 149.5625 | 693700.0 |
| 2000-09-08 11:00:00 | SPY | ETF | 149.5625 | 150.0 | 149.3125 | 149.7812 | 555100.0 |
| 2000-09-08 12:00:00 | SPY | ETF | 149.8438 | 150.3438 | 149.6562 | 150.0625 | 129900.0 |
| 2000-09-08 13:00:00 | SPY | ETF | 150.0312 | 150.4688 | 149.875 | 150.125 | 120700.0 |
| 2000-09-08 14:00:00 | SPY | ETF | 150.125 | 150.1562 | 149.6562 | 149.6562 | 399300.0 |
| 2000-09-08 15:00:00 | SPY | ETF | 149.7188 | 150.125 | 149.5625 | 149.7188 | 699300.0 |
| 2000-09-08 16:00:00 | SPY | ETF | 149.75 | 149.875 | 149.6562 | 149.8125 | 453500.0 |
| 2000-09-08 09:00:00 | QQQ | ETF | 97.75 | 98.0 | 96.5625 | 96.7188 | 2649000.0 |
| 2000-09-08 10:00:00 | QQQ | ETF | 96.7188 | 97.0312 | 95.3125 | 95.5 | 5953000.0 |
| 2000-09-08 11:00:00 | QQQ | ETF | 95.5 | 96.8438 | 95.2812 | 96.3125 | 3823500.0 |
| 2000-09-08 12:00:00 | QQQ | ETF | 96.25 | 97.2188 | 96.1875 | 96.75 | 1647400.0 |
| 2000-09-08 13:00:00 | QQQ | ETF | 96.8125 | 97.0625 | 96.4375 | 96.4688 | 1632000.0 |
| 2000-09-08 14:00:00 | QQQ | ETF | 96.4375 | 96.5625 | 95.5625 | 95.625 | 1840800.0 |
| 2000-09-08 15:00:00 | QQQ | ETF | 95.625 | 96.1875 | 95.1875 | 95.3125 | 4479700.0 |
| 2000-09-08 16:00:00 | QQQ | ETF | 95.3125 | 95.375 | 94.75 | 95.0625 | 1411800.0 |
| 2000-09-08 17:00:00 | QQQ | ETF | 95.0625 | 95.1875 | 95.0 | 95.1875 | 8000.0 |
| 2000-09-08 18:00:00 | QQQ | ETF | 95.1875 | 95.1875 | 95.0625 | 95.125 | 2000.0 |
| 2000-09-08 09:00:00 | IWM | ETF | 54.0938 | 54.0938 | 54.0938 | 54.0938 | 200.0 |
| 2000-09-08 10:00:00 | IWM | ETF | 54.2188 | 54.2188 | 53.9062 | 53.9062 | 1400.0 |
| 2000-09-08 11:00:00 | IWM | ETF | 53.8125 | 53.875 | 53.7812 | 53.8438 | 7400.0 |
| 2000-09-08 12:00:00 | IWM | ETF | 54.0938 | 54.1719 | 54.0938 | 54.1719 | 400.0 |
| 2000-09-08 13:00:00 | IWM | ETF | 54.1562 | 54.1562 | 54.1562 | 54.1562 | 1000.0 |
| 2000-09-08 15:00:00 | IWM | ETF | 54.0625 | 54.0625 | 53.7656 | 53.7656 | 117200.0 |
| 2000-09-08 16:00:00 | IWM | ETF | 53.4531 | 53.6094 | 53.4375 | 53.4375 | 1000.0 |
| 2000-09-08 09:00:00 | DIA | ETF | 112.25 | 112.6875 | 112.1875 | 112.3125 | 92500.0 |
| 2000-09-08 10:00:00 | DIA | ETF | 112.3438 | 112.7812 | 112.125 | 112.125 | 114600.0 |
| 2000-09-08 11:00:00 | DIA | ETF | 112.125 | 112.2188 | 111.875 | 112.125 | 17600.0 |
| 2000-09-08 12:00:00 | DIA | ETF | 112.1562 | 112.3438 | 112.0 | 112.25 | 11800.0 |
| 2000-09-08 13:00:00 | DIA | ETF | 112.25 | 112.375 | 112.0 | 112.1875 | 14300.0 |
| 2000-09-08 14:00:00 | DIA | ETF | 112.2188 | 112.375 | 112.0 | 112.125 | 23500.0 |
| 2000-09-08 15:00:00 | DIA | ETF | 112.125 | 112.5 | 111.9062 | 112.2188 | 113600.0 |
| 2000-09-08 16:00:00 | DIA | ETF | 112.25 | 112.25 | 112.0625 | 112.0938 | 31400.0 |
> showing 33 of 175 rows — these rows as CSV