mariyaMintings volume
Updated 2022-04-27
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
›
⌄
--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,
(case when ( BLOCK_TIMESTAMP>='2022-03-31' and BLOCK_TIMESTAMP<='2022-04-14 6:00:00') then TX_MESSAGE:dt:itx[0]:txn:aamt/1e6 end) as during_gov_amount,
(case when not( BLOCK_TIMESTAMP>='2022-03-31' and BLOCK_TIMESTAMP<='2022-04-14 6:00:00') then TX_MESSAGE:dt:itx[0]:txn:aamt/1e6 end) as out_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
--TX_MESSAGE:string like '%RXI3PCQNQKI3WJ2XM4ORAJRLXLYYYJFZVCO4F3LIZD56RPPZLGX2UVQ5LU%'
)
SELECT
sum(during_gov_amount) as amount,'in gornance period' as duration
FROM
sndrs
union
SELECT
sum(out_gov_amount) as amount,'out of gornance period' as duration
FROM
sndrs
Run a query to Download Data