PREVIEW / etf_daily / 2024-07-29
file: by_date/etf_daily/2024/2024-07-29.parquet size: 131 KB rows: 3,432
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-29 | SPY | ETF | 546.02 | 547.05 | 542.72 | 544.76 | 39363819.0 |
| 2024-07-29 | QQQ | ETF | 465.71 | 467.91 | 461.615 | 463.9 | 28218476.0 |
| 2024-07-29 | IWM | ETF | 224.71 | 225.4172 | 220.77 | 221.73 | 33449100.0 |
| 2024-07-29 | DIA | ETF | 406.86 | 407.0 | 403.96 | 405.51 | 2032416.0 |
| 2024-07-29 | GLD | ETF | 221.26 | 221.55 | 219.045 | 220.32 | 4555678.0 |
| 2024-07-29 | TLT | ETF | 93.67 | 93.69 | 93.22 | 93.49 | 25776109.0 |
| 2024-07-29 | AAA | ETF | 25.15 | 25.18 | 25.11 | 25.145 | 3167.0 |
| 2024-07-29 | AAAU | ETF | 23.68 | 23.7 | 23.44 | 23.575 | 2220942.0 |
| 2024-07-29 | AADR | ETF | 61.54 | 61.54 | 61.0 | 61.0 | 659.0 |
| 2024-07-29 | AAPB | ETF | 26.56 | 27.13 | 26.3099 | 26.9 | 105225.0 |
| 2024-07-29 | AAPD | ETF | 17.7 | 17.82 | 17.55 | 17.63 | 283999.0 |
| 2024-07-29 | AAPR | ETF | 25.41 | 25.41 | 25.41 | 25.41 | 221.0 |
| 2024-07-29 | AAPU | ETF | 34.14 | 34.82 | 33.72 | 34.48 | 507681.0 |
| 2024-07-29 | AAPX | ETF | 30.98 | 31.48 | 30.511 | 31.22 | 16481.0 |
| 2024-07-29 | AAPY | ETF | 26.57 | 26.59 | 26.4801 | 26.5393 | 1446.0 |
| 2024-07-29 | AAXJ | ETF | 71.2 | 71.63 | 70.81 | 71.01 | 271341.0 |
| 2024-07-29 | ABCS | ETF | 27.57 | 27.57 | 27.4299 | 27.4315 | 1326.0 |
| 2024-07-29 | ABEQ | ETF | 31.2838 | 31.33 | 31.24 | 31.33 | 958.0 |
| 2024-07-29 | ABNY | ETF | 98.795 | 98.795 | 97.8105 | 97.8105 | 255.0 |
| 2024-07-29 | ACES | ETF | 30.21 | 30.3 | 29.52 | 29.89 | 247222.0 |
| 2024-07-29 | ACIO | ETF | 37.99 | 38.0194 | 37.82 | 37.91 | 61786.0 |
| 2024-07-29 | ACSI | ETF | 55.5183 | 55.5183 | 55.5183 | 55.5183 | 15.0 |
| 2024-07-29 | ACT | ETF | 34.62 | 34.74 | 34.09 | 34.12 | 133414.0 |
| 2024-07-29 | ACTV | ETF | 34.1 | 34.1 | 33.792 | 33.9679 | 4125.0 |
| 2024-07-29 | ACTX | ETF | 0.0002 | 0.0002 | 0.0002 | 0.0002 | 289.0 |
| 2024-07-29 | ACVF | ETF | 41.43 | 41.56 | 41.34 | 41.44 | 13210.0 |
| 2024-07-29 | ACWI | ETF | 112.91 | 113.05 | 112.3 | 112.67 | 1641354.0 |
| 2024-07-29 | ACWV | ETF | 107.82 | 108.025 | 107.53 | 107.86 | 82950.0 |
| 2024-07-29 | ACWX | ETF | 53.53 | 53.53 | 53.239 | 53.37 | 293477.0 |
| 2024-07-29 | ADFI | ETF | 8.566 | 8.61 | 8.55 | 8.57 | 18349.0 |
| 2024-07-29 | ADIV | ETF | 14.28 | 14.2964 | 14.28 | 14.2964 | 594.0 |
| 2024-07-29 | ADME | ETF | 43.94 | 43.94 | 43.81 | 43.8393 | 9061.0 |
| 2024-07-29 | ADPV | ETF | 30.9704 | 31.03 | 30.91 | 30.9214 | 9243.0 |
| 2024-07-29 | ADVE | ETF | 32.97 | 32.97 | 32.9593 | 32.9593 | 255.0 |
| 2024-07-29 | AEMB | ETF | 38.7404 | 38.7404 | 38.7404 | 38.7404 | 45.0 |
| 2024-07-29 | AESR | ETF | 16.11 | 16.15 | 16.04 | 16.0566 | 21084.0 |
| 2024-07-29 | AETH | ETF | 43.98 | 43.98 | 42.47 | 43.0389 | 17200.0 |
| 2024-07-29 | AFIF | ETF | 9.145 | 9.149 | 9.13 | 9.135 | 4172.0 |
| 2024-07-29 | AFK | ETF | 15.85 | 15.9996 | 15.8 | 15.88 | 18181.0 |
| 2024-07-29 | AFLG | ETF | 32.0099 | 32.045 | 31.97 | 32.0347 | 3923.0 |
| 2024-07-29 | AFMC | ETF | 31.3039 | 31.42 | 31.11 | 31.154 | 3036.0 |
| 2024-07-29 | AFSM | ETF | 31.19 | 31.19 | 30.585 | 30.75 | 19070.0 |
| 2024-07-29 | AFTY | ETF | 13.83 | 13.8643 | 13.83 | 13.8643 | 546.0 |
| 2024-07-29 | AGG | ETF | 98.54 | 98.54 | 98.37 | 98.48 | 6668325.0 |
| 2024-07-29 | AGGH | ETF | 21.02 | 21.0699 | 21.01 | 21.01 | 348694.0 |
| 2024-07-29 | AGGY | ETF | 43.5 | 43.5 | 43.42 | 43.46 | 84139.0 |
| 2024-07-29 | AGIX | ETF | 24.24 | 24.265 | 23.94 | 24.055 | 29244.0 |
| 2024-07-29 | AGMI | ETF | 26.9 | 26.9 | 26.8956 | 26.8956 | 501.0 |
| 2024-07-29 | AGNG | ETF | 31.12 | 31.12 | 31.05 | 31.09 | 1539.0 |
| 2024-07-29 | AGOX | ETF | 27.61 | 27.61 | 27.4 | 27.4924 | 15676.0 |
> showing 50 of 3,432 rows — these rows as CSV