PREVIEW / etf_daily / 2024-10-17
file: by_date/etf_daily/2024/2024-10-17.parquet size: 142 KB rows: 3,743
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-17 | SPY | ETF | 585.91 | 586.12 | 582.16 | 582.35 | 34294825.0 |
| 2024-10-17 | QQQ | ETF | 496.44 | 496.49 | 491.1901 | 491.25 | 27210658.0 |
| 2024-10-17 | IWM | ETF | 226.91 | 226.96 | 224.91 | 226.12 | 18000651.0 |
| 2024-10-17 | DIA | ETF | 432.54 | 432.89 | 431.2 | 432.45 | 3456779.0 |
| 2024-10-17 | GLD | ETF | 247.75 | 249.06 | 247.62 | 248.63 | 5170765.0 |
| 2024-10-17 | TLT | ETF | 94.29 | 94.44 | 93.6701 | 93.8 | 43377081.0 |
| 2024-10-17 | AAA | ETF | 25.1145 | 25.16 | 25.0636 | 25.14 | 10698.0 |
| 2024-10-17 | AAAU | ETF | 26.52 | 26.665 | 26.51 | 26.62 | 1799662.0 |
| 2024-10-17 | AADR | ETF | 65.39 | 65.46 | 65.39 | 65.46 | 288.0 |
| 2024-10-17 | AAPB | ETF | 30.0 | 30.0 | 29.1985 | 29.65 | 55445.0 |
| 2024-10-17 | AAPD | ETF | 16.42 | 16.62 | 16.39 | 16.515 | 188349.0 |
| 2024-10-17 | AAPR | ETF | 26.25 | 26.2634 | 26.23 | 26.255 | 16663.0 |
| 2024-10-17 | AAPU | ETF | 38.03 | 38.04 | 36.99 | 37.49 | 456382.0 |
| 2024-10-17 | AAPX | ETF | 33.98 | 34.33 | 33.9301 | 34.12 | 14207.0 |
| 2024-10-17 | AAPY | ETF | 27.8441 | 27.8441 | 27.8441 | 27.8441 | 257.0 |
| 2024-10-17 | AAXJ | ETF | 77.62 | 77.87 | 77.34 | 77.68 | 494398.0 |
| 2024-10-17 | ABCS | ETF | 28.77 | 28.77 | 28.74 | 28.77 | 1120.0 |
| 2024-10-17 | ABEQ | ETF | 33.07 | 33.1 | 33.0 | 33.04 | 42824.0 |
| 2024-10-17 | ABNY | ETF | 82.5 | 82.5 | 81.4005 | 82.15 | 3829.0 |
| 2024-10-17 | ACES | ETF | 29.02 | 29.02 | 28.33 | 28.33 | 506146.0 |
| 2024-10-17 | ACIO | ETF | 40.44 | 40.44 | 40.225 | 40.24 | 188401.0 |
| 2024-10-17 | ACSI | ETF | 58.64 | 58.6441 | 58.6162 | 58.6441 | 204.0 |
| 2024-10-17 | ACT | ETF | 36.79 | 36.9799 | 36.58 | 36.93 | 213231.0 |
| 2024-10-17 | ACTV | ETF | 34.54 | 34.548 | 34.49 | 34.548 | 2438.0 |
| 2024-10-17 | ACTX | ETF | 0.0001 | 0.0001 | 0.0001 | 0.0001 | 419.0 |
| 2024-10-17 | ACVF | ETF | 44.75 | 44.75 | 44.4873 | 44.51 | 3808.0 |
| 2024-10-17 | ACWI | ETF | 120.48 | 120.6 | 119.93 | 119.95 | 2355985.0 |
| 2024-10-17 | ACWV | ETF | 115.17 | 115.21 | 114.8001 | 114.96 | 60050.0 |
| 2024-10-17 | ACWX | ETF | 56.07 | 56.12 | 55.9362 | 55.98 | 1591868.0 |
| 2024-10-17 | ADFI | ETF | 8.62 | 8.64 | 8.61 | 8.64 | 25248.0 |
| 2024-10-17 | ADIV | ETF | 16.07 | 16.114 | 16.0 | 16.08 | 4064.0 |
| 2024-10-17 | ADME | ETF | 47.24 | 47.25 | 46.79 | 46.85 | 20782.0 |
| 2024-10-17 | ADPV | ETF | 33.37 | 33.37 | 33.2266 | 33.2267 | 2951.0 |
| 2024-10-17 | ADVE | ETF | 35.1112 | 35.1112 | 35.1112 | 35.1112 | 2.0 |
| 2024-10-17 | AESR | ETF | 17.32 | 17.35 | 17.25 | 17.25 | 30822.0 |
| 2024-10-17 | AETH | ETF | 33.44 | 33.59 | 33.1075 | 33.3042 | 5587.0 |
| 2024-10-17 | AFIF | ETF | 9.09 | 9.19 | 9.09 | 9.17 | 170823.0 |
| 2024-10-17 | AFK | ETF | 16.93 | 16.9799 | 16.61 | 16.81 | 5768.0 |
| 2024-10-17 | AFLG | ETF | 34.75 | 34.79 | 34.6188 | 34.64 | 60263.0 |
| 2024-10-17 | AFMC | ETF | 32.9056 | 32.92 | 32.8673 | 32.8673 | 1666.0 |
| 2024-10-17 | AFSM | ETF | 31.35 | 31.44 | 31.345 | 31.43 | 151489.0 |
| 2024-10-17 | AGG | ETF | 99.6 | 99.66 | 99.42 | 99.45 | 5302760.0 |
| 2024-10-17 | AGGH | ETF | 21.27 | 21.27 | 21.1162 | 21.16 | 45183.0 |
| 2024-10-17 | AGGS | ETF | 41.7517 | 41.7517 | 41.7517 | 41.7517 | 2.0 |
| 2024-10-17 | AGGY | ETF | 44.25 | 44.26 | 44.12 | 44.13 | 129506.0 |
| 2024-10-17 | AGIH | ETF | 24.8999 | 24.8999 | 24.8999 | 24.8999 | 3.0 |
| 2024-10-17 | AGIX | ETF | 26.37 | 26.44 | 26.2673 | 26.2673 | 1521.0 |
| 2024-10-17 | AGMI | ETF | 29.9 | 30.05 | 29.84 | 29.84 | 456.0 |
| 2024-10-17 | AGNG | ETF | 32.81 | 32.8216 | 32.47 | 32.47 | 7833.0 |
| 2024-10-17 | AGOX | ETF | 29.42 | 29.9 | 29.4001 | 29.4394 | 44734.0 |
> showing 50 of 3,743 rows — these rows as CSV