SELECT

trunc(block_timestamp,'day') as date,

COUNT(DISTINCT tx_id) as transfers,

sum(transfers) over (order by date) as cum_transfers,

sum(amount/power(10, 10)) as amounts,

sum(amounts) over (order by date) as cum_volume,

avg(amount/power(10, 10)) as avg_transfer_amount

FROM osmosis.core.fact_transfers x

join osmosis.core.dim_labels y on x.currency=y.address

WHERE SENDER LIKE 'osmo%'

AND not receiver LIKE 'osmo%' and project_name='DOT.axl'

GROUP BY 1