PREVIEW / etf_daily / 2024-09-06
file: by_date/etf_daily/2024/2024-09-06.parquet size: 133 KB rows: 3,500
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-09-06 | SPY | ETF | 549.94 | 551.6 | 539.44 | 540.36 | 68529128.0 |
| 2024-09-06 | QQQ | ETF | 460.33 | 461.22 | 448.19 | 448.69 | 50624385.0 |
| 2024-09-06 | IWM | ETF | 211.93 | 213.19 | 207.14 | 207.9 | 34627013.0 |
| 2024-09-06 | DIA | ETF | 408.96 | 411.0 | 403.78 | 404.47 | 3350534.0 |
| 2024-09-06 | GLD | ETF | 231.83 | 232.76 | 229.62 | 230.63 | 6261867.0 |
| 2024-09-06 | TLT | ETF | 99.55 | 100.78 | 99.1901 | 99.56 | 57317971.0 |
| 2024-09-06 | AAA | ETF | 25.0639 | 25.0639 | 25.035 | 25.035 | 2266.0 |
| 2024-09-06 | AAAU | ETF | 24.82 | 24.91 | 24.58 | 24.69 | 2628080.0 |
| 2024-09-06 | AADR | ETF | 60.7359 | 60.7359 | 60.7359 | 60.7359 | 2.0 |
| 2024-09-06 | AAPB | ETF | 28.02 | 28.26 | 26.91 | 27.22 | 79078.0 |
| 2024-09-06 | AAPD | ETF | 17.24 | 17.56 | 17.131 | 17.48 | 363011.0 |
| 2024-09-06 | AAPR | ETF | 25.689 | 25.689 | 25.6237 | 25.6237 | 2743.0 |
| 2024-09-06 | AAPU | ETF | 35.73 | 36.139 | 34.45 | 34.8 | 617746.0 |
| 2024-09-06 | AAPX | ETF | 32.52 | 32.67 | 31.24 | 31.51 | 19136.0 |
| 2024-09-06 | AAPY | ETF | 27.13 | 27.13 | 26.6203 | 26.6203 | 896.0 |
| 2024-09-06 | AAXJ | ETF | 71.57 | 71.58 | 70.18 | 70.22 | 248872.0 |
| 2024-09-06 | ABCS | ETF | 27.4419 | 27.4419 | 26.91 | 26.953 | 1635.0 |
| 2024-09-06 | ABEQ | ETF | 32.345 | 32.345 | 32.1301 | 32.1498 | 819.0 |
| 2024-09-06 | ABNY | ETF | 78.75 | 78.761 | 77.0 | 77.124 | 1103.0 |
| 2024-09-06 | ACES | ETF | 27.82 | 27.82 | 26.7 | 26.72 | 52744.0 |
| 2024-09-06 | ACIO | ETF | 38.65 | 38.65 | 38.1205 | 38.16 | 146914.0 |
| 2024-09-06 | ACSI | ETF | 55.7125 | 55.7125 | 55.7125 | 55.7125 | 83.0 |
| 2024-09-06 | ACT | ETF | 35.43 | 36.0 | 35.365 | 35.7 | 469518.0 |
| 2024-09-06 | ACTV | ETF | 32.36 | 32.36 | 31.86 | 31.8691 | 4482.0 |
| 2024-09-06 | ACVF | ETF | 41.9 | 41.9 | 41.15 | 41.1621 | 5616.0 |
| 2024-09-06 | ACWI | ETF | 114.25 | 114.5699 | 112.12 | 112.31 | 1865677.0 |
| 2024-09-06 | ACWV | ETF | 112.67 | 113.021 | 111.62 | 111.67 | 164596.0 |
| 2024-09-06 | ACWX | ETF | 54.61 | 54.72 | 53.635 | 53.72 | 881019.0 |
| 2024-09-06 | ADFI | ETF | 8.775 | 8.79 | 8.76 | 8.78 | 13993.0 |
| 2024-09-06 | ADIV | ETF | 14.97 | 14.97 | 14.85 | 14.8745 | 833.0 |
| 2024-09-06 | ADME | ETF | 44.37 | 44.37 | 43.84 | 43.93 | 44968.0 |
| 2024-09-06 | ADPV | ETF | 31.37 | 31.37 | 30.7748 | 30.7748 | 1938.0 |
| 2024-09-06 | AEMB | ETF | 39.43 | 39.43 | 39.4106 | 39.4106 | 169.0 |
| 2024-09-06 | AESR | ETF | 16.11 | 16.11 | 15.77 | 15.85 | 11806.0 |
| 2024-09-06 | AETH | ETF | 30.0 | 30.0 | 28.51 | 28.6785 | 2824.0 |
| 2024-09-06 | AFIF | ETF | 9.18 | 9.23 | 9.18 | 9.215 | 4323.0 |
| 2024-09-06 | AFK | ETF | 15.91 | 15.98 | 15.58 | 15.68 | 10728.0 |
| 2024-09-06 | AFLG | ETF | 32.04 | 32.04 | 31.88 | 31.8993 | 17443.0 |
| 2024-09-06 | AFMC | ETF | 30.355 | 30.355 | 29.91 | 29.9233 | 458.0 |
| 2024-09-06 | AFSM | ETF | 28.755 | 28.79 | 28.66 | 28.7101 | 2996.0 |
| 2024-09-06 | AFTY | ETF | 13.8 | 13.8 | 13.7851 | 13.7851 | 305.0 |
| 2024-09-06 | AGG | ETF | 101.13 | 101.595 | 100.97 | 101.19 | 8805805.0 |
| 2024-09-06 | AGGH | ETF | 21.77 | 21.8 | 21.63 | 21.63 | 93244.0 |
| 2024-09-06 | AGGY | ETF | 44.75 | 44.94 | 44.6927 | 44.78 | 153408.0 |
| 2024-09-06 | AGIX | ETF | 23.5 | 23.5 | 22.7943 | 22.7943 | 1021.0 |
| 2024-09-06 | AGMI | ETF | 24.72 | 24.72 | 24.0022 | 24.0022 | 112.0 |
| 2024-09-06 | AGNG | ETF | 32.32 | 32.32 | 32.22 | 32.22 | 1249.0 |
| 2024-09-06 | AGOX | ETF | 27.41 | 27.41 | 26.93 | 26.95 | 48741.0 |
| 2024-09-06 | AGQ | ETF | 34.92 | 35.16 | 32.27 | 32.7 | 2018364.0 |
| 2024-09-06 | AGQI | ETF | 14.33 | 14.39 | 14.085 | 14.0921 | 14780.0 |
> showing 50 of 3,500 rows — these rows as CSV