PREVIEW / etf_1hour / 2000-07-18
file: by_date/etf_1hour/2000/2000-07-18.parquet size: 9 KB rows: 171
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-18 09:00:00 | SPY | ETF | 150.625 | 150.625 | 150.25 | 150.4375 | 384500.0 |
| 2000-07-18 10:00:00 | SPY | ETF | 150.375 | 150.5312 | 149.8438 | 150.0 | 779200.0 |
| 2000-07-18 11:00:00 | SPY | ETF | 149.9375 | 149.9375 | 149.3438 | 149.7188 | 485300.0 |
| 2000-07-18 12:00:00 | SPY | ETF | 149.7188 | 150.0 | 149.625 | 149.625 | 142400.0 |
| 2000-07-18 13:00:00 | SPY | ETF | 149.75 | 150.125 | 149.625 | 149.9375 | 355800.0 |
| 2000-07-18 14:00:00 | SPY | ETF | 149.9375 | 150.0625 | 149.625 | 149.9062 | 218000.0 |
| 2000-07-18 15:00:00 | SPY | ETF | 150.0 | 150.125 | 149.3438 | 149.6875 | 1022200.0 |
| 2000-07-18 16:00:00 | SPY | ETF | 149.875 | 149.9375 | 149.5625 | 149.75 | 783800.0 |
| 2000-07-18 09:00:00 | QQQ | ETF | 100.375 | 100.7812 | 100.0625 | 100.5 | 2870800.0 |
| 2000-07-18 10:00:00 | QQQ | ETF | 100.5625 | 100.625 | 99.125 | 99.3125 | 4267100.0 |
| 2000-07-18 11:00:00 | QQQ | ETF | 99.375 | 99.4375 | 98.3438 | 99.0625 | 4031000.0 |
| 2000-07-18 12:00:00 | QQQ | ETF | 99.0625 | 99.6562 | 98.9375 | 99.4375 | 1418200.0 |
| 2000-07-18 13:00:00 | QQQ | ETF | 99.4375 | 99.875 | 99.1875 | 99.5 | 1540000.0 |
| 2000-07-18 14:00:00 | QQQ | ETF | 99.5 | 99.875 | 99.125 | 99.6875 | 1816600.0 |
| 2000-07-18 15:00:00 | QQQ | ETF | 99.6875 | 99.7188 | 98.75 | 99.0 | 4070600.0 |
| 2000-07-18 16:00:00 | QQQ | ETF | 99.125 | 99.5 | 99.0 | 99.25 | 599700.0 |
| 2000-07-18 17:00:00 | QQQ | ETF | 99.3125 | 99.375 | 99.0625 | 99.375 | 6800.0 |
| 2000-07-18 18:00:00 | QQQ | ETF | 99.375 | 99.5 | 99.0 | 99.5 | 4300.0 |
| 2000-07-18 09:00:00 | IWM | ETF | 54.1406 | 54.1406 | 54.1406 | 54.1406 | 400.0 |
| 2000-07-18 10:00:00 | IWM | ETF | 53.9688 | 54.0312 | 53.75 | 53.75 | 17400.0 |
| 2000-07-18 11:00:00 | IWM | ETF | 53.7031 | 53.75 | 53.5625 | 53.5625 | 6200.0 |
| 2000-07-18 12:00:00 | IWM | ETF | 53.7969 | 53.8125 | 53.75 | 53.75 | 1400.0 |
| 2000-07-18 13:00:00 | IWM | ETF | 53.8906 | 53.8906 | 53.875 | 53.875 | 400.0 |
| 2000-07-18 14:00:00 | IWM | ETF | 53.9062 | 54.0156 | 53.9062 | 53.9844 | 105200.0 |
| 2000-07-18 15:00:00 | IWM | ETF | 53.875 | 53.875 | 53.6875 | 53.6875 | 104000.0 |
| 2000-07-18 16:00:00 | IWM | ETF | 53.5625 | 53.5625 | 53.5625 | 53.5625 | 400.0 |
| 2000-07-18 09:00:00 | DIA | ETF | 107.5625 | 108.0 | 107.5625 | 107.6875 | 36200.0 |
| 2000-07-18 10:00:00 | DIA | ETF | 107.8125 | 107.9062 | 107.3125 | 107.4062 | 69600.0 |
| 2000-07-18 11:00:00 | DIA | ETF | 107.375 | 107.4375 | 107.0312 | 107.4375 | 99600.0 |
| 2000-07-18 12:00:00 | DIA | ETF | 107.3438 | 107.4688 | 107.1875 | 107.25 | 40300.0 |
| 2000-07-18 13:00:00 | DIA | ETF | 107.3125 | 107.6562 | 107.25 | 107.5625 | 20800.0 |
| 2000-07-18 14:00:00 | DIA | ETF | 107.4688 | 107.8125 | 107.4375 | 107.5938 | 42900.0 |
| 2000-07-18 15:00:00 | DIA | ETF | 107.5312 | 107.75 | 107.2812 | 107.6562 | 28700.0 |
| 2000-07-18 16:00:00 | DIA | ETF | 107.5625 | 107.625 | 107.5625 | 107.625 | 6000.0 |
> showing 34 of 171 rows — these rows as CSV