[CONTRIBUTION] Add DeSyn Protocol TVL models for Ethereum, Arbitrum, BSC，hemi，scroll，plume，linea
Nobody has claimed this yet.
Assessment
- Difficulty
- 4/5
- Estimated time
- 3-5 days
- Newbie friendliness
- 35/100
- Issue type
- Feature
- Clarity
- Mostly clear
- Activity status
- Stale
- Tech stack
- sql
- Domain
- blockchain, data
Research direction
Start by examining existing Spellbook TVL models that use balances_*_erc20_day and factory event topics such as LogNewCrp and LOG_NEW_POOL. Verify the listed factory addresses and chain coverage, then confirm that per-chain DeSyn models and the aggregated desyn_tvl model provide daily TVL for all requested networks.
Written by the indexing model from the issue text.
Description
DeSyn Protocol is a decentralized asset management protocol (Balancer-like pools for portfolios/ETFs), with TVL over $1B (per DefiLlama). Currently no coverage in Spellbook.
Plan:
- Dynamic TVL calculation using factory events (LogNewCrp and LOG_NEW_POOL topics) from provided factories.
- Per-chain models: desyn_ethereum_tvl, desyn_arbitrum_tvl, desyn_bsc_tvl
- Aggregated: desyn_tvl
- Use balances_*_erc20_day for efficient daily TVL.
Factories (official from user/DeSyn docs):
- Ethereum: Factory 0x01a38B39BEddCD6bFEedBA14057E053cBF529cD2, CRPFactory 0xE806Af9E1e73281F420e0996d3F5b9333267Dc13
- Arbitrum: Factory 0xdE6b117384452b21F5a643E56952593B88110e78, CRPFactory 0xf63013e0F946D70C42C7c7AeF8d34BB1BceE3F09
- BSC: Factory 0x770c9d0851b21df8A84943EdE4f487D30d9741ba, CRPFactory 0x5Df07916f622EAE27b68dDE3bE2f85d49C6661fA
- Linea：Factory 0x5C3027D8Cb28A712413553206A094213337E88c5，CRPFactory 0x90Ac490b6d384290618C61E49182b3D3Cc61f86f
- scroll：Factory 0x09eFC8C8F08B810F1F76B0c926D6dCeb37409665 ，CRPFactory 0xe788511225632ffdA2c532d65ede98aF047282e8
- hemi：Factory 0xdE6b117384452b21F5a643E56952593B88110e78，CRPFactory 0xf63013e0F946D70C42C7c7AeF8d34BB1BceE3F09
- plume： Factory 0x770c9d0851b21df8A84943EdE4f487D30d9741ba，CRPFactory 0x5Df07916f622EAE27b68dDE3bE2f85d49C6661fA
This will enable community dashboards and queries for DeSyn.
- Dominant language
- Python
- Stars
- 1.5k
- Forks
- 1.4k
- Avg merge
- 3d 16h
- Merged PRs (30d)
- 22
Contributor guide
First steps
- Read the whole issue, then the project's contributing guide.
- Comment on the issue to say you are picking it up — it saves two people doing the same work.
- Fork the repository and make your change on a branch.
- Open a pull request that references the issue number.
More from duneanalytics/spellbook
-
Difficulty 2/5 1-3 hours Newbie friendliness 65/100
duneanalytics/spellbook#9935 · 1 comment ·
-
Difficulty 4/5 3-5 days Newbie friendliness 35/100
duneanalytics/spellbook#10016 ·
-
bug
Difficulty 4/5 3-5 days Newbie friendliness 42/100
duneanalytics/spellbook#9997 ·
-
Difficulty 4/5 3-5 days Newbie friendliness 55/100
duneanalytics/spellbook#9980 ·
-
bug
Difficulty 5/5 Over a week Newbie friendliness 35/100
duneanalytics/spellbook#9965 ·
All issues in duneanalytics/spellbook
Similar issues
-
Difficulty 2/5 1-3 hours Newbie friendliness 74/100
bancolombia/sentinel#23 ·
-
test md OpenCI
Difficulty 2/5 1-3 hours Newbie friendliness 74/100
-
integration:quickjs org:external priority:backlog topic:code-interpreter topic:middleware type:feature
Difficulty 2/5 1-3 hours Newbie friendliness 74/100
langchain-ai/deepagents#6450 ·
-
bug client
Difficulty 2/5 1-3 hours Newbie friendliness 88/100
-
Difficulty 2/5 1-3 hours Newbie friendliness 74/100