freemartianDebank - Polygon Deposits
    Updated 2023-07-04

    select
    count(distinct from_address) as Polygon_Depositors_Count,
    count(tx_hash) as Polygon_Deposits_Count,
    sum(amount) as Polygon_Deposits_Amount,
    (CASE
    when contract_address = '0x2791bca1f2de4661ed88a30c99a7a9449aa84174' then 'USDC'
    when contract_address = '0xc2132d05d31c914a87c6611c10748aeb04b58e8f' then 'USDT'
    end) as Symbol
    from polygon.core.ez_token_transfers
    where to_address = '0xde74f4efdeec194c3f7b26be736bc8b5266ff7a5'
    and contract_address in ('0xc2132d05d31c914a87c6611c10748aeb04b58e8f', '0x2791bca1f2de4661ed88a30c99a7a9449aa84174')
    and ORIGIN_FUNCTION_SIGNATURE = '0xa9059cbb'
    group by contract_address


    Run a query to Download Data