SELECT

count(DISTINCT tx_id) as transcations,

transcations/count(distinct block_timestamp) as tx_per_day,

count(distinct tx_from) as unique_user,

sum(

CASE

when tx_succeeded = true then 1

ELSE 0

END

) AS successful_txs,

sum(

CASE

when tx_succeeded = true then 0

ELSE 1

END

) AS failed_txs,

from

sei.core.fact_transactions

WHERE

block_timestamp >= '2024-01-01'

and block_timestamp < CURRENT_DATE