ErsvanMona Lisa- Lil Pump ft Soulja Boy MFT - General
    Updated 2022-05-26
    WITH w_amount_transfer (address,action_name,NUM_ACTION,AMOUNT_TOTAL) AS
    (
    SELECT
    algorand.asset_transfer_transaction.sender AS address, 'SEND' AS action_name,COUNT(*) AS NUM_ACTION, SUM(ASSET_AMOUNT) AS AMOUNT_TOTAL_ACTION
    FROM
    algorand.asset_transfer_transaction
    WHERE
    ASSET_ID = 725937713
    AND ASSET_AMOUNT != 0
    GROUP BY algorand.asset_transfer_transaction.sender
    UNION ALL
    SELECT
    algorand.asset_transfer_transaction.asset_receiver AS address, 'RECEIVER' AS action_name, COUNT(*) AS NUM_ACTION, SUM(ASSET_AMOUNT) AS AMOUNT_TOTAL
    FROM
    algorand.asset_transfer_transaction
    WHERE
    ASSET_ID = 725937713
    AND ASSET_AMOUNT != 0
    GROUP BY algorand.asset_transfer_transaction.asset_receiver
    )

    SELECT * FROM w_amount_transfer
    /*
    SELECT
    *
    FROM
    algorand.account_asset
    WHERE
    address = 'ISSY3W2SLS3S5NHLUH3G77PH6SCBQ5ZTZ22ZCIPXGB26ESHYP32MELSMU4'
    */
    Run a query to Download Data