-- DATE_TRUNC('{{Time_Interval}}',BLOCK_TIMESTAMP) AS DATE

LABEL_TYPE

,COUNT(*) AS "# Txs"

,COUNT(DISTINCT FROM_ADDRESS) AS "Active users"

FROM sei.core_evm.fact_transactions

JOIN crosschain.core.dim_labels

on from_address = address or to_address = address

WHERE LABEL_TYPE != 'chadmin'

GROUP by 1

ORDER by 2 DESC