nitsAI Goanna Payment Transactions
    Updated 2022-05-27
    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