PREVIEW / etf_1hour / 2000-04-17
file: by_date/etf_1hour/2000/2000-04-17.parquet size: 8 KB rows: 135
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-04-17 09:00:00 | SPY | ETF | 135.1875 | 137.75 | 135.1875 | 137.0 | 2313100.0 |
| 2000-04-17 10:00:00 | SPY | ETF | 137.0 | 138.1875 | 135.75 | 138.0 | 2479500.0 |
| 2000-04-17 11:00:00 | SPY | ETF | 137.75 | 138.25 | 136.75 | 137.125 | 7138200.0 |
| 2000-04-17 12:00:00 | SPY | ETF | 136.875 | 136.875 | 134.6875 | 136.0 | 3053700.0 |
| 2000-04-17 13:00:00 | SPY | ETF | 136.0625 | 137.1875 | 135.0938 | 135.0938 | 2328300.0 |
| 2000-04-17 14:00:00 | SPY | ETF | 135.25 | 138.25 | 135.125 | 138.2188 | 2923500.0 |
| 2000-04-17 15:00:00 | SPY | ETF | 138.1875 | 140.125 | 136.7188 | 140.0625 | 2820500.0 |
| 2000-04-17 16:00:00 | SPY | ETF | 140.25 | 140.4375 | 140.0 | 140.25 | 602900.0 |
| 2000-04-17 17:00:00 | SPY | ETF | 140.75 | 140.75 | 140.75 | 140.75 | 300.0 |
| 2000-04-17 09:00:00 | QQQ | ETF | 78.0312 | 83.375 | 78.0 | 82.75 | 8461300.0 |
| 2000-04-17 10:00:00 | QQQ | ETF | 82.625 | 84.75 | 80.625 | 84.5 | 9361300.0 |
| 2000-04-17 11:00:00 | QQQ | ETF | 84.5 | 84.9688 | 82.3125 | 82.625 | 6120700.0 |
| 2000-04-17 12:00:00 | QQQ | ETF | 82.6562 | 83.0 | 79.625 | 81.75 | 7743700.0 |
| 2000-04-17 13:00:00 | QQQ | ETF | 81.75 | 82.375 | 80.0 | 80.125 | 5271700.0 |
| 2000-04-17 14:00:00 | QQQ | ETF | 80.0 | 84.0625 | 79.5 | 84.0 | 7030900.0 |
| 2000-04-17 15:00:00 | QQQ | ETF | 83.875 | 88.0 | 82.0312 | 87.625 | 9902400.0 |
| 2000-04-17 16:00:00 | QQQ | ETF | 87.625 | 90.0 | 87.5 | 89.5 | 846100.0 |
| 2000-04-17 17:00:00 | QQQ | ETF | 89.5 | 90.0 | 89.0 | 89.75 | 13900.0 |
| 2000-04-17 18:00:00 | QQQ | ETF | 90.0 | 90.0 | 89.625 | 89.625 | 4200.0 |
| 2000-04-17 09:00:00 | DIA | ETF | 102.875 | 104.7812 | 102.875 | 104.125 | 1259700.0 |
| 2000-04-17 10:00:00 | DIA | ETF | 104.0 | 104.6875 | 103.0312 | 104.3125 | 1325600.0 |
| 2000-04-17 11:00:00 | DIA | ETF | 104.0625 | 104.5 | 103.5312 | 103.75 | 588300.0 |
| 2000-04-17 12:00:00 | DIA | ETF | 103.5 | 103.8125 | 102.25 | 103.5 | 386800.0 |
| 2000-04-17 13:00:00 | DIA | ETF | 103.5 | 104.3125 | 103.0 | 103.0 | 636600.0 |
| 2000-04-17 14:00:00 | DIA | ETF | 102.9688 | 105.0 | 102.7188 | 104.9375 | 796200.0 |
| 2000-04-17 15:00:00 | DIA | ETF | 104.9688 | 105.9688 | 103.75 | 105.9688 | 823000.0 |
| 2000-04-17 16:00:00 | DIA | ETF | 105.75 | 106.0312 | 105.5625 | 106.0 | 136200.0 |
> showing 27 of 135 rows — these rows as CSV