fayulasmokas
@fayulasmokas
Query transaction volumes with SQL, e.g., SELECT SUM(value) as volume, DATE(block_time) FROM erc20_ethereum.evt_Transfer WHERE contract_address = <token_address> GROUP BY date. Calculate NVT by dividing the token’s market cap (sourced from CoinGecko or CoinMarketCap) by the volume from Dune. Create a dashboard to track NVT trends. For example, a low NVT for a project like Chainlink, paired with growing transaction volume on Dune, suggests undervaluation and strong value. Always validate with fundamental analysis (e.g., project roadmap).
1 reply
0 recast
0 reaction
trittenwaltruda
@trittenwaltruda
☺️
0 reply
0 recast
0 reaction