freemartianTop 10 Popular Pools on Tinyman - 2
Updated 2022-05-22
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
›
⌄
select sum(asset_amount)*1e-6 as stake_amount, att.asset_receiver, address_name,
(CASE
when asset_id = '386192725' then 'goBTC'
when asset_id = '386195940' then 'goETH'
else 'others' end) as asset
from flipside_prod_db.algorand.asset_transfer_transaction att
inner join flipside_prod_db.algorand.application_call_transaction act on act.tx_group_id = att.tx_group_id
inner join flipside_prod_db.algorand.labels al on al.address = att.asset_receiver
where TRY_BASE64_DECODE_STRING(act.tx_message:txn:apaa[0]::STRING) = 'mint'
and app_id = '552635992'
and asset != 'others'
and att.block_timestamp > '2022-01-01'
group by asset, att.asset_receiver, address_name
order by stake_amount DESC
limit 10
Run a query to Download Data