SELECT

trunc(block_timestamp,'hour') as date,

COUNT(DISTINCT tx_id) as transfers,

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

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

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

avg(amount/power(10, 18)) 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='EVMOS' and block_timestamp>='2023-02-13'

GROUP BY 1