select

date_trunc('day', block_timestamp) as day,

count(distinct tx_id) as number_of_transactions,

sum(tx:body:messages[0]:amount[0]:amount/1e6) as transactions_amount

from

terra.core.fact_transactions

group by

day

select

avg(number_of_transactions) as average_number_of_daily_transactions,

sum(number_of_transactions) as total_number_of_transactions,

avg(transactions_amount) as average_daily_transactions_amount,

sum(transactions_amount) as total_transactions_amount

luna_stats