select distinct tx_id, *

from terra.msgs

where msg_module = 'wasm'

and msg_value:contract = 'terra1sepfj7s0aeg5967uxnfk4thzlerrsktkpelm5s'

),

deposit as (

select msg_value:execute_msg::string as deposit,

sum(msg_value:coins[0]:amount/1e6) as amount_dep,

msg_value:sender::string as sender

from all_tx

where msg_value:coins[0]:denom = 'uusd'

and deposit like '%deposit%'

and tx_status != 'FAILED' and msg_value:sender::string in ('terra1fex9f78reuwhfsnc8sun6mz8rl9zwqh03fhwf3','terra1pzgqghunpfyv5n4ckqud3t9aq2teqcldect35j', 'terra1zw0kfxrxgrs5l087mjm79hcmj3y8z6tljuhpmc',

'terra12dg3r8fu5cqxe0p84eupnwtw8ajzgyj9vqyjmr','terra13x7p0nj4j8qq2hczhtpyzedzshejwn7r5jt0jx','terra1x04xgtwlw72gtfzrq7nfwmr6eexla8ecljw28z','terra1p6kg27mkcul2rxm5z33jufk3ewht7m00xefx7d',

'terra1k8542s5ke56dth7zk4at3vq4aqsst49flfm0wk','terra1cjsf3lf8ryyj7jrraythrjkzy6y27graqvw8x9','terra17wuw5vpa8nnerz6tn6v03wk2g493ygg9rzfvuw')

group by 1,3

)

select *

from deposit