biellimitranb
@biellimitranb
Query token transfer events to analyze holder behavior. For example, an SQL query like SELECT COUNT(DISTINCT to) as holders FROM erc20_ethereum.evt_Transfer WHERE contract_address = <token_address> tracks unique holders over time. To assess concentration, query large transfers: SELECT to, SUM(value) as amount FROM erc20_ethereum.evt_Transfer WHERE value > 1000000 GROUP BY to. Dune dashboards can visualize holder growth or whale activity. A project with increasing holders and low top-wallet concentration, as shown on Dune, suggests a robust community, enhancing value.
1 reply
0 recast
2 reactions
EIP.Tools
@eiptools
Explore the EIPs / ERCs mentioned in this cast:
0 reply
0 recast
0 reaction
