PREVIEW / etf_daily / 2024-08-29
file: by_date/etf_daily/2024/2024-08-29.parquet size: 133 KB rows: 3,459
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-29 | SPY | ETF | 560.31 | 563.68 | 557.18 | 558.35 | 38656940.0 |
| 2024-08-29 | QQQ | ETF | 473.28 | 477.93 | 469.372 | 470.66 | 41081465.0 |
| 2024-08-29 | IWM | ETF | 218.78 | 220.98 | 217.15 | 218.81 | 24750821.0 |
| 2024-08-29 | DIA | ETF | 414.37 | 416.3 | 411.3 | 413.91 | 5023221.0 |
| 2024-08-29 | GLD | ETF | 231.95 | 233.61 | 231.92 | 232.95 | 5682141.0 |
| 2024-08-29 | TLT | ETF | 97.37 | 97.64 | 97.125 | 97.53 | 24760271.0 |
| 2024-08-29 | AAA | ETF | 25.14 | 25.16 | 25.1001 | 25.14 | 3818.0 |
| 2024-08-29 | AAAU | ETF | 24.83 | 25.0099 | 24.83 | 24.935 | 2124858.0 |
| 2024-08-29 | AADR | ETF | 62.47 | 62.47 | 62.47 | 62.47 | 68.0 |
| 2024-08-29 | AAPB | ETF | 29.63 | 30.3 | 29.375 | 29.56 | 337616.0 |
| 2024-08-29 | AAPD | ETF | 16.74 | 16.83 | 16.54 | 16.77 | 394191.0 |
| 2024-08-29 | AAPU | ETF | 37.89 | 38.8 | 37.49 | 37.78 | 1897308.0 |
| 2024-08-29 | AAPX | ETF | 34.27 | 35.079 | 34.1001 | 34.22 | 36039.0 |
| 2024-08-29 | AAPY | ETF | 27.8 | 27.8 | 27.5695 | 27.5695 | 1120.0 |
| 2024-08-29 | AAXJ | ETF | 72.87 | 73.17 | 72.75 | 72.78 | 295172.0 |
| 2024-08-29 | ABCS | ETF | 27.9375 | 28.0668 | 27.85 | 27.8772 | 3905.0 |
| 2024-08-29 | ABEQ | ETF | 32.13 | 32.8273 | 31.4001 | 32.5435 | 3600.0 |
| 2024-08-29 | ABNY | ETF | 81.2 | 81.5 | 80.439 | 80.439 | 2925.0 |
| 2024-08-29 | ACES | ETF | 28.8 | 29.35 | 28.68 | 28.87 | 13702.0 |
| 2024-08-29 | ACIO | ETF | 39.14 | 39.25 | 38.9015 | 38.96 | 133569.0 |
| 2024-08-29 | ACSI | ETF | 56.7413 | 56.7413 | 56.7413 | 56.7413 | 50.0 |
| 2024-08-29 | ACT | ETF | 35.31 | 35.52 | 35.12 | 35.22 | 192975.0 |
| 2024-08-29 | ACTV | ETF | 32.88 | 33.1053 | 32.7801 | 32.88 | 13193.0 |
| 2024-08-29 | ACVF | ETF | 42.6904 | 42.855 | 42.55 | 42.55 | 3538.0 |
| 2024-08-29 | ACWI | ETF | 116.44 | 117.13 | 115.99 | 116.16 | 2105419.0 |
| 2024-08-29 | ACWV | ETF | 113.08 | 113.55 | 112.83 | 113.18 | 183922.0 |
| 2024-08-29 | ACWX | ETF | 55.78 | 55.965 | 55.61 | 55.67 | 246384.0 |
| 2024-08-29 | ADFI | ETF | 8.74 | 8.75 | 8.6901 | 8.73 | 17551.0 |
| 2024-08-29 | ADIV | ETF | 15.46 | 15.46 | 15.41 | 15.4125 | 1051.0 |
| 2024-08-29 | ADME | ETF | 45.48 | 45.51 | 45.1175 | 45.19 | 28404.0 |
| 2024-08-29 | ADPV | ETF | 32.08 | 32.08 | 31.7406 | 31.7406 | 3236.0 |
| 2024-08-29 | ADVE | ETF | 34.396 | 34.396 | 34.242 | 34.242 | 172.0 |
| 2024-08-29 | AEMB | ETF | 38.7 | 39.79 | 38.7 | 39.5719 | 486.0 |
| 2024-08-29 | AESR | ETF | 16.6 | 16.71 | 16.51 | 16.51 | 24402.0 |
| 2024-08-29 | AETH | ETF | 33.24 | 33.35 | 32.6929 | 32.6929 | 1185.0 |
| 2024-08-29 | AFIF | ETF | 9.23 | 9.23 | 9.16 | 9.19 | 19587.0 |
| 2024-08-29 | AFK | ETF | 16.49 | 16.68 | 16.432 | 16.44 | 5327.0 |
| 2024-08-29 | AFLG | ETF | 33.146 | 33.26 | 32.9907 | 32.9907 | 10024.0 |
| 2024-08-29 | AFMC | ETF | 31.4999 | 31.4999 | 31.28 | 31.2917 | 2248.0 |
| 2024-08-29 | AFSM | ETF | 30.42 | 30.42 | 30.2819 | 30.2819 | 366.0 |
| 2024-08-29 | AFTY | ETF | 14.005 | 14.005 | 14.005 | 14.005 | 18.0 |
| 2024-08-29 | AGG | ETF | 100.45 | 100.55 | 100.3506 | 100.49 | 7022036.0 |
| 2024-08-29 | AGGH | ETF | 21.51 | 21.61 | 21.4 | 21.61 | 48137.0 |
| 2024-08-29 | AGGY | ETF | 44.33 | 44.41 | 44.3 | 44.33 | 58165.0 |
| 2024-08-29 | AGIX | ETF | 24.39 | 24.7 | 24.2501 | 24.2501 | 2300.0 |
| 2024-08-29 | AGMI | ETF | 26.25 | 26.4075 | 26.25 | 26.4075 | 445.0 |
| 2024-08-29 | AGNG | ETF | 33.19 | 33.3599 | 33.1 | 33.12 | 7967.0 |
| 2024-08-29 | AGOX | ETF | 29.14 | 29.14 | 28.0001 | 28.28 | 67948.0 |
| 2024-08-29 | AGQ | ETF | 36.3 | 37.215 | 36.12 | 36.59 | 1182016.0 |
| 2024-08-29 | AGQI | ETF | 14.56 | 14.6639 | 14.55 | 14.585 | 2847.0 |
> showing 50 of 3,459 rows — these rows as CSV