select block_timestamp::date,

tx_id,

tx_from_address,

tx_to_address,

event_inputs:pool,

case event_inputs:pool

when '109' then 'Fuse-6 USDC'

when '108' then 'Fuse-18 USDC'

when '106' then 'Fuse-11 USDC'

when '104' then 'Fuse-15 USDC'

when '103' then 'Fuse-14 USDC'

when '102' then 'Fuse-13 USDC'

when '101' then 'Fuse-7 USDC'

when '100' then 'Fuse-R4 USDC'

when '3' then 'Fuse-mStable'

when '2' then 'AAVE'

when '1' then 'Compound'

else 'you lost money'

end as pool_name,

event_inputs:amount as amount,

event_inputs:action,

event_inputs:currencyCode

from ethereum.events_emitted

where tx_to_address = '0x66f4856f1bbd1eb09e1c8d9d646f5a3a193da569'

and event_name = 'PoolAllocation'

select pool_name,

sum(amount)

from pool

group by 1

-- where tx_id = '0x0da59251949251154ab0e3e8c078cf2ef1a2a28f29e08014142697235ea268ae'