ErsvanUser and amount $CRUMB rewards in airdrop
    Updated 2022-06-06
    WITH TID (ID) AS(
    SELECT ASSET_ID FROM flipside_prod_db.algorand.asset WHERE CREATOR_ADDRESS = 'GOOSECHXVEKJ4SO43NTW5HXOIGLFGC2SQDAVWQGJCN576ODJ5SECV6MUOM' AND ASSET_DELETED = FALSE
    ),

    TAd (Ad) AS (
    SELECT
    DISTINCT ADDRESS
    FROM
    flipside_prod_db.algorand.account_asset
    JOIN TID ON ASSET_ID = ID
    WHERE AMOUNT != 0
    ),
    TTd (DAY_DATE,ADDRESS,AMOUNT) AS (
    SELECT
    DISTINCT
    DATE_TRUNC('day', block_timestamp) AS DAY_DATE,
    ASSET_RECEIVER,
    ASSET_AMOUNT
    FROM
    flipside_prod_db.algorand.asset_transfer_transaction
    JOIN TAd ON Ad = ASSET_RECEIVER
    WHERE
    ASSET_ID = 751294723
    AND ASSET_AMOUNT != 0
    AND SENDER ='R6HMZIHUFPPFOOKO2ZBFA3M5ZGZ27ON67BOAIPTPQRPICNV75BWDLNFALE'
    )

    SELECT
    ADDRESS,
    SUM(AMOUNT) AS AMOUNT
    FROM
    TTd
    WHERE
    DAYOFWEEK(DAY_DATE) = 1
    GROUP BY ADDRESS
    Run a query to Download Data