alirsUntitled Query
    Updated 2022-08-25
    with lp as (select
    tx_hash
    from ethereum.core.fact_event_logs
    where ORIGIN_TO_ADDRESS = '0xd9e1ce17f2641f24ae83637ab66a2cca9c378b9f'
    and ORIGIN_FUNCTION_SIGNATURE in ('0xf305d719', '0xded9382a','0xe8e33700')
    ),

    r_lp as (select
    tx_hash
    from ethereum.core.fact_event_logs
    where ORIGIN_TO_ADDRESS = '0xef0881ec094552b2e128cf945ef17a6752b4ec5d'
    and origin_function_signature in ('0x0ad58d2f' )

    ),

    t1 as (select
    ORIGIN_FROM_ADDRESS,
    min(BLOCK_TIMESTAMP) as dt_add,
    sum(AMOUNT_USD) as add_LP
    from ethereum.core.ez_token_transfers where tx_hash in (select tx_hash from lp)
    group by 1),

    t2 as (select
    ORIGIN_FROM_ADDRESS,
    max(BLOCK_TIMESTAMP) as dt_removal,
    sum(AMOUNT_USD) as removal_LP
    from ethereum.core.ez_token_transfers where tx_hash in (select tx_hash from r_lp)
    group by 1),

    t3 as (select
    t1.ORIGIN_FROM_ADDRESS as u1,
    dt_removal,
    removal_LP-add_LP as profit_lost
    from t1 left join t2 on t1.ORIGIN_FROM_ADDRESS=t2.ORIGIN_FROM_ADDRESS)

    select
    Run a query to Download Data