PREVIEW / etf_1hour / 2002-09-18
file: by_date/etf_1hour/2002/2002-09-18.parquet size: 15 KB rows: 348
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-18 09:00:00 | SPY | ETF | 87.01 | 87.51 | 86.81 | 87.29 | 6678900.0 |
| 2002-09-18 10:00:00 | SPY | ETF | 87.3 | 87.31 | 86.44 | 86.5 | 6962900.0 |
| 2002-09-18 11:00:00 | SPY | ETF | 86.5 | 86.8 | 86.28 | 86.53 | 3890700.0 |
| 2002-09-18 12:00:00 | SPY | ETF | 86.53 | 86.98 | 86.46 | 86.54 | 3664100.0 |
| 2002-09-18 13:00:00 | SPY | ETF | 86.57 | 87.35 | 86.47 | 87.11 | 6897200.0 |
| 2002-09-18 14:00:00 | SPY | ETF | 87.12 | 88.11 | 86.96 | 87.92 | 8125300.0 |
| 2002-09-18 15:00:00 | SPY | ETF | 87.93 | 88.5 | 87.4 | 87.49 | 10595900.0 |
| 2002-09-18 16:00:00 | SPY | ETF | 87.46 | 87.57 | 86.49 | 86.95 | 1755400.0 |
| 2002-09-18 09:00:00 | QQQ | ETF | 22.01 | 22.24 | 21.95 | 22.09 | 12601900.0 |
| 2002-09-18 10:00:00 | QQQ | ETF | 22.09 | 22.13 | 21.82 | 21.86 | 10722800.0 |
| 2002-09-18 11:00:00 | QQQ | ETF | 21.83 | 21.94 | 21.78 | 21.89 | 7759700.0 |
| 2002-09-18 12:00:00 | QQQ | ETF | 21.9 | 22.05 | 21.83 | 21.84 | 7310100.0 |
| 2002-09-18 13:00:00 | QQQ | ETF | 21.83 | 22.14 | 21.81 | 22.04 | 8248300.0 |
| 2002-09-18 14:00:00 | QQQ | ETF | 22.08 | 22.44 | 22.01 | 22.36 | 13201300.0 |
| 2002-09-18 15:00:00 | QQQ | ETF | 22.36 | 22.55 | 22.15 | 22.24 | 21271600.0 |
| 2002-09-18 16:00:00 | QQQ | ETF | 22.24 | 22.25 | 21.85 | 21.93 | 2121400.0 |
| 2002-09-18 09:00:00 | IWM | ETF | 37.325 | 37.665 | 37.3 | 37.63 | 491800.0 |
| 2002-09-18 10:00:00 | IWM | ETF | 37.53 | 37.53 | 37.155 | 37.155 | 207400.0 |
| 2002-09-18 11:00:00 | IWM | ETF | 37.16 | 37.3 | 37.155 | 37.275 | 131400.0 |
| 2002-09-18 12:00:00 | IWM | ETF | 37.27 | 37.375 | 37.125 | 37.125 | 85600.0 |
| 2002-09-18 13:00:00 | IWM | ETF | 37.145 | 37.325 | 37.1 | 37.205 | 151000.0 |
| 2002-09-18 14:00:00 | IWM | ETF | 37.205 | 37.635 | 37.205 | 37.625 | 174600.0 |
| 2002-09-18 15:00:00 | IWM | ETF | 37.595 | 37.85 | 37.425 | 37.425 | 856000.0 |
| 2002-09-18 16:00:00 | IWM | ETF | 37.775 | 37.775 | 37.775 | 37.775 | 600.0 |
| 2002-09-18 09:00:00 | DIA | ETF | 81.41 | 81.98 | 81.25 | 81.74 | 1843800.0 |
| 2002-09-18 10:00:00 | DIA | ETF | 81.7 | 81.75 | 80.86 | 80.99 | 1481600.0 |
| 2002-09-18 11:00:00 | DIA | ETF | 80.99 | 81.29 | 80.77 | 81.03 | 1015400.0 |
| 2002-09-18 12:00:00 | DIA | ETF | 81.02 | 81.57 | 80.95 | 81.08 | 1500500.0 |
| 2002-09-18 13:00:00 | DIA | ETF | 81.1 | 81.89 | 81.07 | 81.56 | 1164400.0 |
| 2002-09-18 14:00:00 | DIA | ETF | 81.6 | 82.6 | 81.42 | 82.3 | 1736500.0 |
| 2002-09-18 15:00:00 | DIA | ETF | 82.32 | 82.86 | 81.88 | 81.95 | 2167800.0 |
| 2002-09-18 16:00:00 | DIA | ETF | 81.95 | 82.05 | 81.19 | 81.42 | 426100.0 |
| 2002-09-18 09:00:00 | TLT | ETF | 89.46 | 89.46 | 89.2 | 89.3 | 36000.0 |
| 2002-09-18 10:00:00 | TLT | ETF | 89.25 | 89.28 | 89.09 | 89.22 | 6900.0 |
| 2002-09-18 11:00:00 | TLT | ETF | 89.08 | 89.52 | 89.08 | 89.44 | 60200.0 |
| 2002-09-18 12:00:00 | TLT | ETF | 89.4 | 89.45 | 89.25 | 89.45 | 6900.0 |
| 2002-09-18 13:00:00 | TLT | ETF | 89.44 | 89.56 | 89.24 | 89.42 | 27600.0 |
| 2002-09-18 14:00:00 | TLT | ETF | 89.38 | 89.46 | 89.1 | 89.1 | 50100.0 |
| 2002-09-18 15:00:00 | TLT | ETF | 89.1 | 89.1 | 89.02 | 89.1 | 7000.0 |
| 2002-09-18 16:00:00 | TLT | ETF | 89.06 | 89.18 | 89.06 | 89.16 | 1900.0 |
> showing 40 of 348 rows — these rows as CSV