freemartianDebank - Optimism Deposits
    Updated 2023-07-04
    select
    count(distinct from_address) as Optimism_Depositors_Count,
    count(tx_hash) as Optimism_Deposits_Count,
    sum(amount) as Optimism_Deposits_Amount,
    (CASE
    when contract_address = '0x7f5c764cbc14f9669b88837ca1490cca17c31607' then 'USDC'
    when contract_address = '0x94b008aa00579c1307b0ef2c499ad98a8ce58e58' then 'USDT'
    end) as Symbol
    from optimism.core.ez_token_transfers
    where to_address = '0x824a2d0ae45c447caa8d0da4bb68a1a0056cadc6'
    and contract_address in ('0x7f5c764cbc14f9669b88837ca1490cca17c31607', '0x94b008aa00579c1307b0ef2c499ad98a8ce58e58')
    and ORIGIN_FUNCTION_SIGNATURE = '0xa9059cbb'
    group by contract_address

    -- select * from optimism.core.ez_token_transfers
    -- where tx_hash = '0x1ab3009dbb589906714f1084d4b7b178e7ccef0cff67c4e0ac3b15da6bb3300e'
    Run a query to Download Data