with ids as
(SELECT asset_id, asset_name
FROM algorand.asset
WHERE asset_name LIKE 'Al Goanna%')
SELECT date(block_timestamp) as day, sum(amount) as total_vol, sum(total_vol) over (ORDER by day) as cumulative_vol
from algorand.payment_transaction
where tx_group_id in ( SELECT tx_group_id
from algorand.transactions
where asset_id in (SELECT asset_id from ids) and tx_type != 'acfg' ) and asset_id = '0'
GROUP by 1
-- LIMIT 100