freemartianTop 5 Pools With Most Withdrawal Activity
Updated 2022-06-14
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
›
⌄
select contract_address as pool_address, count(distinct tx_hash) as activity,
case when pool_address = '0x5d1c5dee420004767d3e2fb7aa7c75aa92c33117' then ' xMILADY'
when pool_address = '0xc088661f2703e5c011612d6a7ff960ee669f8b56' then 'xGOBLIN'
when pool_address = '0x3e7d590b398a8bd7a12fb6071af197bf74248895' then ' xTUBBY'
when pool_address = '0x1b80250c32d5b5e278d03e9843475c56bf0a439e' then ' xWARRIOR'
when pool_address = '0x1ea1ccfecc55938a71c67150c41e7eba0743e94c' then ' xWIZARD'
end as pool_name
from ethereum_core.fact_event_logs
where origin_to_address = '0x3e135c3e981fae3383a5ae0d323860a34cfab893'
and event_inputs:to = '0x0000000000000000000000000000000000000000'
and tx_status = 'SUCCESS'
and event_name is not null
and block_timestamp > CURRENT_DATE - 60
group by pool_address, pool_name
order by activity desc
limit 5
Run a query to Download Data