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