0xaimanUntitled Query
    Updated 2022-11-27
    WITH tab1 as (
    SELECT
    address,
    address_name
    FROM crosschain.address_labels
    WHERE blockchain LIKE 'polygon'
    AND project_name LIKE 'sushiswap'
    ), tab2 as (
    SELECT
    address_name as a1,
    symbol as s1,
    sum(amount) as amt1
    FROM polygon.udm_events LEFT outer join tab1 on address = to_address
    WHERE to_address IN (SELECT address from tab1)
    AND (ORIGIN_FUNCTION_NAME LIKE '%remove%' or ORIGIN_FUNCTION_NAME LIKE '%add%')
    GROUP by 1,2
    ), tab3 as (
    SELECT
    address_name as a2,
    symbol as s2,
    sum(amount) as amt2
    FROM polygon.udm_events LEFT outer join tab1 on address = from_address
    WHERE from_address IN (SELECT address from tab1)
    AND (ORIGIN_FUNCTION_NAME LIKE '%remove%' or ORIGIN_FUNCTION_NAME LIKE '%add%')
    GROUP by 1,2
    ), tab4 as (
    SELECT
    a1,
    s1,
    amt1 - amt2 as amtg
    FROM tab2 join tab3 on a1 = a2 and s2 = s1
    ), tab5 as (
    SELECT
    symbol,
    avg(price) as p
    FROM ethereum.token_prices_hourly
    Run a query to Download Data