PREVIEW / etf_1hour / 2000-11-08
file: by_date/etf_1hour/2000/2000-11-08.parquet size: 10 KB rows: 185
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-08 09:00:00 | SPY | ETF | 144.0625 | 144.0625 | 143.1562 | 143.1875 | 658200.0 |
| 2000-11-08 10:00:00 | SPY | ETF | 143.125 | 143.1562 | 142.3125 | 142.75 | 1085400.0 |
| 2000-11-08 11:00:00 | SPY | ETF | 142.8438 | 143.2188 | 142.3438 | 142.8125 | 623400.0 |
| 2000-11-08 12:00:00 | SPY | ETF | 142.9688 | 143.0938 | 142.4375 | 142.6875 | 702900.0 |
| 2000-11-08 13:00:00 | SPY | ETF | 142.625 | 142.7812 | 141.7188 | 142.375 | 575400.0 |
| 2000-11-08 14:00:00 | SPY | ETF | 142.2188 | 142.5 | 141.75 | 142.1875 | 284100.0 |
| 2000-11-08 15:00:00 | SPY | ETF | 142.1875 | 142.4062 | 141.0312 | 141.25 | 1423200.0 |
| 2000-11-08 16:00:00 | SPY | ETF | 141.1875 | 141.1875 | 140.0 | 140.0 | 524200.0 |
| 2000-11-08 17:00:00 | SPY | ETF | 140.625 | 140.625 | 140.625 | 140.625 | 50000.0 |
| 2000-11-08 09:00:00 | QQQ | ETF | 82.125 | 82.25 | 80.8125 | 80.9375 | 2608600.0 |
| 2000-11-08 10:00:00 | QQQ | ETF | 80.75 | 80.9375 | 79.3125 | 79.5938 | 7031100.0 |
| 2000-11-08 11:00:00 | QQQ | ETF | 79.5625 | 79.9688 | 78.875 | 79.375 | 4510600.0 |
| 2000-11-08 12:00:00 | QQQ | ETF | 79.375 | 79.7812 | 78.5 | 78.875 | 2738100.0 |
| 2000-11-08 13:00:00 | QQQ | ETF | 78.8438 | 78.875 | 77.25 | 78.2812 | 6062400.0 |
| 2000-11-08 14:00:00 | QQQ | ETF | 78.2812 | 78.3125 | 77.3125 | 78.125 | 4935200.0 |
| 2000-11-08 15:00:00 | QQQ | ETF | 78.0938 | 78.2812 | 76.3125 | 76.3125 | 7735700.0 |
| 2000-11-08 16:00:00 | QQQ | ETF | 76.3125 | 77.0 | 75.625 | 77.0 | 3185600.0 |
| 2000-11-08 17:00:00 | QQQ | ETF | 76.0 | 76.25 | 75.625 | 75.75 | 58500.0 |
| 2000-11-08 18:00:00 | QQQ | ETF | 75.9375 | 76.25 | 75.8125 | 75.9375 | 13800.0 |
| 2000-11-08 09:00:00 | IWM | ETF | 50.7188 | 50.7188 | 50.6562 | 50.6562 | 1600.0 |
| 2000-11-08 10:00:00 | IWM | ETF | 50.5312 | 50.6562 | 50.5312 | 50.5938 | 23200.0 |
| 2000-11-08 11:00:00 | IWM | ETF | 50.5938 | 50.625 | 50.375 | 50.625 | 82600.0 |
| 2000-11-08 12:00:00 | IWM | ETF | 50.625 | 50.6406 | 50.625 | 50.625 | 20400.0 |
| 2000-11-08 13:00:00 | IWM | ETF | 50.75 | 50.75 | 50.4062 | 50.5 | 8200.0 |
| 2000-11-08 14:00:00 | IWM | ETF | 50.5156 | 50.5312 | 50.3438 | 50.3438 | 11400.0 |
| 2000-11-08 15:00:00 | IWM | ETF | 50.375 | 50.5156 | 50.0 | 50.0 | 24400.0 |
| 2000-11-08 16:00:00 | IWM | ETF | 49.8438 | 50.0 | 49.7812 | 49.7812 | 20400.0 |
| 2000-11-08 09:00:00 | DIA | ETF | 110.0938 | 110.2188 | 109.4375 | 109.5 | 177900.0 |
| 2000-11-08 10:00:00 | DIA | ETF | 109.5938 | 109.8438 | 109.0625 | 109.7188 | 373700.0 |
| 2000-11-08 11:00:00 | DIA | ETF | 109.5938 | 110.2188 | 109.375 | 109.9375 | 123700.0 |
| 2000-11-08 12:00:00 | DIA | ETF | 110.0625 | 110.0938 | 109.625 | 109.8125 | 119700.0 |
| 2000-11-08 13:00:00 | DIA | ETF | 109.6875 | 109.9375 | 109.25 | 109.6562 | 140100.0 |
| 2000-11-08 14:00:00 | DIA | ETF | 109.7812 | 109.875 | 109.375 | 109.5625 | 77200.0 |
| 2000-11-08 15:00:00 | DIA | ETF | 109.5625 | 109.7812 | 109.0 | 109.0 | 311100.0 |
| 2000-11-08 16:00:00 | DIA | ETF | 108.875 | 109.0625 | 108.75 | 108.75 | 95500.0 |
> showing 35 of 185 rows — these rows as CSV