shadilGard.Money Algorand’s First Algorithmic Stablecoin
Updated 2022-04-18
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
›
⌄
SELECT
date(ac.BLOCK_TIMESTAMP) as date,
sum(mi.tx_message:txn:aamt::float/1e6) as mint_amount,
sum(pt.amount) as fee,
count(DISTINCT ac.sender) as wallets
from algorand.transactions ac, algorand.transactions mi
join algorand.payment_transaction pt on mi.tx_group_id = pt.tx_group_id and pt.receiver = 'MTMJ5ADRK3CFG3HGUI7FS4Y55WGCUO5CRUMVNBZ7FW5IIG6T3IU2VJHUMM'
where ac.BLOCK_TIMESTAMP::date >= '2022-03-31'
and ac.tx_group_id = mi.tx_group_id
and mi.tx_type_name = 'asset transfer'
and mi.asset_id = '684649988' -- GARD
-- and ac.tx_group_id = 'zNQKdnCbtFJwrIrWPGQxCH4rtBAtEqA5m2vm/Mi119Y='
and TRY_BASE64_DECODE_STRING(ac.tx_message:txn:apaa[0]::STRING) = 'NewPosition'
and ac.tx_message:txn:apid::string = '684650147'
-- and sender = 'J2E2XXS4FTW3POVNZIHRIHTFRGOWEWX65NFYIVYIA27HUK63NWT65OLB2Y'
-- and asset_id = '684649988' --'GARD'
GROUP BY date
Run a query to Download Data