Zanyar_98Colum
Updated 2022-06-25
9
1
2
3
4
5
6
7
8
›
⌄
WITH Metamask_wallet_holders AS(SELECT BLOCK_TIMESTAMP::DATE AS DAYS, COUNT((ORIGIN_FROM_ADDRESS)) AS Holders
FROM ethereum.core.ez_dex_swaps
WHERE ORIGIN_TO_ADDRESS= LOWER('0x881D40237659C251811CEC9c364ef91dC08D300C')
GROUP BY DAYS
ORDER BY DAYS
)
SELECT DAYS, Holders, SUM(Holders) OVER (ORDER BY DAYS ASC) Comulative_Holders FROM Metamask_wallet_holders
Run a query to Download Data