headitmanagerTotal Swaps of Humble Swap
Updated 2022-06-23
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
34
35
36
›
⌄
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