PREVIEW / etf_1hour / 2000-12-06
file: by_date/etf_1hour/2000/2000-12-06.parquet size: 10 KB rows: 197
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-12-06 09:00:00 | SPY | ETF | 137.7812 | 138.3438 | 137.25 | 137.5 | 2171600.0 |
| 2000-12-06 10:00:00 | SPY | ETF | 137.5938 | 138.0 | 137.125 | 137.7188 | 2403000.0 |
| 2000-12-06 11:00:00 | SPY | ETF | 137.6875 | 137.9688 | 137.125 | 137.125 | 1265600.0 |
| 2000-12-06 12:00:00 | SPY | ETF | 137.0938 | 137.4375 | 137.0312 | 137.1875 | 462200.0 |
| 2000-12-06 13:00:00 | SPY | ETF | 137.1875 | 137.3438 | 135.375 | 136.25 | 2077200.0 |
| 2000-12-06 14:00:00 | SPY | ETF | 136.25 | 136.5938 | 135.375 | 135.6875 | 1814400.0 |
| 2000-12-06 15:00:00 | SPY | ETF | 135.625 | 136.25 | 135.0312 | 135.5312 | 1529000.0 |
| 2000-12-06 16:00:00 | SPY | ETF | 135.6875 | 136.0 | 135.1562 | 135.6875 | 390400.0 |
| 2000-12-06 09:00:00 | QQQ | ETF | 70.5938 | 72.2812 | 70.0 | 71.125 | 12156800.0 |
| 2000-12-06 10:00:00 | QQQ | ETF | 71.125 | 71.3438 | 69.8125 | 71.3125 | 12281900.0 |
| 2000-12-06 11:00:00 | QQQ | ETF | 71.2188 | 72.0 | 70.0 | 70.0 | 7766600.0 |
| 2000-12-06 12:00:00 | QQQ | ETF | 70.0 | 70.75 | 69.875 | 70.4375 | 3634100.0 |
| 2000-12-06 13:00:00 | QQQ | ETF | 70.4688 | 70.6875 | 68.875 | 69.5312 | 5981100.0 |
| 2000-12-06 14:00:00 | QQQ | ETF | 69.75 | 69.9062 | 68.4375 | 68.9062 | 7637100.0 |
| 2000-12-06 15:00:00 | QQQ | ETF | 68.9062 | 69.4375 | 67.75 | 68.8125 | 9179900.0 |
| 2000-12-06 16:00:00 | QQQ | ETF | 68.8125 | 72.0 | 65.75 | 68.0 | 1588700.0 |
| 2000-12-06 17:00:00 | QQQ | ETF | 68.0 | 68.25 | 67.25 | 68.0938 | 67200.0 |
| 2000-12-06 18:00:00 | QQQ | ETF | 68.125 | 68.25 | 67.875 | 67.875 | 10000.0 |
| 2000-12-06 09:00:00 | IWM | ETF | 47.0938 | 47.5312 | 47.0938 | 47.5312 | 16800.0 |
| 2000-12-06 10:00:00 | IWM | ETF | 47.4375 | 47.4688 | 47.2812 | 47.375 | 7600.0 |
| 2000-12-06 11:00:00 | IWM | ETF | 47.5 | 47.5 | 47.2812 | 47.3438 | 42600.0 |
| 2000-12-06 12:00:00 | IWM | ETF | 47.3438 | 47.4062 | 47.1875 | 47.3125 | 20200.0 |
| 2000-12-06 13:00:00 | IWM | ETF | 47.3281 | 47.3281 | 46.9062 | 47.0625 | 53400.0 |
| 2000-12-06 14:00:00 | IWM | ETF | 47.0312 | 47.0312 | 46.4062 | 46.4688 | 82000.0 |
| 2000-12-06 15:00:00 | IWM | ETF | 46.5312 | 46.5625 | 46.25 | 46.5 | 19800.0 |
| 2000-12-06 16:00:00 | IWM | ETF | 46.1562 | 46.1562 | 46.1562 | 46.1562 | 200.0 |
| 2000-12-06 09:00:00 | DIA | ETF | 108.5 | 108.8438 | 108.375 | 108.4375 | 158200.0 |
| 2000-12-06 10:00:00 | DIA | ETF | 108.3438 | 108.8438 | 108.125 | 108.5 | 565000.0 |
| 2000-12-06 11:00:00 | DIA | ETF | 108.5312 | 108.625 | 107.9375 | 107.9375 | 136100.0 |
| 2000-12-06 12:00:00 | DIA | ETF | 107.9688 | 108.1875 | 107.8125 | 108.0 | 73600.0 |
| 2000-12-06 13:00:00 | DIA | ETF | 107.9375 | 108.125 | 106.6875 | 107.375 | 302400.0 |
| 2000-12-06 14:00:00 | DIA | ETF | 107.4062 | 107.5938 | 106.6562 | 107.0938 | 187400.0 |
| 2000-12-06 15:00:00 | DIA | ETF | 107.0 | 107.2188 | 106.25 | 106.8125 | 265100.0 |
| 2000-12-06 16:00:00 | DIA | ETF | 106.875 | 106.875 | 106.4375 | 106.625 | 19100.0 |
> showing 34 of 197 rows — these rows as CSV