freemartiantop aave
    Updated 2022-09-14
    select
    origin_from_address,
    symbol,
    sum(event_inputs:value)/pow(10,18) as deposit_amount
    from optimism.core.fact_event_logs l
    join optimism.core.dim_contracts c on c.address = l.contract_address
    where origin_to_address = '0x76d3030728e52deb8848d5613abade88441cbc59'
    and event_name = 'Deposit'
    and event_inputs:sender = '0x76d3030728e52deb8848d5613abade88441cbc59'
    and origin_from_address in (
    select
    origin_from_address
    from ethereum.core.ez_eth_transfers
    where origin_to_address = '0x99c9fc46f92e8a1c0dec1b1747d010903e884be1'
    and block_timestamp > CURRENT_DATE - 120
    group by origin_from_address
    order by sum(amount) desc
    limit 50
    )
    group by origin_from_address, symbol

    Run a query to Download Data