headitmanagerTotal users who have used TERRASWAP
Updated 2022-03-07
999
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
›
⌄
with tbl1 as
(
select distinct tx_from[0] as all_address from terra.transactions where
date(block_timestamp) <= DATEADD(DAY, -90, CURRENT_DATE) and tx_from[0] is not null
)
,tbl2 as
(
select distinct tx_from[0] as new_address from terra.transactions where
date(block_timestamp) > DATEADD(DAY, -90, CURRENT_DATE) and tx_from[0] is not null
)
,tbl3 as
(select new_address from tbl2 left join tbl1 on tbl2.new_address=tbl1.all_address where all_address is null
)
select count(distinct msg_value:sender) as users ,
(
case
WHEN msg_value:contract='terra1pn20mcwnmeyxf68vpt3cyel3n57qm9mp289jta' then 'LOTA-UST Pair'
WHEN msg_value:contract='terra1vayuttjw6z4hk5r734z9qatgs8vp6r5a2t043p' then 'LUNI-UST Pair'
WHEN msg_value:contract='terra1xj2w7w8mx6m2nueczgsxy2gnmujwejjeu2xf78' then 'APOLLO-UST Pair'
WHEN msg_value:contract='terra1llhpkqd5enjfflt27u3jx0jcp5pdn6s9lfadx3' then 'LUNAX-UST PAIR'
WHEN msg_value:contract='terra1zrzy688j8g6446jzd88vzjzqtywh6xavww92hy' then 'LUNAX-Luna Pair'
WHEN msg_value:contract='terra1zz39wfyyqt4tjz7dz6p7s9c8pwmcw2xzde3xl8' then 'DPH-UST PAIR'
WHEN msg_value:contract='terra1e59utusv5rspqsu8t37h5w887d9rdykljedxw0' then 'VKR-UST Pair'
WHEN msg_value:contract='terra1z6tp0ruxvynsx5r9mmcc2wcezz9ey9pmrw5r8g' then 'ORION-UST PAIR'
WHEN msg_value:contract='terra1fmv3g96s4xc9nrnlkdn87vxyaydd22xsxzel5r' then 'SDOLLAR-UST PAIR'
WHEN msg_value:contract='terra1stdzf28wlq7llzfecse366r657rtdh6wtrdfk2' then 'tSHIBA-UST Pair'
WHEN msg_value:contract='terra1ykfz4hrq8en2f098j8a4ppaq8u8hangpw9tnqu' then 'BTL-UST Pair'
WHEN msg_value:contract='terra1v4kpj65uq63m4x0mqzntzm27ecpactt42nyp5c' then 'WHALE-UST Pair'
WHEN msg_value:contract='terra1x8h5gan6vey5cz2xfyst74mtqsj7746fqj2hze' then 'LUNAX-bLUNA Pair'
WHEN msg_value:contract='terra1de8xa55xm83s3ke0s20fc5pxy7p3cpndmmm7zk' then 'stLUNA-LUNA Pair'
WHEN msg_value:contract='terra1jzqlw8mfau9ewr7lufqkrpgfzk4legz9zx306p' then 'TLAND-UST Pair'
WHEN msg_value:contract='terra1z50zu7j39s2dls8k9xqyxc89305up0w7f7ec3n' then 'aUST-UST Pair'
WHEN msg_value:contract='terra1pufczag48fwqhsmekfullmyu02f93flvfc9a25' then 'ASTRO-UST Pair'
WHEN msg_value:contract='terra1ycp5lnn0qu4sq4wq7k63zax9f05852xt9nu3yc' then 'ATLO-UST Pair'
WHEN msg_value:contract='terra1p44kn7l233p7gcj0v3mzury8k7cwf4zt6gsxs5' then 'GLOW-UST Pair'
Run a query to Download Data