PREVIEW / etf_1hour / 2002-02-19
file: by_date/etf_1hour/2002/2002-02-19.parquet size: 14 KB rows: 295
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-19 09:00:00 | SPY | ETF | 110.23 | 110.29 | 109.88 | 110.13 | 1970200.0 |
| 2002-02-19 10:00:00 | SPY | ETF | 110.08 | 110.29 | 109.28 | 109.52 | 3264800.0 |
| 2002-02-19 11:00:00 | SPY | ETF | 109.52 | 109.69 | 109.23 | 109.66 | 1358600.0 |
| 2002-02-19 12:00:00 | SPY | ETF | 109.7 | 109.79 | 109.2 | 109.25 | 1439300.0 |
| 2002-02-19 13:00:00 | SPY | ETF | 109.21 | 109.58 | 109.2 | 109.33 | 1653700.0 |
| 2002-02-19 14:00:00 | SPY | ETF | 109.33 | 109.6 | 109.08 | 109.43 | 1148700.0 |
| 2002-02-19 15:00:00 | SPY | ETF | 109.4 | 109.43 | 108.61 | 108.74 | 2923500.0 |
| 2002-02-19 16:00:00 | SPY | ETF | 108.74 | 108.83 | 108.67 | 108.8 | 1543000.0 |
| 2002-02-19 17:00:00 | SPY | ETF | 108.85 | 108.88 | 108.76 | 108.8 | 3800.0 |
| 2002-02-19 18:00:00 | SPY | ETF | 108.8 | 108.8 | 108.8 | 108.8 | 200.0 |
| 2002-02-19 09:00:00 | QQQ | ETF | 35.37 | 35.42 | 35.18 | 35.31 | 9140100.0 |
| 2002-02-19 10:00:00 | QQQ | ETF | 35.31 | 35.46 | 34.94 | 35.1 | 11596000.0 |
| 2002-02-19 11:00:00 | QQQ | ETF | 35.09 | 35.12 | 34.86 | 35.08 | 9643900.0 |
| 2002-02-19 12:00:00 | QQQ | ETF | 35.07 | 35.12 | 34.69 | 34.72 | 7711700.0 |
| 2002-02-19 13:00:00 | QQQ | ETF | 34.74 | 34.91 | 34.65 | 34.73 | 6570700.0 |
| 2002-02-19 14:00:00 | QQQ | ETF | 34.74 | 34.85 | 34.58 | 34.77 | 6663500.0 |
| 2002-02-19 15:00:00 | QQQ | ETF | 34.77 | 34.85 | 34.32 | 34.56 | 15267500.0 |
| 2002-02-19 16:00:00 | QQQ | ETF | 34.56 | 34.89 | 34.47 | 34.62 | 4001200.0 |
| 2002-02-19 17:00:00 | QQQ | ETF | 34.63 | 34.65 | 34.61 | 34.65 | 29300.0 |
| 2002-02-19 18:00:00 | QQQ | ETF | 34.67 | 34.7 | 34.61 | 34.63 | 31700.0 |
| 2002-02-19 09:00:00 | IWM | ETF | 46.25 | 46.4 | 46.2 | 46.345 | 165800.0 |
| 2002-02-19 10:00:00 | IWM | ETF | 46.3 | 46.35 | 45.98 | 46.105 | 129800.0 |
| 2002-02-19 11:00:00 | IWM | ETF | 46.0 | 46.105 | 45.93 | 46.06 | 123200.0 |
| 2002-02-19 12:00:00 | IWM | ETF | 46.085 | 46.095 | 45.9 | 45.945 | 80200.0 |
| 2002-02-19 13:00:00 | IWM | ETF | 45.89 | 46.045 | 45.84 | 46.025 | 47000.0 |
| 2002-02-19 14:00:00 | IWM | ETF | 45.95 | 46.0 | 45.9 | 46.0 | 22800.0 |
| 2002-02-19 15:00:00 | IWM | ETF | 46.0 | 46.0 | 45.625 | 45.765 | 236000.0 |
| 2002-02-19 16:00:00 | IWM | ETF | 45.625 | 45.775 | 45.625 | 45.755 | 161200.0 |
| 2002-02-19 09:00:00 | DIA | ETF | 98.6 | 98.75 | 98.35 | 98.67 | 477300.0 |
| 2002-02-19 10:00:00 | DIA | ETF | 98.62 | 98.9 | 98.05 | 98.28 | 714000.0 |
| 2002-02-19 11:00:00 | DIA | ETF | 98.25 | 98.5 | 98.11 | 98.48 | 778600.0 |
| 2002-02-19 12:00:00 | DIA | ETF | 98.45 | 98.56 | 98.0 | 98.0 | 184400.0 |
| 2002-02-19 13:00:00 | DIA | ETF | 98.0 | 98.38 | 98.0 | 98.15 | 444600.0 |
| 2002-02-19 14:00:00 | DIA | ETF | 98.17 | 98.47 | 98.01 | 98.26 | 211200.0 |
| 2002-02-19 15:00:00 | DIA | ETF | 98.25 | 98.26 | 97.37 | 97.46 | 798000.0 |
| 2002-02-19 16:00:00 | DIA | ETF | 97.49 | 97.58 | 97.47 | 97.5 | 69300.0 |
> showing 36 of 295 rows — these rows as CSV