PapasotGard daily burns
    Updated 2022-04-19
    SELECT
    date_trunc('day',block_timestamp) as block_day,
    SUM(asset_amount)/1000000 as Gard_returns,
    COUNT(DISTINCT(asset_receiver)) as Users
    FROM
    algorand.asset_transfer_transaction
    WHERE
    asset_id = 684649988
    AND
    asset_receiver = 'J2E2XXS4FTW3POVNZIHRIHTFRGOWEWX65NFYIVYIA27HUK63NWT65OLB2Y'
    AND
    block_timestamp > '2022-4-1'
    GROUP BY block_day
    order by block_day
    Run a query to Download Data