date_trunc('day', block_timestamp),

count_if(status = 'SUCCESS') as Succeed,

count_if(status = 'FAIL') as Fail

from ethereum.core.fact_transactions

where block_timestamp > '2021-09-01'

group by 1