itsxenuxNumber of Metamask wallet holders per day
    Updated 2022-06-24
    with query as (
    select origin_from_address as wallet_address,
    block_timestamp as date_time
    from ethereum.core.ez_token_transfers
    where origin_to_address = '0x881d40237659c251811cec9c364ef91dc08d300c'
    and amount_usd > 0
    group by date_time,wallet_address)

    select count(user_address) as total_wallets,
    query.date_time::date as date_time
    from flipside_prod_db.ethereum.erc20_balances join query
    on flipside_prod_db.ethereum.erc20_balances.user_address = query.wallet_address
    where balance_date = current_date - 1
    and contract_address = 'ETH'
    group by date_time
    Run a query to Download Data