PREVIEW / etf_daily / 2024-07-16
file: by_date/etf_daily/2024/2024-07-16.parquet size: 132 KB rows: 3,438
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-07-16 | SPY | ETF | 562.865 | 565.16 | 562.1 | 564.86 | 36362595.0 |
| 2024-07-16 | QQQ | ETF | 497.62 | 498.44 | 493.15 | 496.34 | 25950622.0 |
| 2024-07-16 | IWM | ETF | 219.14 | 224.86 | 219.02 | 224.6 | 68478740.0 |
| 2024-07-16 | DIA | ETF | 403.86 | 409.985 | 403.85 | 409.66 | 6542618.0 |
| 2024-07-16 | GLD | ETF | 225.45 | 228.29 | 225.3 | 228.29 | 11057993.0 |
| 2024-07-16 | TLT | ETF | 93.53 | 94.21 | 93.39 | 94.17 | 36331861.0 |
| 2024-07-16 | AAA | ETF | 25.11 | 25.11 | 25.028 | 25.07 | 26940.0 |
| 2024-07-16 | AAAU | ETF | 24.12 | 24.43 | 24.11 | 24.43 | 1438717.0 |
| 2024-07-16 | AADR | ETF | 64.29 | 64.29 | 63.56 | 64.06 | 1886.0 |
| 2024-07-16 | AAPB | ETF | 31.43 | 31.69 | 30.68 | 31.32 | 157816.0 |
| 2024-07-16 | AAPD | ETF | 16.35 | 16.5415 | 16.27 | 16.37 | 172966.0 |
| 2024-07-16 | AAPR | ETF | 25.56 | 25.67 | 25.56 | 25.67 | 19030.0 |
| 2024-07-16 | AAPU | ETF | 40.32 | 40.66 | 39.3062 | 40.13 | 947867.0 |
| 2024-07-16 | AAPX | ETF | 36.56 | 36.7501 | 35.85 | 36.44 | 29809.0 |
| 2024-07-16 | AAXJ | ETF | 74.3 | 74.75 | 74.19 | 74.7 | 801234.0 |
| 2024-07-16 | ABCS | ETF | 27.2561 | 27.5563 | 27.2 | 27.5563 | 2269.0 |
| 2024-07-16 | ABEQ | ETF | 31.17 | 31.2745 | 31.15 | 31.2745 | 7250.0 |
| 2024-07-16 | ABNY | ETF | 102.7 | 103.45 | 102.275 | 103.45 | 308.0 |
| 2024-07-16 | ACES | ETF | 31.25 | 31.96 | 31.04 | 31.96 | 108852.0 |
| 2024-07-16 | ACIO | ETF | 38.76 | 38.87 | 38.7026 | 38.83 | 93531.0 |
| 2024-07-16 | ACSI | ETF | 57.0155 | 57.0155 | 57.0155 | 57.0155 | 161.0 |
| 2024-07-16 | ACT | ETF | 32.36 | 33.22 | 32.2926 | 33.2 | 275270.0 |
| 2024-07-16 | ACTV | ETF | 33.26 | 33.97 | 33.26 | 33.97 | 72241.0 |
| 2024-07-16 | ACVF | ETF | 42.55 | 42.72 | 42.5 | 42.72 | 6114.0 |
| 2024-07-16 | ACWI | ETF | 116.23 | 116.75 | 116.115 | 116.69 | 12654927.0 |
| 2024-07-16 | ACWV | ETF | 107.17 | 107.85 | 106.76 | 107.84 | 99852.0 |
| 2024-07-16 | ACWX | ETF | 54.83 | 55.2 | 54.77 | 55.19 | 449445.0 |
| 2024-07-16 | ADFI | ETF | 8.6 | 8.62 | 8.59 | 8.61 | 26260.0 |
| 2024-07-16 | ADIV | ETF | 14.95 | 14.95 | 14.9301 | 14.9301 | 567.0 |
| 2024-07-16 | ADME | ETF | 45.09 | 45.2843 | 45.08 | 45.2843 | 11945.0 |
| 2024-07-16 | ADPV | ETF | 30.93 | 31.69 | 30.93 | 31.6777 | 6038.0 |
| 2024-07-16 | ADVE | ETF | 33.87 | 34.0222 | 33.87 | 34.0222 | 202.0 |
| 2024-07-16 | AEMB | ETF | 38.9 | 38.9 | 38.9 | 38.9 | 16.0 |
| 2024-07-16 | AESR | ETF | 16.82 | 16.85 | 16.78 | 16.84 | 23677.0 |
| 2024-07-16 | AETH | ETF | 44.68 | 45.7 | 44.485 | 45.4316 | 5375.0 |
| 2024-07-16 | AFIF | ETF | 9.1795 | 9.18 | 9.17 | 9.175 | 13455.0 |
| 2024-07-16 | AFK | ETF | 16.51 | 16.712 | 16.5001 | 16.61 | 15666.0 |
| 2024-07-16 | AFLG | ETF | 32.69 | 32.8351 | 32.69 | 32.8351 | 5885.0 |
| 2024-07-16 | AFMC | ETF | 30.632 | 31.28 | 30.6164 | 31.27 | 9738.0 |
| 2024-07-16 | AFSM | ETF | 30.26 | 30.77 | 30.0 | 30.76 | 23307.0 |
| 2024-07-16 | AFTY | ETF | 14.2748 | 14.2748 | 14.24 | 14.27 | 1076.0 |
| 2024-07-16 | AGG | ETF | 98.18 | 98.45 | 98.14 | 98.45 | 8923927.0 |
| 2024-07-16 | AGGH | ETF | 21.17 | 21.2599 | 21.065 | 21.11 | 108437.0 |
| 2024-07-16 | AGGY | ETF | 43.58 | 43.66 | 43.545 | 43.65 | 62768.0 |
| 2024-07-16 | AGMI | ETF | 28.9 | 29.5692 | 28.84 | 29.5692 | 1023.0 |
| 2024-07-16 | AGNG | ETF | 30.94 | 31.189 | 30.94 | 31.09 | 1479.0 |
| 2024-07-16 | AGOX | ETF | 28.6 | 28.74 | 28.5501 | 28.675 | 18907.0 |
| 2024-07-16 | AGQ | ETF | 40.94 | 42.79 | 40.791 | 42.55 | 1673341.0 |
| 2024-07-16 | AGQI | ETF | 14.67 | 14.7499 | 14.67 | 14.7499 | 7836.0 |
| 2024-07-16 | AGZ | ETF | 108.45 | 108.47 | 108.26 | 108.44 | 16915.0 |
> showing 50 of 3,438 rows — these rows as CSV