headitmanagerTotal users who have used each projects
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='terra1mtwph2juhj0rvjz7dy92gvl6xvukaxu8rfv8ts' then 'Anchor - bLuna Hub'
WHEN msg_value:contract='terra17yap3mhph35pcwvhza38c2lkj7gzywzy05h7l0' then 'Anchor - bLuna Reward'
WHEN msg_value:contract='terra199t7hg7w5vymehhg834r6799pju2q3a0ya7ae9' then 'Anchor - bLuna Airdrop Registry'
WHEN msg_value:contract='terra1tmnqgvg567ypvsvk6rwsga3srp7e3lg6u0elp8' then 'Anchor - Overseer'
WHEN msg_value:contract='terra1sepfj7s0aeg5967uxnfk4thzlerrsktkpelm5s' then 'Anchor - Market'
WHEN msg_value:contract='terra1ptjp2vfjrwh0j0faj9r6katm640kgjxnwwq9kn' then 'Anchor - bLuna Custody'
WHEN msg_value:contract='terra1kq8zzq5hufas9t0kjsjc62t2kucfnx8txf547n' then 'Anchor - Interest Model'
WHEN msg_value:contract='terra14mufqpr5mevdfn92p4jchpkxp7xr46uyknqjwq' then 'Anchor - Distribution Model'
WHEN msg_value:contract='terra1cgg6yef7qcdm070qftghfulaxmllgmvk77nc7t' then 'Anchor - Price Oracle'
WHEN msg_value:contract='terra1w9ky73v4g7v98zzdqpqgf3kjmusnx4d4mvnac6' then 'Anchor - Liquidation (Legacy)'
WHEN msg_value:contract='terra1f32xyep306hhcxxxf7mlyh0ucggc00rm2s9da5' then 'Anchor - Governance'
WHEN msg_value:contract='terra1897an2xux840p9lrh6py3ryankc6mspw49xse3' then 'Anchor - LP Staking'
WHEN msg_value:contract='terra12wk8dey0kffwp27l5ucfumczlsc9aned8rqueg' then 'Anchor - Community Fund'
WHEN msg_value:contract='terra14ku9pgw5ld90dexlyju02u4rn6frheexr5f96h' then 'Anchor - Fee Collector'
WHEN msg_value:contract='terra1mxf7d5updqxfgvchd7lv6575ehhm8qfdttuqzz' then 'Anchor - Reward Distributor'
WHEN msg_value:contract='terra146ahqn6d3qgdvmj8cj96hh03dzmeedhsf0kxqm' then 'Anchor - Airdrop'
WHEN msg_value:contract='terra1939tzfn4hn960ychpcsjshu8jds3zdwlp8jed9' then 'Anchor - bETH Reward'
WHEN msg_value:contract='terra10cxuzggyvvv44magvrh3thpdnk9cmlgk93gmx2' then 'Anchor - bETH Custody'
WHEN msg_value:contract='terra1e25zllgag7j9xsun3me4stnye2pcg66234je3u' then 'Anchor - Liquidation Queue'
Run a query to Download Data