PREVIEW / etf_1hour / 2001-01-04
file: by_date/etf_1hour/2001/2001-01-04.parquet size: 10 KB rows: 204
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-04 09:00:00 | SPY | ETF | 134.9375 | 135.2188 | 134.3125 | 135.1875 | 1351700.0 |
| 2001-01-04 10:00:00 | SPY | ETF | 135.125 | 135.4688 | 133.6875 | 134.3438 | 1486800.0 |
| 2001-01-04 11:00:00 | SPY | ETF | 134.3438 | 134.8438 | 133.875 | 134.5 | 1089300.0 |
| 2001-01-04 12:00:00 | SPY | ETF | 134.5312 | 135.2812 | 134.3438 | 134.5625 | 1179600.0 |
| 2001-01-04 13:00:00 | SPY | ETF | 134.5312 | 134.9375 | 133.6562 | 134.1875 | 1082000.0 |
| 2001-01-04 14:00:00 | SPY | ETF | 134.25 | 134.4062 | 133.0 | 133.375 | 890300.0 |
| 2001-01-04 15:00:00 | SPY | ETF | 133.4062 | 133.9062 | 133.125 | 133.4062 | 1049700.0 |
| 2001-01-04 16:00:00 | SPY | ETF | 133.25 | 133.9375 | 133.25 | 133.5312 | 994100.0 |
| 2001-01-04 17:00:00 | SPY | ETF | 134.1875 | 134.375 | 133.75 | 133.75 | 5300.0 |
| 2001-01-04 09:00:00 | QQQ | ETF | 61.625 | 63.4375 | 61.5 | 62.375 | 12968500.0 |
| 2001-01-04 10:00:00 | QQQ | ETF | 62.75 | 63.625 | 61.375 | 62.125 | 11580700.0 |
| 2001-01-04 11:00:00 | QQQ | ETF | 62.125 | 62.75 | 61.6875 | 62.6875 | 6282200.0 |
| 2001-01-04 12:00:00 | QQQ | ETF | 62.75 | 63.375 | 62.375 | 62.4688 | 4131100.0 |
| 2001-01-04 13:00:00 | QQQ | ETF | 62.5312 | 62.875 | 61.625 | 62.1562 | 4516000.0 |
| 2001-01-04 14:00:00 | QQQ | ETF | 62.0938 | 62.3125 | 60.5625 | 61.2188 | 8228900.0 |
| 2001-01-04 15:00:00 | QQQ | ETF | 61.25 | 62.0 | 61.0 | 61.5 | 8086400.0 |
| 2001-01-04 16:00:00 | QQQ | ETF | 61.4688 | 62.8125 | 60.5 | 61.3438 | 1517700.0 |
| 2001-01-04 17:00:00 | QQQ | ETF | 61.1875 | 63.0 | 61.0625 | 61.625 | 764100.0 |
| 2001-01-04 18:00:00 | QQQ | ETF | 61.5 | 61.625 | 61.0 | 61.5938 | 36900.0 |
| 2001-01-04 09:00:00 | IWM | ETF | 47.9375 | 48.2812 | 47.9375 | 48.1562 | 70400.0 |
| 2001-01-04 10:00:00 | IWM | ETF | 48.2344 | 48.2812 | 47.8438 | 48.0625 | 217600.0 |
| 2001-01-04 11:00:00 | IWM | ETF | 48.0625 | 48.1562 | 47.7812 | 47.7812 | 63400.0 |
| 2001-01-04 12:00:00 | IWM | ETF | 47.9375 | 48.1562 | 47.9375 | 47.9375 | 62000.0 |
| 2001-01-04 13:00:00 | IWM | ETF | 48.0312 | 48.0312 | 47.75 | 47.75 | 3600.0 |
| 2001-01-04 14:00:00 | IWM | ETF | 47.9062 | 47.9375 | 47.3125 | 47.3125 | 59000.0 |
| 2001-01-04 15:00:00 | IWM | ETF | 47.5938 | 47.7031 | 47.5 | 47.5 | 30600.0 |
| 2001-01-04 09:00:00 | DIA | ETF | 109.125 | 109.9688 | 109.125 | 109.5938 | 378100.0 |
| 2001-01-04 10:00:00 | DIA | ETF | 109.7188 | 110.25 | 109.0938 | 109.7812 | 293200.0 |
| 2001-01-04 11:00:00 | DIA | ETF | 109.7812 | 110.0 | 109.4375 | 109.75 | 79400.0 |
| 2001-01-04 12:00:00 | DIA | ETF | 109.5938 | 110.4062 | 109.5938 | 109.9375 | 157800.0 |
| 2001-01-04 13:00:00 | DIA | ETF | 109.75 | 110.0938 | 109.3438 | 109.5625 | 145000.0 |
| 2001-01-04 14:00:00 | DIA | ETF | 109.5625 | 109.75 | 108.75 | 109.0 | 324300.0 |
| 2001-01-04 15:00:00 | DIA | ETF | 108.875 | 109.375 | 108.875 | 108.875 | 127100.0 |
| 2001-01-04 16:00:00 | DIA | ETF | 109.0938 | 109.25 | 109.0938 | 109.2188 | 10700.0 |
> showing 34 of 204 rows — these rows as CSV