select

distinct origin_from_address as user_address

from ethereum.core.ez_dex_swaps

where origin_to_address= '0x881d40237659c251811cec9c364ef91dc08d300c'

and origin_function_signature = '0x5f575529'

group by user_address

),

swap as (

select

block_timestamp::date as days,

'Swap' as type,

count(distinct tx_hash) as number_of_swap

from ethereum.core.ez_dex_swaps

where origin_from_address in (select user_address from metamask_wallet_address_list)

group by days, type

),

nft_mints as (

select

block_timestamp::date as days,

'NFT mint' as type,

count(distinct tx_hash) as number_of_nft_mint

from ethereum.core.ez_nft_mints

where nft_to_address in (select user_address from metamask_wallet_address_list)

and event_type = 'nft_mint'

group by days, type

),

nft_buy as (

select

block_timestamp::date as days,

'NFT buy' as type,

count(distinct tx_hash) as number_of_nft_buy

from ethereum.core.ez_nft_sales

where buyer_address in (select user_address from metamask_wallet_address_list)

and event_type = 'sale'

group by days, type