PREVIEW / etf_1hour / 2002-09-23
file: by_date/etf_1hour/2002/2002-09-23.parquet size: 15 KB rows: 357
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-09-23 09:00:00 | SPY | ETF | 83.65 | 83.97 | 83.5 | 83.8 | 4763900.0 |
| 2002-09-23 10:00:00 | SPY | ETF | 83.72 | 84.05 | 82.69 | 82.93 | 9807200.0 |
| 2002-09-23 11:00:00 | SPY | ETF | 82.96 | 83.52 | 82.83 | 83.1 | 6578500.0 |
| 2002-09-23 12:00:00 | SPY | ETF | 83.11 | 83.58 | 82.86 | 83.5 | 4113600.0 |
| 2002-09-23 13:00:00 | SPY | ETF | 83.44 | 83.76 | 83.14 | 83.53 | 4037300.0 |
| 2002-09-23 14:00:00 | SPY | ETF | 83.52 | 83.52 | 82.97 | 83.06 | 4833100.0 |
| 2002-09-23 15:00:00 | SPY | ETF | 83.02 | 84.06 | 82.84 | 83.59 | 9258200.0 |
| 2002-09-23 16:00:00 | SPY | ETF | 83.59 | 83.76 | 83.49 | 83.66 | 1655600.0 |
| 2002-09-23 09:00:00 | QQQ | ETF | 21.45 | 21.52 | 21.27 | 21.33 | 7845300.0 |
| 2002-09-23 10:00:00 | QQQ | ETF | 21.32 | 21.41 | 20.99 | 21.08 | 18135000.0 |
| 2002-09-23 11:00:00 | QQQ | ETF | 21.09 | 21.19 | 21.0 | 21.03 | 7629800.0 |
| 2002-09-23 12:00:00 | QQQ | ETF | 21.04 | 21.17 | 20.96 | 21.15 | 6054900.0 |
| 2002-09-23 13:00:00 | QQQ | ETF | 21.15 | 21.29 | 21.06 | 21.09 | 9530700.0 |
| 2002-09-23 14:00:00 | QQQ | ETF | 21.1 | 21.11 | 20.85 | 20.88 | 8273900.0 |
| 2002-09-23 15:00:00 | QQQ | ETF | 20.89 | 21.24 | 20.81 | 20.98 | 12306800.0 |
| 2002-09-23 16:00:00 | QQQ | ETF | 20.98 | 21.06 | 20.96 | 21.02 | 585800.0 |
| 2002-09-23 09:00:00 | IWM | ETF | 36.3 | 36.445 | 36.245 | 36.39 | 416400.0 |
| 2002-09-23 10:00:00 | IWM | ETF | 36.375 | 36.38 | 35.985 | 36.035 | 245600.0 |
| 2002-09-23 11:00:00 | IWM | ETF | 35.985 | 36.11 | 35.915 | 35.915 | 239200.0 |
| 2002-09-23 12:00:00 | IWM | ETF | 35.915 | 35.92 | 35.775 | 35.86 | 57800.0 |
| 2002-09-23 13:00:00 | IWM | ETF | 35.845 | 35.945 | 35.775 | 35.805 | 130200.0 |
| 2002-09-23 14:00:00 | IWM | ETF | 35.795 | 35.795 | 35.535 | 35.535 | 66000.0 |
| 2002-09-23 15:00:00 | IWM | ETF | 35.53 | 35.835 | 35.4 | 35.67 | 471200.0 |
| 2002-09-23 16:00:00 | IWM | ETF | 35.675 | 35.675 | 35.65 | 35.65 | 11600.0 |
| 2002-09-23 09:00:00 | DIA | ETF | 79.02 | 79.2 | 78.7 | 78.84 | 1068600.0 |
| 2002-09-23 10:00:00 | DIA | ETF | 78.84 | 79.15 | 77.91 | 78.11 | 2051100.0 |
| 2002-09-23 11:00:00 | DIA | ETF | 78.1 | 78.66 | 78.03 | 78.28 | 1510100.0 |
| 2002-09-23 12:00:00 | DIA | ETF | 78.28 | 78.61 | 78.0 | 78.6 | 764900.0 |
| 2002-09-23 13:00:00 | DIA | ETF | 78.55 | 78.9 | 78.32 | 78.66 | 847400.0 |
| 2002-09-23 14:00:00 | DIA | ETF | 78.62 | 78.73 | 78.19 | 78.26 | 608300.0 |
| 2002-09-23 15:00:00 | DIA | ETF | 78.28 | 79.23 | 77.31 | 78.75 | 1928500.0 |
| 2002-09-23 16:00:00 | DIA | ETF | 78.77 | 78.89 | 78.65 | 78.8 | 32300.0 |
| 2002-09-23 09:00:00 | TLT | ETF | 90.0 | 90.04 | 89.82 | 89.9 | 5300.0 |
| 2002-09-23 10:00:00 | TLT | ETF | 89.84 | 90.05 | 89.77 | 90.05 | 12400.0 |
| 2002-09-23 11:00:00 | TLT | ETF | 90.0 | 90.06 | 89.82 | 89.98 | 23300.0 |
| 2002-09-23 12:00:00 | TLT | ETF | 90.0 | 90.24 | 90.0 | 90.06 | 26200.0 |
| 2002-09-23 13:00:00 | TLT | ETF | 89.98 | 90.12 | 89.91 | 90.03 | 21600.0 |
| 2002-09-23 14:00:00 | TLT | ETF | 89.97 | 90.1 | 89.97 | 90.1 | 6900.0 |
| 2002-09-23 15:00:00 | TLT | ETF | 90.14 | 90.23 | 89.96 | 90.02 | 67400.0 |
| 2002-09-23 16:00:00 | TLT | ETF | 90.1 | 90.1 | 90.1 | 90.1 | 100.0 |
> showing 40 of 357 rows — these rows as CSV