PREVIEW / etf_daily / 2024-11-06
file: by_date/etf_daily/2024/2024-11-06.parquet size: 144 KB rows: 3,772
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-06 | SPY | ETF | 589.2 | 591.93 | 585.39 | 591.04 | 67288070.0 |
| 2024-11-06 | QQQ | ETF | 500.56 | 506.41 | 499.6 | 505.58 | 43082198.0 |
| 2024-11-06 | IWM | ETF | 236.59 | 237.58 | 232.75 | 237.22 | 73893544.0 |
| 2024-11-06 | DIA | ETF | 434.66 | 437.785 | 433.71 | 437.23 | 7093850.0 |
| 2024-11-06 | GLD | ETF | 245.635 | 247.35 | 244.9506 | 245.7 | 14300956.0 |
| 2024-11-06 | TLT | ETF | 89.64 | 90.72 | 89.5545 | 90.2 | 98351631.0 |
| 2024-11-06 | AAA | ETF | 25.08 | 25.08 | 25.03 | 25.06 | 9898.0 |
| 2024-11-06 | AAAU | ETF | 26.29 | 26.485 | 26.23 | 26.315 | 3141373.0 |
| 2024-11-06 | AADR | ETF | 65.6966 | 65.94 | 65.46 | 65.94 | 3678.0 |
| 2024-11-06 | AAPB | ETF | 27.1 | 27.84 | 27.02 | 27.08 | 120016.0 |
| 2024-11-06 | AAPD | ETF | 17.25 | 17.36 | 17.01 | 17.25 | 503944.0 |
| 2024-11-06 | AAPR | ETF | 26.23 | 26.3245 | 26.22 | 26.3245 | 6099.0 |
| 2024-11-06 | AAPU | ETF | 34.35 | 35.3 | 33.83 | 34.29 | 677584.0 |
| 2024-11-06 | AAPX | ETF | 31.29 | 31.93 | 31.1897 | 31.1897 | 10185.0 |
| 2024-11-06 | AAPY | ETF | 26.77 | 26.98 | 26.7248 | 26.7248 | 5489.0 |
| 2024-11-06 | AAXJ | ETF | 76.16 | 76.775 | 75.905 | 76.52 | 1783055.0 |
| 2024-11-06 | ABCS | ETF | 29.64 | 29.69 | 29.4635 | 29.69 | 1826.0 |
| 2024-11-06 | ABEQ | ETF | 32.6704 | 32.7922 | 32.6704 | 32.7922 | 3215.0 |
| 2024-11-06 | ABNY | ETF | 84.95 | 85.0 | 84.197 | 84.6195 | 3060.0 |
| 2024-11-06 | ACES | ETF | 27.83 | 27.8415 | 26.9 | 27.65 | 135134.0 |
| 2024-11-06 | ACIO | ETF | 40.61 | 40.69 | 40.2775 | 40.67 | 210917.0 |
| 2024-11-06 | ACSI | ETF | 60.2757 | 60.2757 | 60.2757 | 60.2757 | 13.0 |
| 2024-11-06 | ACT | ETF | 34.05 | 34.4175 | 33.47 | 34.03 | 646269.0 |
| 2024-11-06 | ACTV | ETF | 33.67 | 34.0007 | 33.66 | 33.94 | 9853.0 |
| 2024-11-06 | ACVF | ETF | 45.06 | 45.38 | 44.7129 | 45.08 | 23969.0 |
| 2024-11-06 | ACWI | ETF | 119.73 | 120.42 | 119.155 | 120.27 | 3767205.0 |
| 2024-11-06 | ACWV | ETF | 113.88 | 113.93 | 113.23 | 113.72 | 88035.0 |
| 2024-11-06 | ACWX | ETF | 54.65 | 54.8 | 54.26 | 54.74 | 916290.0 |
| 2024-11-06 | ADFI | ETF | 8.49 | 8.53 | 8.48 | 8.49 | 15703.0 |
| 2024-11-06 | ADIV | ETF | 15.83 | 15.87 | 15.83 | 15.85 | 567.0 |
| 2024-11-06 | ADME | ETF | 47.055 | 47.2881 | 46.87 | 47.17 | 105120.0 |
| 2024-11-06 | ADPV | ETF | 34.1308 | 34.7828 | 34.03 | 34.7828 | 6805.0 |
| 2024-11-06 | ADVE | ETF | 36.72 | 36.72 | 34.59 | 34.7786 | 2303.0 |
| 2024-11-06 | AESR | ETF | 17.442 | 17.5476 | 17.38 | 17.5476 | 15799.0 |
| 2024-11-06 | AETH | ETF | 33.58 | 34.5156 | 33.421 | 34.48 | 17929.0 |
| 2024-11-06 | AFIF | ETF | 9.1611 | 9.17 | 9.16 | 9.165 | 3995.0 |
| 2024-11-06 | AFK | ETF | 16.52 | 16.52 | 16.075 | 16.39 | 36711.0 |
| 2024-11-06 | AFLG | ETF | 34.73 | 34.994 | 34.7 | 34.994 | 6008.0 |
| 2024-11-06 | AFMC | ETF | 33.8 | 33.93 | 33.53 | 33.9 | 44740.0 |
| 2024-11-06 | AFSM | ETF | 32.41 | 32.89 | 32.3368 | 32.86 | 47680.0 |
| 2024-11-06 | AGG | ETF | 97.43 | 97.8199 | 97.355 | 97.59 | 9153625.0 |
| 2024-11-06 | AGGH | ETF | 20.68 | 20.74 | 20.5568 | 20.74 | 47695.0 |
| 2024-11-06 | AGGS | ETF | 40.92 | 41.03 | 40.92 | 40.97 | 402.0 |
| 2024-11-06 | AGGY | ETF | 43.2 | 43.41 | 43.16 | 43.28 | 77467.0 |
| 2024-11-06 | AGIH | ETF | 24.5731 | 24.5731 | 24.5731 | 24.5731 | 6.0 |
| 2024-11-06 | AGIX | ETF | 27.16 | 27.335 | 27.16 | 27.31 | 562.0 |
| 2024-11-06 | AGMI | ETF | 29.15 | 29.5844 | 29.15 | 29.5844 | 1868.0 |
| 2024-11-06 | AGNG | ETF | 32.43 | 32.43 | 31.54 | 31.9 | 6764.0 |
| 2024-11-06 | AGOX | ETF | 29.44 | 29.45 | 28.7301 | 29.07 | 27095.0 |
| 2024-11-06 | AGQ | ETF | 39.07 | 40.39 | 38.81 | 39.83 | 2192575.0 |
> showing 50 of 3,772 rows — these rows as CSV