PREVIEW / etf_1hour / 2000-08-15
file: by_date/etf_1hour/2000/2000-08-15.parquet size: 9 KB rows: 177
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-08-15 09:00:00 | SPY | ETF | 149.3438 | 149.4062 | 149.0625 | 149.2188 | 416400.0 |
| 2000-08-15 10:00:00 | SPY | ETF | 149.3125 | 149.5938 | 148.8125 | 149.0625 | 709100.0 |
| 2000-08-15 11:00:00 | SPY | ETF | 149.0625 | 149.1562 | 148.5625 | 148.9375 | 749700.0 |
| 2000-08-15 12:00:00 | SPY | ETF | 149.0 | 149.2188 | 148.8125 | 149.125 | 472800.0 |
| 2000-08-15 13:00:00 | SPY | ETF | 149.125 | 149.3125 | 148.8125 | 148.9375 | 568000.0 |
| 2000-08-15 14:00:00 | SPY | ETF | 149.0938 | 149.8125 | 149.0312 | 149.6875 | 373100.0 |
| 2000-08-15 15:00:00 | SPY | ETF | 149.625 | 149.7188 | 148.625 | 149.0312 | 1319400.0 |
| 2000-08-15 16:00:00 | SPY | ETF | 149.0625 | 149.1562 | 148.875 | 149.1562 | 904000.0 |
| 2000-08-15 09:00:00 | QQQ | ETF | 92.75 | 93.125 | 92.375 | 92.625 | 1684500.0 |
| 2000-08-15 10:00:00 | QQQ | ETF | 92.625 | 93.6875 | 92.5 | 93.0625 | 3090900.0 |
| 2000-08-15 11:00:00 | QQQ | ETF | 93.0625 | 93.125 | 92.0 | 92.4688 | 1759800.0 |
| 2000-08-15 12:00:00 | QQQ | ETF | 92.4375 | 92.75 | 92.0625 | 92.6562 | 944800.0 |
| 2000-08-15 13:00:00 | QQQ | ETF | 92.625 | 92.875 | 92.25 | 92.4375 | 984100.0 |
| 2000-08-15 14:00:00 | QQQ | ETF | 92.4375 | 93.9688 | 92.4375 | 93.9375 | 2352800.0 |
| 2000-08-15 15:00:00 | QQQ | ETF | 93.9375 | 93.9375 | 92.625 | 92.9688 | 2760000.0 |
| 2000-08-15 16:00:00 | QQQ | ETF | 92.9375 | 93.1875 | 92.875 | 93.1875 | 428300.0 |
| 2000-08-15 17:00:00 | QQQ | ETF | 93.0 | 93.0 | 93.0 | 93.0 | 400.0 |
| 2000-08-15 09:00:00 | IWM | ETF | 51.5469 | 51.5469 | 51.3125 | 51.3125 | 2400.0 |
| 2000-08-15 10:00:00 | IWM | ETF | 51.5156 | 51.625 | 51.25 | 51.25 | 9600.0 |
| 2000-08-15 11:00:00 | IWM | ETF | 51.0469 | 51.2812 | 51.0469 | 51.2812 | 3200.0 |
| 2000-08-15 12:00:00 | IWM | ETF | 51.25 | 51.25 | 51.0312 | 51.2188 | 51200.0 |
| 2000-08-15 13:00:00 | IWM | ETF | 51.125 | 51.2031 | 51.125 | 51.2031 | 2400.0 |
| 2000-08-15 14:00:00 | IWM | ETF | 51.2812 | 51.3438 | 51.125 | 51.3438 | 4400.0 |
| 2000-08-15 15:00:00 | IWM | ETF | 51.3438 | 51.3438 | 50.9062 | 50.9062 | 116000.0 |
| 2000-08-15 09:00:00 | DIA | ETF | 111.4688 | 111.5 | 111.0938 | 111.25 | 101500.0 |
| 2000-08-15 10:00:00 | DIA | ETF | 111.2812 | 111.4062 | 110.7812 | 110.875 | 475900.0 |
| 2000-08-15 11:00:00 | DIA | ETF | 110.9375 | 110.9688 | 110.625 | 110.9062 | 235500.0 |
| 2000-08-15 12:00:00 | DIA | ETF | 110.9062 | 111.125 | 110.8125 | 111.125 | 46400.0 |
| 2000-08-15 13:00:00 | DIA | ETF | 111.0 | 111.2188 | 110.9062 | 110.9062 | 143300.0 |
| 2000-08-15 14:00:00 | DIA | ETF | 111.0625 | 111.3438 | 110.9375 | 111.3438 | 79800.0 |
| 2000-08-15 15:00:00 | DIA | ETF | 111.25 | 111.3438 | 110.6875 | 110.9688 | 162800.0 |
| 2000-08-15 16:00:00 | DIA | ETF | 111.0 | 111.0 | 110.75 | 110.9375 | 13000.0 |
> showing 32 of 177 rows — these rows as CSV