PREVIEW / etf_daily / 2024-10-14
file: by_date/etf_daily/2024/2024-10-14.parquet size: 142 KB rows: 3,739
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-10-14 | SPY | ETF | 581.22 | 585.27 | 580.73 | 584.32 | 36133960.0 |
| 2024-10-14 | QQQ | ETF | 495.77 | 498.83 | 495.26 | 497.5 | 26060145.0 |
| 2024-10-14 | IWM | ETF | 221.45 | 223.11 | 220.4301 | 222.89 | 19116207.0 |
| 2024-10-14 | DIA | ETF | 428.32 | 431.42 | 427.19 | 430.89 | 2177857.0 |
| 2024-10-14 | GLD | ETF | 245.16 | 245.86 | 244.26 | 245.07 | 3913481.0 |
| 2024-10-14 | TLT | ETF | 93.04 | 93.78 | 92.98 | 93.765 | 28721614.0 |
| 2024-10-14 | AAA | ETF | 25.1 | 25.13 | 25.075 | 25.105 | 6704.0 |
| 2024-10-14 | AAAU | ETF | 26.25 | 26.3103 | 26.1498 | 26.235 | 1851225.0 |
| 2024-10-14 | AADR | ETF | 65.2884 | 65.2884 | 65.2884 | 65.2884 | 184.0 |
| 2024-10-14 | AAPB | ETF | 28.77 | 29.51 | 28.77 | 29.46 | 103972.0 |
| 2024-10-14 | AAPD | ETF | 16.77 | 16.77 | 16.545 | 16.56 | 266688.0 |
| 2024-10-14 | AAPR | ETF | 26.24 | 26.275 | 26.24 | 26.275 | 231.0 |
| 2024-10-14 | AAPU | ETF | 36.45 | 37.4 | 36.43 | 37.28 | 573131.0 |
| 2024-10-14 | AAPX | ETF | 33.1 | 34.01 | 33.1 | 33.9311 | 4923.0 |
| 2024-10-14 | AAPY | ETF | 27.69 | 27.7193 | 27.5601 | 27.7193 | 1762.0 |
| 2024-10-14 | AAXJ | ETF | 79.02 | 79.7 | 78.72 | 79.11 | 437189.0 |
| 2024-10-14 | ABCS | ETF | 28.5199 | 28.6575 | 28.41 | 28.6575 | 2266.0 |
| 2024-10-14 | ABEQ | ETF | 32.59 | 32.75 | 32.59 | 32.75 | 2417.0 |
| 2024-10-14 | ABNY | ETF | 84.225 | 85.0 | 84.225 | 84.825 | 1409.0 |
| 2024-10-14 | ACES | ETF | 28.76 | 28.76 | 28.46 | 28.6217 | 22459.0 |
| 2024-10-14 | ACIO | ETF | 40.32 | 40.51 | 40.2914 | 40.45 | 116518.0 |
| 2024-10-14 | ACSI | ETF | 58.5011 | 58.5011 | 58.5011 | 58.5011 | 41.0 |
| 2024-10-14 | ACT | ETF | 36.16 | 36.28 | 36.015 | 36.22 | 123832.0 |
| 2024-10-14 | ACTV | ETF | 33.778 | 33.83 | 33.75 | 33.83 | 6157.0 |
| 2024-10-14 | ACVF | ETF | 44.45 | 44.67 | 44.44 | 44.58 | 5358.0 |
| 2024-10-14 | ACWI | ETF | 120.25 | 120.93 | 120.14 | 120.78 | 634075.0 |
| 2024-10-14 | ACWV | ETF | 114.47 | 115.09 | 114.38 | 115.05 | 55639.0 |
| 2024-10-14 | ACWX | ETF | 56.62 | 56.79 | 56.42 | 56.74 | 460018.0 |
| 2024-10-14 | ADFI | ETF | 8.62 | 8.635 | 8.57 | 8.635 | 13864.0 |
| 2024-10-14 | ADIV | ETF | 17.37 | 17.37 | 16.325 | 16.325 | 2250.0 |
| 2024-10-14 | ADME | ETF | 46.99 | 47.1199 | 46.99 | 47.1 | 14380.0 |
| 2024-10-14 | ADPV | ETF | 32.76 | 33.1 | 32.76 | 33.0642 | 1676.0 |
| 2024-10-14 | ADVE | ETF | 35.8566 | 35.8566 | 35.8566 | 35.8566 | 0.0 |
| 2024-10-14 | AESR | ETF | 17.29 | 17.4499 | 17.29 | 17.42 | 27598.0 |
| 2024-10-14 | AETH | ETF | 32.75 | 33.85 | 32.731 | 33.7318 | 7513.0 |
| 2024-10-14 | AFIF | ETF | 9.2 | 9.205 | 9.195 | 9.205 | 6446.0 |
| 2024-10-14 | AFK | ETF | 16.75 | 16.795 | 16.54 | 16.54 | 6132.0 |
| 2024-10-14 | AFLG | ETF | 34.61 | 34.69 | 34.5799 | 34.69 | 3290.0 |
| 2024-10-14 | AFMC | ETF | 32.53 | 32.5744 | 32.53 | 32.5744 | 594.0 |
| 2024-10-14 | AFSM | ETF | 31.09 | 31.09 | 31.0839 | 31.0839 | 308.0 |
| 2024-10-14 | AGG | ETF | 99.2 | 99.42 | 99.1701 | 99.41 | 3511074.0 |
| 2024-10-14 | AGGH | ETF | 21.1 | 21.3 | 21.09 | 21.3 | 42870.0 |
| 2024-10-14 | AGGS | ETF | 41.727 | 41.727 | 41.7265 | 41.7265 | 261.0 |
| 2024-10-14 | AGGY | ETF | 43.98 | 44.08 | 43.97 | 44.07 | 58174.0 |
| 2024-10-14 | AGIH | ETF | 24.93 | 24.93 | 24.93 | 24.93 | 3.0 |
| 2024-10-14 | AGIX | ETF | 26.7 | 26.7 | 26.49 | 26.595 | 550.0 |
| 2024-10-14 | AGMI | ETF | 29.855 | 30.0 | 29.855 | 29.89 | 210.0 |
| 2024-10-14 | AGNG | ETF | 32.62 | 32.84 | 32.55 | 32.72 | 2844.0 |
| 2024-10-14 | AGOX | ETF | 29.41 | 29.78 | 29.41 | 29.62 | 20145.0 |
| 2024-10-14 | AGQ | ETF | 40.31 | 41.14 | 39.84 | 40.47 | 922628.0 |
> showing 50 of 3,739 rows — these rows as CSV