PREVIEW / etf_daily / 2024-08-21
file: by_date/etf_daily/2024/2024-08-21.parquet size: 133 KB rows: 3,458
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-08-21 | SPY | ETF | 559.77 | 562.11 | 557.99 | 560.62 | 41499864.0 |
| 2024-08-21 | QQQ | ETF | 481.05 | 484.37 | 479.32 | 482.5 | 25658787.0 |
| 2024-08-21 | IWM | ETF | 214.28 | 215.66 | 212.82 | 215.46 | 19532172.0 |
| 2024-08-21 | DIA | ETF | 409.32 | 409.991 | 407.5901 | 408.99 | 1437508.0 |
| 2024-08-21 | GLD | ETF | 231.69 | 232.87 | 230.48 | 232.15 | 5330194.0 |
| 2024-08-21 | TLT | ETF | 98.67 | 99.2 | 98.21 | 98.73 | 29208536.0 |
| 2024-08-21 | AAA | ETF | 25.1327 | 25.14 | 25.1 | 25.14 | 3518.0 |
| 2024-08-21 | AAAU | ETF | 24.81 | 24.93 | 24.67 | 24.845 | 1707633.0 |
| 2024-08-21 | AADR | ETF | 62.42 | 62.42 | 62.42 | 62.42 | 9.0 |
| 2024-08-21 | AAPB | ETF | 28.76 | 29.0797 | 28.44 | 28.72 | 118704.0 |
| 2024-08-21 | AAPD | ETF | 17.01 | 17.075 | 16.88 | 17.0 | 228904.0 |
| 2024-08-21 | AAPR | ETF | 25.82 | 25.845 | 25.82 | 25.845 | 394.0 |
| 2024-08-21 | AAPU | ETF | 36.79 | 37.2496 | 36.38 | 36.73 | 316710.0 |
| 2024-08-21 | AAPX | ETF | 33.4258 | 33.66 | 32.94 | 33.295 | 19391.0 |
| 2024-08-21 | AAXJ | ETF | 72.92 | 73.42 | 72.92 | 73.3 | 108238.0 |
| 2024-08-21 | ABCS | ETF | 27.354 | 27.4867 | 27.354 | 27.4867 | 2587.0 |
| 2024-08-21 | ABEQ | ETF | 31.87 | 31.98 | 31.86 | 31.96 | 2581.0 |
| 2024-08-21 | ABNY | ETF | 80.7 | 80.7 | 79.8665 | 80.3085 | 689.0 |
| 2024-08-21 | ACES | ETF | 28.32 | 28.69 | 28.3 | 28.69 | 63290.0 |
| 2024-08-21 | ACIO | ETF | 39.1 | 39.22 | 38.9626 | 39.125 | 155005.0 |
| 2024-08-21 | ACSI | ETF | 56.66 | 56.66 | 56.6261 | 56.6261 | 197.0 |
| 2024-08-21 | ACT | ETF | 34.24 | 34.87 | 33.92 | 34.82 | 287496.0 |
| 2024-08-21 | ACTV | ETF | 32.34 | 32.615 | 32.33 | 32.615 | 11084.0 |
| 2024-08-21 | ACVF | ETF | 42.5954 | 42.7174 | 42.57 | 42.7057 | 14454.0 |
| 2024-08-21 | ACWI | ETF | 115.99 | 116.42 | 115.67 | 116.26 | 2689021.0 |
| 2024-08-21 | ACWV | ETF | 111.82 | 112.15 | 111.72 | 112.02 | 123179.0 |
| 2024-08-21 | ACWX | ETF | 55.14 | 55.42 | 55.08 | 55.31 | 845682.0 |
| 2024-08-21 | ADFI | ETF | 8.68 | 8.75 | 8.68 | 8.74 | 11450.0 |
| 2024-08-21 | ADIV | ETF | 15.24 | 15.265 | 15.24 | 15.265 | 303.0 |
| 2024-08-21 | ADME | ETF | 45.18 | 45.41 | 45.18 | 45.3548 | 12272.0 |
| 2024-08-21 | ADPV | ETF | 31.04 | 31.2137 | 31.04 | 31.2137 | 654.0 |
| 2024-08-21 | AEMB | ETF | 39.7265 | 39.7265 | 39.7265 | 39.7265 | 0.0 |
| 2024-08-21 | AESR | ETF | 16.67 | 16.765 | 16.63 | 16.7282 | 13140.0 |
| 2024-08-21 | AETH | ETF | 33.43 | 34.3867 | 33.43 | 34.3867 | 3369.0 |
| 2024-08-21 | AFIF | ETF | 9.24 | 9.24 | 9.15 | 9.15 | 23025.0 |
| 2024-08-21 | AFK | ETF | 16.36 | 16.49 | 16.17 | 16.36 | 2284.0 |
| 2024-08-21 | AFLG | ETF | 32.8 | 32.8746 | 32.79 | 32.8746 | 2262.0 |
| 2024-08-21 | AFMC | ETF | 30.7444 | 30.9516 | 30.7 | 30.9516 | 2491.0 |
| 2024-08-21 | AFSM | ETF | 29.6608 | 29.8271 | 29.54 | 29.8271 | 1871.0 |
| 2024-08-21 | AFTY | ETF | 14.11 | 14.14 | 14.11 | 14.14 | 735.0 |
| 2024-08-21 | AGG | ETF | 100.61 | 100.9 | 100.43 | 100.72 | 6364558.0 |
| 2024-08-21 | AGGH | ETF | 21.76 | 21.76 | 21.58 | 21.58 | 103515.0 |
| 2024-08-21 | AGGY | ETF | 44.57 | 44.6491 | 44.49 | 44.585 | 32510.0 |
| 2024-08-21 | AGIX | ETF | 25.13 | 25.24 | 25.12 | 25.2258 | 2907.0 |
| 2024-08-21 | AGMI | ETF | 27.1 | 27.55 | 27.1 | 27.4493 | 328.0 |
| 2024-08-21 | AGNG | ETF | 32.47 | 32.74 | 32.47 | 32.6 | 6805.0 |
| 2024-08-21 | AGOX | ETF | 29.55 | 29.55 | 29.14 | 29.4935 | 161770.0 |
| 2024-08-21 | AGQ | ETF | 37.01 | 37.67 | 36.3412 | 37.16 | 1293691.0 |
| 2024-08-21 | AGQI | ETF | 14.4406 | 14.49 | 14.4406 | 14.475 | 7472.0 |
| 2024-08-21 | AGZ | ETF | 109.98 | 110.16 | 109.94 | 110.04 | 11894.0 |
> showing 50 of 3,458 rows — these rows as CSV