PREVIEW / etf_1hour / 2002-08-30
file: by_date/etf_1hour/2002/2002-08-30.parquet size: 14 KB rows: 326
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-30 09:00:00 | SPY | ETF | 91.68 | 92.14 | 91.4 | 91.92 | 2606300.0 |
| 2002-08-30 10:00:00 | SPY | ETF | 91.92 | 93.06 | 91.9 | 92.7 | 7721000.0 |
| 2002-08-30 11:00:00 | SPY | ETF | 92.69 | 92.87 | 92.37 | 92.68 | 2762600.0 |
| 2002-08-30 12:00:00 | SPY | ETF | 92.68 | 93.26 | 92.52 | 93.08 | 3182400.0 |
| 2002-08-30 13:00:00 | SPY | ETF | 93.07 | 93.18 | 92.87 | 93.0 | 1801400.0 |
| 2002-08-30 14:00:00 | SPY | ETF | 93.0 | 93.39 | 92.66 | 92.88 | 3315700.0 |
| 2002-08-30 15:00:00 | SPY | ETF | 92.88 | 92.91 | 91.85 | 92.09 | 6625900.0 |
| 2002-08-30 16:00:00 | SPY | ETF | 92.06 | 92.18 | 91.74 | 91.78 | 805700.0 |
| 2002-08-30 09:00:00 | QQQ | ETF | 23.62 | 23.79 | 23.49 | 23.57 | 7282900.0 |
| 2002-08-30 10:00:00 | QQQ | ETF | 23.55 | 24.0 | 23.53 | 23.77 | 15943100.0 |
| 2002-08-30 11:00:00 | QQQ | ETF | 23.77 | 23.87 | 23.58 | 23.61 | 4137500.0 |
| 2002-08-30 12:00:00 | QQQ | ETF | 23.64 | 23.84 | 23.56 | 23.78 | 4923700.0 |
| 2002-08-30 13:00:00 | QQQ | ETF | 23.76 | 23.8 | 23.67 | 23.71 | 2695700.0 |
| 2002-08-30 14:00:00 | QQQ | ETF | 23.71 | 23.95 | 23.7 | 23.79 | 9260300.0 |
| 2002-08-30 15:00:00 | QQQ | ETF | 23.81 | 23.85 | 23.38 | 23.48 | 12426900.0 |
| 2002-08-30 16:00:00 | QQQ | ETF | 23.48 | 23.5 | 23.44 | 23.49 | 726800.0 |
| 2002-08-30 09:00:00 | IWM | ETF | 39.175 | 39.45 | 39.155 | 39.33 | 74800.0 |
| 2002-08-30 10:00:00 | IWM | ETF | 39.475 | 39.59 | 39.38 | 39.445 | 233200.0 |
| 2002-08-30 11:00:00 | IWM | ETF | 39.45 | 39.48 | 39.33 | 39.4 | 91400.0 |
| 2002-08-30 12:00:00 | IWM | ETF | 39.42 | 39.5 | 39.29 | 39.385 | 249200.0 |
| 2002-08-30 13:00:00 | IWM | ETF | 39.355 | 39.45 | 39.33 | 39.445 | 92000.0 |
| 2002-08-30 14:00:00 | IWM | ETF | 39.425 | 39.5 | 39.31 | 39.37 | 245000.0 |
| 2002-08-30 15:00:00 | IWM | ETF | 39.32 | 39.32 | 38.875 | 38.88 | 306000.0 |
| 2002-08-30 16:00:00 | IWM | ETF | 39.0 | 39.025 | 38.885 | 39.025 | 78200.0 |
| 2002-08-30 09:00:00 | DIA | ETF | 86.2 | 86.91 | 86.05 | 86.78 | 1193000.0 |
| 2002-08-30 10:00:00 | DIA | ETF | 86.76 | 87.76 | 86.75 | 87.39 | 2337600.0 |
| 2002-08-30 11:00:00 | DIA | ETF | 87.35 | 87.54 | 87.01 | 87.35 | 671100.0 |
| 2002-08-30 12:00:00 | DIA | ETF | 87.42 | 87.93 | 87.2 | 87.72 | 960500.0 |
| 2002-08-30 13:00:00 | DIA | ETF | 87.74 | 87.81 | 87.51 | 87.69 | 441800.0 |
| 2002-08-30 14:00:00 | DIA | ETF | 87.64 | 88.03 | 87.34 | 87.51 | 1443400.0 |
| 2002-08-30 15:00:00 | DIA | ETF | 87.5 | 87.55 | 86.52 | 86.75 | 2047700.0 |
| 2002-08-30 16:00:00 | DIA | ETF | 86.75 | 86.82 | 86.52 | 86.52 | 216900.0 |
| 2002-08-30 09:00:00 | TLT | ETF | 86.75 | 86.91 | 86.75 | 86.81 | 5300.0 |
| 2002-08-30 10:00:00 | TLT | ETF | 86.7 | 86.7 | 86.45 | 86.53 | 30300.0 |
| 2002-08-30 11:00:00 | TLT | ETF | 86.6 | 86.77 | 86.57 | 86.77 | 17500.0 |
| 2002-08-30 12:00:00 | TLT | ETF | 86.85 | 86.89 | 86.76 | 86.88 | 7200.0 |
| 2002-08-30 13:00:00 | TLT | ETF | 86.85 | 87.03 | 86.85 | 86.98 | 4300.0 |
| 2002-08-30 14:00:00 | TLT | ETF | 87.0 | 87.1 | 86.93 | 87.04 | 8700.0 |
| 2002-08-30 15:00:00 | TLT | ETF | 87.07 | 87.13 | 86.95 | 87.08 | 4800.0 |
> showing 39 of 326 rows — these rows as CSV