Total unique users

Abbas_ra21Total unique users

Updated 2022-09-03

with users AS (select distinct DEPOSITOR AS user from ethereum.maker.ez_deposits

union ALL

select distinct ORIGIN_FROM_ADDRESS AS user from ethereum.maker.ez_delegations

union ALL

select distinct VOTER AS user from ethereum.maker.ez_governance_votes

union ALL

select distinct BORROWER AS user from ethereum.maker.ez_flash_loans

union ALL

select distinct LIQUIDATED_WALLET AS user from ethereum.maker.ez_liquidations

union ALL

select distinct PAYER AS user from ethereum.maker.ez_repayments

union ALL

select distinct CREATOR AS user from ethereum.maker.ez_vault_creation

union ALL

select distinct WITHDRAWER AS user from ethereum.maker.ez_withdrawals)

select count(distinct user) AS users from users

Run a query to Download Data

flipside