PREVIEW / etf_1hour / 2001-01-26
file: by_date/etf_1hour/2001/2001-01-26.parquet size: 10 KB rows: 203
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 |
|---|---|---|---|---|---|---|---|
| 2001-01-26 09:00:00 | SPY | ETF | 135.1562 | 135.5938 | 135.0625 | 135.5 | 774500.0 |
| 2001-01-26 10:00:00 | SPY | ETF | 135.4688 | 135.8438 | 134.4375 | 134.6562 | 1602800.0 |
| 2001-01-26 11:00:00 | SPY | ETF | 134.75 | 135.0938 | 134.4688 | 134.8438 | 325600.0 |
| 2001-01-26 12:00:00 | SPY | ETF | 134.8438 | 135.6562 | 134.75 | 135.3438 | 1126600.0 |
| 2001-01-26 13:00:00 | SPY | ETF | 135.5 | 136.0 | 135.375 | 135.75 | 992400.0 |
| 2001-01-26 14:00:00 | SPY | ETF | 135.8438 | 136.125 | 135.3438 | 135.9062 | 899700.0 |
| 2001-01-26 15:00:00 | SPY | ETF | 135.9375 | 135.9688 | 135.375 | 135.7812 | 619200.0 |
| 2001-01-26 16:00:00 | SPY | ETF | 135.7188 | 135.9062 | 135.125 | 135.125 | 326200.0 |
| 2001-01-26 09:00:00 | QQQ | ETF | 63.5625 | 63.9375 | 63.0 | 63.9062 | 7746000.0 |
| 2001-01-26 10:00:00 | QQQ | ETF | 63.875 | 64.5938 | 63.4375 | 63.875 | 8952800.0 |
| 2001-01-26 11:00:00 | QQQ | ETF | 63.875 | 63.9062 | 63.125 | 63.5625 | 3027900.0 |
| 2001-01-26 12:00:00 | QQQ | ETF | 63.5625 | 64.8125 | 63.5 | 64.5625 | 5419600.0 |
| 2001-01-26 13:00:00 | QQQ | ETF | 64.5625 | 65.75 | 64.5625 | 65.4375 | 7929000.0 |
| 2001-01-26 14:00:00 | QQQ | ETF | 65.4688 | 65.75 | 64.875 | 65.5312 | 3938200.0 |
| 2001-01-26 15:00:00 | QQQ | ETF | 65.5 | 65.8125 | 64.875 | 65.5625 | 4698000.0 |
| 2001-01-26 16:00:00 | QQQ | ETF | 65.5625 | 66.25 | 65.0312 | 65.6875 | 984800.0 |
| 2001-01-26 17:00:00 | QQQ | ETF | 65.6875 | 65.9375 | 62.625 | 65.75 | 12900.0 |
| 2001-01-26 18:00:00 | QQQ | ETF | 65.75 | 65.75 | 65.625 | 65.625 | 1700.0 |
| 2001-01-26 09:00:00 | IWM | ETF | 49.5312 | 49.5312 | 49.25 | 49.5 | 140600.0 |
| 2001-01-26 10:00:00 | IWM | ETF | 49.4688 | 49.625 | 49.1719 | 49.1719 | 23400.0 |
| 2001-01-26 11:00:00 | IWM | ETF | 49.2656 | 49.2969 | 49.2656 | 49.2969 | 10000.0 |
| 2001-01-26 12:00:00 | IWM | ETF | 49.1719 | 49.375 | 49.1719 | 49.3438 | 61600.0 |
| 2001-01-26 13:00:00 | IWM | ETF | 49.375 | 49.7031 | 49.375 | 49.6562 | 109200.0 |
| 2001-01-26 14:00:00 | IWM | ETF | 49.6875 | 49.75 | 49.5 | 49.75 | 12600.0 |
| 2001-01-26 15:00:00 | IWM | ETF | 49.9062 | 50.0 | 49.6875 | 49.7812 | 75000.0 |
| 2001-01-26 16:00:00 | IWM | ETF | 49.8125 | 49.8125 | 49.8125 | 49.8125 | 800.0 |
| 2001-01-26 09:00:00 | DIA | ETF | 107.125 | 107.5938 | 106.9062 | 107.5 | 148300.0 |
| 2001-01-26 10:00:00 | DIA | ETF | 107.5 | 107.5 | 106.1875 | 106.4688 | 499700.0 |
| 2001-01-26 11:00:00 | DIA | ETF | 106.5 | 106.8125 | 106.375 | 106.625 | 45100.0 |
| 2001-01-26 12:00:00 | DIA | ETF | 106.6562 | 107.0625 | 106.625 | 106.7812 | 82300.0 |
| 2001-01-26 13:00:00 | DIA | ETF | 106.875 | 107.125 | 106.75 | 107.0 | 272800.0 |
| 2001-01-26 14:00:00 | DIA | ETF | 106.9062 | 107.1875 | 106.75 | 107.1562 | 159400.0 |
| 2001-01-26 15:00:00 | DIA | ETF | 107.0312 | 107.1562 | 106.5 | 106.7812 | 72200.0 |
| 2001-01-26 16:00:00 | DIA | ETF | 106.6875 | 106.7812 | 106.625 | 106.7188 | 214300.0 |
> showing 34 of 203 rows — these rows as CSV