PREVIEW / etf_1hour / 2000-11-09
file: by_date/etf_1hour/2000/2000-11-09.parquet size: 10 KB rows: 179
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-09 09:00:00 | SPY | ETF | 140.0 | 140.5 | 139.0625 | 140.2812 | 1926300.0 |
| 2000-11-09 10:00:00 | SPY | ETF | 140.4062 | 141.2188 | 139.8438 | 140.5625 | 1051400.0 |
| 2000-11-09 11:00:00 | SPY | ETF | 140.5625 | 140.7188 | 140.0625 | 140.4688 | 221800.0 |
| 2000-11-09 12:00:00 | SPY | ETF | 140.6562 | 140.6562 | 139.4062 | 139.7188 | 340600.0 |
| 2000-11-09 13:00:00 | SPY | ETF | 139.625 | 139.8125 | 137.25 | 137.9688 | 1768800.0 |
| 2000-11-09 14:00:00 | SPY | ETF | 138.0 | 140.3438 | 137.8438 | 140.0312 | 2072600.0 |
| 2000-11-09 15:00:00 | SPY | ETF | 140.0312 | 140.75 | 139.125 | 140.4062 | 1262600.0 |
| 2000-11-09 16:00:00 | SPY | ETF | 140.4062 | 140.4062 | 138.1562 | 139.8438 | 1304200.0 |
| 2000-11-09 09:00:00 | QQQ | ETF | 74.75 | 75.875 | 73.7812 | 75.8438 | 11986500.0 |
| 2000-11-09 10:00:00 | QQQ | ETF | 75.75 | 76.9375 | 74.75 | 75.8438 | 9593000.0 |
| 2000-11-09 11:00:00 | QQQ | ETF | 75.75 | 76.0 | 74.9375 | 76.0 | 4019800.0 |
| 2000-11-09 12:00:00 | QQQ | ETF | 76.0 | 76.1875 | 74.375 | 74.9062 | 4382100.0 |
| 2000-11-09 13:00:00 | QQQ | ETF | 74.9375 | 75.25 | 73.0 | 73.7188 | 11349300.0 |
| 2000-11-09 14:00:00 | QQQ | ETF | 73.75 | 76.125 | 73.625 | 75.7812 | 11296900.0 |
| 2000-11-09 15:00:00 | QQQ | ETF | 75.7812 | 76.625 | 74.875 | 76.3125 | 6716000.0 |
| 2000-11-09 16:00:00 | QQQ | ETF | 76.2812 | 76.5 | 75.0 | 76.0625 | 1609600.0 |
| 2000-11-09 17:00:00 | QQQ | ETF | 76.0 | 76.125 | 75.5 | 76.0 | 14200.0 |
| 2000-11-09 18:00:00 | QQQ | ETF | 75.75 | 75.75 | 75.25 | 75.25 | 4100.0 |
| 2000-11-09 09:00:00 | IWM | ETF | 49.375 | 49.5 | 49.125 | 49.4688 | 57000.0 |
| 2000-11-09 10:00:00 | IWM | ETF | 49.3438 | 49.6875 | 49.3438 | 49.6562 | 38200.0 |
| 2000-11-09 11:00:00 | IWM | ETF | 49.4688 | 49.5 | 49.2344 | 49.4375 | 33200.0 |
| 2000-11-09 12:00:00 | IWM | ETF | 49.2812 | 49.2812 | 49.2188 | 49.2188 | 5600.0 |
| 2000-11-09 13:00:00 | IWM | ETF | 49.0625 | 49.1875 | 48.7188 | 48.7188 | 56400.0 |
| 2000-11-09 14:00:00 | IWM | ETF | 48.5312 | 49.1562 | 48.5312 | 49.1562 | 34000.0 |
| 2000-11-09 15:00:00 | IWM | ETF | 49.125 | 49.4688 | 49.125 | 49.375 | 24200.0 |
| 2000-11-09 16:00:00 | IWM | ETF | 49.3125 | 49.3125 | 49.25 | 49.25 | 400.0 |
| 2000-11-09 09:00:00 | DIA | ETF | 107.9375 | 108.5625 | 107.4375 | 108.5625 | 447800.0 |
| 2000-11-09 10:00:00 | DIA | ETF | 108.5 | 108.9688 | 107.875 | 108.625 | 646900.0 |
| 2000-11-09 11:00:00 | DIA | ETF | 108.5 | 108.7188 | 108.3125 | 108.5625 | 118900.0 |
| 2000-11-09 12:00:00 | DIA | ETF | 108.75 | 108.875 | 107.5312 | 107.875 | 233500.0 |
| 2000-11-09 13:00:00 | DIA | ETF | 108.0312 | 108.1875 | 106.25 | 106.75 | 1097400.0 |
| 2000-11-09 14:00:00 | DIA | ETF | 106.8125 | 108.5938 | 106.625 | 108.3125 | 660900.0 |
| 2000-11-09 15:00:00 | DIA | ETF | 108.5625 | 108.9375 | 107.75 | 108.5 | 481200.0 |
| 2000-11-09 16:00:00 | DIA | ETF | 108.6562 | 108.6562 | 107.875 | 108.2188 | 26000.0 |
| 2000-11-09 18:00:00 | DIA | ETF | 108.0625 | 108.0625 | 108.0625 | 108.0625 | 300.0 |
> showing 35 of 179 rows — these rows as CSV