date_trunc( 'month' , a.block_timestamp ) as "monthly" ,

count( distinct a.tx_fee ) as "transactions"

avalanche.core.fact_transactions a

where

year( a.block_timestamp ) = 2024 and

a.block_timestamp >= dateadd( 'month' , -6 , current_date )

group by 1

order by 1 desc