select
distinct date(date_trunc('day',block_timestamp)) as DATE,
case status when 'FALSE' then 'Failed'
when 'TRUE' then 'Successful'
end as transaction_status,
count(TX_HASH) as HARMONY_transactions
from flipside_prod_db.mdao_harmony.txs
WHERE DATE >= date('2020-01-01') and DATE < CURRENT_DATE
group by 1,2