PREVIEW / etf_daily / 2024-11-05
file: by_date/etf_daily/2024/2024-11-05.parquet size: 144 KB rows: 3,766
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-05 | SPY | ETF | 570.74 | 576.74 | 570.52 | 576.7 | 39196363.0 |
| 2024-11-05 | QQQ | ETF | 487.61 | 492.88 | 487.52 | 492.21 | 24353615.0 |
| 2024-11-05 | IWM | ETF | 219.34 | 224.29 | 219.06 | 224.23 | 25817766.0 |
| 2024-11-05 | DIA | ETF | 418.27 | 422.6199 | 417.71 | 422.3 | 2979797.0 |
| 2024-11-05 | GLD | ETF | 253.78 | 253.9893 | 252.41 | 253.4 | 6020553.0 |
| 2024-11-05 | TLT | ETF | 92.03 | 92.9 | 91.6 | 92.74 | 45432474.0 |
| 2024-11-05 | AAA | ETF | 25.07 | 25.07 | 25.04 | 25.0475 | 7328.0 |
| 2024-11-05 | AAAU | ETF | 27.165 | 27.1999 | 27.0299 | 27.13 | 1801420.0 |
| 2024-11-05 | AADR | ETF | 65.5 | 65.8 | 65.5 | 65.8 | 238.0 |
| 2024-11-05 | AAPB | ETF | 27.0 | 27.37 | 26.91 | 27.26 | 24451.0 |
| 2024-11-05 | AAPD | ETF | 17.28 | 17.3101 | 17.1699 | 17.19 | 259002.0 |
| 2024-11-05 | AAPR | ETF | 26.12 | 26.21 | 26.0801 | 26.1638 | 38909.0 |
| 2024-11-05 | AAPU | ETF | 33.99 | 34.71 | 33.99 | 34.52 | 317516.0 |
| 2024-11-05 | AAPX | ETF | 30.89 | 31.38 | 30.89 | 31.3069 | 5332.0 |
| 2024-11-05 | AAPY | ETF | 26.79 | 26.81 | 26.7046 | 26.7046 | 665.0 |
| 2024-11-05 | AAXJ | ETF | 77.62 | 77.87 | 77.47 | 77.79 | 694172.0 |
| 2024-11-05 | ABCS | ETF | 28.53 | 28.656 | 28.5299 | 28.656 | 1912.0 |
| 2024-11-05 | ABEQ | ETF | 32.5 | 32.61 | 32.5 | 32.57 | 10509.0 |
| 2024-11-05 | ABNY | ETF | 82.95 | 84.19 | 82.95 | 83.2635 | 1050.0 |
| 2024-11-05 | ACES | ETF | 28.58 | 29.27 | 28.58 | 29.26 | 25287.0 |
| 2024-11-05 | ACIO | ETF | 39.6 | 39.91 | 39.6 | 39.9 | 207768.0 |
| 2024-11-05 | ACSI | ETF | 58.2516 | 58.2516 | 58.2516 | 58.2516 | 83.0 |
| 2024-11-05 | ACT | ETF | 32.42 | 32.865 | 32.42 | 32.78 | 810246.0 |
| 2024-11-05 | ACTV | ETF | 32.02 | 32.5816 | 32.02 | 32.5816 | 1871.0 |
| 2024-11-05 | ACVF | ETF | 43.5 | 43.96 | 43.5 | 43.96 | 17458.0 |
| 2024-11-05 | ACWI | ETF | 117.84 | 118.87 | 117.83 | 118.85 | 1754682.0 |
| 2024-11-05 | ACWV | ETF | 112.47 | 113.3 | 112.43 | 113.26 | 158645.0 |
| 2024-11-05 | ACWX | ETF | 55.14 | 55.4701 | 55.09 | 55.43 | 743070.0 |
| 2024-11-05 | ADFI | ETF | 8.56 | 8.58 | 8.52 | 8.54 | 27771.0 |
| 2024-11-05 | ADIV | ETF | 16.2 | 16.2 | 16.01 | 16.055 | 848.0 |
| 2024-11-05 | ADME | ETF | 46.085 | 46.35 | 46.085 | 46.35 | 16540.0 |
| 2024-11-05 | ADPV | ETF | 32.8199 | 33.1392 | 32.8199 | 33.1392 | 5212.0 |
| 2024-11-05 | ADVE | ETF | 35.1295 | 35.1295 | 35.1295 | 35.1295 | 1.0 |
| 2024-11-05 | AESR | ETF | 17.12 | 17.14 | 17.09 | 17.1 | 25132.0 |
| 2024-11-05 | AETH | ETF | 31.44 | 31.475 | 30.97 | 30.9759 | 4091.0 |
| 2024-11-05 | AFIF | ETF | 9.18 | 9.18 | 9.1601 | 9.17 | 74006.0 |
| 2024-11-05 | AFK | ETF | 16.6 | 16.73 | 16.5 | 16.73 | 22314.0 |
| 2024-11-05 | AFLG | ETF | 33.9534 | 34.22 | 33.9534 | 34.2196 | 9286.0 |
| 2024-11-05 | AFMC | ETF | 32.18 | 32.58 | 32.18 | 32.58 | 884.0 |
| 2024-11-05 | AFSM | ETF | 30.79 | 30.9494 | 30.79 | 30.9494 | 47978.0 |
| 2024-11-05 | AGG | ETF | 98.09 | 98.39 | 97.86 | 98.36 | 6638253.0 |
| 2024-11-05 | AGGH | ETF | 20.7 | 20.8 | 20.6505 | 20.7797 | 54831.0 |
| 2024-11-05 | AGGS | ETF | 41.3 | 41.3 | 41.3 | 41.3 | 102.0 |
| 2024-11-05 | AGGY | ETF | 43.51 | 43.66 | 43.4122 | 43.65 | 50965.0 |
| 2024-11-05 | AGIH | ETF | 24.6049 | 24.6049 | 24.6049 | 24.6049 | 1.0 |
| 2024-11-05 | AGIX | ETF | 26.23 | 26.58 | 26.23 | 26.45 | 5304.0 |
| 2024-11-05 | AGMI | ETF | 30.616 | 30.616 | 30.29 | 30.33 | 426.0 |
| 2024-11-05 | AGNG | ETF | 32.05 | 32.3199 | 30.84 | 32.19 | 11043.0 |
| 2024-11-05 | AGOX | ETF | 28.092 | 28.25 | 28.03 | 28.17 | 12034.0 |
| 2024-11-05 | AGQ | ETF | 44.19 | 44.44 | 43.51 | 43.7 | 1026122.0 |
> showing 50 of 3,766 rows — these rows as CSV