freemartianTop 10 Popular Pools on Tinyman - 2
    Updated 2022-05-22
    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