PREVIEW / etf_1hour / 2002-07-15
file: by_date/etf_1hour/2002/2002-07-15.parquet size: 15 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-07-15 09:00:00 | SPY | ETF | 91.64 | 91.64 | 90.56 | 90.8 | 7749900.0 |
| 2002-07-15 10:00:00 | SPY | ETF | 90.74 | 91.15 | 90.12 | 90.51 | 9151500.0 |
| 2002-07-15 11:00:00 | SPY | ETF | 90.49 | 90.73 | 89.57 | 90.0 | 10044200.0 |
| 2002-07-15 12:00:00 | SPY | ETF | 90.0 | 90.01 | 89.15 | 89.62 | 6280400.0 |
| 2002-07-15 13:00:00 | SPY | ETF | 89.62 | 89.77 | 88.94 | 89.3 | 4216200.0 |
| 2002-07-15 14:00:00 | SPY | ETF | 89.34 | 89.37 | 87.89 | 89.06 | 11130400.0 |
| 2002-07-15 15:00:00 | SPY | ETF | 89.1 | 92.2 | 89.0 | 92.1 | 17498800.0 |
| 2002-07-15 16:00:00 | SPY | ETF | 92.01 | 92.4 | 91.9 | 92.34 | 1745100.0 |
| 2002-07-15 09:00:00 | QQQ | ETF | 24.68 | 24.7 | 24.32 | 24.56 | 13654700.0 |
| 2002-07-15 10:00:00 | QQQ | ETF | 24.56 | 24.89 | 24.36 | 24.68 | 22462500.0 |
| 2002-07-15 11:00:00 | QQQ | ETF | 24.65 | 24.82 | 24.46 | 24.74 | 15428700.0 |
| 2002-07-15 12:00:00 | QQQ | ETF | 24.7 | 24.76 | 24.4 | 24.58 | 10733400.0 |
| 2002-07-15 13:00:00 | QQQ | ETF | 24.58 | 24.64 | 24.25 | 24.4 | 12120500.0 |
| 2002-07-15 14:00:00 | QQQ | ETF | 24.39 | 24.42 | 23.75 | 24.18 | 27034600.0 |
| 2002-07-15 15:00:00 | QQQ | ETF | 24.18 | 25.44 | 24.15 | 25.41 | 32308700.0 |
| 2002-07-15 16:00:00 | QQQ | ETF | 25.41 | 25.64 | 25.24 | 25.57 | 1377100.0 |
| 2002-07-15 09:00:00 | IWM | ETF | 40.95 | 40.95 | 40.735 | 40.735 | 456800.0 |
| 2002-07-15 10:00:00 | IWM | ETF | 40.72 | 40.735 | 40.5 | 40.5 | 482400.0 |
| 2002-07-15 11:00:00 | IWM | ETF | 40.5 | 40.57 | 40.075 | 40.175 | 621400.0 |
| 2002-07-15 12:00:00 | IWM | ETF | 40.15 | 40.22 | 39.88 | 40.01 | 107800.0 |
| 2002-07-15 13:00:00 | IWM | ETF | 40.09 | 40.09 | 39.865 | 40.04 | 79800.0 |
| 2002-07-15 14:00:00 | IWM | ETF | 39.96 | 39.96 | 39.425 | 39.665 | 313600.0 |
| 2002-07-15 15:00:00 | IWM | ETF | 39.665 | 40.91 | 39.665 | 40.85 | 1317600.0 |
| 2002-07-15 16:00:00 | IWM | ETF | 40.755 | 40.85 | 40.755 | 40.77 | 13400.0 |
| 2002-07-15 09:00:00 | DIA | ETF | 86.41 | 86.41 | 85.19 | 85.53 | 1437200.0 |
| 2002-07-15 10:00:00 | DIA | ETF | 85.53 | 85.95 | 84.9 | 85.33 | 1890000.0 |
| 2002-07-15 11:00:00 | DIA | ETF | 85.16 | 85.41 | 84.03 | 84.46 | 2917200.0 |
| 2002-07-15 12:00:00 | DIA | ETF | 84.41 | 84.5 | 83.6 | 84.08 | 1699900.0 |
| 2002-07-15 13:00:00 | DIA | ETF | 84.09 | 84.18 | 83.4 | 83.77 | 1385300.0 |
| 2002-07-15 14:00:00 | DIA | ETF | 83.85 | 83.9 | 82.55 | 83.83 | 2888800.0 |
| 2002-07-15 15:00:00 | DIA | ETF | 83.83 | 86.75 | 83.69 | 86.54 | 6042600.0 |
| 2002-07-15 16:00:00 | DIA | ETF | 86.6 | 86.9 | 86.36 | 86.79 | 164500.0 |
> showing 32 of 329 rows — these rows as CSV