PREVIEW / etf_1hour / 2000-10-18
file: by_date/etf_1hour/2000/2000-10-18.parquet size: 10 KB rows: 193
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-10-18 09:00:00 | SPY | ETF | 132.625 | 133.1562 | 130.1562 | 132.2188 | 2767800.0 |
| 2000-10-18 10:00:00 | SPY | ETF | 132.125 | 134.4062 | 132.0 | 133.9062 | 2209600.0 |
| 2000-10-18 11:00:00 | SPY | ETF | 134.0625 | 135.5 | 133.75 | 134.6875 | 1175700.0 |
| 2000-10-18 12:00:00 | SPY | ETF | 134.6875 | 135.2188 | 133.625 | 135.0 | 728700.0 |
| 2000-10-18 13:00:00 | SPY | ETF | 135.0625 | 135.125 | 133.9062 | 134.75 | 619900.0 |
| 2000-10-18 14:00:00 | SPY | ETF | 134.8125 | 136.125 | 134.5625 | 135.7812 | 932800.0 |
| 2000-10-18 15:00:00 | SPY | ETF | 135.8125 | 135.9375 | 134.1875 | 134.4062 | 1307700.0 |
| 2000-10-18 16:00:00 | SPY | ETF | 134.3125 | 135.0 | 134.0625 | 134.0625 | 1019700.0 |
| 2000-10-18 17:00:00 | SPY | ETF | 135.0625 | 135.25 | 134.875 | 134.875 | 5100.0 |
| 2000-10-18 09:00:00 | QQQ | ETF | 76.75 | 76.875 | 74.5625 | 75.9375 | 12614100.0 |
| 2000-10-18 10:00:00 | QQQ | ETF | 75.9375 | 79.6875 | 75.75 | 78.75 | 11738300.0 |
| 2000-10-18 11:00:00 | QQQ | ETF | 78.7812 | 80.7188 | 78.3125 | 79.5625 | 11736400.0 |
| 2000-10-18 12:00:00 | QQQ | ETF | 79.7188 | 81.0 | 78.5625 | 80.4375 | 4820500.0 |
| 2000-10-18 13:00:00 | QQQ | ETF | 80.4688 | 80.625 | 79.0 | 79.75 | 6356300.0 |
| 2000-10-18 14:00:00 | QQQ | ETF | 79.6875 | 81.1875 | 79.3125 | 80.4375 | 6610200.0 |
| 2000-10-18 15:00:00 | QQQ | ETF | 80.4375 | 80.6875 | 78.1875 | 78.4062 | 7253700.0 |
| 2000-10-18 16:00:00 | QQQ | ETF | 78.25 | 80.8438 | 75.375 | 78.75 | 1231100.0 |
| 2000-10-18 17:00:00 | QQQ | ETF | 79.0 | 79.5625 | 78.25 | 79.125 | 98700.0 |
| 2000-10-18 18:00:00 | QQQ | ETF | 79.125 | 80.0 | 78.5 | 79.625 | 48600.0 |
| 2000-10-18 09:00:00 | IWM | ETF | 45.8125 | 45.8125 | 45.6875 | 45.7188 | 75000.0 |
| 2000-10-18 10:00:00 | IWM | ETF | 45.875 | 46.5938 | 45.875 | 46.4688 | 41800.0 |
| 2000-10-18 11:00:00 | IWM | ETF | 46.5312 | 46.75 | 46.2812 | 46.375 | 17000.0 |
| 2000-10-18 12:00:00 | IWM | ETF | 46.4062 | 46.5625 | 46.375 | 46.5625 | 29000.0 |
| 2000-10-18 13:00:00 | IWM | ETF | 46.5625 | 46.5625 | 46.4375 | 46.4375 | 37200.0 |
| 2000-10-18 14:00:00 | IWM | ETF | 46.5 | 46.8125 | 46.5 | 46.8125 | 15400.0 |
| 2000-10-18 15:00:00 | IWM | ETF | 46.5625 | 46.625 | 46.3906 | 46.625 | 117800.0 |
| 2000-10-18 16:00:00 | IWM | ETF | 46.5312 | 46.5312 | 46.5312 | 46.5312 | 200.0 |
| 2000-10-18 09:00:00 | DIA | ETF | 99.0 | 99.0 | 96.75 | 98.1875 | 1118600.0 |
| 2000-10-18 10:00:00 | DIA | ETF | 98.1875 | 99.125 | 97.875 | 99.0312 | 508000.0 |
| 2000-10-18 11:00:00 | DIA | ETF | 99.2812 | 99.9688 | 99.0625 | 99.625 | 387600.0 |
| 2000-10-18 12:00:00 | DIA | ETF | 99.6875 | 100.25 | 99.125 | 99.9375 | 127500.0 |
| 2000-10-18 13:00:00 | DIA | ETF | 100.0312 | 100.0312 | 99.25 | 99.8125 | 101500.0 |
| 2000-10-18 14:00:00 | DIA | ETF | 99.75 | 100.8125 | 99.75 | 100.5312 | 307100.0 |
| 2000-10-18 15:00:00 | DIA | ETF | 100.5 | 100.625 | 99.5 | 99.9062 | 388300.0 |
| 2000-10-18 16:00:00 | DIA | ETF | 99.6875 | 99.9688 | 99.6875 | 99.7812 | 37400.0 |
| 2000-10-18 17:00:00 | DIA | ETF | 102.0 | 102.0 | 102.0 | 102.0 | 200.0 |
> showing 36 of 193 rows — these rows as CSV