ChinmayFTotal IB tokens (Liquidity Incentives) claimed across assets
    Updated 2023-04-13
    with a as (select contract_address, sum(event_inputs:reward::integer)/1e18 as "Incentives" from optimism.core.fact_event_logs
    where topics[0] = lower('0x540798df468d7b23d11f156fdb954cb19ad414d150722a7b6d55ba369dea792e')
    and contract_address in (lower('0xf75e85e9127039b4cf818118CC8c5b257EdF6684'), lower('0xD52dF1Ea7b51B76cC831Ed68Ff93e92f80271617'), lower('0x100bE116E7D934268Db5dFcFAD54cB221504C479'))
    group by 1
    )

    select *, case when contract_address = lower('0xf75e85e9127039b4cf818118CC8c5b257EdF6684') then 'WETH'
    when contract_address = lower('0xD52dF1Ea7b51B76cC831Ed68Ff93e92f80271617') then 'DAI'
    when contract_address = lower('0x100bE116E7D934268Db5dFcFAD54cB221504C479') then 'USDC'
    else null end as type
    from a
    Run a query to Download Data