trunc(block_timestamp:: date,'week') as weekly,

label_type,

count(distinct tx_hash) as txs,

count(distinct from_address) as users

from blast.core.fact_transactions

join blast.core.dim_labels on to_address = address

where status = 'SUCCESS'

and block_timestamp:: date >= '2024-02-29'

group by 1,2

HAVING label_type NOT IN ('chadmin','token')