label,

project_name

from osmosis.core.dim_labels

where address in ('ibc/8242AD24008032E457D2E12D46588FD39FB54FB29680C6C7663D296B383C37C4', -- USDT

'ibc/9F9B07EF9AD291167CF5700628145DE1DEB777C2CFC7907553B24446515F6D0E', --USDC.grv

'ibc/F292A17CF920E3462C816CBE6B042E779F676CAB59096904C4C1C966413E3DF5', --DAI.grv

'ibc/D189335C6E4A68B513C10AB227BF1C1D38C746766278BA3EEB4FB14124F1D858', --axlUSDC

'ibc/0CD3A0285E1341859B5E86B6AB7682F023D03E97607CCC1DC95706411D866DF7')) --DAI.grv

select date_trunc('week', block_timestamp) as week,

label,

sum(amount / pow(10,decimal)) as volume_transferred,

count(distinct(sender)) as user_count,

count(distinct(tx_id)) as tx_count

from osmosis.core.fact_transfers a

join osmosis.core.dim_labels b on a.address = b.currency

where tx_status = 'SUCCEEDED'

and transfer_type = 'OSMOSIS'

and amount > 0

group by 1,2

order by 1