USER_ADDRESS as address,

max(LAST_ACTIVITY_BLOCK_TIMESTAMP) as cohortDate

FROM ethereum.core.ez_current_balances

where symbol='DYDX' and token_name='dYdX'

and user_address not in (select address from ethereum.core.dim_labels where address_name is not null)

and current_bal is not null and current_bal >0

GROUP BY 1

select

count (distinct user_address) as "Holders"

FROM ethereum.core.ez_current_balances join lastdate on address = user_address and cohortDate = LAST_ACTIVITY_BLOCK_TIMESTAMP

where symbol='DYDX' and token_name='dYdX'

and current_bal is not null and current_bal >0