select

date_trunc('day', block_timestamp) as date,

count(distinct tx_id) as no_txn,

(

sum(

iff(tx_succeeded = TRUE, 1, 0)

) / no_txn

) * 100 as success_rate,

sum(FEE) as paid_fee,

avg(FEE) as avg_fee,

-------------------------------

count(DISTINCT TX_SENDER) as senders,

sum(senders) over (

order by

date

) as cum_senders ,

count(

DISTINCT TX : body : messages[0] : to_address

) as receivers,

sum(

TX : body : messages[0] : amount[0] : amount

)/ pow(10, 6) as LUNA_volume,

no_txn /(7 * 24 * 60 * 60) as TPS

-----------------------------------

from

terra.core.fact_transactions

where

tx : body : messages[0] : amount[0] : denom = 'uluna'

and

GROUP by

1