date_trunc(day,block_timestamp) as timeperiod

,count(DISTINCT (tx_hash))

,CASE

WHEN STATUS = 'SUCCESS'

THEN 'successful transactions'

ELSE 'failed transactions'

END AS STATUS

FROM bsc.core.fact_transactions

WHERE block_timestamp >= CURRENT_DATE - 7

GROUP BY 1,3

order by 1 desc