PREVIEW / etf_daily / 2024-11-20
file: by_date/etf_daily/2024/2024-11-20.parquet size: 145 KB rows: 3,784
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-20 | SPY | ETF | 590.38 | 590.79 | 584.63 | 590.5 | 49060661.0 |
| 2024-11-20 | QQQ | ETF | 503.16 | 503.48 | 496.555 | 503.17 | 29565491.0 |
| 2024-11-20 | IWM | ETF | 230.23 | 230.93 | 228.04 | 230.93 | 23659018.0 |
| 2024-11-20 | DIA | ETF | 433.55 | 434.91 | 430.92 | 434.29 | 3688318.0 |
| 2024-11-20 | GLD | ETF | 243.74 | 245.21 | 243.51 | 244.62 | 6451527.0 |
| 2024-11-20 | TLT | ETF | 90.15 | 90.83 | 90.11 | 90.41 | 27683734.0 |
| 2024-11-20 | AAA | ETF | 25.0798 | 25.1699 | 25.05 | 25.16 | 5974.0 |
| 2024-11-20 | AAAU | ETF | 26.09 | 26.2499 | 26.07 | 26.185 | 2191018.0 |
| 2024-11-20 | AADR | ETF | 66.99 | 67.36 | 66.545 | 67.36 | 1775.0 |
| 2024-11-20 | AAPB | ETF | 28.58 | 28.7 | 27.93 | 28.55 | 20837.0 |
| 2024-11-20 | AAPD | ETF | 16.77 | 17.0106 | 16.73 | 16.78 | 146145.0 |
| 2024-11-20 | AAPR | ETF | 26.23 | 26.2985 | 26.23 | 26.2985 | 2048.0 |
| 2024-11-20 | AAPU | ETF | 35.83 | 36.4 | 35.18 | 36.11 | 270104.0 |
| 2024-11-20 | AAPX | ETF | 32.68 | 32.7774 | 32.1085 | 32.77 | 6990.0 |
| 2024-11-20 | AAPY | ETF | 26.499 | 26.7096 | 26.499 | 26.7096 | 381.0 |
| 2024-11-20 | AAXJ | ETF | 74.28 | 74.53 | 73.88 | 74.3 | 423735.0 |
| 2024-11-20 | ABCS | ETF | 29.3 | 29.4951 | 29.26 | 29.4951 | 1763.0 |
| 2024-11-20 | ABEQ | ETF | 32.555 | 32.6542 | 32.5 | 32.6542 | 2281.0 |
| 2024-11-20 | ABNY | ETF | 77.1 | 79.15 | 77.1 | 78.9255 | 6234.0 |
| 2024-11-20 | ACES | ETF | 26.43 | 26.76 | 26.42 | 26.6 | 44290.0 |
| 2024-11-20 | ACIO | ETF | 40.5 | 40.53 | 40.235 | 40.52 | 125524.0 |
| 2024-11-20 | ACSI | ETF | 60.8182 | 60.8182 | 60.8182 | 60.8182 | 93.0 |
| 2024-11-20 | ACT | ETF | 33.82 | 33.945 | 33.5885 | 33.86 | 230345.0 |
| 2024-11-20 | ACTV | ETF | 32.1135 | 32.38 | 32.1001 | 32.38 | 9073.0 |
| 2024-11-20 | ACVF | ETF | 44.94 | 44.94 | 44.5875 | 44.8601 | 6362.0 |
| 2024-11-20 | ACWI | ETF | 119.52 | 119.56 | 118.52 | 119.56 | 1851018.0 |
| 2024-11-20 | ACWV | ETF | 112.18 | 112.73 | 112.0229 | 112.7 | 74913.0 |
| 2024-11-20 | ACWX | ETF | 53.51 | 53.73 | 53.245 | 53.61 | 658302.0 |
| 2024-11-20 | ADFI | ETF | 8.485 | 8.5099 | 8.47 | 8.4912 | 16007.0 |
| 2024-11-20 | ADIV | ETF | 15.5 | 15.55 | 15.4929 | 15.55 | 3702.0 |
| 2024-11-20 | ADME | ETF | 47.015 | 47.22 | 46.8303 | 47.22 | 13133.0 |
| 2024-11-20 | ADPV | ETF | 37.0 | 37.0 | 36.5762 | 36.7698 | 8935.0 |
| 2024-11-20 | ADVE | ETF | 33.7701 | 33.7701 | 33.7701 | 33.7701 | 5.0 |
| 2024-11-20 | AESR | ETF | 17.38 | 17.466 | 17.3408 | 17.466 | 9560.0 |
| 2024-11-20 | AETH | ETF | 39.93 | 39.96 | 38.75 | 39.2953 | 11899.0 |
| 2024-11-20 | AFIF | ETF | 9.18 | 9.18 | 9.14 | 9.16 | 8316.0 |
| 2024-11-20 | AFK | ETF | 16.04 | 16.04 | 15.73 | 15.8 | 154598.0 |
| 2024-11-20 | AFLG | ETF | 35.31 | 35.31 | 34.94 | 35.28 | 44220.0 |
| 2024-11-20 | AFMC | ETF | 33.31 | 33.31 | 33.07 | 33.2785 | 10298.0 |
| 2024-11-20 | AFSM | ETF | 31.4503 | 31.67 | 31.4503 | 31.6677 | 1822.0 |
| 2024-11-20 | AGG | ETF | 97.69 | 97.93 | 97.67 | 97.79 | 5542385.0 |
| 2024-11-20 | AGGH | ETF | 20.83 | 20.83 | 20.73 | 20.82 | 73361.0 |
| 2024-11-20 | AGGS | ETF | 41.0891 | 41.0891 | 41.0891 | 41.0891 | 1.0 |
| 2024-11-20 | AGGY | ETF | 43.36 | 43.44 | 43.34 | 43.39 | 70616.0 |
| 2024-11-20 | AGIH | ETF | 24.5789 | 24.5789 | 24.5789 | 24.5789 | 4.0 |
| 2024-11-20 | AGIX | ETF | 27.61 | 27.61 | 27.195 | 27.56 | 1531.0 |
| 2024-11-20 | AGMI | ETF | 28.21 | 28.21 | 28.21 | 28.21 | 117.0 |
| 2024-11-20 | AGNG | ETF | 30.07 | 30.7799 | 30.07 | 30.71 | 22205.0 |
| 2024-11-20 | AGOX | ETF | 29.0 | 29.2162 | 28.85 | 29.18 | 14896.0 |
| 2024-11-20 | AGQ | ETF | 39.51 | 39.7293 | 38.63 | 38.8 | 1342914.0 |
> showing 50 of 3,784 rows — these rows as CSV