PREVIEW / etf_1hour / 2002-08-12
file: by_date/etf_1hour/2002/2002-08-12.parquet size: 14 KB rows: 325
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-12 09:00:00 | SPY | ETF | 89.99 | 90.05 | 89.55 | 90.03 | 3638900.0 |
| 2002-08-12 10:00:00 | SPY | ETF | 89.99 | 90.61 | 89.77 | 90.29 | 6229800.0 |
| 2002-08-12 11:00:00 | SPY | ETF | 90.28 | 90.44 | 89.82 | 90.16 | 2323000.0 |
| 2002-08-12 12:00:00 | SPY | ETF | 90.16 | 90.58 | 90.0 | 90.34 | 2213000.0 |
| 2002-08-12 13:00:00 | SPY | ETF | 90.33 | 90.44 | 89.91 | 90.05 | 1846600.0 |
| 2002-08-12 14:00:00 | SPY | ETF | 90.03 | 90.73 | 89.95 | 90.7 | 2488400.0 |
| 2002-08-12 15:00:00 | SPY | ETF | 90.76 | 91.27 | 90.52 | 90.69 | 4989400.0 |
| 2002-08-12 16:00:00 | SPY | ETF | 90.69 | 90.76 | 90.54 | 90.62 | 604900.0 |
| 2002-08-12 09:00:00 | QQQ | ETF | 23.05 | 23.15 | 22.92 | 23.12 | 14215300.0 |
| 2002-08-12 10:00:00 | QQQ | ETF | 23.13 | 23.16 | 22.96 | 23.03 | 12461600.0 |
| 2002-08-12 11:00:00 | QQQ | ETF | 23.03 | 23.1 | 22.9 | 23.04 | 4920600.0 |
| 2002-08-12 12:00:00 | QQQ | ETF | 23.04 | 23.28 | 22.98 | 23.17 | 5973700.0 |
| 2002-08-12 13:00:00 | QQQ | ETF | 23.18 | 23.23 | 23.02 | 23.08 | 2774600.0 |
| 2002-08-12 14:00:00 | QQQ | ETF | 23.09 | 23.3 | 23.05 | 23.3 | 5268000.0 |
| 2002-08-12 15:00:00 | QQQ | ETF | 23.3 | 23.48 | 23.2 | 23.33 | 11883300.0 |
| 2002-08-12 16:00:00 | QQQ | ETF | 23.31 | 23.42 | 23.29 | 23.4 | 364100.0 |
| 2002-08-12 09:00:00 | IWM | ETF | 38.25 | 38.275 | 38.105 | 38.19 | 248400.0 |
| 2002-08-12 10:00:00 | IWM | ETF | 38.25 | 38.335 | 38.175 | 38.295 | 241000.0 |
| 2002-08-12 11:00:00 | IWM | ETF | 38.225 | 38.325 | 38.205 | 38.315 | 106000.0 |
| 2002-08-12 12:00:00 | IWM | ETF | 38.275 | 38.52 | 38.26 | 38.52 | 80400.0 |
| 2002-08-12 13:00:00 | IWM | ETF | 38.395 | 38.45 | 38.31 | 38.375 | 75400.0 |
| 2002-08-12 14:00:00 | IWM | ETF | 38.445 | 38.56 | 38.375 | 38.485 | 172000.0 |
| 2002-08-12 15:00:00 | IWM | ETF | 38.52 | 38.88 | 38.495 | 38.65 | 309400.0 |
| 2002-08-12 16:00:00 | IWM | ETF | 38.6 | 38.6 | 38.6 | 38.6 | 64600.0 |
| 2002-08-12 09:00:00 | DIA | ETF | 86.38 | 86.4 | 85.98 | 86.31 | 1313800.0 |
| 2002-08-12 10:00:00 | DIA | ETF | 86.25 | 86.8 | 86.05 | 86.57 | 2313500.0 |
| 2002-08-12 11:00:00 | DIA | ETF | 86.58 | 86.69 | 86.18 | 86.48 | 827500.0 |
| 2002-08-12 12:00:00 | DIA | ETF | 86.51 | 86.81 | 86.25 | 86.54 | 634000.0 |
| 2002-08-12 13:00:00 | DIA | ETF | 86.55 | 86.69 | 86.1 | 86.33 | 601600.0 |
| 2002-08-12 14:00:00 | DIA | ETF | 86.33 | 86.87 | 86.17 | 86.8 | 816900.0 |
| 2002-08-12 15:00:00 | DIA | ETF | 86.84 | 87.49 | 86.75 | 86.97 | 2059500.0 |
| 2002-08-12 16:00:00 | DIA | ETF | 86.9 | 86.99 | 86.87 | 86.99 | 56900.0 |
| 2002-08-12 09:00:00 | TLT | ETF | 85.3 | 86.3 | 85.16 | 85.34 | 15400.0 |
| 2002-08-12 10:00:00 | TLT | ETF | 85.17 | 85.32 | 85.14 | 85.32 | 2900.0 |
| 2002-08-12 11:00:00 | TLT | ETF | 85.27 | 85.39 | 85.22 | 85.36 | 5500.0 |
| 2002-08-12 12:00:00 | TLT | ETF | 85.38 | 85.45 | 85.38 | 85.42 | 1300.0 |
| 2002-08-12 13:00:00 | TLT | ETF | 85.35 | 85.58 | 85.35 | 85.58 | 2200.0 |
| 2002-08-12 14:00:00 | TLT | ETF | 85.61 | 85.61 | 85.44 | 85.49 | 2300.0 |
| 2002-08-12 15:00:00 | TLT | ETF | 85.37 | 85.46 | 85.28 | 85.4 | 1700.0 |
> showing 39 of 325 rows — these rows as CSV