PREVIEW / etf_1hour / 2002-09-06
file: by_date/etf_1hour/2002/2002-09-06.parquet size: 14 KB rows: 329
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-06 09:00:00 | SPY | ETF | 89.75 | 90.45 | 89.71 | 89.84 | 7733400.0 |
| 2002-09-06 10:00:00 | SPY | ETF | 89.86 | 90.1 | 89.34 | 89.93 | 7436400.0 |
| 2002-09-06 11:00:00 | SPY | ETF | 89.95 | 90.25 | 89.52 | 89.91 | 4142500.0 |
| 2002-09-06 12:00:00 | SPY | ETF | 89.94 | 90.18 | 89.76 | 90.12 | 1903000.0 |
| 2002-09-06 13:00:00 | SPY | ETF | 90.14 | 90.33 | 89.95 | 90.03 | 2708500.0 |
| 2002-09-06 14:00:00 | SPY | ETF | 90.0 | 90.34 | 89.84 | 90.22 | 3008400.0 |
| 2002-09-06 15:00:00 | SPY | ETF | 90.25 | 90.57 | 89.72 | 89.86 | 6832000.0 |
| 2002-09-06 16:00:00 | SPY | ETF | 89.86 | 90.08 | 89.74 | 90.0 | 1248200.0 |
| 2002-09-06 09:00:00 | QQQ | ETF | 22.66 | 22.9 | 22.65 | 22.8 | 14697800.0 |
| 2002-09-06 10:00:00 | QQQ | ETF | 22.81 | 22.95 | 22.6 | 22.92 | 19768700.0 |
| 2002-09-06 11:00:00 | QQQ | ETF | 22.9 | 23.0 | 22.75 | 22.86 | 10688800.0 |
| 2002-09-06 12:00:00 | QQQ | ETF | 22.85 | 23.02 | 22.84 | 23.0 | 7068200.0 |
| 2002-09-06 13:00:00 | QQQ | ETF | 23.0 | 23.11 | 22.98 | 23.0 | 7507300.0 |
| 2002-09-06 14:00:00 | QQQ | ETF | 23.0 | 23.11 | 22.93 | 23.08 | 6102000.0 |
| 2002-09-06 15:00:00 | QQQ | ETF | 23.07 | 23.22 | 22.85 | 22.9 | 17204300.0 |
| 2002-09-06 16:00:00 | QQQ | ETF | 22.91 | 22.92 | 22.85 | 22.85 | 1099500.0 |
| 2002-09-06 09:00:00 | IWM | ETF | 38.4 | 38.65 | 38.4 | 38.47 | 67400.0 |
| 2002-09-06 10:00:00 | IWM | ETF | 38.46 | 38.94 | 38.46 | 38.94 | 241600.0 |
| 2002-09-06 11:00:00 | IWM | ETF | 38.94 | 39.0 | 38.755 | 38.865 | 72400.0 |
| 2002-09-06 12:00:00 | IWM | ETF | 38.87 | 38.975 | 38.825 | 38.925 | 34000.0 |
| 2002-09-06 13:00:00 | IWM | ETF | 38.97 | 39.055 | 38.85 | 38.975 | 157200.0 |
| 2002-09-06 14:00:00 | IWM | ETF | 38.975 | 39.1 | 38.925 | 39.1 | 77000.0 |
| 2002-09-06 15:00:00 | IWM | ETF | 39.06 | 39.19 | 38.945 | 39.16 | 891400.0 |
| 2002-09-06 16:00:00 | IWM | ETF | 39.2 | 39.2 | 39.15 | 39.15 | 186800.0 |
| 2002-09-06 09:00:00 | DIA | ETF | 84.31 | 84.99 | 84.2 | 84.34 | 1736200.0 |
| 2002-09-06 10:00:00 | DIA | ETF | 84.34 | 84.65 | 83.9 | 84.3 | 2286800.0 |
| 2002-09-06 11:00:00 | DIA | ETF | 84.29 | 84.59 | 84.01 | 84.38 | 1061000.0 |
| 2002-09-06 12:00:00 | DIA | ETF | 84.39 | 84.61 | 84.2 | 84.53 | 644700.0 |
| 2002-09-06 13:00:00 | DIA | ETF | 84.56 | 84.8 | 84.38 | 84.53 | 757500.0 |
| 2002-09-06 14:00:00 | DIA | ETF | 84.53 | 84.84 | 84.33 | 84.7 | 805000.0 |
| 2002-09-06 15:00:00 | DIA | ETF | 84.7 | 85.0 | 84.27 | 84.38 | 1551600.0 |
| 2002-09-06 16:00:00 | DIA | ETF | 84.39 | 84.55 | 84.37 | 84.52 | 103700.0 |
| 2002-09-06 09:00:00 | TLT | ETF | 87.97 | 88.08 | 87.87 | 88.08 | 6000.0 |
| 2002-09-06 10:00:00 | TLT | ETF | 88.0 | 88.19 | 87.95 | 88.14 | 71700.0 |
| 2002-09-06 11:00:00 | TLT | ETF | 87.98 | 88.11 | 87.5 | 87.51 | 12600.0 |
| 2002-09-06 12:00:00 | TLT | ETF | 87.51 | 87.6 | 87.27 | 87.44 | 11900.0 |
| 2002-09-06 13:00:00 | TLT | ETF | 87.42 | 87.43 | 87.26 | 87.43 | 7200.0 |
| 2002-09-06 14:00:00 | TLT | ETF | 87.48 | 87.48 | 87.2 | 87.3 | 17500.0 |
| 2002-09-06 15:00:00 | TLT | ETF | 87.25 | 87.5 | 87.24 | 87.46 | 13100.0 |
> showing 39 of 329 rows — these rows as CSV