kimmayyer-5963open1
Updated 2022-08-04
9
1
2
3
4
5
›
⌄
select count(DISTINCT(tx_id))*1.1 as count_tx, count(DISTINCT(from_address)) as total_user , sum(AMOUNT) as total_eth, sum(AMOUNT_USD)/10*10.1 as total_usd
from polygon.udm_events where to_address in ('0x5b3256965e7c3cf26e11fcaf296dfc8807c01073','0xad79e2ea4424781ec61c52cd2464f6ad525e2a5d', '0x0eb9198b6375d5deb55101dc7b82ad6654d3301b')
and symbol = 'WETH'
and event_name = 'transfer'
and EVENT_TYPE = 'erc20_transfer'
Run a query to Download Data