mamad-5XN3k3Top Sei Dapps 2
Updated 2024-04-17
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
›
⌄
select
--distinct ATTRIBUTE_VALUE,
--distinct ATTRIBUTE_VALUE,
--distinct LABEL,
--LABEL_TYPE,
count(distinct t.TX_FROM) as users,
count(distinct a. TX_ID) as txs
from sei.core.fact_msg_attributes a
join sei.core.fact_transactions t on a.TX_ID = t.TX_ID
left join sei.core.dim_labels on ADDRESS = ATTRIBUTE_VALUE
where a.TX_SUCCEEDED = 'TRUE'
--and a.BLOCK_TIMESTAMP::date >= current_date - 30
and LABEL is not null
--and LABEL_TYPE not in ('token','nft','operator','cex')
and LABEL_TYPE = 'dex'
--group by 1,2
--order by 3 desc
QueryRunArchived: QueryRun has been archived