headitmanagerTotal users who have used MIRROR
Updated 2022-03-07
99
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='terra1wh39swv7nq36pnefnupttm2nr96kz7jjddyt2x' then 'Governance'
WHEN msg_value:contract='terra1mzj9nsxx0lxlaxnekleqdy8xnyw2qrh3uz6h8p' then 'Factory'
WHEN msg_value:contract='terra1t6xe0txzywdg85n6k8c960cuwgh6l8esw6lau9' then 'Oracle'
WHEN msg_value:contract='terra1wfz7h3aqf4cjmjcvc6s8lxdhh7k30nkczyf0mj' then 'Mint'
WHEN msg_value:contract='terra17f7zu97865jmknk7p2glqvxzhduk78772ezac5' then 'Staking'
WHEN msg_value:contract='terra1s4fllut0e6vw0k3fxsg4fs6fm2ad6hn0prqp3s' then 'Collector'
WHEN msg_value:contract='terra1x35fvy3sy47drd3qs288sm47fjzjnksuwpyl9k' then 'Community'
WHEN msg_value:contract='terra1kalp2knjm4cs3f59ukr4hdhuuncp648eqrgshw' then 'Airdrop'
WHEN msg_value:contract='terra1zpr8tq3ts96mthcdkukmqq4y9lhw0ycevsnw89' then 'Limit Order'
WHEN msg_value:contract='terra1pmlh0j5gpzh2wsmyd3cuk39cgh2gfwk6h5wy9j' then 'Collateral Oracle'
WHEN msg_value:contract='terra16mlzdwqq5qs6a23250lq0fftke8v80sapc5kye' then 'Short Reward'
WHEN msg_value:contract='terra1mwshjfdth2xtpx7gvnwpzhks2clr9z7h9m0e0f' then 'Band Oracle'
end
) as projects
from terra.msgs
where
(
msg_value:contract in
Run a query to Download Data