PREVIEW / etf_daily / 2024-09-27
file: by_date/etf_daily/2024/2024-09-27.parquet size: 136 KB rows: 3,539
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-27 | SPY | ETF | 573.39 | 574.22 | 570.42 | 571.47 | 42042420.0 |
| 2024-09-27 | QQQ | ETF | 490.5 | 490.64 | 485.56 | 486.75 | 22851120.0 |
| 2024-09-27 | IWM | ETF | 220.86 | 222.599 | 219.53 | 220.33 | 23925025.0 |
| 2024-09-27 | DIA | ETF | 422.59 | 426.2 | 422.24 | 422.95 | 3628092.0 |
| 2024-09-27 | GLD | ETF | 246.31 | 246.75 | 244.19 | 245.02 | 8221410.0 |
| 2024-09-27 | TLT | ETF | 98.54 | 98.755 | 98.21 | 98.57 | 28254263.0 |
| 2024-09-27 | AAA | ETF | 25.11 | 25.18 | 25.0548 | 25.155 | 4789.0 |
| 2024-09-27 | AAAU | ETF | 26.38 | 26.41 | 26.142 | 26.23 | 2469382.0 |
| 2024-09-27 | AADR | ETF | 64.23 | 64.23 | 64.23 | 64.23 | 134.0 |
| 2024-09-27 | AAPB | ETF | 28.89 | 29.129 | 28.57 | 28.67 | 79524.0 |
| 2024-09-27 | AAPD | ETF | 16.77 | 16.855 | 16.695 | 16.81 | 144763.0 |
| 2024-09-27 | AAPR | ETF | 26.26 | 26.27 | 26.19 | 26.19 | 4001.0 |
| 2024-09-27 | AAPU | ETF | 36.57 | 36.94 | 36.2391 | 36.37 | 663616.0 |
| 2024-09-27 | AAPX | ETF | 33.51 | 33.62 | 33.09 | 33.19 | 9655.0 |
| 2024-09-27 | AAPY | ETF | 27.34 | 27.34 | 27.2994 | 27.2994 | 292.0 |
| 2024-09-27 | AAXJ | ETF | 79.69 | 80.21 | 79.52 | 79.71 | 2977416.0 |
| 2024-09-27 | ABCS | ETF | 28.4541 | 28.4793 | 28.345 | 28.38 | 2909.0 |
| 2024-09-27 | ABEQ | ETF | 32.65 | 32.82 | 32.65 | 32.781 | 748.0 |
| 2024-09-27 | ABNY | ETF | 84.35 | 84.35 | 82.075 | 82.075 | 407.0 |
| 2024-09-27 | ACES | ETF | 29.44 | 30.0 | 29.44 | 29.79 | 80483.0 |
| 2024-09-27 | ACIO | ETF | 39.74 | 39.74 | 39.5301 | 39.59 | 163458.0 |
| 2024-09-27 | ACSI | ETF | 58.465 | 58.465 | 58.465 | 58.465 | 61.0 |
| 2024-09-27 | ACT | ETF | 36.53 | 36.71 | 36.13 | 36.21 | 357099.0 |
| 2024-09-27 | ACTV | ETF | 34.1 | 34.14 | 33.76 | 33.8838 | 3315.0 |
| 2024-09-27 | ACVF | ETF | 43.7299 | 43.7299 | 43.5626 | 43.5875 | 4290.0 |
| 2024-09-27 | ACWI | ETF | 119.99 | 120.235 | 119.35 | 119.56 | 1619181.0 |
| 2024-09-27 | ACWV | ETF | 114.71 | 115.3299 | 114.71 | 114.72 | 176740.0 |
| 2024-09-27 | ACWX | ETF | 57.91 | 57.955 | 57.47 | 57.56 | 422248.0 |
| 2024-09-27 | ADFI | ETF | 8.8 | 8.8 | 8.77 | 8.785 | 25174.0 |
| 2024-09-27 | ADIV | ETF | 16.47 | 16.54 | 16.45 | 16.47 | 4928.0 |
| 2024-09-27 | ADME | ETF | 46.03 | 46.22 | 45.96 | 46.0 | 10538.0 |
| 2024-09-27 | ADPV | ETF | 31.58 | 31.8734 | 31.58 | 31.7968 | 3984.0 |
| 2024-09-27 | ADVE | ETF | 36.62 | 36.64 | 36.4334 | 36.4334 | 3132.0 |
| 2024-09-27 | AESR | ETF | 16.99 | 16.99 | 16.92 | 16.95 | 31826.0 |
| 2024-09-27 | AETH | ETF | 34.24 | 35.08 | 34.102 | 34.7921 | 8486.0 |
| 2024-09-27 | AFIF | ETF | 9.2 | 9.22 | 9.2 | 9.2141 | 134296.0 |
| 2024-09-27 | AFK | ETF | 17.25 | 17.25 | 17.0 | 17.25 | 16067.0 |
| 2024-09-27 | AFLG | ETF | 34.18 | 34.18 | 33.9896 | 33.9896 | 5895.0 |
| 2024-09-27 | AFMC | ETF | 32.1 | 32.1409 | 32.1 | 32.1409 | 646.0 |
| 2024-09-27 | AFSM | ETF | 30.606 | 30.96 | 30.5985 | 30.66 | 915.0 |
| 2024-09-27 | AFTY | ETF | 16.44 | 16.62 | 16.36 | 16.55 | 17152.0 |
| 2024-09-27 | AGG | ETF | 101.41 | 101.56 | 101.325 | 101.5 | 5018057.0 |
| 2024-09-27 | AGGH | ETF | 21.74 | 21.74 | 21.64 | 21.7 | 48962.0 |
| 2024-09-27 | AGGS | ETF | 42.595 | 42.61 | 42.5743 | 42.5743 | 355.0 |
| 2024-09-27 | AGGY | ETF | 44.8 | 44.8729 | 44.78 | 44.83 | 72505.0 |
| 2024-09-27 | AGIX | ETF | 25.71 | 25.71 | 25.3798 | 25.3798 | 4669.0 |
| 2024-09-27 | AGMI | ETF | 30.47 | 30.47 | 29.8137 | 29.8137 | 530.0 |
| 2024-09-27 | AGNG | ETF | 32.87 | 32.88 | 32.79 | 32.82 | 3268.0 |
| 2024-09-27 | AGOX | ETF | 29.15 | 29.16 | 28.76 | 29.05 | 30637.0 |
| 2024-09-27 | AGQ | ETF | 43.17 | 43.53 | 41.03 | 41.74 | 2533305.0 |
> showing 50 of 3,539 rows — these rows as CSV