with vault_created_wallets as (
SELECT
pt.receiver as wallet
FROM algorand.application_call_transaction ac
join algorand.payment_transaction pt on pt.tx_group_id = ac.tx_group_id
where date(ac.block_timestamp) >= '2022-03-28'
-- and ac.tx_group_id = '+JaQWvUgft6dgzaCMzjXcAIqPz9dj1qSdFHz7Bn1p+E=' -- sample deposit transaction
and try_base64_decode_string(ac.tx_message:txn:note::string) = 'Market: mt'
and ac.app_id = '465814318'
)
SELECT sum(balance) as total_algo from algorand.account
where address in (SELECT wallet from vault_created_wallets)