hessWeb3 Area
Updated 2023-04-20
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
›
⌄
with price as ( select recorded_hour::date as date, symbol , avg(price) as avg_price
from osmosis.core.ez_prices
group by 1,2)
,
platform as ( select sender , receiver
from axelar.core.ez_satellite )
,
labels as ( select 'Axelar' as chain,address, label, label_type
from axelar.core.dim_labels
UNION
select 'Osmosis' as chain, label,address, label_type
from osmosis.core.dim_labels
UNION
select 'Terra' as chain,address, label, label_type
from terra.core.dim_address_labels
UNION
select BLOCKCHAIN as chain,address, project_name as label, label_type
from crosschain.core.address_labels)
select label_type, count(DISTINCT sender) as count_user
from platform a join labels b on a.receiver = b.address
where label_type not in ('chadmin','operator')
group by 1
Run a query to Download Data