PREVIEW / etf_1hour / 2000-11-27
file: by_date/etf_1hour/2000/2000-11-27.parquet size: 10 KB rows: 183
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-11-27 09:00:00 | SPY | ETF | 136.4688 | 136.5 | 135.9062 | 136.4375 | 1518700.0 |
| 2000-11-27 10:00:00 | SPY | ETF | 136.2812 | 136.6875 | 135.8125 | 136.4688 | 1240000.0 |
| 2000-11-27 11:00:00 | SPY | ETF | 136.5312 | 136.5625 | 135.8125 | 136.0625 | 1413200.0 |
| 2000-11-27 12:00:00 | SPY | ETF | 136.0938 | 136.2188 | 135.5 | 135.9688 | 203100.0 |
| 2000-11-27 13:00:00 | SPY | ETF | 135.8125 | 136.25 | 135.75 | 135.75 | 145000.0 |
| 2000-11-27 14:00:00 | SPY | ETF | 135.8125 | 135.9375 | 135.3125 | 135.8125 | 277500.0 |
| 2000-11-27 15:00:00 | SPY | ETF | 135.75 | 136.5 | 135.3125 | 135.5 | 588100.0 |
| 2000-11-27 16:00:00 | SPY | ETF | 135.375 | 136.0312 | 135.3438 | 136.0312 | 296800.0 |
| 2000-11-27 09:00:00 | QQQ | ETF | 72.5625 | 72.9375 | 72.0 | 72.25 | 7673800.0 |
| 2000-11-27 10:00:00 | QQQ | ETF | 72.25 | 72.3438 | 70.625 | 71.1562 | 6985600.0 |
| 2000-11-27 11:00:00 | QQQ | ETF | 71.1562 | 71.375 | 70.2812 | 70.7812 | 3481300.0 |
| 2000-11-27 12:00:00 | QQQ | ETF | 70.75 | 70.875 | 69.8125 | 70.1562 | 3540200.0 |
| 2000-11-27 13:00:00 | QQQ | ETF | 70.2188 | 70.6875 | 69.625 | 69.6875 | 2942600.0 |
| 2000-11-27 14:00:00 | QQQ | ETF | 69.7188 | 69.75 | 68.75 | 69.3438 | 3871600.0 |
| 2000-11-27 15:00:00 | QQQ | ETF | 69.4375 | 70.4375 | 69.0 | 69.125 | 5025300.0 |
| 2000-11-27 16:00:00 | QQQ | ETF | 69.125 | 70.1875 | 69.0625 | 69.5 | 587800.0 |
| 2000-11-27 17:00:00 | QQQ | ETF | 69.5625 | 69.625 | 69.375 | 69.5625 | 5300.0 |
| 2000-11-27 18:00:00 | QQQ | ETF | 70.0 | 70.0 | 69.375 | 69.375 | 2100.0 |
| 2000-11-27 09:00:00 | IWM | ETF | 47.9062 | 48.0 | 47.7812 | 47.7812 | 12000.0 |
| 2000-11-27 10:00:00 | IWM | ETF | 48.0469 | 48.0469 | 47.8125 | 47.8438 | 15800.0 |
| 2000-11-27 11:00:00 | IWM | ETF | 47.7812 | 47.7812 | 47.625 | 47.625 | 4400.0 |
| 2000-11-27 12:00:00 | IWM | ETF | 47.5938 | 47.6406 | 47.4219 | 47.4219 | 109800.0 |
| 2000-11-27 13:00:00 | IWM | ETF | 47.5 | 47.5 | 47.5 | 47.5 | 6000.0 |
| 2000-11-27 14:00:00 | IWM | ETF | 47.4375 | 47.4688 | 47.2188 | 47.2188 | 3600.0 |
| 2000-11-27 15:00:00 | IWM | ETF | 47.4688 | 47.5625 | 47.0625 | 47.0625 | 48000.0 |
| 2000-11-27 16:00:00 | IWM | ETF | 47.0625 | 47.0625 | 47.0625 | 47.0625 | 30000.0 |
| 2000-11-27 09:00:00 | DIA | ETF | 106.1875 | 106.25 | 105.6562 | 106.0 | 213300.0 |
| 2000-11-27 10:00:00 | DIA | ETF | 106.0625 | 106.3438 | 105.6562 | 106.2188 | 61500.0 |
| 2000-11-27 11:00:00 | DIA | ETF | 106.125 | 106.2812 | 105.6875 | 106.0625 | 58200.0 |
| 2000-11-27 12:00:00 | DIA | ETF | 106.0 | 106.0938 | 105.625 | 105.7812 | 75800.0 |
| 2000-11-27 13:00:00 | DIA | ETF | 105.7812 | 106.1562 | 105.7812 | 105.8125 | 41100.0 |
| 2000-11-27 14:00:00 | DIA | ETF | 105.875 | 106.0938 | 105.6562 | 106.0 | 51800.0 |
| 2000-11-27 15:00:00 | DIA | ETF | 106.0312 | 106.4688 | 105.4688 | 105.625 | 212900.0 |
| 2000-11-27 16:00:00 | DIA | ETF | 105.6562 | 105.875 | 105.5938 | 105.875 | 25700.0 |
> showing 34 of 183 rows — these rows as CSV