BLOCK_TIMESTAMP::date as date

,sum(fee) as fee_volume

,avg(fee) as avg_fee_volume

,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(tx:body:messages[0]:amount[0]:amount)/1e6 as luna_volume

,sum(luna_volume) over(order by date) as growth_luna_volume

,sum(tx_count) over(order by date) as growth_tx_count

,sum(senders) over(order by date) as growth_senders

,sum(receivers) over(order by date) as growth_receivers

from terra.core.fact_transactions

where FEE_DENOM='uluna'

and TX_SUCCEEDED=true

group by 1