headitmanagerTotal Swaps of Humble Swap
    Updated 2022-06-23
    with Humble_groupid as (
    select tx_group_id
    from algorand.application_call_transaction
    where
    base64_decode_string(tx_message:txn:note::String)='Reach 0.1.10'
    and tx_message:txn:apaa[1]::String = 'Aw=='
    )
    ,Humble_totalswaps as (
    select count(distinct algorand.application_call_transaction.tx_group_id) as swap_count
    from algorand.application_call_transaction
    inner join Humble_groupid
    on Humble_groupid.tx_group_id=algorand.application_call_transaction.tx_group_id)
    ,Humble_swaps_overtime as (
    select count(distinct algorand.application_call_transaction.tx_group_id) as swap_count,block_timestamp::date as swap_date
    from algorand.application_call_transaction
    inner join Humble_groupid
    on Humble_groupid.tx_group_id=algorand.application_call_transaction.tx_group_id
    group by swap_date)

    ,Humble_wallets as (
    select count(distinct sender) as wallet , block_timestamp::date as swap_date from algorand.transactions
    inner join Humble_groupid
    on Humble_groupid.tx_group_id=algorand.transactions.tx_group_id
    group by swap_date)

    ,Humble_asset1 as (select algorand.asset.asset_id as asi,algorand.asset.asset_name as asn,algorand.transfers.tx_group_id as gi from algorand.transfers
    inner join Humble_groupid
    on Humble_groupid.tx_group_id=algorand.transfers.tx_group_id
    inner join algorand.asset
    on algorand.asset.asset_id=algorand.transfers.asset_id
    where INNER_TX=0)

    ,Humble_asset2 as (select algorand.asset.asset_id as asi,algorand.asset.asset_name as asn,algorand.transfers.tx_group_id as gi from algorand.transfers
    inner join Humble_groupid
    Run a query to Download Data