PREVIEW / etf_1hour / 2000-02-22
file: by_date/etf_1hour/2000/2000-02-22.parquet size: 8 KB rows: 129
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-22 09:00:00 | SPY | ETF | 135.1875 | 135.9688 | 135.0625 | 135.125 | 1563500.0 |
| 2000-02-22 10:00:00 | SPY | ETF | 135.0938 | 135.3125 | 133.7188 | 133.9375 | 2776700.0 |
| 2000-02-22 11:00:00 | SPY | ETF | 133.9688 | 134.75 | 133.5312 | 134.5625 | 2848800.0 |
| 2000-02-22 12:00:00 | SPY | ETF | 134.625 | 134.6875 | 133.8125 | 134.0312 | 805000.0 |
| 2000-02-22 13:00:00 | SPY | ETF | 134.0938 | 134.6875 | 133.8125 | 134.4062 | 1170000.0 |
| 2000-02-22 14:00:00 | SPY | ETF | 134.3125 | 134.6562 | 133.5312 | 134.6562 | 1180000.0 |
| 2000-02-22 15:00:00 | SPY | ETF | 134.5 | 136.3438 | 134.5 | 135.4062 | 4802000.0 |
| 2000-02-22 16:00:00 | SPY | ETF | 135.5312 | 135.5938 | 134.7188 | 134.9688 | 426900.0 |
| 2000-02-22 09:00:00 | QQQ | ETF | 99.0 | 99.9375 | 98.7812 | 99.2188 | 2968200.0 |
| 2000-02-22 10:00:00 | QQQ | ETF | 99.0625 | 99.1719 | 96.875 | 97.25 | 8809800.0 |
| 2000-02-22 11:00:00 | QQQ | ETF | 97.0625 | 98.1875 | 96.25 | 98.125 | 6467200.0 |
| 2000-02-22 12:00:00 | QQQ | ETF | 98.125 | 98.2188 | 97.0938 | 97.1875 | 2418600.0 |
| 2000-02-22 13:00:00 | QQQ | ETF | 97.1875 | 98.1875 | 97.0 | 97.625 | 2585400.0 |
| 2000-02-22 14:00:00 | QQQ | ETF | 97.6875 | 98.0 | 96.75 | 98.0 | 3814200.0 |
| 2000-02-22 15:00:00 | QQQ | ETF | 98.0 | 99.7031 | 97.9375 | 98.8438 | 9034000.0 |
| 2000-02-22 16:00:00 | QQQ | ETF | 98.875 | 98.9375 | 98.4375 | 98.5 | 259400.0 |
| 2000-02-22 17:00:00 | QQQ | ETF | 98.625 | 98.75 | 98.625 | 98.75 | 800.0 |
| 2000-02-22 09:00:00 | DIA | ETF | 102.875 | 103.0312 | 102.0625 | 102.2812 | 238800.0 |
| 2000-02-22 10:00:00 | DIA | ETF | 102.0938 | 102.3125 | 101.0 | 101.4688 | 228800.0 |
| 2000-02-22 11:00:00 | DIA | ETF | 101.4688 | 102.3125 | 101.1875 | 102.3125 | 169500.0 |
| 2000-02-22 12:00:00 | DIA | ETF | 102.125 | 102.2812 | 101.5625 | 101.8438 | 142100.0 |
| 2000-02-22 13:00:00 | DIA | ETF | 101.875 | 102.4375 | 101.6875 | 102.0 | 132800.0 |
| 2000-02-22 14:00:00 | DIA | ETF | 101.875 | 102.1562 | 101.375 | 102.1562 | 156300.0 |
| 2000-02-22 15:00:00 | DIA | ETF | 102.1562 | 103.4688 | 102.0938 | 103.0312 | 390300.0 |
| 2000-02-22 16:00:00 | DIA | ETF | 103.0312 | 103.0312 | 102.625 | 102.8125 | 58100.0 |
> showing 25 of 129 rows — these rows as CSV