PREVIEW / etf_daily / 2024-10-22
file: by_date/etf_daily/2024/2024-10-22.parquet size: 143 KB rows: 3,742
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-22 | SPY | ETF | 581.05 | 584.5 | 580.38 | 583.32 | 34076098.0 |
| 2024-10-22 | QQQ | ETF | 492.73 | 497.445 | 491.97 | 495.96 | 26685841.0 |
| 2024-10-22 | IWM | ETF | 221.47 | 221.83 | 220.3 | 221.26 | 15786804.0 |
| 2024-10-22 | DIA | ETF | 427.64 | 430.42 | 427.1596 | 429.31 | 2303983.0 |
| 2024-10-22 | GLD | ETF | 253.06 | 253.94 | 252.52 | 253.93 | 5746963.0 |
| 2024-10-22 | TLT | ETF | 92.65 | 92.76 | 92.091 | 92.32 | 31335326.0 |
| 2024-10-22 | AAA | ETF | 25.1233 | 25.1411 | 25.1 | 25.125 | 6370.0 |
| 2024-10-22 | AAAU | ETF | 27.1 | 27.19 | 27.035 | 27.185 | 2405382.0 |
| 2024-10-22 | AADR | ETF | 65.6236 | 65.6236 | 65.6236 | 65.6236 | 21.0 |
| 2024-10-22 | AAPB | ETF | 29.99 | 30.6 | 29.75 | 30.5 | 67717.0 |
| 2024-10-22 | AAPD | ETF | 16.4 | 16.4777 | 16.24 | 16.27 | 175613.0 |
| 2024-10-22 | AAPR | ETF | 26.21 | 26.275 | 26.21 | 26.24 | 17102.0 |
| 2024-10-22 | AAPU | ETF | 37.96 | 38.77 | 37.61 | 38.68 | 491551.0 |
| 2024-10-22 | AAPX | ETF | 34.39 | 35.2899 | 34.36 | 35.259 | 11586.0 |
| 2024-10-22 | AAPY | ETF | 28.2 | 28.2284 | 28.2 | 28.2284 | 174.0 |
| 2024-10-22 | AAXJ | ETF | 77.65 | 78.01 | 77.52 | 77.82 | 399747.0 |
| 2024-10-22 | ABCS | ETF | 28.38 | 28.3963 | 28.3501 | 28.3963 | 1230.0 |
| 2024-10-22 | ABEQ | ETF | 32.95 | 33.08 | 32.95 | 33.05 | 4739.0 |
| 2024-10-22 | ABNY | ETF | 83.45 | 83.45 | 82.0 | 82.14 | 1653.0 |
| 2024-10-22 | ACES | ETF | 28.09 | 28.1993 | 27.751 | 28.14 | 60730.0 |
| 2024-10-22 | ACIO | ETF | 40.21 | 40.38 | 40.1401 | 40.33 | 117769.0 |
| 2024-10-22 | ACSI | ETF | 58.6236 | 58.6236 | 58.6236 | 58.6236 | 19.0 |
| 2024-10-22 | ACT | ETF | 35.96 | 36.16 | 35.85 | 36.05 | 126539.0 |
| 2024-10-22 | ACTV | ETF | 33.91 | 33.91 | 33.65 | 33.7161 | 7035.0 |
| 2024-10-22 | ACVF | ETF | 44.31 | 44.43 | 44.245 | 44.3724 | 2241.0 |
| 2024-10-22 | ACWI | ETF | 119.51 | 120.04 | 119.39 | 119.81 | 5092849.0 |
| 2024-10-22 | ACWV | ETF | 113.99 | 114.1873 | 113.804 | 114.06 | 79586.0 |
| 2024-10-22 | ACWX | ETF | 55.68 | 55.7 | 55.51 | 55.63 | 687628.0 |
| 2024-10-22 | ADFI | ETF | 8.59 | 8.59 | 8.56 | 8.58 | 9205.0 |
| 2024-10-22 | ADIV | ETF | 16.15 | 16.1741 | 16.145 | 16.1741 | 421.0 |
| 2024-10-22 | ADME | ETF | 46.78 | 46.95 | 46.77 | 46.93 | 19166.0 |
| 2024-10-22 | ADPV | ETF | 32.865 | 32.865 | 32.74 | 32.8595 | 37314.0 |
| 2024-10-22 | ADVE | ETF | 34.93 | 35.0159 | 34.93 | 35.0159 | 201.0 |
| 2024-10-22 | AESR | ETF | 17.22 | 17.34 | 17.21 | 17.31 | 20855.0 |
| 2024-10-22 | AETH | ETF | 33.58 | 33.7399 | 33.541 | 33.6971 | 13656.0 |
| 2024-10-22 | AFIF | ETF | 9.1713 | 9.1713 | 9.15 | 9.155 | 7840.0 |
| 2024-10-22 | AFK | ETF | 17.0 | 17.139 | 16.91 | 17.04 | 6223.0 |
| 2024-10-22 | AFLG | ETF | 34.55 | 34.55 | 34.4 | 34.5272 | 9179.0 |
| 2024-10-22 | AFMC | ETF | 32.1607 | 32.1607 | 32.1607 | 32.1607 | 102.0 |
| 2024-10-22 | AFSM | ETF | 30.581 | 30.621 | 30.581 | 30.6125 | 1924.0 |
| 2024-10-22 | AGG | ETF | 98.93 | 99.01 | 98.77 | 98.85 | 10928805.0 |
| 2024-10-22 | AGGH | ETF | 21.16 | 21.16 | 20.99 | 21.0 | 117197.0 |
| 2024-10-22 | AGGS | ETF | 41.491 | 41.491 | 41.491 | 41.491 | 5.0 |
| 2024-10-22 | AGGY | ETF | 43.91 | 43.91 | 43.76 | 43.83 | 73387.0 |
| 2024-10-22 | AGIH | ETF | 24.7936 | 24.7936 | 24.7936 | 24.7936 | 2.0 |
| 2024-10-22 | AGIX | ETF | 26.26 | 26.33 | 26.21 | 26.308 | 974.0 |
| 2024-10-22 | AGMI | ETF | 32.91 | 32.966 | 32.66 | 32.966 | 407.0 |
| 2024-10-22 | AGNG | ETF | 32.49 | 32.65 | 32.49 | 32.52 | 2257.0 |
| 2024-10-22 | AGOX | ETF | 29.2539 | 29.2999 | 29.09 | 29.18 | 32800.0 |
| 2024-10-22 | AGQ | ETF | 48.99 | 50.1298 | 48.45 | 49.9 | 2860753.0 |
> showing 50 of 3,742 rows — these rows as CSV