dex_address as (

select distinct address,

label

from algorand.labels

where label_type = 'dex' and label not like '%group%'

),

dex_swap as (

select

block_timestamp,

tx_id,

sender,

receiver,

amount,

x.receiver as address,

label as dex

from algorand.payment_transaction x join dex_address y on x.receiver=y.address

where block_timestamp >='2022-05-01' and block_timestamp <'2022-06-30'

select

trunc(block_timestamp,'day') as date,

case when date>='2022-05-01' and date <'2022-05-30' then 'May transaction'

else 'June_transaction' end as "May Vs June Transaction",

count (distinct dex_transfers.address) as unique_wallet,

count(tx_id) as transactions,

sum(amount) as volume

from dex_transfers join dex_address on dex_transfers.address= dex_address.address

group by 1

order by 1 asc