rajsFuse Pool DAI Allocation
Updated 2022-05-21
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
›
⌄
SELECT
to_address,
case when to_address = '0x989273ec41274c4227bcb878c2c26fdd3afbe70d' then 'Fuse Pool 6'
when to_address = '0x8e4e0257a4759559b4b1ac087fe8d80c63f20d19' then 'Fuse Pool 18'
when to_address = '0x7322b10db09687fe8889ad8e87f333f95104839f' then 'Fuse Pool 7'
when to_address = '0x3dfd23a6c5e8bbcfc9581d2e864a68feb6a076d3' then 'Aave'
when to_address = '0x5d3a536e4d6dbd6114cc1ead35777bab948e3643' then 'Compound'
end as pool_name,
sum(amount) as amount,
count(tx_id) as no_of_txs
from ethereum.udm_events
where from_address = '0xafd2aade64e6ea690173f6de59fc09f5c9190d74'
and origin_function_signature = '0xd42ec3fe'
-- and to_label_type is null
group by 1
order by 3 desc
Run a query to Download Data