PREVIEW / etf_1hour / 2002-02-21
file: by_date/etf_1hour/2002/2002-02-21.parquet size: 13 KB rows: 287
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 |
|---|---|---|---|---|---|---|---|
| 2002-02-21 09:00:00 | SPY | ETF | 109.93 | 110.28 | 109.85 | 110.22 | 2326300.0 |
| 2002-02-21 10:00:00 | SPY | ETF | 110.22 | 110.53 | 109.79 | 110.06 | 4232100.0 |
| 2002-02-21 11:00:00 | SPY | ETF | 110.0 | 110.29 | 109.77 | 110.07 | 3324000.0 |
| 2002-02-21 12:00:00 | SPY | ETF | 110.12 | 110.63 | 110.09 | 110.38 | 3025800.0 |
| 2002-02-21 13:00:00 | SPY | ETF | 110.37 | 110.57 | 109.9 | 109.96 | 1866800.0 |
| 2002-02-21 14:00:00 | SPY | ETF | 109.9 | 110.18 | 109.7 | 109.76 | 2900700.0 |
| 2002-02-21 15:00:00 | SPY | ETF | 109.7 | 109.72 | 108.4 | 108.6 | 4674000.0 |
| 2002-02-21 16:00:00 | SPY | ETF | 108.58 | 108.61 | 108.0 | 108.4 | 3286800.0 |
| 2002-02-21 17:00:00 | SPY | ETF | 108.32 | 108.4 | 108.3 | 108.4 | 59900.0 |
| 2002-02-21 18:00:00 | SPY | ETF | 108.38 | 108.38 | 108.38 | 108.38 | 200.0 |
| 2002-02-21 09:00:00 | QQQ | ETF | 34.79 | 34.95 | 34.41 | 34.58 | 14361100.0 |
| 2002-02-21 10:00:00 | QQQ | ETF | 34.59 | 34.84 | 34.29 | 34.42 | 15726100.0 |
| 2002-02-21 11:00:00 | QQQ | ETF | 34.43 | 34.64 | 34.25 | 34.6 | 9031400.0 |
| 2002-02-21 12:00:00 | QQQ | ETF | 34.6 | 34.95 | 34.51 | 34.77 | 15146400.0 |
| 2002-02-21 13:00:00 | QQQ | ETF | 34.8 | 34.94 | 34.44 | 34.48 | 9165200.0 |
| 2002-02-21 14:00:00 | QQQ | ETF | 34.45 | 34.56 | 34.2 | 34.22 | 11717300.0 |
| 2002-02-21 15:00:00 | QQQ | ETF | 34.26 | 34.27 | 33.6 | 33.6 | 28306100.0 |
| 2002-02-21 16:00:00 | QQQ | ETF | 33.61 | 33.85 | 33.46 | 33.65 | 3661800.0 |
| 2002-02-21 17:00:00 | QQQ | ETF | 33.65 | 33.66 | 33.55 | 33.61 | 337100.0 |
| 2002-02-21 18:00:00 | QQQ | ETF | 33.62 | 33.64 | 33.56 | 33.58 | 29200.0 |
| 2002-02-21 09:00:00 | IWM | ETF | 46.45 | 46.45 | 46.275 | 46.365 | 54200.0 |
| 2002-02-21 10:00:00 | IWM | ETF | 46.4 | 46.46 | 46.285 | 46.305 | 51400.0 |
| 2002-02-21 11:00:00 | IWM | ETF | 46.4 | 46.435 | 46.275 | 46.435 | 73800.0 |
| 2002-02-21 12:00:00 | IWM | ETF | 46.445 | 46.545 | 46.375 | 46.545 | 23800.0 |
| 2002-02-21 13:00:00 | IWM | ETF | 46.525 | 46.55 | 46.365 | 46.405 | 19600.0 |
| 2002-02-21 14:00:00 | IWM | ETF | 46.41 | 46.415 | 46.285 | 46.355 | 46800.0 |
| 2002-02-21 15:00:00 | IWM | ETF | 46.255 | 46.345 | 45.58 | 45.58 | 267600.0 |
| 2002-02-21 16:00:00 | IWM | ETF | 45.58 | 45.61 | 45.525 | 45.525 | 117800.0 |
| 2002-02-21 09:00:00 | DIA | ETF | 99.37 | 99.93 | 99.29 | 99.93 | 898100.0 |
| 2002-02-21 10:00:00 | DIA | ETF | 99.94 | 100.1 | 99.58 | 99.8 | 1507600.0 |
| 2002-02-21 11:00:00 | DIA | ETF | 99.8 | 100.12 | 99.6 | 99.84 | 401700.0 |
| 2002-02-21 12:00:00 | DIA | ETF | 99.89 | 100.46 | 99.89 | 100.3 | 2613300.0 |
| 2002-02-21 13:00:00 | DIA | ETF | 100.3 | 100.44 | 99.8 | 99.85 | 724100.0 |
| 2002-02-21 14:00:00 | DIA | ETF | 99.84 | 100.08 | 99.68 | 99.79 | 875900.0 |
| 2002-02-21 15:00:00 | DIA | ETF | 99.73 | 99.73 | 98.35 | 98.6 | 2955300.0 |
| 2002-02-21 16:00:00 | DIA | ETF | 98.6 | 99.39 | 98.35 | 98.78 | 126500.0 |
| 2002-02-21 17:00:00 | DIA | ETF | 98.7 | 98.7 | 98.7 | 98.7 | 500.0 |
| 2002-02-21 18:00:00 | DIA | ETF | 98.7 | 98.7 | 98.43 | 98.43 | 500.0 |
> showing 38 of 287 rows — these rows as CSV