PREVIEW / etf_1hour / 2000-01-27
file: by_date/etf_1hour/2000/2000-01-27.parquet size: 8 KB rows: 132
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-01-27 09:00:00 | SPY | ETF | 141.8438 | 141.8438 | 141.25 | 141.2812 | 2904200.0 |
| 2000-01-27 10:00:00 | SPY | ETF | 141.4688 | 142.2188 | 141.4688 | 141.8125 | 1495600.0 |
| 2000-01-27 11:00:00 | SPY | ETF | 141.9688 | 142.1562 | 140.875 | 141.0 | 866700.0 |
| 2000-01-27 12:00:00 | SPY | ETF | 141.125 | 141.1875 | 139.6875 | 139.8125 | 1387400.0 |
| 2000-01-27 13:00:00 | SPY | ETF | 139.7188 | 140.75 | 139.7188 | 140.375 | 830800.0 |
| 2000-01-27 14:00:00 | SPY | ETF | 140.2812 | 140.625 | 138.375 | 138.625 | 902400.0 |
| 2000-01-27 15:00:00 | SPY | ETF | 138.625 | 140.2188 | 138.125 | 140.0 | 2117700.0 |
| 2000-01-27 16:00:00 | SPY | ETF | 140.1562 | 140.6875 | 140.1562 | 140.25 | 342200.0 |
| 2000-01-27 09:00:00 | QQQ | ETF | 91.75 | 92.0625 | 91.1719 | 91.625 | 3127200.0 |
| 2000-01-27 10:00:00 | QQQ | ETF | 91.6094 | 92.25 | 91.6094 | 92.0938 | 3855800.0 |
| 2000-01-27 11:00:00 | QQQ | ETF | 92.1094 | 92.5 | 90.375 | 91.0 | 4255600.0 |
| 2000-01-27 12:00:00 | QQQ | ETF | 90.9062 | 91.2188 | 89.3125 | 89.5 | 3576800.0 |
| 2000-01-27 13:00:00 | QQQ | ETF | 89.5 | 90.7812 | 89.3125 | 90.1094 | 4007000.0 |
| 2000-01-27 14:00:00 | QQQ | ETF | 90.0625 | 90.4375 | 88.125 | 88.6562 | 3909800.0 |
| 2000-01-27 15:00:00 | QQQ | ETF | 88.6719 | 89.9688 | 87.625 | 89.9688 | 6941400.0 |
| 2000-01-27 16:00:00 | QQQ | ETF | 89.9375 | 90.5 | 89.8125 | 90.5 | 669800.0 |
| 2000-01-27 17:00:00 | QQQ | ETF | 90.5 | 90.5 | 90.375 | 90.375 | 3600.0 |
| 2000-01-27 18:00:00 | QQQ | ETF | 90.5625 | 90.5625 | 90.5625 | 90.5625 | 200.0 |
| 2000-01-27 09:00:00 | DIA | ETF | 111.125 | 111.25 | 110.8125 | 110.9375 | 100900.0 |
| 2000-01-27 10:00:00 | DIA | ETF | 111.0 | 111.5938 | 110.875 | 111.4688 | 97000.0 |
| 2000-01-27 11:00:00 | DIA | ETF | 111.5 | 111.5938 | 110.75 | 110.9062 | 57800.0 |
| 2000-01-27 12:00:00 | DIA | ETF | 110.8438 | 111.0625 | 109.875 | 109.9375 | 137500.0 |
| 2000-01-27 13:00:00 | DIA | ETF | 109.875 | 110.7188 | 109.75 | 110.5 | 87700.0 |
| 2000-01-27 14:00:00 | DIA | ETF | 110.5 | 110.7812 | 109.3125 | 109.5 | 106300.0 |
| 2000-01-27 15:00:00 | DIA | ETF | 109.4375 | 110.4375 | 109.1875 | 110.3438 | 226900.0 |
| 2000-01-27 16:00:00 | DIA | ETF | 110.375 | 110.7188 | 110.375 | 110.4688 | 18100.0 |
> showing 26 of 132 rows — these rows as CSV