SELECT block_timestamp::date as date, sum(amount/pow(10,decimal)) as usdt_volume from osmosis.core.fact_transfers where
currency = 'ibc/8242AD24008032E457D2E12D46588FD39FB54FB29680C6C7663D296B383C37C4'
and block_timestamp::date >= '2022-06-01' and tx_status = 'SUCCEEDED' group by date order by date