PREVIEW / etf_daily / 2024-10-18
file: by_date/etf_daily/2024/2024-10-18.parquet size: 142 KB rows: 3,732
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-18 | SPY | ETF | 584.07 | 585.39 | 582.58 | 584.59 | 37382087.0 |
| 2024-10-18 | QQQ | ETF | 494.06 | 495.57 | 493.3 | 494.47 | 25335030.0 |
| 2024-10-18 | IWM | ETF | 226.66 | 227.0299 | 225.39 | 225.65 | 19287834.0 |
| 2024-10-18 | DIA | ETF | 432.26 | 433.2 | 430.33 | 432.64 | 2298958.0 |
| 2024-10-18 | GLD | ETF | 250.0 | 251.37 | 249.9 | 251.27 | 7802984.0 |
| 2024-10-18 | TLT | ETF | 94.05 | 94.28 | 93.86 | 93.87 | 25214966.0 |
| 2024-10-18 | AAA | ETF | 25.14 | 25.14 | 25.085 | 25.105 | 4619.0 |
| 2024-10-18 | AAAU | ETF | 26.77 | 26.91 | 26.755 | 26.9 | 2131142.0 |
| 2024-10-18 | AADR | ETF | 65.67 | 65.8299 | 65.59 | 65.78 | 3619.0 |
| 2024-10-18 | AAPB | ETF | 30.56 | 30.56 | 30.11 | 30.33 | 81239.0 |
| 2024-10-18 | AAPD | ETF | 16.25 | 16.39 | 16.25 | 16.32 | 230647.0 |
| 2024-10-18 | AAPR | ETF | 26.2306 | 26.2913 | 26.2306 | 26.2913 | 9568.0 |
| 2024-10-18 | AAPU | ETF | 38.705 | 38.72 | 38.112 | 38.4 | 554666.0 |
| 2024-10-18 | AAPX | ETF | 35.19 | 35.21 | 34.8502 | 34.93 | 16571.0 |
| 2024-10-18 | AAPY | ETF | 28.11 | 28.1146 | 28.11 | 28.1146 | 350.0 |
| 2024-10-18 | AAXJ | ETF | 79.03 | 79.03 | 78.57 | 78.61 | 854205.0 |
| 2024-10-18 | ABCS | ETF | 28.77 | 28.81 | 28.77 | 28.7949 | 1698.0 |
| 2024-10-18 | ABEQ | ETF | 33.05 | 33.29 | 33.05 | 33.2853 | 1983.0 |
| 2024-10-18 | ABNY | ETF | 81.8 | 82.4995 | 81.6 | 82.4 | 1621.0 |
| 2024-10-18 | ACES | ETF | 28.44 | 28.52 | 28.23 | 28.5 | 130862.0 |
| 2024-10-18 | ACIO | ETF | 40.47 | 40.47 | 40.295 | 40.43 | 129814.0 |
| 2024-10-18 | ACSI | ETF | 59.002 | 59.002 | 59.002 | 59.002 | 15.0 |
| 2024-10-18 | ACT | ETF | 36.99 | 37.42 | 36.56 | 36.63 | 199031.0 |
| 2024-10-18 | ACTV | ETF | 34.62 | 34.8 | 34.62 | 34.7992 | 5702.0 |
| 2024-10-18 | ACVF | ETF | 44.4987 | 44.5994 | 44.4987 | 44.5577 | 5186.0 |
| 2024-10-18 | ACWI | ETF | 120.62 | 120.755 | 120.29 | 120.65 | 991072.0 |
| 2024-10-18 | ACWV | ETF | 115.41 | 115.59 | 115.06 | 115.32 | 106272.0 |
| 2024-10-18 | ACWX | ETF | 56.43 | 56.44 | 56.27 | 56.4 | 421111.0 |
| 2024-10-18 | ADFI | ETF | 8.6135 | 8.65 | 8.6 | 8.63 | 17810.0 |
| 2024-10-18 | ADIV | ETF | 16.2226 | 16.2226 | 16.205 | 16.205 | 547.0 |
| 2024-10-18 | ADME | ETF | 47.13 | 47.13 | 46.89 | 47.06 | 29065.0 |
| 2024-10-18 | ADPV | ETF | 33.4069 | 33.43 | 33.37 | 33.3725 | 2976.0 |
| 2024-10-18 | ADVE | ETF | 35.4429 | 35.4429 | 35.4429 | 35.4429 | 54.0 |
| 2024-10-18 | AESR | ETF | 17.2901 | 17.36 | 17.29 | 17.34 | 29817.0 |
| 2024-10-18 | AETH | ETF | 33.56 | 34.4099 | 33.49 | 34.048 | 9245.0 |
| 2024-10-18 | AFIF | ETF | 9.26 | 9.26 | 9.15 | 9.18 | 58835.0 |
| 2024-10-18 | AFK | ETF | 16.86 | 16.98 | 16.69 | 16.98 | 14546.0 |
| 2024-10-18 | AFLG | ETF | 34.69 | 34.78 | 34.66 | 34.74 | 7544.0 |
| 2024-10-18 | AFMC | ETF | 32.86 | 32.94 | 32.83 | 32.8521 | 2822.0 |
| 2024-10-18 | AFSM | ETF | 31.42 | 31.43 | 31.25 | 31.27 | 3899.0 |
| 2024-10-18 | AGG | ETF | 99.63 | 99.675 | 99.5 | 99.52 | 4967266.0 |
| 2024-10-18 | AGGH | ETF | 21.11 | 21.22 | 21.11 | 21.22 | 69208.0 |
| 2024-10-18 | AGGS | ETF | 41.81 | 41.81 | 41.794 | 41.794 | 100.0 |
| 2024-10-18 | AGGY | ETF | 44.2 | 44.2101 | 44.145 | 44.15 | 51687.0 |
| 2024-10-18 | AGIH | ETF | 24.9244 | 24.9244 | 24.9244 | 24.9244 | 3.0 |
| 2024-10-18 | AGIX | ETF | 26.2853 | 26.2853 | 26.2853 | 26.2853 | 23.0 |
| 2024-10-18 | AGMI | ETF | 30.5 | 31.7547 | 30.5 | 31.7547 | 324.0 |
| 2024-10-18 | AGNG | ETF | 32.72 | 32.95 | 32.72 | 32.88 | 1911.0 |
| 2024-10-18 | AGOX | ETF | 29.75 | 29.75 | 28.2501 | 29.42 | 37279.0 |
| 2024-10-18 | AGQ | ETF | 43.19 | 46.8699 | 43.0337 | 46.69 | 5170326.0 |
> showing 50 of 3,732 rows — these rows as CSV