Pmisha-bmlMdxbento2.2.polygon
    Updated 2022-05-18
    with t1 as (select
    FROM_ADDRESS as u1,
    symbol as token
    from ethereum_core.ez_token_transfers
    where TO_ADDRESS= '0xf5bce5077908a1b7370b9ae04adc565ebd643966'
    and BLOCK_TIMESTAMP>= '2022-01-01'
    and TOKEN_PRICE between 0.99 and 1.01
    ),

    t2 as (select
    'Only Stablecoins depositor' as x1,
    count(distinct FROM_ADDRESS) as users
    from polygon.udm_events
    where TO_ADDRESS= '0x0319000133d3ada02600f0875d2cf03d442c3367'
    and BLOCK_TIMESTAMP>= '2022-01-01'
    and symbol in (select token from t1)
    and FROM_ADDRESS in (select u1 from t1)
    ),

    t3 as (select
    'Other coins depositor' as x1,
    count(distinct FROM_ADDRESS) as users
    from polygon.udm_events
    where TO_ADDRESS= '0x0319000133d3ada02600f0875d2cf03d442c3367'
    and BLOCK_TIMESTAMP>= '2022-01-01'
    and symbol not in (select token from t1)
    and FROM_ADDRESS in (select u1 from t1)
    )

    select * from t2
    union all
    select * from t3

    Run a query to Download Data