PREVIEW / etf_daily / 2024-10-11
file: by_date/etf_daily/2024/2024-10-11.parquet size: 143 KB rows: 3,737
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-10-11 | SPY | ETF | 576.05 | 580.33 | 575.91 | 579.58 | 42229657.0 |
| 2024-10-11 | QQQ | ETF | 490.74 | 494.39 | 490.17 | 493.36 | 20644497.0 |
| 2024-10-11 | IWM | ETF | 216.77 | 221.61 | 216.71 | 221.26 | 19915447.0 |
| 2024-10-11 | DIA | ETF | 425.28 | 429.07 | 425.01 | 428.73 | 3751832.0 |
| 2024-10-11 | GLD | ETF | 244.5 | 245.92 | 244.47 | 245.47 | 5781274.0 |
| 2024-10-11 | TLT | ETF | 93.48 | 94.0656 | 93.422 | 93.7 | 27282557.0 |
| 2024-10-11 | AAA | ETF | 25.1 | 25.1 | 25.0633 | 25.09 | 10442.0 |
| 2024-10-11 | AAAU | ETF | 26.185 | 26.3222 | 26.17 | 26.265 | 1536686.0 |
| 2024-10-11 | AADR | ETF | 64.67 | 64.67 | 64.67 | 64.67 | 13.0 |
| 2024-10-11 | AAPB | ETF | 28.91 | 28.91 | 28.48 | 28.49 | 75415.0 |
| 2024-10-11 | AAPD | ETF | 16.7283 | 16.85 | 16.7283 | 16.85 | 73133.0 |
| 2024-10-11 | AAPR | ETF | 26.19 | 26.2284 | 26.18 | 26.2284 | 6820.0 |
| 2024-10-11 | AAPU | ETF | 36.7 | 36.7 | 36.05 | 36.08 | 460638.0 |
| 2024-10-11 | AAPX | ETF | 33.15 | 33.2249 | 32.921 | 33.0 | 3517.0 |
| 2024-10-11 | AAPY | ETF | 27.36 | 27.42 | 27.36 | 27.3619 | 946.0 |
| 2024-10-11 | AAXJ | ETF | 78.67 | 79.675 | 78.51 | 79.57 | 383812.0 |
| 2024-10-11 | ABCS | ETF | 28.35 | 28.48 | 28.34 | 28.4547 | 1700.0 |
| 2024-10-11 | ABEQ | ETF | 32.6499 | 32.65 | 32.5872 | 32.5872 | 1353.0 |
| 2024-10-11 | ABNY | ETF | 84.5 | 85.0 | 84.5 | 84.5 | 1073.0 |
| 2024-10-11 | ACES | ETF | 28.06 | 28.8 | 28.06 | 28.76 | 153846.0 |
| 2024-10-11 | ACIO | ETF | 40.03 | 40.295 | 40.011 | 40.2 | 52375.0 |
| 2024-10-11 | ACSI | ETF | 58.2291 | 58.2291 | 58.2291 | 58.2291 | 21.0 |
| 2024-10-11 | ACT | ETF | 35.86 | 36.46 | 35.86 | 36.18 | 141159.0 |
| 2024-10-11 | ACTV | ETF | 33.62 | 33.6734 | 33.62 | 33.6689 | 2821.0 |
| 2024-10-11 | ACTX | ETF | 0.0001 | 0.0001 | 0.0001 | 0.0001 | 153.0 |
| 2024-10-11 | ACVF | ETF | 43.92 | 44.279 | 43.92 | 44.2632 | 15035.0 |
| 2024-10-11 | ACWI | ETF | 119.32 | 120.29 | 119.32 | 120.16 | 1093757.0 |
| 2024-10-11 | ACWV | ETF | 113.74 | 114.6 | 113.74 | 114.51 | 64024.0 |
| 2024-10-11 | ACWX | ETF | 56.38 | 56.74 | 56.28 | 56.71 | 735006.0 |
| 2024-10-11 | ADFI | ETF | 8.64 | 8.66 | 8.63 | 8.64 | 30614.0 |
| 2024-10-11 | ADIV | ETF | 16.06 | 16.335 | 16.06 | 16.335 | 5929.0 |
| 2024-10-11 | ADME | ETF | 46.59 | 46.8 | 46.59 | 46.76 | 7613.0 |
| 2024-10-11 | ADPV | ETF | 32.63 | 32.745 | 32.625 | 32.745 | 4796.0 |
| 2024-10-11 | ADVE | ETF | 36.02 | 36.02 | 35.9587 | 35.9587 | 435.0 |
| 2024-10-11 | AESR | ETF | 17.24 | 17.28 | 17.22 | 17.22 | 27575.0 |
| 2024-10-11 | AETH | ETF | 31.2399 | 31.7065 | 31.21 | 31.57 | 6190.0 |
| 2024-10-11 | AFIF | ETF | 9.2 | 9.21 | 9.195 | 9.205 | 10588.0 |
| 2024-10-11 | AFK | ETF | 16.78 | 16.8 | 16.7 | 16.73 | 6327.0 |
| 2024-10-11 | AFLG | ETF | 34.35 | 34.3687 | 34.275 | 34.36 | 4711.0 |
| 2024-10-11 | AFMC | ETF | 32.26 | 32.3182 | 32.2181 | 32.3182 | 2704.0 |
| 2024-10-11 | AFSM | ETF | 30.69 | 30.9025 | 30.69 | 30.9025 | 1311.0 |
| 2024-10-11 | AGG | ETF | 99.41 | 99.62 | 99.36 | 99.5 | 4874223.0 |
| 2024-10-11 | AGGH | ETF | 21.3 | 21.325 | 21.14 | 21.25 | 50183.0 |
| 2024-10-11 | AGGS | ETF | 41.7482 | 41.7482 | 41.7482 | 41.7482 | 2.0 |
| 2024-10-11 | AGGY | ETF | 44.06 | 44.152 | 44.05 | 44.1 | 46656.0 |
| 2024-10-11 | AGIH | ETF | 24.9679 | 24.9679 | 24.9679 | 24.9679 | 2.0 |
| 2024-10-11 | AGIX | ETF | 26.26 | 26.3645 | 26.26 | 26.345 | 3380.0 |
| 2024-10-11 | AGMI | ETF | 30.23 | 30.23 | 30.1676 | 30.1676 | 109.0 |
| 2024-10-11 | AGNG | ETF | 32.49 | 32.7 | 32.251 | 32.7 | 5511.0 |
| 2024-10-11 | AGOX | ETF | 30.65 | 30.65 | 29.3725 | 29.5652 | 21967.0 |
> showing 50 of 3,737 rows — these rows as CSV