PREVIEW / etf_daily / 2024-08-16
file: by_date/etf_daily/2024/2024-08-16.parquet size: 132 KB rows: 3,460
schema
date DATE symbol VARCHAR asset_type VARCHAR open DOUBLE high DOUBLE low DOUBLE close DOUBLE volume DOUBLE
sample rows
| date | symbol | asset_type | open | high | low | close | volume |
|---|---|---|---|---|---|---|---|
| 2024-08-16 | SPY | ETF | 551.42 | 555.02 | 551.26 | 554.31 | 44283195.0 |
| 2024-08-16 | QQQ | ETF | 472.62 | 476.41 | 471.65 | 475.03 | 38383623.0 |
| 2024-08-16 | IWM | ETF | 211.37 | 213.98 | 211.28 | 212.6 | 30406842.0 |
| 2024-08-16 | DIA | ETF | 405.03 | 407.37 | 404.6 | 406.74 | 2788727.0 |
| 2024-08-16 | GLD | ETF | 229.99 | 232.02 | 229.005 | 231.99 | 12018689.0 |
| 2024-08-16 | TLT | ETF | 97.44 | 97.5399 | 97.01 | 97.44 | 28464812.0 |
| 2024-08-16 | AAA | ETF | 25.04 | 25.0599 | 25.01 | 25.03 | 7890.0 |
| 2024-08-16 | AAAU | ETF | 24.6 | 24.825 | 24.51 | 24.81 | 2925558.0 |
| 2024-08-16 | AADR | ETF | 62.29 | 62.38 | 62.29 | 62.38 | 123.0 |
| 2024-08-16 | AAPB | ETF | 28.2 | 28.79 | 28.1 | 28.66 | 48609.0 |
| 2024-08-16 | AAPD | ETF | 17.17 | 17.175 | 16.94 | 17.01 | 288511.0 |
| 2024-08-16 | AAPR | ETF | 25.645 | 25.7002 | 25.645 | 25.7002 | 13096.0 |
| 2024-08-16 | AAPU | ETF | 36.06 | 36.95 | 35.9601 | 36.69 | 332329.0 |
| 2024-08-16 | AAPX | ETF | 32.74 | 33.405 | 32.59 | 33.21 | 16144.0 |
| 2024-08-16 | AAPY | ETF | 27.54 | 27.5579 | 27.5007 | 27.5007 | 468.0 |
| 2024-08-16 | AAXJ | ETF | 72.35 | 72.91 | 72.35 | 72.89 | 224958.0 |
| 2024-08-16 | ABCS | ETF | 27.1828 | 27.2513 | 27.1828 | 27.2513 | 2124.0 |
| 2024-08-16 | ABEQ | ETF | 31.5276 | 31.6943 | 31.5276 | 31.6943 | 2230.0 |
| 2024-08-16 | ABNY | ETF | 79.9 | 80.25 | 79.75 | 79.75 | 1849.0 |
| 2024-08-16 | ACES | ETF | 28.11 | 28.35 | 27.97 | 28.2 | 52182.0 |
| 2024-08-16 | ACIO | ETF | 38.57 | 38.77 | 38.57 | 38.7265 | 134718.0 |
| 2024-08-16 | ACSI | ETF | 55.9975 | 55.9975 | 55.9975 | 55.9975 | 8.0 |
| 2024-08-16 | ACT | ETF | 33.94 | 34.25 | 33.73 | 34.13 | 159765.0 |
| 2024-08-16 | ACTV | ETF | 32.1 | 32.16 | 32.07 | 32.1536 | 23735.0 |
| 2024-08-16 | ACVF | ETF | 41.89 | 42.15 | 41.89 | 42.105 | 6622.0 |
| 2024-08-16 | ACWI | ETF | 114.26 | 114.899 | 114.21 | 114.8 | 2234727.0 |
| 2024-08-16 | ACWV | ETF | 110.01 | 110.59 | 109.995 | 110.56 | 136700.0 |
| 2024-08-16 | ACWX | ETF | 54.26 | 54.585 | 54.26 | 54.56 | 406998.0 |
| 2024-08-16 | ADFI | ETF | 8.67 | 8.78 | 8.6507 | 8.75 | 13811.0 |
| 2024-08-16 | ADIV | ETF | 14.8889 | 14.9354 | 14.8889 | 14.9354 | 369.0 |
| 2024-08-16 | ADME | ETF | 44.78 | 44.91 | 44.78 | 44.82 | 20283.0 |
| 2024-08-16 | ADPV | ETF | 30.94 | 31.0142 | 30.94 | 31.0142 | 6214.0 |
| 2024-08-16 | AEMB | ETF | 39.3254 | 39.95 | 39.15 | 39.4174 | 1193.0 |
| 2024-08-16 | AESR | ETF | 16.47 | 16.52 | 16.46 | 16.49 | 13996.0 |
| 2024-08-16 | AETH | ETF | 33.68 | 34.1595 | 33.2779 | 34.0732 | 4419.0 |
| 2024-08-16 | AFIF | ETF | 9.15 | 9.16 | 9.15 | 9.155 | 7293.0 |
| 2024-08-16 | AFK | ETF | 16.0 | 16.11 | 15.7301 | 16.0953 | 11964.0 |
| 2024-08-16 | AFLG | ETF | 32.4 | 32.51 | 32.35 | 32.461 | 19413.0 |
| 2024-08-16 | AFMC | ETF | 30.37 | 30.55 | 30.37 | 30.4548 | 1051.0 |
| 2024-08-16 | AFSM | ETF | 29.47 | 29.64 | 29.47 | 29.5404 | 2673.0 |
| 2024-08-16 | AFTY | ETF | 14.1295 | 14.1295 | 14.1295 | 14.1295 | 9.0 |
| 2024-08-16 | AGG | ETF | 100.03 | 100.12 | 99.85 | 100.12 | 6503949.0 |
| 2024-08-16 | AGGH | ETF | 21.66 | 21.66 | 21.44 | 21.63 | 121668.0 |
| 2024-08-16 | AGGS | ETF | 41.945 | 42.0203 | 41.945 | 42.0203 | 147.0 |
| 2024-08-16 | AGGY | ETF | 44.26 | 44.35 | 44.2 | 44.3 | 61712.0 |
| 2024-08-16 | AGIX | ETF | 24.74 | 24.81 | 24.71 | 24.8044 | 1653.0 |
| 2024-08-16 | AGMI | ETF | 26.02 | 26.17 | 26.02 | 26.17 | 144.0 |
| 2024-08-16 | AGNG | ETF | 32.0 | 32.23 | 31.95 | 32.1021 | 8142.0 |
| 2024-08-16 | AGOX | ETF | 28.78 | 29.19 | 28.77 | 29.01 | 35889.0 |
| 2024-08-16 | AGQ | ETF | 34.23 | 35.7899 | 33.98 | 35.74 | 1807858.0 |
> showing 50 of 3,460 rows — these rows as CSV