PREVIEW / etf_1hour / 2002-08-08
file: by_date/etf_1hour/2002/2002-08-08.parquet size: 15 KB rows: 338
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-08-08 09:00:00 | SPY | ETF | 88.42 | 89.15 | 87.82 | 88.71 | 8374200.0 |
| 2002-08-08 10:00:00 | SPY | ETF | 88.71 | 88.92 | 87.8 | 88.25 | 7415800.0 |
| 2002-08-08 11:00:00 | SPY | ETF | 88.21 | 89.29 | 88.21 | 89.03 | 5225500.0 |
| 2002-08-08 12:00:00 | SPY | ETF | 89.02 | 89.3 | 88.85 | 89.01 | 3017100.0 |
| 2002-08-08 13:00:00 | SPY | ETF | 88.97 | 90.03 | 88.93 | 89.75 | 4258300.0 |
| 2002-08-08 14:00:00 | SPY | ETF | 89.76 | 90.7 | 89.55 | 90.7 | 7461600.0 |
| 2002-08-08 15:00:00 | SPY | ETF | 90.7 | 91.1 | 90.37 | 90.98 | 8533300.0 |
| 2002-08-08 16:00:00 | SPY | ETF | 91.0 | 91.08 | 90.85 | 90.95 | 1347400.0 |
| 2002-08-08 09:00:00 | QQQ | ETF | 22.75 | 22.9 | 22.5 | 22.65 | 19019600.0 |
| 2002-08-08 10:00:00 | QQQ | ETF | 22.65 | 22.72 | 22.33 | 22.51 | 17812100.0 |
| 2002-08-08 11:00:00 | QQQ | ETF | 22.5 | 23.01 | 22.49 | 22.83 | 14394500.0 |
| 2002-08-08 12:00:00 | QQQ | ETF | 22.84 | 22.9 | 22.64 | 22.71 | 5824400.0 |
| 2002-08-08 13:00:00 | QQQ | ETF | 22.74 | 23.26 | 22.7 | 23.11 | 11524200.0 |
| 2002-08-08 14:00:00 | QQQ | ETF | 23.13 | 23.48 | 23.05 | 23.42 | 20869300.0 |
| 2002-08-08 15:00:00 | QQQ | ETF | 23.45 | 23.6 | 23.33 | 23.53 | 17088000.0 |
| 2002-08-08 16:00:00 | QQQ | ETF | 23.52 | 23.57 | 23.5 | 23.57 | 558400.0 |
| 2002-08-08 09:00:00 | IWM | ETF | 38.22 | 38.42 | 37.85 | 38.265 | 54000.0 |
| 2002-08-08 10:00:00 | IWM | ETF | 38.25 | 38.255 | 37.955 | 38.05 | 233000.0 |
| 2002-08-08 11:00:00 | IWM | ETF | 38.075 | 38.275 | 38.075 | 38.21 | 204600.0 |
| 2002-08-08 12:00:00 | IWM | ETF | 38.2 | 38.225 | 38.125 | 38.125 | 84200.0 |
| 2002-08-08 13:00:00 | IWM | ETF | 38.15 | 38.5 | 38.15 | 38.38 | 365400.0 |
| 2002-08-08 14:00:00 | IWM | ETF | 38.37 | 38.875 | 38.345 | 38.805 | 712000.0 |
| 2002-08-08 15:00:00 | IWM | ETF | 38.81 | 38.895 | 38.645 | 38.85 | 443400.0 |
| 2002-08-08 16:00:00 | IWM | ETF | 38.895 | 38.895 | 38.835 | 38.835 | 20400.0 |
| 2002-08-08 09:00:00 | DIA | ETF | 85.08 | 85.66 | 84.34 | 85.2 | 2330000.0 |
| 2002-08-08 10:00:00 | DIA | ETF | 85.2 | 85.39 | 84.35 | 84.66 | 2094200.0 |
| 2002-08-08 11:00:00 | DIA | ETF | 84.65 | 85.61 | 84.63 | 85.34 | 1637200.0 |
| 2002-08-08 12:00:00 | DIA | ETF | 85.35 | 85.66 | 85.14 | 85.27 | 1332700.0 |
| 2002-08-08 13:00:00 | DIA | ETF | 85.27 | 86.2 | 85.23 | 85.85 | 1405500.0 |
| 2002-08-08 14:00:00 | DIA | ETF | 85.85 | 86.91 | 85.72 | 86.89 | 2268000.0 |
| 2002-08-08 15:00:00 | DIA | ETF | 86.89 | 87.35 | 86.53 | 87.17 | 2776600.0 |
| 2002-08-08 16:00:00 | DIA | ETF | 87.1 | 87.25 | 87.05 | 87.25 | 119100.0 |
| 2002-08-08 09:00:00 | TLT | ETF | 83.58 | 83.7 | 83.44 | 83.6 | 5100.0 |
| 2002-08-08 10:00:00 | TLT | ETF | 83.52 | 83.77 | 83.48 | 83.75 | 7800.0 |
| 2002-08-08 11:00:00 | TLT | ETF | 83.74 | 83.74 | 83.68 | 83.68 | 2000.0 |
| 2002-08-08 12:00:00 | TLT | ETF | 83.7 | 83.7 | 83.62 | 83.69 | 4200.0 |
| 2002-08-08 13:00:00 | TLT | ETF | 83.75 | 83.75 | 83.38 | 83.38 | 12700.0 |
| 2002-08-08 14:00:00 | TLT | ETF | 83.36 | 83.45 | 83.36 | 83.43 | 4700.0 |
| 2002-08-08 15:00:00 | TLT | ETF | 83.56 | 83.7 | 83.56 | 83.7 | 4400.0 |
> showing 39 of 338 rows — these rows as CSV