Wild Tales
Wild Tales
Wild Tales
Toggle theme
Wild Tales
Written by
Wild Tales
Subscribe
Subscribe
A Cohort Retention Query
Cohort tables show us, for a given cohort, the month in which a user interacted with a protocol and the percentage of users who continued to interact in subsequent periods. Take a look on how these tables are built.
Wild Tales
Aug 31
Account Dusting and Poisoning on Solana
Wild Tales
Apr 30
Account dusting and address poisoning are deceptive practices on the Solana blockchain that exploit users through low-value transactions. Dusting floods account addresses with tiny SOL transfers to promote scams or track activity, while address poisoning tricks users into sending funds to malicious account addresses mimicking legitimate ones. This report details our investigation into these tactics, delivering a public dashboard on Dune and an open-source API using Solscan endpoin...
DAOs that do something on Solana
Wild Tales
Apr 14
DAOs, or decentralized autonomous organizations, are a relatively recent development, evolving from Ethereum to other networks. They offer a decentralized alternative to the governance of protocols and organizations. In this case, we will examine the situation on Solana through the Realms platform, which facilitates on-chain management of DAOs through various governance tools, treasury management, and proposal management.Realms appeared in 2022, marking a turning point with a peak in activity...
DAOS.FUN
Wild Tales
Feb 27
DAOS.FUN has a combined market cap of 435 million but manages less than 7 million in assets, showing a big gap between value and actual funds.The platform raised 8.19 million USD across 265 DAOs, using Solana’s Token2022 standard for fundraising, with most of funds going to risky assets like memecoins.Most DAOs performed poorly, with only 31 out of 161 having positive returns, while 40 lost 80-100% of their value, highlighting the high risk and volatility of the platform.OverviewSin...
From Logs to Clarity: Unlocking EVM Event Decoding
Wild Tales
Dec 8
Events are crucial in the Ethereum Virtual Machine (EVM) networks. Interestingly, half of the transactions to smart contracts on Scroll are to non-decoded contracts on Dune. To unlock full data insights, you need to read this article.
The Devcon Experience
Wild Tales
Dec 2
Devcon is Ethereum's most ambitious conference, bringing together developers, researchers, and blockchain industry professionals to share ideas and build the future of the chain. Thanks to Seed's sponsorship and a year of preparation, I was able to attend this life-changing event.
Impact of Gas Subsidies on Uniswap
Wild Tales
Jul 31
Explore the impact of Rabby's gas subsidy campaign on Uniswap across various Layer 2 chains. Discover how transaction costs, user activity, and swap volumes were influenced during this innovative initiative.
Account Dusting and Poisoning on Solana
Wild Tales
Apr 30
Account dusting and address poisoning are deceptive practices on the Solana blockchain that exploit users through low-value transactions. Dusting floods account addresses with tiny SOL transfers to promote scams or track activity, while address poisoning tricks users into sending funds to malicious account addresses mimicking legitimate ones. This report details our investigation into these tactics, delivering a public dashboard on Dune and an open-source API using Solscan endpoin...
DAOs that do something on Solana
Wild Tales
Apr 14
DAOs, or decentralized autonomous organizations, are a relatively recent development, evolving from Ethereum to other networks. They offer a decentralized alternative to the governance of protocols and organizations. In this case, we will examine the situation on Solana through the Realms platform, which facilitates on-chain management of DAOs through various governance tools, treasury management, and proposal management.Realms appeared in 2022, marking a turning point with a peak in activity...
DAOS.FUN
Wild Tales
Feb 27
DAOS.FUN has a combined market cap of 435 million but manages less than 7 million in assets, showing a big gap between value and actual funds.The platform raised 8.19 million USD across 265 DAOs, using Solana’s Token2022 standard for fundraising, with most of funds going to risky assets like memecoins.Most DAOs performed poorly, with only 31 out of 161 having positive returns, while 40 lost 80-100% of their value, highlighting the high risk and volatility of the platform.OverviewSin...
From Logs to Clarity: Unlocking EVM Event Decoding
Wild Tales
Dec 8
Events are crucial in the Ethereum Virtual Machine (EVM) networks. Interestingly, half of the transactions to smart contracts on Scroll are to non-decoded contracts on Dune. To unlock full data insights, you need to read this article.
The Devcon Experience
Wild Tales
Dec 2
Devcon is Ethereum's most ambitious conference, bringing together developers, researchers, and blockchain industry professionals to share ideas and build the future of the chain. Thanks to Seed's sponsorship and a year of preparation, I was able to attend this life-changing event.
Impact of Gas Subsidies on Uniswap
Wild Tales
Jul 31
Explore the impact of Rabby's gas subsidy campaign on Uniswap across various Layer 2 chains. Discover how transaction costs, user activity, and swap volumes were influenced during this innovative initiative.