PREVIEW / etf_1hour / 2001-01-19
file: by_date/etf_1hour/2001/2001-01-19.parquet size: 10 KB rows: 199
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-19 09:00:00 | SPY | ETF | 136.1875 | 136.1875 | 134.6875 | 134.75 | 1604400.0 |
| 2001-01-19 10:00:00 | SPY | ETF | 134.875 | 135.0 | 133.875 | 134.25 | 1578100.0 |
| 2001-01-19 11:00:00 | SPY | ETF | 134.1875 | 134.7812 | 134.0 | 134.75 | 819100.0 |
| 2001-01-19 12:00:00 | SPY | ETF | 134.7812 | 134.8125 | 134.1562 | 134.3438 | 718800.0 |
| 2001-01-19 13:00:00 | SPY | ETF | 134.3125 | 134.9688 | 134.1562 | 134.8125 | 246400.0 |
| 2001-01-19 14:00:00 | SPY | ETF | 134.75 | 135.25 | 134.4688 | 134.4688 | 781400.0 |
| 2001-01-19 15:00:00 | SPY | ETF | 134.5 | 134.6875 | 134.0625 | 134.4688 | 1303700.0 |
| 2001-01-19 16:00:00 | SPY | ETF | 134.4062 | 134.5 | 134.0312 | 134.0312 | 389800.0 |
| 2001-01-19 17:00:00 | SPY | ETF | 134.75 | 136.0 | 134.75 | 136.0 | 500.0 |
| 2001-01-19 09:00:00 | QQQ | ETF | 68.125 | 68.3125 | 66.75 | 66.75 | 12542100.0 |
| 2001-01-19 10:00:00 | QQQ | ETF | 66.7812 | 67.0 | 65.5625 | 66.4062 | 14512200.0 |
| 2001-01-19 11:00:00 | QQQ | ETF | 66.4375 | 66.875 | 65.9062 | 66.625 | 5632700.0 |
| 2001-01-19 12:00:00 | QQQ | ETF | 66.6875 | 66.7188 | 66.0625 | 66.4062 | 3090200.0 |
| 2001-01-19 13:00:00 | QQQ | ETF | 66.4062 | 67.1875 | 66.3125 | 67.0 | 4679600.0 |
| 2001-01-19 14:00:00 | QQQ | ETF | 66.9375 | 67.5312 | 66.5312 | 66.5312 | 5121100.0 |
| 2001-01-19 15:00:00 | QQQ | ETF | 66.5 | 66.7812 | 66.0 | 66.3438 | 7036900.0 |
| 2001-01-19 16:00:00 | QQQ | ETF | 66.3438 | 66.5938 | 65.7812 | 66.3125 | 1240000.0 |
| 2001-01-19 17:00:00 | QQQ | ETF | 66.25 | 66.4375 | 66.25 | 66.375 | 13700.0 |
| 2001-01-19 18:00:00 | QQQ | ETF | 66.4375 | 66.4375 | 66.0 | 66.3125 | 12100.0 |
| 2001-01-19 09:00:00 | IWM | ETF | 49.9062 | 49.9062 | 49.0938 | 49.0938 | 67600.0 |
| 2001-01-19 10:00:00 | IWM | ETF | 49.0625 | 49.0625 | 48.8125 | 49.0 | 48400.0 |
| 2001-01-19 11:00:00 | IWM | ETF | 48.9844 | 49.0625 | 48.875 | 49.0312 | 154000.0 |
| 2001-01-19 12:00:00 | IWM | ETF | 49.0312 | 49.0312 | 48.7188 | 48.7188 | 35400.0 |
| 2001-01-19 13:00:00 | IWM | ETF | 48.8438 | 49.0625 | 48.7188 | 49.0625 | 61000.0 |
| 2001-01-19 14:00:00 | IWM | ETF | 48.9688 | 49.1562 | 48.7812 | 48.7812 | 47000.0 |
| 2001-01-19 15:00:00 | IWM | ETF | 48.75 | 48.8438 | 48.625 | 48.75 | 139600.0 |
| 2001-01-19 16:00:00 | IWM | ETF | 48.625 | 48.625 | 48.3906 | 48.625 | 32200.0 |
| 2001-01-19 09:00:00 | DIA | ETF | 107.125 | 107.125 | 106.125 | 106.25 | 196000.0 |
| 2001-01-19 10:00:00 | DIA | ETF | 106.25 | 106.5938 | 105.7188 | 106.0938 | 135400.0 |
| 2001-01-19 11:00:00 | DIA | ETF | 105.9062 | 106.1562 | 105.6562 | 106.1562 | 136100.0 |
| 2001-01-19 12:00:00 | DIA | ETF | 106.125 | 106.1875 | 105.75 | 105.875 | 54800.0 |
| 2001-01-19 13:00:00 | DIA | ETF | 105.75 | 106.1562 | 105.6875 | 106.0 | 43800.0 |
| 2001-01-19 14:00:00 | DIA | ETF | 106.0 | 106.375 | 105.8438 | 105.9375 | 49800.0 |
| 2001-01-19 15:00:00 | DIA | ETF | 106.0 | 106.1875 | 105.6562 | 105.9375 | 340800.0 |
| 2001-01-19 16:00:00 | DIA | ETF | 105.875 | 105.9375 | 105.5625 | 105.5625 | 21400.0 |
> showing 35 of 199 rows — these rows as CSV