sarathmetamask users 2
Updated 2022-06-25
9
1
2
3
4
5
6
7
8
›
⌄
with data1 as (SELECT distinct origin_from_Address from ethereum.core.ez_dex_swaps where origin_to_Address=lower('0x881D40237659C251811CEC9c364ef91dC08D300C')),
data2 as(
SELECT user_Address,sum(balance) as eth_volume from ethereum.erc20_balances where symbol='ETH' and user_address in (SELECT origin_from_Address from data1 )
GROUP by 1
ORDER by ETH_volume DESC)
SELECT * from data2
LIMIT 1000
Run a query to Download Data