PREVIEW / etf_1hour / 2002-08-14
file: by_date/etf_1hour/2002/2002-08-14.parquet size: 15 KB rows: 346
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-14 09:00:00 | SPY | ETF | 89.02 | 89.33 | 88.8 | 88.89 | 4972100.0 |
| 2002-08-14 10:00:00 | SPY | ETF | 88.89 | 89.25 | 88.02 | 88.9 | 9549200.0 |
| 2002-08-14 11:00:00 | SPY | ETF | 88.94 | 89.05 | 88.36 | 88.48 | 3320500.0 |
| 2002-08-14 12:00:00 | SPY | ETF | 88.44 | 89.15 | 88.35 | 88.98 | 2022500.0 |
| 2002-08-14 13:00:00 | SPY | ETF | 88.98 | 89.99 | 88.5 | 89.84 | 5409300.0 |
| 2002-08-14 14:00:00 | SPY | ETF | 89.84 | 91.38 | 89.82 | 91.21 | 8703000.0 |
| 2002-08-14 15:00:00 | SPY | ETF | 91.27 | 92.62 | 91.02 | 92.35 | 15889800.0 |
| 2002-08-14 16:00:00 | SPY | ETF | 92.38 | 92.45 | 92.21 | 92.22 | 1691100.0 |
| 2002-08-14 09:00:00 | QQQ | ETF | 22.67 | 22.82 | 22.54 | 22.7 | 11119900.0 |
| 2002-08-14 10:00:00 | QQQ | ETF | 22.67 | 22.89 | 22.47 | 22.78 | 17549200.0 |
| 2002-08-14 11:00:00 | QQQ | ETF | 22.8 | 22.85 | 22.63 | 22.72 | 6263900.0 |
| 2002-08-14 12:00:00 | QQQ | ETF | 22.72 | 22.98 | 22.67 | 22.93 | 5895100.0 |
| 2002-08-14 13:00:00 | QQQ | ETF | 22.93 | 23.27 | 22.82 | 23.23 | 14078800.0 |
| 2002-08-14 14:00:00 | QQQ | ETF | 23.23 | 23.8 | 23.22 | 23.74 | 18597000.0 |
| 2002-08-14 15:00:00 | QQQ | ETF | 23.71 | 24.12 | 23.66 | 24.03 | 23663600.0 |
| 2002-08-14 16:00:00 | QQQ | ETF | 24.05 | 24.08 | 23.96 | 24.04 | 833700.0 |
| 2002-08-14 09:00:00 | IWM | ETF | 37.775 | 37.955 | 37.625 | 37.725 | 682600.0 |
| 2002-08-14 10:00:00 | IWM | ETF | 37.685 | 37.875 | 37.075 | 37.82 | 799800.0 |
| 2002-08-14 11:00:00 | IWM | ETF | 37.715 | 37.83 | 37.545 | 37.6 | 245400.0 |
| 2002-08-14 12:00:00 | IWM | ETF | 37.545 | 37.75 | 37.535 | 37.725 | 105600.0 |
| 2002-08-14 13:00:00 | IWM | ETF | 37.695 | 38.02 | 37.625 | 38.02 | 403200.0 |
| 2002-08-14 14:00:00 | IWM | ETF | 38.02 | 38.445 | 38.0 | 38.445 | 472000.0 |
| 2002-08-14 15:00:00 | IWM | ETF | 38.45 | 38.955 | 38.395 | 38.85 | 1288200.0 |
| 2002-08-14 16:00:00 | IWM | ETF | 38.8 | 38.84 | 38.8 | 38.84 | 4400.0 |
| 2002-08-14 09:00:00 | DIA | ETF | 85.0 | 85.15 | 84.56 | 84.64 | 868600.0 |
| 2002-08-14 10:00:00 | DIA | ETF | 84.61 | 84.8 | 83.7 | 84.45 | 2535300.0 |
| 2002-08-14 11:00:00 | DIA | ETF | 84.46 | 84.6 | 83.88 | 83.88 | 1053900.0 |
| 2002-08-14 12:00:00 | DIA | ETF | 83.9 | 84.49 | 83.72 | 84.37 | 1053300.0 |
| 2002-08-14 13:00:00 | DIA | ETF | 84.37 | 85.33 | 83.85 | 85.23 | 1906600.0 |
| 2002-08-14 14:00:00 | DIA | ETF | 85.2 | 86.53 | 85.1 | 86.43 | 3526900.0 |
| 2002-08-14 15:00:00 | DIA | ETF | 86.39 | 87.85 | 86.2 | 87.55 | 3537400.0 |
| 2002-08-14 16:00:00 | DIA | ETF | 87.67 | 87.67 | 87.43 | 87.47 | 187600.0 |
| 2002-08-14 09:00:00 | TLT | ETF | 87.46 | 87.46 | 87.15 | 87.26 | 6800.0 |
| 2002-08-14 10:00:00 | TLT | ETF | 87.36 | 87.9 | 87.35 | 87.4 | 41300.0 |
| 2002-08-14 11:00:00 | TLT | ETF | 87.38 | 87.86 | 87.38 | 87.86 | 14900.0 |
| 2002-08-14 12:00:00 | TLT | ETF | 87.88 | 87.9 | 87.38 | 87.5 | 3900.0 |
| 2002-08-14 13:00:00 | TLT | ETF | 87.5 | 87.52 | 87.08 | 87.16 | 18300.0 |
| 2002-08-14 14:00:00 | TLT | ETF | 87.0 | 87.15 | 86.75 | 87.1 | 18700.0 |
| 2002-08-14 15:00:00 | TLT | ETF | 87.1 | 87.2 | 86.75 | 86.75 | 20200.0 |
| 2002-08-14 16:00:00 | TLT | ETF | 86.78 | 86.78 | 86.78 | 86.78 | 900.0 |
> showing 40 of 346 rows — these rows as CSV