PREVIEW / etf_daily / 2024-10-29
file: by_date/etf_daily/2024/2024-10-29.parquet size: 144 KB rows: 3,754
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-29 | SPY | ETF | 579.85 | 582.907 | 578.43 | 581.77 | 41867976.0 |
| 2024-10-29 | QQQ | ETF | 495.72 | 501.35 | 493.85 | 500.16 | 28014059.0 |
| 2024-10-29 | IWM | ETF | 220.74 | 221.9 | 219.97 | 221.74 | 20143643.0 |
| 2024-10-29 | DIA | ETF | 422.23 | 424.97 | 421.76 | 422.5 | 2572110.0 |
| 2024-10-29 | GLD | ETF | 254.49 | 256.29 | 254.23 | 256.09 | 8869951.0 |
| 2024-10-29 | TLT | ETF | 91.17 | 92.06 | 90.9837 | 92.03 | 46459991.0 |
| 2024-10-29 | AAA | ETF | 25.14 | 25.1744 | 25.125 | 25.125 | 9922.0 |
| 2024-10-29 | AAAU | ETF | 27.25 | 27.435 | 27.22 | 27.415 | 1855751.0 |
| 2024-10-29 | AADR | ETF | 65.331 | 65.47 | 65.1 | 65.1 | 853.0 |
| 2024-10-29 | AAPB | ETF | 29.8 | 30.03 | 29.57 | 29.93 | 32920.0 |
| 2024-10-29 | AAPD | ETF | 16.46 | 16.51 | 16.395 | 16.44 | 95447.0 |
| 2024-10-29 | AAPR | ETF | 26.21 | 26.255 | 26.2 | 26.255 | 21500.0 |
| 2024-10-29 | AAPU | ETF | 37.7 | 38.05 | 37.4 | 37.84 | 297735.0 |
| 2024-10-29 | AAPX | ETF | 34.45 | 34.6197 | 34.28 | 34.46 | 13280.0 |
| 2024-10-29 | AAPY | ETF | 27.7144 | 27.7144 | 27.7144 | 27.7144 | 177.0 |
| 2024-10-29 | AAXJ | ETF | 77.29 | 77.42 | 77.12 | 77.18 | 563004.0 |
| 2024-10-29 | ABCS | ETF | 28.3685 | 28.44 | 28.3685 | 28.42 | 1903.0 |
| 2024-10-29 | ABEQ | ETF | 32.75 | 32.89 | 32.75 | 32.8321 | 3546.0 |
| 2024-10-29 | ABNY | ETF | 82.7 | 82.7 | 81.9 | 82.416 | 2386.0 |
| 2024-10-29 | ACES | ETF | 28.16 | 28.16 | 27.65 | 27.65 | 10372.0 |
| 2024-10-29 | ACIO | ETF | 40.09 | 40.26 | 40.0528 | 40.19 | 111164.0 |
| 2024-10-29 | ACSI | ETF | 58.7344 | 58.7344 | 58.7344 | 58.7344 | 13.0 |
| 2024-10-29 | ACT | ETF | 34.42 | 34.97 | 33.75 | 34.46 | 2358687.0 |
| 2024-10-29 | ACTV | ETF | 33.2234 | 33.2234 | 33.07 | 33.11 | 6804.0 |
| 2024-10-29 | ACVF | ETF | 44.14 | 44.25 | 44.14 | 44.18 | 6111.0 |
| 2024-10-29 | ACWI | ETF | 119.25 | 119.62 | 118.96 | 119.37 | 1218103.0 |
| 2024-10-29 | ACWV | ETF | 113.105 | 113.31 | 112.74 | 112.78 | 79235.0 |
| 2024-10-29 | ACWX | ETF | 55.42 | 55.5 | 55.29 | 55.35 | 337918.0 |
| 2024-10-29 | ADFI | ETF | 8.5003 | 8.56 | 8.5 | 8.5519 | 10140.0 |
| 2024-10-29 | ADIV | ETF | 15.97 | 15.97 | 15.9296 | 15.9296 | 279.0 |
| 2024-10-29 | ADME | ETF | 46.48 | 46.81 | 46.458 | 46.72 | 20201.0 |
| 2024-10-29 | ADPV | ETF | 33.51 | 33.51 | 33.27 | 33.4662 | 6018.0 |
| 2024-10-29 | ADVE | ETF | 34.91 | 34.925 | 34.86 | 34.925 | 472.0 |
| 2024-10-29 | AESR | ETF | 17.18 | 17.35 | 17.18 | 17.3 | 8407.0 |
| 2024-10-29 | AETH | ETF | 33.55 | 34.23 | 33.55 | 33.68 | 9886.0 |
| 2024-10-29 | AFIF | ETF | 9.14 | 9.145 | 9.1323 | 9.145 | 3238.0 |
| 2024-10-29 | AFK | ETF | 16.83 | 16.99 | 16.83 | 16.84 | 22303.0 |
| 2024-10-29 | AFLG | ETF | 34.2407 | 34.4 | 34.2407 | 34.35 | 13065.0 |
| 2024-10-29 | AFMC | ETF | 31.9198 | 32.179 | 31.9198 | 32.179 | 1404.0 |
| 2024-10-29 | AFSM | ETF | 30.49 | 30.61 | 30.42 | 30.61 | 30266.0 |
| 2024-10-29 | AGG | ETF | 98.12 | 98.56 | 98.0871 | 98.54 | 5420493.0 |
| 2024-10-29 | AGGH | ETF | 20.74 | 20.7434 | 20.6379 | 20.7 | 55440.0 |
| 2024-10-29 | AGGS | ETF | 41.26 | 41.3833 | 41.23 | 41.3833 | 502.0 |
| 2024-10-29 | AGGY | ETF | 43.39 | 43.58 | 43.35 | 43.58 | 75810.0 |
| 2024-10-29 | AGIH | ETF | 24.6349 | 24.6349 | 24.6349 | 24.6349 | 2.0 |
| 2024-10-29 | AGIX | ETF | 26.42 | 26.72 | 26.4 | 26.72 | 10789.0 |
| 2024-10-29 | AGMI | ETF | 32.25 | 32.3807 | 32.25 | 32.3807 | 135.0 |
| 2024-10-29 | AGNG | ETF | 32.67 | 32.67 | 32.54 | 32.635 | 3151.0 |
| 2024-10-29 | AGOX | ETF | 28.7014 | 29.39 | 28.7014 | 29.23 | 48254.0 |
| 2024-10-29 | AGQ | ETF | 48.06 | 49.1 | 47.74 | 48.76 | 2501069.0 |
> showing 50 of 3,754 rows — these rows as CSV