PREVIEW / etf_daily / 2024-11-21
file: by_date/etf_daily/2024/2024-11-21.parquet size: 144 KB rows: 3,785
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-11-21 | SPY | ETF | 593.4 | 595.12 | 587.45 | 593.67 | 46643878.0 |
| 2024-11-21 | QQQ | ETF | 506.24 | 506.96 | 497.56 | 504.98 | 34526738.0 |
| 2024-11-21 | IWM | ETF | 232.16 | 235.57 | 231.11 | 234.44 | 28324588.0 |
| 2024-11-21 | DIA | ETF | 435.86 | 440.54 | 433.63 | 438.97 | 7314658.0 |
| 2024-11-21 | GLD | ETF | 246.23 | 246.81 | 245.69 | 246.66 | 7509816.0 |
| 2024-11-21 | TLT | ETF | 90.45 | 90.85 | 90.0 | 90.34 | 28296792.0 |
| 2024-11-21 | AAA | ETF | 25.0653 | 25.1163 | 25.0601 | 25.1 | 1088.0 |
| 2024-11-21 | AAAU | ETF | 26.36 | 26.43 | 26.3001 | 26.405 | 2378904.0 |
| 2024-11-21 | AADR | ETF | 67.45 | 67.45 | 67.45 | 67.45 | 11.0 |
| 2024-11-21 | AAPB | ETF | 28.1 | 28.84 | 27.8105 | 28.47 | 30862.0 |
| 2024-11-21 | AAPD | ETF | 16.81 | 17.0279 | 16.71 | 16.83 | 182296.0 |
| 2024-11-21 | AAPR | ETF | 26.27 | 26.35 | 26.27 | 26.335 | 4638.0 |
| 2024-11-21 | AAPU | ETF | 36.11 | 36.4987 | 35.1243 | 35.99 | 383393.0 |
| 2024-11-21 | AAPX | ETF | 32.4 | 33.15 | 32.0855 | 32.77 | 17881.0 |
| 2024-11-21 | AAPY | ETF | 26.6495 | 26.6495 | 26.6495 | 26.6495 | 379.0 |
| 2024-11-21 | AAXJ | ETF | 74.02 | 74.21 | 73.77 | 74.12 | 176289.0 |
| 2024-11-21 | ABCS | ETF | 29.71 | 29.95 | 29.71 | 29.9448 | 1288.0 |
| 2024-11-21 | ABEQ | ETF | 32.8106 | 32.88 | 32.8106 | 32.8483 | 2064.0 |
| 2024-11-21 | ABNY | ETF | 78.95 | 78.95 | 78.0 | 78.5075 | 2872.0 |
| 2024-11-21 | ACES | ETF | 26.71 | 27.05 | 26.56 | 26.84 | 34521.0 |
| 2024-11-21 | ACIO | ETF | 40.63 | 40.77 | 40.35 | 40.7 | 126013.0 |
| 2024-11-21 | ACSI | ETF | 61.0458 | 61.0458 | 61.0458 | 61.0458 | 60.0 |
| 2024-11-21 | ACT | ETF | 34.05 | 34.44 | 33.8516 | 34.39 | 256006.0 |
| 2024-11-21 | ACTV | ETF | 32.62 | 33.12 | 32.611 | 33.12 | 9341.0 |
| 2024-11-21 | ACVF | ETF | 45.214 | 45.45 | 45.214 | 45.3988 | 5362.0 |
| 2024-11-21 | ACWI | ETF | 119.95 | 120.265 | 119.105 | 120.01 | 3315303.0 |
| 2024-11-21 | ACWV | ETF | 112.5 | 113.47 | 112.35 | 113.36 | 224308.0 |
| 2024-11-21 | ACWX | ETF | 53.565 | 53.76 | 53.36 | 53.7 | 1407318.0 |
| 2024-11-21 | ADFI | ETF | 8.49 | 8.4901 | 8.44 | 8.44 | 22134.0 |
| 2024-11-21 | ADIV | ETF | 15.565 | 15.59 | 15.55 | 15.59 | 820.0 |
| 2024-11-21 | ADME | ETF | 47.3 | 47.5699 | 46.99 | 47.4475 | 10704.0 |
| 2024-11-21 | ADPV | ETF | 37.06 | 37.26 | 36.98 | 37.0776 | 13722.0 |
| 2024-11-21 | ADVE | ETF | 33.9339 | 33.9339 | 33.9339 | 33.9339 | 1.0 |
| 2024-11-21 | AESR | ETF | 17.4 | 17.65 | 17.4 | 17.6166 | 24744.0 |
| 2024-11-21 | AETH | ETF | 42.78 | 43.1835 | 41.48 | 42.8314 | 32177.0 |
| 2024-11-21 | AFIF | ETF | 9.17 | 9.17 | 9.16 | 9.17 | 11432.0 |
| 2024-11-21 | AFK | ETF | 16.02 | 16.07 | 15.91 | 16.07 | 15602.0 |
| 2024-11-21 | AFLG | ETF | 35.56 | 35.68 | 35.2075 | 35.62 | 26344.0 |
| 2024-11-21 | AFMC | ETF | 33.52 | 33.8892 | 33.52 | 33.8119 | 7388.0 |
| 2024-11-21 | AFSM | ETF | 31.91 | 32.252 | 31.91 | 32.19 | 6318.0 |
| 2024-11-21 | AGG | ETF | 97.85 | 98.01 | 97.6701 | 97.74 | 6309970.0 |
| 2024-11-21 | AGGH | ETF | 20.72 | 20.85 | 20.69 | 20.82 | 41813.0 |
| 2024-11-21 | AGGS | ETF | 41.075 | 41.075 | 41.075 | 41.075 | 0.0 |
| 2024-11-21 | AGGY | ETF | 43.39 | 43.47 | 43.32 | 43.35 | 118239.0 |
| 2024-11-21 | AGIH | ETF | 24.57 | 24.57 | 24.57 | 24.57 | 4.0 |
| 2024-11-21 | AGIX | ETF | 27.85 | 28.11 | 27.7893 | 28.1 | 1644.0 |
| 2024-11-21 | AGMI | ETF | 28.2029 | 28.2029 | 28.2029 | 28.2029 | 6.0 |
| 2024-11-21 | AGNG | ETF | 30.84 | 30.98 | 30.83 | 30.98 | 1939.0 |
| 2024-11-21 | AGOX | ETF | 29.2584 | 29.29 | 28.91 | 29.2405 | 29300.0 |
| 2024-11-21 | AGQ | ETF | 39.23 | 39.25 | 38.27 | 38.67 | 1312687.0 |
> showing 50 of 3,785 rows — these rows as CSV