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

LABEL_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 between '2023-01-01' and CURRENT_DATE - 5

group by 1,2