count(distinct tx_hash) as tx_cnt,

count(distinct address) as user_cnt

(select date_trunc('quarter',block_timestamp) as datetime,

tx_hash,

from_address as address

from avalanche.core.fact_transactions

union all

select date_trunc('quarter',block_timestamp) as datetime,

tx_hash,

to_address as address

from avalanche.core.fact_transactions)

where datetime >= '2024-01-01'

group by 1