PREVIEW / etf_1hour / 2002-07-30
file: by_date/etf_1hour/2002/2002-07-30.parquet size: 15 KB rows: 351
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-07-30 09:00:00 | SPY | ETF | 89.32 | 89.6 | 89.0 | 89.27 | 4743600.0 |
| 2002-07-30 10:00:00 | SPY | ETF | 89.26 | 89.83 | 88.72 | 89.37 | 7768300.0 |
| 2002-07-30 11:00:00 | SPY | ETF | 89.37 | 89.53 | 88.77 | 89.42 | 4279500.0 |
| 2002-07-30 12:00:00 | SPY | ETF | 89.44 | 90.57 | 89.38 | 90.12 | 5604100.0 |
| 2002-07-30 13:00:00 | SPY | ETF | 90.15 | 91.4 | 90.01 | 91.27 | 7376400.0 |
| 2002-07-30 14:00:00 | SPY | ETF | 91.33 | 91.34 | 89.66 | 89.73 | 7197700.0 |
| 2002-07-30 15:00:00 | SPY | ETF | 89.7 | 90.76 | 89.59 | 90.63 | 6866600.0 |
| 2002-07-30 16:00:00 | SPY | ETF | 90.7 | 90.94 | 90.55 | 90.94 | 1558100.0 |
| 2002-07-30 09:00:00 | QQQ | ETF | 23.73 | 23.9 | 23.61 | 23.82 | 15353100.0 |
| 2002-07-30 10:00:00 | QQQ | ETF | 23.82 | 24.05 | 23.59 | 23.95 | 23489000.0 |
| 2002-07-30 11:00:00 | QQQ | ETF | 23.98 | 24.05 | 23.82 | 23.99 | 8202200.0 |
| 2002-07-30 12:00:00 | QQQ | ETF | 24.0 | 24.34 | 23.97 | 24.28 | 14094400.0 |
| 2002-07-30 13:00:00 | QQQ | ETF | 24.28 | 24.69 | 24.21 | 24.61 | 19501100.0 |
| 2002-07-30 14:00:00 | QQQ | ETF | 24.61 | 24.66 | 24.07 | 24.1 | 16331500.0 |
| 2002-07-30 15:00:00 | QQQ | ETF | 24.12 | 24.4 | 24.06 | 24.34 | 16121800.0 |
| 2002-07-30 16:00:00 | QQQ | ETF | 24.36 | 24.36 | 24.28 | 24.31 | 815900.0 |
| 2002-07-30 09:00:00 | IWM | ETF | 39.85 | 39.85 | 39.5 | 39.725 | 822200.0 |
| 2002-07-30 10:00:00 | IWM | ETF | 39.6 | 39.7 | 39.005 | 39.155 | 582800.0 |
| 2002-07-30 11:00:00 | IWM | ETF | 39.1 | 39.125 | 38.76 | 39.035 | 166800.0 |
| 2002-07-30 12:00:00 | IWM | ETF | 38.99 | 39.95 | 38.99 | 39.78 | 320200.0 |
| 2002-07-30 13:00:00 | IWM | ETF | 39.765 | 40.2 | 39.765 | 40.185 | 340200.0 |
| 2002-07-30 14:00:00 | IWM | ETF | 40.195 | 40.215 | 39.62 | 39.62 | 435000.0 |
| 2002-07-30 15:00:00 | IWM | ETF | 39.61 | 40.0 | 39.55 | 40.0 | 649600.0 |
| 2002-07-30 16:00:00 | IWM | ETF | 40.1 | 40.1 | 39.895 | 39.895 | 20200.0 |
| 2002-07-30 09:00:00 | DIA | ETF | 86.35 | 86.6 | 86.02 | 86.36 | 2024300.0 |
| 2002-07-30 10:00:00 | DIA | ETF | 86.28 | 86.75 | 85.65 | 86.1 | 2957700.0 |
| 2002-07-30 11:00:00 | DIA | ETF | 86.1 | 86.3 | 85.41 | 86.17 | 1477500.0 |
| 2002-07-30 12:00:00 | DIA | ETF | 86.2 | 87.15 | 86.16 | 86.62 | 1551900.0 |
| 2002-07-30 13:00:00 | DIA | ETF | 86.69 | 87.75 | 86.47 | 87.58 | 2030100.0 |
| 2002-07-30 14:00:00 | DIA | ETF | 87.55 | 87.65 | 86.04 | 86.08 | 2295200.0 |
| 2002-07-30 15:00:00 | DIA | ETF | 86.06 | 86.99 | 85.95 | 86.92 | 2449500.0 |
| 2002-07-30 16:00:00 | DIA | ETF | 86.92 | 87.1 | 86.9 | 87.05 | 62000.0 |
| 2002-07-30 09:00:00 | TLT | ETF | 81.75 | 81.83 | 81.75 | 81.83 | 500.0 |
| 2002-07-30 10:00:00 | TLT | ETF | 81.8 | 81.8 | 81.8 | 81.8 | 200.0 |
| 2002-07-30 12:00:00 | TLT | ETF | 81.9 | 81.9 | 81.76 | 81.76 | 1500.0 |
| 2002-07-30 13:00:00 | TLT | ETF | 81.57 | 81.57 | 81.54 | 81.54 | 200.0 |
| 2002-07-30 14:00:00 | TLT | ETF | 81.6 | 81.64 | 81.58 | 81.64 | 3400.0 |
| 2002-07-30 15:00:00 | TLT | ETF | 81.66 | 81.66 | 81.52 | 81.52 | 300.0 |
> showing 38 of 351 rows — these rows as CSV