date_trunc('day', BLOCK_TIMESTAMP)::date AS DAY,

iff(BLOCK_TIMESTAMP::date >= '2023-01-14', 'After Announce', ' Before Announce') as type ,

count(TX_ID) AS txns,

count(distinct SENDER) AS act_users,

txns/act_users as txs_per_user

from terra.core.ez_transfers t , terra.core.dim_address_labels l

where

RECEIVER = address

and TX_SUCCEEDED='TRUE'

and BLOCK_TIMESTAMP::date ilike '2023%'

and LABEL_TYPE = 'dex'

group by 1,2