PREVIEW / etf_1hour / 2000-10-26
file: by_date/etf_1hour/2000/2000-10-26.parquet size: 10 KB rows: 186
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-26 09:00:00 | SPY | ETF | 137.125 | 137.4688 | 136.5 | 137.0625 | 1027100.0 |
| 2000-10-26 10:00:00 | SPY | ETF | 136.9688 | 137.6562 | 135.4062 | 135.5625 | 1104100.0 |
| 2000-10-26 11:00:00 | SPY | ETF | 135.625 | 135.75 | 134.5625 | 135.5312 | 1036200.0 |
| 2000-10-26 12:00:00 | SPY | ETF | 135.4375 | 136.0938 | 135.0625 | 135.375 | 787000.0 |
| 2000-10-26 13:00:00 | SPY | ETF | 135.4062 | 135.4688 | 134.3125 | 134.6562 | 718100.0 |
| 2000-10-26 14:00:00 | SPY | ETF | 134.5 | 135.8438 | 134.0312 | 135.3125 | 943900.0 |
| 2000-10-26 15:00:00 | SPY | ETF | 135.5938 | 137.6562 | 135.3125 | 136.625 | 2263500.0 |
| 2000-10-26 16:00:00 | SPY | ETF | 136.5625 | 136.8125 | 136.0 | 136.6875 | 801100.0 |
| 2000-10-26 17:00:00 | SPY | ETF | 135.75 | 136.6875 | 135.75 | 136.6875 | 50800.0 |
| 2000-10-26 09:00:00 | QQQ | ETF | 78.1875 | 78.5 | 76.7812 | 78.25 | 6199800.0 |
| 2000-10-26 10:00:00 | QQQ | ETF | 78.25 | 79.25 | 75.625 | 76.0 | 9088400.0 |
| 2000-10-26 11:00:00 | QQQ | ETF | 76.125 | 76.2812 | 74.625 | 75.875 | 11802000.0 |
| 2000-10-26 12:00:00 | QQQ | ETF | 75.75 | 77.0938 | 75.25 | 75.8125 | 7957400.0 |
| 2000-10-26 13:00:00 | QQQ | ETF | 75.8125 | 75.875 | 73.75 | 74.5 | 8922400.0 |
| 2000-10-26 14:00:00 | QQQ | ETF | 74.375 | 76.9375 | 73.625 | 76.3125 | 9728400.0 |
| 2000-10-26 15:00:00 | QQQ | ETF | 76.3125 | 80.0 | 75.8125 | 79.0625 | 11169100.0 |
| 2000-10-26 16:00:00 | QQQ | ETF | 79.0625 | 80.25 | 78.0 | 78.625 | 2592400.0 |
| 2000-10-26 17:00:00 | QQQ | ETF | 79.0 | 81.3125 | 78.75 | 80.875 | 273900.0 |
| 2000-10-26 18:00:00 | QQQ | ETF | 81.0 | 81.1875 | 80.5 | 80.9688 | 22300.0 |
| 2000-10-26 09:00:00 | IWM | ETF | 47.7031 | 47.75 | 47.7031 | 47.75 | 1400.0 |
| 2000-10-26 10:00:00 | IWM | ETF | 47.7812 | 47.8281 | 47.625 | 47.625 | 10400.0 |
| 2000-10-26 11:00:00 | IWM | ETF | 47.3438 | 47.3438 | 46.9688 | 47.0 | 11400.0 |
| 2000-10-26 12:00:00 | IWM | ETF | 47.1562 | 47.25 | 46.9375 | 46.9375 | 6200.0 |
| 2000-10-26 13:00:00 | IWM | ETF | 47.125 | 47.125 | 46.8906 | 46.9375 | 32200.0 |
| 2000-10-26 14:00:00 | IWM | ETF | 46.8438 | 47.0938 | 46.8438 | 47.0938 | 13000.0 |
| 2000-10-26 15:00:00 | IWM | ETF | 47.3438 | 48.0 | 47.3438 | 48.0 | 22200.0 |
| 2000-10-26 09:00:00 | DIA | ETF | 103.0938 | 103.8125 | 103.0312 | 103.4375 | 135300.0 |
| 2000-10-26 10:00:00 | DIA | ETF | 103.4375 | 103.9688 | 102.75 | 103.0312 | 610100.0 |
| 2000-10-26 11:00:00 | DIA | ETF | 103.0 | 103.3125 | 102.5 | 103.1562 | 206000.0 |
| 2000-10-26 12:00:00 | DIA | ETF | 103.1562 | 103.75 | 103.0312 | 103.4375 | 96000.0 |
| 2000-10-26 13:00:00 | DIA | ETF | 103.375 | 103.4688 | 102.75 | 102.8438 | 174200.0 |
| 2000-10-26 14:00:00 | DIA | ETF | 103.0 | 103.4688 | 102.625 | 103.4062 | 172400.0 |
| 2000-10-26 15:00:00 | DIA | ETF | 103.2812 | 104.7188 | 103.25 | 103.875 | 371000.0 |
| 2000-10-26 16:00:00 | DIA | ETF | 103.75 | 104.0312 | 103.6875 | 103.6875 | 110900.0 |
> showing 34 of 186 rows — these rows as CSV