count(distinct tx_hash) as no_of_txns,

sum(tx_fee) as tot_fees_generated,

count(distinct from_address) as no_of_users

from arbitrum.core.fact_transactions

where to_address=lower('0xfc5A1A6EB076a2C7aD06eD22C90d7E710E35ad0a')

and block_timestamp >= dateadd(month, -1, getdate())

and status = 'SUCCESS'

group by day

order by day desc