tx_data as (

select

block_timestamp,

tx_hash,

tx_receiver,

tx_signer,

tx_status

from near.core.fact_transactions

select

date(block_timestamp) as date,

count(distinct tx_hash) as txs,

count( distinct

case when tx_status = 'Success' then tx_hash else null end

) as s_txs,

count( distinct

case when tx_status = 'Success' then null else tx_hash end

) as f_txs,

count(distinct tx_signer) as users,

count( distinct

case when tx_status = 'Success' then tx_signer else null end

) as s_user,

count( distinct

case when tx_status = 'Success' then null else tx_signer end

) as f_user,

count(distinct tx_receiver) as receivers,

count( distinct

case when tx_status = 'Success' then tx_receiver else null end

) as s_receiver,

count( distinct

case when tx_status = 'Success' then null else tx_receiver end