SELECT

event_inputs:pool::number as pool_no,

sum(event_inputs:amount)/pow(10,18) as amount,

case

WHEN pool_no = 100 THEN 'Fuse-6'

WHEN pool_no = 102 THEN 'Fuse-18'

WHEN pool_no = 101 THEN 'Fuse-7'

-- WHEN pool_no = 1 THEN 'Compound'

-- WHEN pool_no = 2 THEN 'Aave Interest bearing'

end

as pool_name,

'dai' as type

FROM flipside_prod_db.ethereum_core.fact_event_logs

WHERE lower(ORIGIN_TO_ADDRESS) = '0xafd2aade64e6ea690173f6de59fc09f5c9190d74'

and ORIGIN_FUNCTION_SIGNATURE = '0xd42ec3fe'

AND event_name = 'PoolAllocation'

AND pool_no >= 100 -- exclude aave, compound

AND TX_STATUS = 'SUCCESS'

group by pool_no

ORDER by amount DESC

),

usdc_alloc as (

SELECT

event_inputs:pool::number as pool_no,

sum(event_inputs:amount)/pow(10,6) as amount,

case

WHEN pool_no = 109 THEN 'Fuse-6'

WHEN pool_no = 101 THEN 'Fuse-7'

WHEN pool_no = 108 THEN 'Fuse-18'

-- 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'