PREVIEW / etf_1hour / 2001-01-25
file: by_date/etf_1hour/2001/2001-01-25.parquet size: 10 KB rows: 189
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-25 09:00:00 | SPY | ETF | 136.25 | 136.6875 | 136.0312 | 136.5312 | 961300.0 |
| 2001-01-25 10:00:00 | SPY | ETF | 136.6875 | 137.25 | 135.6562 | 135.875 | 2482500.0 |
| 2001-01-25 11:00:00 | SPY | ETF | 135.75 | 136.8438 | 135.6875 | 136.6875 | 1881800.0 |
| 2001-01-25 12:00:00 | SPY | ETF | 136.6562 | 136.75 | 136.2188 | 136.5625 | 822200.0 |
| 2001-01-25 13:00:00 | SPY | ETF | 136.6562 | 137.0312 | 136.4062 | 136.625 | 1325300.0 |
| 2001-01-25 14:00:00 | SPY | ETF | 136.5 | 136.625 | 135.75 | 136.0 | 1067600.0 |
| 2001-01-25 15:00:00 | SPY | ETF | 136.0 | 136.3125 | 135.75 | 136.0625 | 1353400.0 |
| 2001-01-25 16:00:00 | SPY | ETF | 136.0312 | 136.1562 | 135.8438 | 136.0312 | 413500.0 |
| 2001-01-25 09:00:00 | QQQ | ETF | 66.875 | 67.3125 | 66.5312 | 67.25 | 8140200.0 |
| 2001-01-25 10:00:00 | QQQ | ETF | 67.25 | 67.6562 | 65.9688 | 66.0 | 12491800.0 |
| 2001-01-25 11:00:00 | QQQ | ETF | 66.0312 | 66.75 | 65.75 | 66.4688 | 8056100.0 |
| 2001-01-25 12:00:00 | QQQ | ETF | 66.5 | 66.5312 | 65.8125 | 66.1875 | 3939500.0 |
| 2001-01-25 13:00:00 | QQQ | ETF | 66.2188 | 66.625 | 65.5938 | 65.6875 | 4690700.0 |
| 2001-01-25 14:00:00 | QQQ | ETF | 65.7812 | 65.875 | 64.75 | 65.125 | 8621900.0 |
| 2001-01-25 15:00:00 | QQQ | ETF | 65.0 | 65.4062 | 64.625 | 64.7812 | 7161100.0 |
| 2001-01-25 16:00:00 | QQQ | ETF | 64.75 | 66.5 | 64.0625 | 66.5 | 1653400.0 |
| 2001-01-25 17:00:00 | QQQ | ETF | 64.5 | 65.125 | 63.1875 | 63.375 | 349800.0 |
| 2001-01-25 18:00:00 | QQQ | ETF | 63.5 | 63.75 | 63.375 | 63.625 | 86200.0 |
| 2001-01-25 09:00:00 | IWM | ETF | 50.0156 | 50.0156 | 49.8438 | 49.9062 | 51400.0 |
| 2001-01-25 10:00:00 | IWM | ETF | 50.0 | 50.1562 | 49.7188 | 49.7969 | 55600.0 |
| 2001-01-25 11:00:00 | IWM | ETF | 49.6562 | 50.0312 | 49.6094 | 50.0312 | 107600.0 |
| 2001-01-25 12:00:00 | IWM | ETF | 49.9844 | 50.0 | 49.8438 | 49.9844 | 63400.0 |
| 2001-01-25 13:00:00 | IWM | ETF | 50.0 | 50.1562 | 49.9688 | 49.9688 | 217400.0 |
| 2001-01-25 14:00:00 | IWM | ETF | 49.9844 | 50.0 | 49.7188 | 49.7812 | 109200.0 |
| 2001-01-25 15:00:00 | IWM | ETF | 50.0 | 50.0625 | 49.7344 | 49.8125 | 147400.0 |
| 2001-01-25 16:00:00 | IWM | ETF | 49.75 | 49.75 | 49.75 | 49.75 | 10000.0 |
| 2001-01-25 09:00:00 | DIA | ETF | 106.6875 | 107.2188 | 106.4375 | 107.2188 | 191200.0 |
| 2001-01-25 10:00:00 | DIA | ETF | 107.2188 | 107.6562 | 106.5625 | 107.0 | 237800.0 |
| 2001-01-25 11:00:00 | DIA | ETF | 106.8125 | 107.4688 | 106.7812 | 107.375 | 144800.0 |
| 2001-01-25 12:00:00 | DIA | ETF | 107.3125 | 107.5625 | 107.0938 | 107.375 | 121200.0 |
| 2001-01-25 13:00:00 | DIA | ETF | 107.5312 | 107.9375 | 107.4375 | 107.5938 | 266700.0 |
| 2001-01-25 14:00:00 | DIA | ETF | 107.5625 | 107.625 | 107.1875 | 107.3125 | 94500.0 |
| 2001-01-25 15:00:00 | DIA | ETF | 107.25 | 107.7188 | 107.0625 | 107.4688 | 153600.0 |
| 2001-01-25 16:00:00 | DIA | ETF | 107.3125 | 107.3125 | 107.3125 | 107.3125 | 1000.0 |
> showing 34 of 189 rows — these rows as CSV