PapasotCOSG yieldly distribution pool staked daily
    Updated 2023-01-03
    SELECT
    date_trunc('day',block_timestamp) as block_day,
    SUM(asset_amount)/1000000 as COSG_staked,
    COUNT(DISTINCT(sender)) as Users
    FROM
    algorand.asset_transfer_transaction
    WHERE
    asset_id = 571576867
    AND
    asset_receiver = 'EHKPJLIA2UAUDIGUF2T2XPKZTIFFO2HW56TZGL62SB3C4Q4IDT7ADW7BO4'
    AND
    block_timestamp > '2022-04-15'
    GROUP BY block_day
    order by block_day
    Run a query to Download Data