date_trunc('week', block_timestamp) as week,

sum(amount) as amounts

from osmosis.core.fact_transfers

where TRANSFER_TYPE in ('IBC_TRANSFER_OUT')

GROUP BY week