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

WHERE SENDER LIKE 'osmo%'

AND not receiver LIKE 'osmo%' and currency='ibc/C5579A9595790017C600DD726276D978B9BF314CF82406CE342720A9C7911A01' and block_timestamp>='2023-02-13'

GROUP BY 1