(select date_trunc('day', block_timestamp::date) as dates, tx_id ,platform

from ethereum.dex_swaps

where block_timestamp >= '2022-01-01'

and direction = 'IN'

and amount_in > '0'

),

event as

(select date_trunc('day', block_timestamp::date) as date, tx_id as daily, origin_address as N_Wallet

from ethereum.udm_events

where block_timestamp >= '2022-01-01'

select Dex.dates, Dex.platform , count(distinct (event.N_Wallet )) as N_Wallets,count(distinct tx_id) as Daily_Transactions

from dex

join event on dex.tx_id=event.daily

where platform != 'curve'

group by dates , platform

order by dates