select block_timestamp::date as fecha,

tx_id,

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

from ethereum.events_emitted

where tx_to_address = '0x66f4856f1bbd1eb09e1c8d9d646f5a3a193da569'

and tx_from_address = '0x1e87ebbe2e02037dd4697d443c5507ff97959c99'

and event_name = 'PoolAllocation'

),

TRANSFERS as (

select block_timestamp::date as fecha,

tx_id,

event_inputs:to as event_to,

event_inputs:from as event_from,

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

contract_name as currency,

contract_address

from ethereum.events_emitted

where tx_to_address = '0x66f4856f1bbd1eb09e1c8d9d646f5a3a193da569'

and tx_from_address = '0x1e87ebbe2e02037dd4697d443c5507ff97959c99'

and event_name = 'Transfer'