count(DISTINCT BLOCK_TIMESTAMP::date) as days_activity

,count(DISTINCT tx_id) as tx_count

,count(DISTINCT tx:body:messages[0]:from_address) as senders

,count(DISTINCT tx:body:messages[0]:to_address) as receivers

,sum(fee) as fee_volume

,avg(fee) as avg_fee_volume

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

from terra.core.fact_transactions

where FEE_DENOM='uluna'

and TX_SUCCEEDED=true