date(block_timestamp) as date,

count(tx_hash) as transactions,

count(distinct from_address) as addresses

from

bsc.core.fact_transactions

where date >= current_date - interval '{{Days}} days'

group by 1

order by 1 desc