PREVIEW / etf_1hour / 2000-02-10
file: by_date/etf_1hour/2000/2000-02-10.parquet size: 8 KB rows: 134
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-02-10 09:00:00 | SPY | ETF | 141.625 | 142.0 | 141.0312 | 141.2812 | 1061800.0 |
| 2000-02-10 10:00:00 | SPY | ETF | 141.2812 | 142.1875 | 141.0625 | 141.125 | 1164500.0 |
| 2000-02-10 11:00:00 | SPY | ETF | 141.125 | 142.1562 | 141.0 | 141.8125 | 867700.0 |
| 2000-02-10 12:00:00 | SPY | ETF | 141.75 | 142.5625 | 141.6562 | 142.2812 | 387000.0 |
| 2000-02-10 13:00:00 | SPY | ETF | 142.1875 | 142.375 | 141.375 | 141.9062 | 896600.0 |
| 2000-02-10 14:00:00 | SPY | ETF | 141.8125 | 142.0 | 140.875 | 141.3125 | 1033700.0 |
| 2000-02-10 15:00:00 | SPY | ETF | 141.25 | 142.0 | 140.875 | 141.875 | 986400.0 |
| 2000-02-10 16:00:00 | SPY | ETF | 141.875 | 141.9062 | 141.375 | 141.5625 | 215700.0 |
| 2000-02-10 09:00:00 | QQQ | ETF | 99.8125 | 99.8125 | 98.5469 | 99.0938 | 4041400.0 |
| 2000-02-10 10:00:00 | QQQ | ETF | 98.9062 | 100.2188 | 98.875 | 99.375 | 4196400.0 |
| 2000-02-10 11:00:00 | QQQ | ETF | 99.375 | 100.625 | 99.25 | 100.4062 | 2910600.0 |
| 2000-02-10 12:00:00 | QQQ | ETF | 100.4375 | 101.6875 | 100.375 | 101.375 | 3140000.0 |
| 2000-02-10 13:00:00 | QQQ | ETF | 101.375 | 101.4375 | 100.5 | 101.0625 | 3050600.0 |
| 2000-02-10 14:00:00 | QQQ | ETF | 101.0938 | 101.25 | 100.0 | 100.5 | 3888000.0 |
| 2000-02-10 15:00:00 | QQQ | ETF | 100.5 | 102.1562 | 100.1562 | 102.0312 | 4418000.0 |
| 2000-02-10 16:00:00 | QQQ | ETF | 102.125 | 102.25 | 101.875 | 102.1875 | 478800.0 |
| 2000-02-10 17:00:00 | QQQ | ETF | 102.25 | 102.25 | 102.25 | 102.25 | 200.0 |
| 2000-02-10 18:00:00 | QQQ | ETF | 102.25 | 102.25 | 102.25 | 102.25 | 1000.0 |
| 2000-02-10 09:00:00 | DIA | ETF | 107.25 | 107.375 | 106.5 | 107.0 | 99000.0 |
| 2000-02-10 10:00:00 | DIA | ETF | 107.0 | 107.3438 | 106.5625 | 106.75 | 189600.0 |
| 2000-02-10 11:00:00 | DIA | ETF | 106.8438 | 107.25 | 106.5938 | 107.0625 | 123000.0 |
| 2000-02-10 12:00:00 | DIA | ETF | 107.0312 | 107.5938 | 106.875 | 107.2812 | 110000.0 |
| 2000-02-10 13:00:00 | DIA | ETF | 107.2812 | 107.2812 | 106.375 | 106.6562 | 152200.0 |
| 2000-02-10 14:00:00 | DIA | ETF | 106.875 | 106.9375 | 106.2812 | 106.5312 | 156900.0 |
| 2000-02-10 15:00:00 | DIA | ETF | 106.5 | 106.6562 | 106.0312 | 106.625 | 264300.0 |
| 2000-02-10 16:00:00 | DIA | ETF | 106.5938 | 107.0 | 106.125 | 107.0 | 49500.0 |
> showing 26 of 134 rows — these rows as CSV