PREVIEW / etf_1hour / 2002-09-04
file: by_date/etf_1hour/2002/2002-09-04.parquet size: 15 KB rows: 358
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-04 09:00:00 | SPY | ETF | 88.61 | 89.27 | 88.25 | 89.23 | 7569200.0 |
| 2002-09-04 10:00:00 | SPY | ETF | 89.23 | 89.38 | 88.41 | 88.62 | 9761100.0 |
| 2002-09-04 11:00:00 | SPY | ETF | 88.58 | 88.99 | 88.3 | 88.72 | 3706200.0 |
| 2002-09-04 12:00:00 | SPY | ETF | 88.72 | 88.79 | 88.06 | 88.61 | 5949700.0 |
| 2002-09-04 13:00:00 | SPY | ETF | 88.61 | 89.1 | 88.44 | 88.79 | 4170200.0 |
| 2002-09-04 14:00:00 | SPY | ETF | 88.79 | 89.9 | 88.77 | 89.7 | 7239100.0 |
| 2002-09-04 15:00:00 | SPY | ETF | 89.68 | 90.25 | 89.57 | 89.74 | 7690000.0 |
| 2002-09-04 16:00:00 | SPY | ETF | 89.73 | 89.8 | 89.32 | 89.54 | 1523500.0 |
| 2002-09-04 09:00:00 | QQQ | ETF | 22.5 | 22.85 | 22.42 | 22.84 | 12809900.0 |
| 2002-09-04 10:00:00 | QQQ | ETF | 22.84 | 22.9 | 22.51 | 22.56 | 13556600.0 |
| 2002-09-04 11:00:00 | QQQ | ETF | 22.56 | 22.69 | 22.43 | 22.54 | 6883100.0 |
| 2002-09-04 12:00:00 | QQQ | ETF | 22.54 | 22.54 | 22.24 | 22.45 | 10307000.0 |
| 2002-09-04 13:00:00 | QQQ | ETF | 22.43 | 22.6 | 22.32 | 22.47 | 8329300.0 |
| 2002-09-04 14:00:00 | QQQ | ETF | 22.45 | 22.93 | 22.45 | 22.88 | 13505400.0 |
| 2002-09-04 15:00:00 | QQQ | ETF | 22.88 | 23.02 | 22.82 | 22.85 | 14111500.0 |
| 2002-09-04 16:00:00 | QQQ | ETF | 22.85 | 22.89 | 22.72 | 22.73 | 601600.0 |
| 2002-09-04 09:00:00 | IWM | ETF | 37.85 | 38.205 | 37.725 | 38.195 | 89000.0 |
| 2002-09-04 10:00:00 | IWM | ETF | 38.08 | 38.245 | 37.825 | 37.87 | 455800.0 |
| 2002-09-04 11:00:00 | IWM | ETF | 37.92 | 38.05 | 37.83 | 37.99 | 156200.0 |
| 2002-09-04 12:00:00 | IWM | ETF | 38.05 | 38.07 | 37.85 | 38.065 | 91000.0 |
| 2002-09-04 13:00:00 | IWM | ETF | 38.05 | 38.19 | 37.95 | 38.175 | 348800.0 |
| 2002-09-04 14:00:00 | IWM | ETF | 38.18 | 38.725 | 38.155 | 38.725 | 221000.0 |
| 2002-09-04 15:00:00 | IWM | ETF | 38.65 | 38.9 | 38.645 | 38.735 | 459000.0 |
| 2002-09-04 16:00:00 | IWM | ETF | 38.7 | 38.7 | 38.675 | 38.675 | 2600.0 |
| 2002-09-04 09:00:00 | DIA | ETF | 83.59 | 84.0 | 83.04 | 83.93 | 1660900.0 |
| 2002-09-04 10:00:00 | DIA | ETF | 83.91 | 83.99 | 83.3 | 83.47 | 1966000.0 |
| 2002-09-04 11:00:00 | DIA | ETF | 83.47 | 83.8 | 83.14 | 83.54 | 1052700.0 |
| 2002-09-04 12:00:00 | DIA | ETF | 83.55 | 83.59 | 82.95 | 83.38 | 1525300.0 |
| 2002-09-04 13:00:00 | DIA | ETF | 83.41 | 83.86 | 83.23 | 83.58 | 1306400.0 |
| 2002-09-04 14:00:00 | DIA | ETF | 83.55 | 84.55 | 83.55 | 84.29 | 1859900.0 |
| 2002-09-04 15:00:00 | DIA | ETF | 84.33 | 84.79 | 84.2 | 84.4 | 1949100.0 |
| 2002-09-04 16:00:00 | DIA | ETF | 84.4 | 84.4 | 84.02 | 84.14 | 103900.0 |
| 2002-09-04 09:00:00 | TLT | ETF | 88.03 | 88.03 | 87.84 | 87.88 | 19100.0 |
| 2002-09-04 10:00:00 | TLT | ETF | 87.93 | 88.09 | 87.93 | 88.09 | 8000.0 |
| 2002-09-04 11:00:00 | TLT | ETF | 88.06 | 88.06 | 88.06 | 88.06 | 100.0 |
| 2002-09-04 12:00:00 | TLT | ETF | 88.18 | 88.2 | 88.17 | 88.2 | 2100.0 |
| 2002-09-04 13:00:00 | TLT | ETF | 88.05 | 88.2 | 88.05 | 88.16 | 5400.0 |
| 2002-09-04 14:00:00 | TLT | ETF | 88.2 | 88.3 | 88.2 | 88.3 | 3000.0 |
| 2002-09-04 15:00:00 | TLT | ETF | 88.18 | 88.18 | 87.89 | 88.02 | 27600.0 |
> showing 39 of 358 rows — these rows as CSV