KaskoazulPlanetwatch rewards Top 10
    Updated 2022-01-29
    -- Algorand Bounty - Planetwatch Rewards

    --PlanetWatch is an environmental monitoring company that pays users in Planets to carry air quality sensors
    -- How many wallets have been rewarded for participating in the PlanetWatch Air monitoring program?
    -- Show us how the number of wallets being rewarded daily changes over time.
    -- Show us how the number of daily rewards has changed over time
    -- What day were the most rewards issued? Was there an event correlated with this?
    -- Who are the top 10 earners of Planets?
    --Rewards Wallet Address: ZW3ISEHZUHPO7OZGMKLKIIMKVICOUDRCERI454I3DB2BH52HGLSO67W754
    --Asset ID: 27165954

    SELECT
    --block_timestamp,
    --asset_id,
    asset_receiver,
    --sender,
    --tx_id,
    --asset_amount,
    sum(asset_amount)
    FROM
    algorand.asset_transfer_transaction
    WHERE
    sender = 'ZW3ISEHZUHPO7OZGMKLKIIMKVICOUDRCERI454I3DB2BH52HGLSO67W754'
    AND asset_id = '27165954'
    AND asset_amount > 0
    --AND block_timestamp > current_date - 90

    GROUP by 1
    ORDER by 2 desc

    LIMIT 10
    Run a query to Download Data