rajsCelsius Add Liquidity
    Updated 2022-07-11
    with sushilp as
    (
    SELECT
    *
    from ethereum.core.dim_dex_liquidity_pools
    where platform = 'sushiswap'
    )
    SELECT
    *
    from ethereum.core.fact_event_logs l
    inner join sushilp s
    on l.contract_address = s.pool_address
    where origin_from_address IN
    (
    SELECT
    address
    from flipside_prod_db.crosschain.address_labels
    where address_name ilike '%celsius wallet%'
    )
    and event_name = 'AddLiquidity'
    order by 1 desc
    Run a query to Download Data