PREVIEW / etf_1hour / 2000-07-21
file: by_date/etf_1hour/2000/2000-07-21.parquet size: 9 KB rows: 159
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-07-21 09:00:00 | SPY | ETF | 149.75 | 149.75 | 149.2812 | 149.5 | 750500.0 |
| 2000-07-21 10:00:00 | SPY | ETF | 149.5625 | 149.5625 | 148.2812 | 148.5 | 992000.0 |
| 2000-07-21 11:00:00 | SPY | ETF | 148.4375 | 148.8125 | 148.375 | 148.7188 | 275200.0 |
| 2000-07-21 12:00:00 | SPY | ETF | 148.75 | 148.9375 | 148.5312 | 148.5625 | 346100.0 |
| 2000-07-21 13:00:00 | SPY | ETF | 148.5625 | 148.7812 | 147.875 | 148.0 | 212000.0 |
| 2000-07-21 14:00:00 | SPY | ETF | 148.0312 | 148.4688 | 148.0 | 148.2188 | 1204200.0 |
| 2000-07-21 15:00:00 | SPY | ETF | 148.25 | 148.9062 | 148.125 | 148.25 | 1280000.0 |
| 2000-07-21 16:00:00 | SPY | ETF | 148.1875 | 148.375 | 147.6875 | 147.6875 | 596400.0 |
| 2000-07-21 09:00:00 | QQQ | ETF | 98.4375 | 99.1875 | 98.4375 | 98.75 | 2258000.0 |
| 2000-07-21 10:00:00 | QQQ | ETF | 98.75 | 98.75 | 97.125 | 97.5 | 3906200.0 |
| 2000-07-21 11:00:00 | QQQ | ETF | 97.5625 | 98.0938 | 97.4375 | 98.0938 | 1959200.0 |
| 2000-07-21 12:00:00 | QQQ | ETF | 98.0938 | 98.6875 | 98.0 | 98.1875 | 1763500.0 |
| 2000-07-21 13:00:00 | QQQ | ETF | 98.1875 | 98.4375 | 97.5 | 97.6562 | 784500.0 |
| 2000-07-21 14:00:00 | QQQ | ETF | 97.625 | 98.125 | 97.5 | 97.9375 | 776000.0 |
| 2000-07-21 15:00:00 | QQQ | ETF | 97.9375 | 98.4062 | 97.375 | 97.6875 | 2264600.0 |
| 2000-07-21 16:00:00 | QQQ | ETF | 97.5938 | 97.7188 | 97.3125 | 97.3125 | 652500.0 |
| 2000-07-21 17:00:00 | QQQ | ETF | 97.3125 | 97.3125 | 97.3125 | 97.3125 | 700.0 |
| 2000-07-21 18:00:00 | QQQ | ETF | 97.375 | 97.5 | 97.0 | 97.0 | 1300.0 |
| 2000-07-21 10:00:00 | IWM | ETF | 53.1875 | 53.1875 | 52.5 | 52.6094 | 9800.0 |
| 2000-07-21 11:00:00 | IWM | ETF | 52.6875 | 52.7031 | 52.5 | 52.6406 | 4200.0 |
| 2000-07-21 12:00:00 | IWM | ETF | 52.75 | 52.75 | 52.6562 | 52.6562 | 40800.0 |
| 2000-07-21 13:00:00 | IWM | ETF | 52.625 | 52.625 | 52.5 | 52.5 | 600.0 |
| 2000-07-21 14:00:00 | IWM | ETF | 52.5938 | 52.5938 | 52.5 | 52.5 | 31400.0 |
| 2000-07-21 15:00:00 | IWM | ETF | 52.625 | 52.625 | 52.4688 | 52.625 | 1600.0 |
| 2000-07-21 16:00:00 | IWM | ETF | 52.1562 | 52.25 | 52.0312 | 52.0312 | 62200.0 |
| 2000-07-21 09:00:00 | DIA | ETF | 108.0312 | 108.3438 | 108.0 | 108.0938 | 108100.0 |
| 2000-07-21 10:00:00 | DIA | ETF | 108.0625 | 108.25 | 107.375 | 107.5938 | 81300.0 |
| 2000-07-21 11:00:00 | DIA | ETF | 107.6875 | 107.6875 | 107.25 | 107.4688 | 28700.0 |
| 2000-07-21 12:00:00 | DIA | ETF | 107.3125 | 107.6875 | 107.3125 | 107.5938 | 12800.0 |
| 2000-07-21 13:00:00 | DIA | ETF | 107.4062 | 107.6875 | 107.0625 | 107.25 | 31400.0 |
| 2000-07-21 14:00:00 | DIA | ETF | 107.3438 | 107.4062 | 107.0312 | 107.4062 | 130600.0 |
| 2000-07-21 15:00:00 | DIA | ETF | 107.2188 | 107.6875 | 107.2188 | 107.2812 | 71600.0 |
| 2000-07-21 16:00:00 | DIA | ETF | 107.2188 | 107.25 | 107.0 | 107.0 | 6500.0 |
> showing 33 of 159 rows — these rows as CSV