maybeyonaszk_distinct_wallets_overall
    Updated 2022-06-16
    with
    op_data as (
    select
    block_timestamp,
    tx_hash,
    origin_from_address,
    origin_to_address,
    origin_function_signature,
    amount,
    case
    when origin_function_signature = '0x2d2da806' then 'eth deposit'
    when origin_function_signature = '0xe17376b5' then 'erc20 deposit'
    else 'sus' end as action
    from ethereum.core.ez_eth_transfers
    where origin_to_address = '0xabea9132b05a70803a4e85094fd0e1800777fbef' -- main bridge
    and action != 'sus'
    )

    select
    -- date(block_timestamp) as date,
    -- action,
    count(tx_hash) as txs,
    count(distinct origin_from_address) as users,
    sum(amount) as eth_vol
    from op_data
    where block_timestamp > current_date - interval '60 days'
    -- group by 1,2
    Run a query to Download Data