KaskoazulPlanetwatch Daily rewards
    Updated 2022-01-29
    SELECT
    DATE_TRUNC('DAY', block_timestamp) as DATE,
    COUNT(asset_receiver) as Number_receiving_addresses,
    COUNT(tx_id) as Number_rewards

    FROM
    algorand.asset_transfer_transaction

    WHERE
    sender = 'ZW3ISEHZUHPO7OZGMKLKIIMKVICOUDRCERI454I3DB2BH52HGLSO67W754'
    AND asset_id = '27165954'
    AND asset_amount > 0

    GROUP BY 1
    ORDER BY 1
    Run a query to Download Data