PREVIEW / etf_1hour / 2000-05-10
file: by_date/etf_1hour/2000/2000-05-10.parquet size: 8 KB rows: 127
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-05-10 09:00:00 | SPY | ETF | 140.5 | 140.9688 | 140.0625 | 140.5 | 697800.0 |
| 2000-05-10 10:00:00 | SPY | ETF | 140.5 | 140.625 | 138.875 | 139.375 | 1569600.0 |
| 2000-05-10 11:00:00 | SPY | ETF | 139.25 | 139.5938 | 138.625 | 139.0625 | 1060100.0 |
| 2000-05-10 12:00:00 | SPY | ETF | 138.9688 | 139.375 | 138.625 | 138.9688 | 890700.0 |
| 2000-05-10 13:00:00 | SPY | ETF | 138.875 | 138.9688 | 137.75 | 138.625 | 1032700.0 |
| 2000-05-10 14:00:00 | SPY | ETF | 138.6875 | 139.9375 | 138.375 | 139.875 | 1489700.0 |
| 2000-05-10 15:00:00 | SPY | ETF | 139.9062 | 140.625 | 138.25 | 138.5938 | 2971200.0 |
| 2000-05-10 16:00:00 | SPY | ETF | 138.625 | 138.7812 | 138.125 | 138.125 | 519400.0 |
| 2000-05-10 09:00:00 | QQQ | ETF | 84.375 | 84.9688 | 83.875 | 84.125 | 3431300.0 |
| 2000-05-10 10:00:00 | QQQ | ETF | 84.125 | 84.4375 | 82.0 | 82.1875 | 6204800.0 |
| 2000-05-10 11:00:00 | QQQ | ETF | 82.125 | 82.75 | 81.5 | 81.625 | 3869100.0 |
| 2000-05-10 12:00:00 | QQQ | ETF | 81.625 | 82.5 | 81.0625 | 81.625 | 4065100.0 |
| 2000-05-10 13:00:00 | QQQ | ETF | 81.625 | 82.3438 | 80.8125 | 82.1875 | 3366100.0 |
| 2000-05-10 14:00:00 | QQQ | ETF | 82.25 | 83.25 | 81.6875 | 83.25 | 5913800.0 |
| 2000-05-10 15:00:00 | QQQ | ETF | 83.25 | 84.375 | 80.75 | 80.9688 | 6040100.0 |
| 2000-05-10 16:00:00 | QQQ | ETF | 81.0 | 81.375 | 79.5 | 79.75 | 1807700.0 |
| 2000-05-10 17:00:00 | QQQ | ETF | 80.0 | 80.0 | 79.625 | 79.75 | 32000.0 |
| 2000-05-10 18:00:00 | QQQ | ETF | 79.875 | 79.875 | 79.75 | 79.75 | 8200.0 |
| 2000-05-10 09:00:00 | DIA | ETF | 104.5312 | 105.0938 | 104.5312 | 104.8125 | 110700.0 |
| 2000-05-10 10:00:00 | DIA | ETF | 105.0 | 105.0 | 103.6875 | 104.0 | 321100.0 |
| 2000-05-10 11:00:00 | DIA | ETF | 104.125 | 104.125 | 103.5312 | 103.75 | 47600.0 |
| 2000-05-10 12:00:00 | DIA | ETF | 103.9062 | 104.2188 | 103.75 | 103.75 | 147300.0 |
| 2000-05-10 13:00:00 | DIA | ETF | 103.875 | 103.9375 | 102.625 | 103.5 | 406600.0 |
| 2000-05-10 14:00:00 | DIA | ETF | 103.375 | 104.4375 | 103.2812 | 104.3438 | 151000.0 |
| 2000-05-10 15:00:00 | DIA | ETF | 104.3438 | 104.7188 | 103.2812 | 103.625 | 543900.0 |
| 2000-05-10 16:00:00 | DIA | ETF | 103.4375 | 103.5 | 103.25 | 103.3125 | 103200.0 |
> showing 26 of 127 rows — these rows as CSV