binhachon3. [Easy] Number of Users of THORChain Bridges by Asset
Updated 2021-10-24
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
›
⌄
--select count (distinct from_address) as number_of_addresses,
-- select date_trunc('Week', block_timestamp) as blocktime, blockchain, pool_name, sum(to_amount_min_usd) as usd_amount from thorchain.swaps
-- group by blocktime, blockchain, pool_name
select blockchain, count(distinct from_address) as number_of_users from (
--------------------Get unique users from swap --------------------------------
select distinct from_address, blockchain from thorchain.swaps
where substr(blockchain,1,3) != substr(pool_name,1,3)
union all
select distinct from_address, case when substr(pool_name,1,3) = 'THO' then 'THOR' else substr(pool_name,1,3) end as blockchain from thorchain.swaps
where substr(blockchain,1,3) != substr(pool_name,1,3)
union all
--------------------Get unique users from upgrades--------------------------------
select distinct from_address, substr(burn_asset,1,3) as blockchain from thorchain.upgrades
union all
select distinct to_address as from_address, 'THOR' as blockchain from thorchain.upgrades
)
group by blockchain
Run a query to Download Data