PREVIEW / etf_1hour / 2000-08-04
file: by_date/etf_1hour/2000/2000-08-04.parquet size: 9 KB rows: 181
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-04 09:00:00 | SPY | ETF | 146.3125 | 146.5625 | 145.8438 | 146.0625 | 709800.0 |
| 2000-08-04 10:00:00 | SPY | ETF | 146.0 | 146.5312 | 145.4062 | 145.625 | 672800.0 |
| 2000-08-04 11:00:00 | SPY | ETF | 145.5 | 146.2188 | 145.4688 | 146.0625 | 244500.0 |
| 2000-08-04 12:00:00 | SPY | ETF | 146.0625 | 146.25 | 145.625 | 146.0938 | 135500.0 |
| 2000-08-04 13:00:00 | SPY | ETF | 146.125 | 146.3125 | 145.75 | 146.0938 | 265100.0 |
| 2000-08-04 14:00:00 | SPY | ETF | 146.0625 | 146.625 | 145.9375 | 146.1875 | 286200.0 |
| 2000-08-04 15:00:00 | SPY | ETF | 146.2188 | 146.7188 | 145.625 | 146.5312 | 1057400.0 |
| 2000-08-04 16:00:00 | SPY | ETF | 146.4375 | 146.5938 | 146.3438 | 146.375 | 265300.0 |
| 2000-08-04 09:00:00 | QQQ | ETF | 92.0 | 92.75 | 91.0625 | 92.0312 | 5295400.0 |
| 2000-08-04 10:00:00 | QQQ | ETF | 92.125 | 92.625 | 89.875 | 90.3438 | 5174800.0 |
| 2000-08-04 11:00:00 | QQQ | ETF | 90.3438 | 91.25 | 90.0625 | 90.9688 | 2243300.0 |
| 2000-08-04 12:00:00 | QQQ | ETF | 90.9375 | 90.9375 | 89.5 | 90.125 | 2263900.0 |
| 2000-08-04 13:00:00 | QQQ | ETF | 90.1875 | 90.375 | 89.125 | 89.7188 | 1892500.0 |
| 2000-08-04 14:00:00 | QQQ | ETF | 89.6562 | 90.875 | 89.25 | 90.1562 | 2224100.0 |
| 2000-08-04 15:00:00 | QQQ | ETF | 89.9375 | 90.4688 | 89.125 | 90.25 | 2605400.0 |
| 2000-08-04 16:00:00 | QQQ | ETF | 90.2188 | 90.3125 | 89.9375 | 90.1875 | 542000.0 |
| 2000-08-04 17:00:00 | QQQ | ETF | 90.125 | 90.125 | 90.125 | 90.125 | 600.0 |
| 2000-08-04 18:00:00 | QQQ | ETF | 90.125 | 90.125 | 90.125 | 90.125 | 200.0 |
| 2000-08-04 09:00:00 | IWM | ETF | 50.5625 | 50.5781 | 50.25 | 50.25 | 142600.0 |
| 2000-08-04 10:00:00 | IWM | ETF | 50.3906 | 50.4375 | 50.0 | 50.0 | 11200.0 |
| 2000-08-04 11:00:00 | IWM | ETF | 50.0938 | 50.2344 | 49.9219 | 50.0781 | 1400.0 |
| 2000-08-04 12:00:00 | IWM | ETF | 50.0938 | 50.125 | 50.0938 | 50.125 | 12000.0 |
| 2000-08-04 13:00:00 | IWM | ETF | 50.125 | 50.125 | 50.125 | 50.125 | 400.0 |
| 2000-08-04 14:00:00 | IWM | ETF | 50.25 | 50.4062 | 50.25 | 50.25 | 19000.0 |
| 2000-08-04 15:00:00 | IWM | ETF | 50.25 | 50.4062 | 50.1875 | 50.4062 | 331000.0 |
| 2000-08-04 16:00:00 | IWM | ETF | 50.3438 | 50.3438 | 50.2188 | 50.2188 | 52800.0 |
| 2000-08-04 09:00:00 | DIA | ETF | 107.125 | 107.375 | 106.625 | 106.875 | 46800.0 |
| 2000-08-04 10:00:00 | DIA | ETF | 106.6875 | 107.2188 | 106.6875 | 106.875 | 126000.0 |
| 2000-08-04 11:00:00 | DIA | ETF | 106.8125 | 107.25 | 106.75 | 107.0938 | 527000.0 |
| 2000-08-04 12:00:00 | DIA | ETF | 107.0938 | 107.2188 | 106.8125 | 107.125 | 5000.0 |
| 2000-08-04 13:00:00 | DIA | ETF | 107.0625 | 107.2188 | 106.9375 | 107.0 | 5900.0 |
| 2000-08-04 14:00:00 | DIA | ETF | 107.125 | 107.4688 | 107.125 | 107.125 | 16100.0 |
| 2000-08-04 15:00:00 | DIA | ETF | 107.1562 | 107.7188 | 107.0312 | 107.6875 | 133400.0 |
| 2000-08-04 16:00:00 | DIA | ETF | 107.4062 | 107.5 | 107.4062 | 107.5 | 19800.0 |
| 2000-08-04 17:00:00 | DIA | ETF | 107.5 | 107.5 | 107.5 | 107.5 | 100.0 |
> showing 35 of 181 rows — these rows as CSV