PREVIEW / etf_1hour / 2000-03-09
file: by_date/etf_1hour/2000/2000-03-09.parquet size: 8 KB rows: 131
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-03-09 09:00:00 | SPY | ETF | 137.25 | 137.25 | 136.125 | 136.3125 | 1164300.0 |
| 2000-03-09 10:00:00 | SPY | ETF | 136.1562 | 138.375 | 136.1562 | 138.2188 | 679400.0 |
| 2000-03-09 11:00:00 | SPY | ETF | 138.1562 | 138.5 | 137.6875 | 138.0 | 553900.0 |
| 2000-03-09 12:00:00 | SPY | ETF | 138.0625 | 138.8438 | 137.8125 | 138.4375 | 958200.0 |
| 2000-03-09 13:00:00 | SPY | ETF | 138.5312 | 138.8438 | 138.1562 | 138.5 | 475800.0 |
| 2000-03-09 14:00:00 | SPY | ETF | 138.6562 | 139.0 | 138.3438 | 138.6875 | 251000.0 |
| 2000-03-09 15:00:00 | SPY | ETF | 138.6875 | 140.5938 | 138.625 | 140.5938 | 893000.0 |
| 2000-03-09 16:00:00 | SPY | ETF | 140.625 | 140.875 | 140.5 | 140.875 | 481100.0 |
| 2000-03-09 09:00:00 | QQQ | ETF | 111.2188 | 111.6875 | 109.0938 | 109.5938 | 3335800.0 |
| 2000-03-09 10:00:00 | QQQ | ETF | 109.5 | 111.9375 | 109.25 | 111.9062 | 6725600.0 |
| 2000-03-09 11:00:00 | QQQ | ETF | 111.75 | 111.9688 | 110.9062 | 111.2188 | 2828200.0 |
| 2000-03-09 12:00:00 | QQQ | ETF | 111.25 | 112.75 | 111.2188 | 112.4375 | 5064800.0 |
| 2000-03-09 13:00:00 | QQQ | ETF | 112.5156 | 112.7344 | 111.75 | 112.5938 | 3322000.0 |
| 2000-03-09 14:00:00 | QQQ | ETF | 112.5 | 112.8594 | 111.6875 | 112.7344 | 3296000.0 |
| 2000-03-09 15:00:00 | QQQ | ETF | 112.7188 | 114.6875 | 112.6406 | 114.6875 | 4867000.0 |
| 2000-03-09 16:00:00 | QQQ | ETF | 114.3125 | 115.0 | 114.3125 | 115.0 | 624000.0 |
| 2000-03-09 17:00:00 | QQQ | ETF | 115.0 | 115.0 | 114.5 | 114.75 | 3600.0 |
| 2000-03-09 18:00:00 | QQQ | ETF | 115.0 | 115.0 | 115.0 | 115.0 | 600.0 |
| 2000-03-09 09:00:00 | DIA | ETF | 98.8438 | 98.8438 | 97.3125 | 97.5625 | 173100.0 |
| 2000-03-09 10:00:00 | DIA | ETF | 97.5625 | 99.0 | 97.4375 | 98.5312 | 272600.0 |
| 2000-03-09 11:00:00 | DIA | ETF | 98.5312 | 98.7188 | 98.2188 | 98.4375 | 168100.0 |
| 2000-03-09 12:00:00 | DIA | ETF | 98.4375 | 98.9688 | 98.2812 | 98.625 | 234800.0 |
| 2000-03-09 13:00:00 | DIA | ETF | 98.625 | 98.8438 | 98.25 | 98.7188 | 70400.0 |
| 2000-03-09 14:00:00 | DIA | ETF | 98.7188 | 99.1562 | 98.625 | 98.9375 | 223300.0 |
| 2000-03-09 15:00:00 | DIA | ETF | 99.0938 | 100.1875 | 98.9375 | 100.0625 | 438000.0 |
| 2000-03-09 16:00:00 | DIA | ETF | 100.25 | 100.4375 | 100.1562 | 100.3125 | 133900.0 |
> showing 26 of 131 rows — these rows as CSV