PREVIEW / etf_daily / 2024-07-08
file: by_date/etf_daily/2024/2024-07-08.parquet size: 131 KB rows: 3,414
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-07-08 | SPY | ETF | 555.44 | 556.2501 | 554.19 | 555.28 | 35439156.0 |
| 2024-07-08 | QQQ | ETF | 496.53 | 497.895 | 495.5 | 497.34 | 22109420.0 |
| 2024-07-08 | IWM | ETF | 202.51 | 203.7 | 201.84 | 202.28 | 20757667.0 |
| 2024-07-08 | DIA | ETF | 394.41 | 396.732 | 392.78 | 393.46 | 3372831.0 |
| 2024-07-08 | GLD | ETF | 219.64 | 220.04 | 217.41 | 218.19 | 5716566.0 |
| 2024-07-08 | TLT | ETF | 92.54 | 92.845 | 92.2246 | 92.76 | 16086439.0 |
| 2024-07-08 | AAA | ETF | 25.08 | 25.08 | 25.06 | 25.06 | 784.0 |
| 2024-07-08 | AAAU | ETF | 23.5 | 23.5411 | 23.2589 | 23.335 | 2846716.0 |
| 2024-07-08 | AADR | ETF | 62.24 | 62.2401 | 62.09 | 62.09 | 762.0 |
| 2024-07-08 | AAPB | ETF | 29.42 | 29.56 | 28.44 | 29.56 | 300335.0 |
| 2024-07-08 | AAPD | ETF | 16.91 | 17.2011 | 16.87 | 16.88 | 249548.0 |
| 2024-07-08 | AAPR | ETF | 25.435 | 25.47 | 25.3912 | 25.46 | 10606.0 |
| 2024-07-08 | AAPU | ETF | 37.75 | 37.94 | 36.43 | 37.91 | 1296174.0 |
| 2024-07-08 | AAPX | ETF | 34.36 | 34.41 | 33.04 | 34.41 | 62014.0 |
| 2024-07-08 | AAPY | ETF | 27.2334 | 27.428 | 27.2334 | 27.428 | 1858.0 |
| 2024-07-08 | AAXJ | ETF | 73.79 | 73.98 | 73.63 | 73.7 | 733914.0 |
| 2024-07-08 | ABCS | ETF | 25.85 | 25.9 | 25.75 | 25.75 | 1202.0 |
| 2024-07-08 | ABEQ | ETF | 30.2 | 30.2 | 30.06 | 30.16 | 5408.0 |
| 2024-07-08 | ABNY | ETF | 106.95 | 106.95 | 102.9505 | 103.555 | 470.0 |
| 2024-07-08 | ACES | ETF | 29.12 | 29.58 | 29.12 | 29.43 | 83261.0 |
| 2024-07-08 | ACIO | ETF | 38.35 | 38.43 | 38.3 | 38.32 | 67039.0 |
| 2024-07-08 | ACSI | ETF | 56.1192 | 56.1192 | 56.1192 | 56.1192 | 188.0 |
| 2024-07-08 | ACT | ETF | 30.58 | 30.82 | 30.17 | 30.19 | 254637.0 |
| 2024-07-08 | ACTV | ETF | 31.99 | 32.133 | 31.9018 | 31.9073 | 6186.0 |
| 2024-07-08 | ACVF | ETF | 41.95 | 41.95 | 41.705 | 41.747 | 5362.0 |
| 2024-07-08 | ACWI | ETF | 114.8 | 114.93 | 114.45 | 114.66 | 1785149.0 |
| 2024-07-08 | ACWV | ETF | 105.2 | 105.6 | 105.1 | 105.19 | 223466.0 |
| 2024-07-08 | ACWX | ETF | 54.39 | 54.42 | 54.1 | 54.14 | 721276.0 |
| 2024-07-08 | ADFI | ETF | 8.52 | 8.53 | 8.5 | 8.515 | 7252.0 |
| 2024-07-08 | ADIV | ETF | 14.88 | 14.88 | 14.825 | 14.825 | 607.0 |
| 2024-07-08 | ADME | ETF | 44.58 | 44.69 | 44.57 | 44.62 | 10308.0 |
| 2024-07-08 | ADPV | ETF | 30.75 | 30.75 | 30.5855 | 30.5855 | 575.0 |
| 2024-07-08 | AEMB | ETF | 38.535 | 38.535 | 38.535 | 38.535 | 27.0 |
| 2024-07-08 | AESR | ETF | 16.7009 | 16.72 | 16.68 | 16.7107 | 9576.0 |
| 2024-07-08 | AETH | ETF | 40.01 | 40.01 | 38.66 | 39.2934 | 10115.0 |
| 2024-07-08 | AFIF | ETF | 9.15 | 9.16 | 9.14 | 9.16 | 15637.0 |
| 2024-07-08 | AFK | ETF | 16.17 | 16.3 | 15.88 | 16.2 | 76197.0 |
| 2024-07-08 | AFLG | ETF | 31.91 | 31.97 | 31.91 | 31.9557 | 22623.0 |
| 2024-07-08 | AFMC | ETF | 29.09 | 29.1 | 28.9614 | 28.9614 | 999.0 |
| 2024-07-08 | AFSM | ETF | 28.27 | 28.27 | 28.1142 | 28.1199 | 1921.0 |
| 2024-07-08 | AFTY | ETF | 13.95 | 13.95 | 13.87 | 13.9 | 866.0 |
| 2024-07-08 | AGG | ETF | 97.59 | 97.65 | 97.45 | 97.61 | 4600181.0 |
| 2024-07-08 | AGGH | ETF | 21.0 | 21.0 | 20.92 | 20.99 | 116174.0 |
| 2024-07-08 | AGGY | ETF | 43.33 | 43.3389 | 43.28 | 43.3 | 76560.0 |
| 2024-07-08 | AGMI | ETF | 27.25 | 27.4572 | 27.25 | 27.4572 | 913.0 |
| 2024-07-08 | AGNG | ETF | 30.39 | 30.39 | 30.275 | 30.28 | 704.0 |
| 2024-07-08 | AGOX | ETF | 28.65 | 28.69 | 28.42 | 28.57 | 30923.0 |
| 2024-07-08 | AGQ | ETF | 42.03 | 42.5 | 40.29 | 41.3 | 1113666.0 |
| 2024-07-08 | AGQI | ETF | 14.55 | 14.55 | 14.51 | 14.52 | 4818.0 |
| 2024-07-08 | AGZ | ETF | 107.99 | 108.0408 | 107.93 | 108.03 | 11647.0 |
> showing 50 of 3,414 rows — these rows as CSV