--The Governance Commitment Period Started March 31st 2022 12:00:00 GMT and Ended April 14th 6:00:00 GMT(For Folks Finance Liquid Staking)
--gALGO3 asset ID = 694432641
with sndrs as (
SELECT
sender,
TX_MESSAGE:dt:itx[0]:txn:xaid as asst,
TX_MESSAGE:dt:itx,
TX_MESSAGE:dt:itx[0]:txn:aamt/1e6 as during_gov_amount,
BLOCK_TIMESTAMP
FROM
algorand.application_call_transaction
WHERE
TRY_BASE64_DECODE_STRING(tx_message:txn:apaa[0]::STRING) = 'm'
AND
asst=694432641
AND
BLOCK_TIMESTAMP>='2022-03-31' and BLOCK_TIMESTAMP<='2022-04-14 6:00:00'
--AND
--TX_MESSAGE:string like '%RXI3PCQNQKI3WJ2XM4ORAJRLXLYYYJFZVCO4F3LIZD56RPPZLGX2UVQ5LU%'
)
SELECT
date_trunc(day,BLOCK_TIMESTAMP),sum(during_gov_amount)
FROM
sndrs
group BY
date_trunc(day,BLOCK_TIMESTAMP)