Sbhn_NPtop 20 contracts resol
Updated 2023-01-21
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
›
⌄
with t1 as (
select
case when PROJECT_NAME ilike '%astro%' then 'Astroport' else PROJECT_NAME end as projects,
min(block_timestamp) as deploy_day,
count(distinct tx_id) as transactions,
count(distinct tx_sender) as users
from terra.core.dim_address_labels
join terra.core.fact_transactions
on address=tx:body:messages[0]:contract
where tx_succeeded= TRUE
group by 1
)
SELECT*
from t1
order by 3 desc
limit 20
Run a query to Download Data