SELECT *

from Arbitrum.core.fact_event_logs

inner join Arbitrum.core.dim_labels b

on contract_address = address

where label_type = 'dex'

and BLOCK_TIMESTAMP >= CURRENT_DATE - {{period}}

)

select

BLOCK_TIMESTAMP:: date as day,

project_name,

count(DISTINCT tx_hash) as total_transactions,

count (distinct origin_from_address) as users

from tab1

group by 1 , 2