date_trunc('day',block_timestamp) as "Date",

count(distinct tx_signer) as Users,

count(distinct tx_hash) as Txs,

count(distinct (case when tx_status = 'Fail' then tx_hash end)) as failedtxs,

TXS/(24*60*60) as "TPS",

Txs/Users as "TPU",

failedtxs/TXS*100 as "% Failed Txs"

from near.core.fact_transactions

where block_timestamp >= '2023-01-01'

and tx_receiver='v1.jumbo_exchange.near'

group by 1