Sbhn_NPtop 20 contracts
Updated 2023-01-12
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
›
⌄
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
and block_timestamp > '2022-12-24'
group by 1
)
SELECT*
from t1
order by 3 desc
limit 20
Run a query to Download Data