where origin_to_address=lower('0x881D40237659C251811CEC9c364ef91dC08D300C'))

, top20 as (select top 20 count(1),event_name from ethereum.core.fact_event_logs where origin_from_address in(select origin_from_address from metamask) and event_name<>''

group by event_name order by 1 desc)

, events_yealy as (select count(1),event_name,year(block_timestamp) from ethereum.core.fact_event_logs inner join metamask

on metamask.origin_from_address=ethereum.core.fact_event_logs.origin_from_address

where event_name in (select event_name from top20) group by event_name,year(block_timestamp) order by 2,3 desc)

, events_in2022 as (select count(1),event_name,block_timestamp::date from ethereum.core.fact_event_logs inner join metamask

on metamask.origin_from_address=ethereum.core.fact_event_logs.origin_from_address where event_name in (select event_name from top20) and block_timestamp::date>='2022-01-01'

group by event_name,block_timestamp::date order by 2 desc)

, swap_platform_yearly as ( select count(1), platform ,year(block_timestamp) from ethereum.core.ez_dex_swaps

inner join metamask on metamask.origin_from_address=ethereum.core.ez_dex_swaps.origin_from_address

group by platform ,year(block_timestamp))

, swap_platform_in2022 as (select count(1), platform ,block_timestamp::date from ethereum.core.ez_dex_swaps

inner join metamask on metamask.origin_from_address=ethereum.core.ez_dex_swaps.origin_from_address

where block_timestamp::date>='2022-01-01'

group by platform ,block_timestamp::date)

select * from swap_platform_yearly