SELECT date(block_timestamp) as date,count( DISTINCT sender) as users,count(tx_id) as transactions, sum(amount/1000000) as transfer_volume,avg(amount/1000000) as average_volume

from osmosis.core.fact_transfers

where currency in (

'ibc/D189335C6E4A68B513C10AB227BF1C1D38C746766278BA3EEB4FB14124F1D858',

'ibc/8242AD24008032E457D2E12D46588FD39FB54FB29680C6C7663D296B383C37C4',

'ibc/0CD3A0285E1341859B5E86B6AB7682F023D03E97607CCC1DC95706411D866DF7'

) and date> CURRENT_DATE-30

GROUP by 1

LIMIT 1000