shadilFuse Pool USDC Allocation
Updated 2022-05-20
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
›
⌄
SELECT
event_inputs:pool::number as pool_no,
sum(event_inputs:amount)/pow(10,6) as USDC_amount,
case
WHEN pool_no = 109 THEN 'Fuse-6'
WHEN pool_no = 101 THEN 'Fuse-7 Tetranode node'
WHEN pool_no = 108 THEN 'Fuse-18 Olympus Pool Party'
-- WHEN pool_no = 1 THEN 'Compound'
-- WHEN pool_no = 2 THEN 'Aave Interest bearing'
WHEN pool_no = 100 THEN 'Fuse R4'
WHEN pool_no = 106 THEN 'Fuse-11 PoolTogether Deposit Tokens'
WHEN pool_no = 104 THEN 'Fuse-15 Cartesian'
WHEN pool_no = 103 THEN 'Fuse-14 WOO'
WHEN pool_no = 102 THEN 'Fuse-13 Yearn"s Yield'
end
as pool_name
FROM ethereum.events_emitted
WHERE lower(contract_address) = lower('0x66f4856f1bbd1eb09e1c8d9d646f5a3a193da569')
AND tx_succeeded = 'TRUE'
AND tx_to_label_subtype = 'pool'
AND event_name = 'PoolAllocation'
AND event_inputs:pool::number >= 100 -- exclude mUSD, aave, compound
group by pool_no
ORDER by USDC_amount DESC