nitsWhich platform has how many users?
Updated 2022-09-06
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
›
⌄
SELECT *, case
when eth_to_address = '0xae7ab96520de3a18e5e111b5eaab095312d7fe84' then 'lido'
when eth_to_address = '0xcbc1065255cbc3ab41a6868c22d1f1c573ab89fd' then 'cream'
when eth_to_address = '0xc874b064f465bdd6411d45734b56fac750cda29a' then 'stakewise'
when eth_to_address = '0x4d05e3d48a938db4b7a9a59a802d5b45011bde58' then 'rocket'
when eth_to_address = '0x00000000219ab540356cbb839cbe05303d7705fa' then 'Direct'
when eth_to_address = '0x84db6ee82b7cf3b47e8f19270abde5718b936670' then 'Ankr' end as contract_name
from
(SELECT eth_to_address, count(DISTINCT eth_from_address) as number_of_users from ethereum.core.ez_eth_transfers
where eth_to_address in ('0xae7ab96520de3a18e5e111b5eaab095312d7fe84',lower('0xC874b064f465bdD6411D45734b56fac750Cda29A'),
lower('0x84db6eE82b7Cf3b47E8F19270abdE5718B936670'),
lower('0x00000000219ab540356cbb839cbe05303d7705fa'),
lower('0x4D05E3d48a938db4b7a9A59A802D5b45011BDe58'),
lower('0xcbc1065255cbc3ab41a6868c22d1f1c573ab89fd')
) GROUP by 1)
Run a query to Download Data