barbodDaily number of gALGO3 receiver in mentioned period
    Updated 2022-04-26
    WITH application_call AS(
    SELECT T1.*,
    TRY_BASE64_DECODE_STRING(tx_message:txn:apaa[0]::STRING) AS appa
    FROM algorand.application_call_transaction T1
    WHERE TRY_BASE64_DECODE_STRING(tx_message:txn:apaa[0]::STRING) ='m'
    ),
    asset_transfer AS(
    SELECT T1.*, (asset_amount / pow(10,6)) AS p_asset_amount
    FROM algorand.asset_transfer_transaction T1
    WHERE INNER_TX = 'true'
    ),
    governance_opportunity AS (
    SELECT t1.*, T2.SENDER as transfer_sender, T2.BLOCK_TIMESTAMP as transfer_date, T2.p_asset_amount
    FROM application_call T1
    JOIN asset_transfer T2 on T2.tx_id = T1.tx_id
    WHERE T1.BLOCK_TIMESTAMP >= '2022-03-30 12:00:00.000'
    AND T1.BLOCK_TIMESTAMP <= '2022-04-14 06:00:00.000'
    )
    SELECT date(transfer_date) as date, sum(p_asset_amount) as total_amount
    FROM governance_opportunity
    GROUP BY transfer_date
    Run a query to Download Data