0-MIDseller position
    Updated 2023-04-15
    with act1 as (
    with tab1 as (
    select BLOCK_TIMESTAMP::date as date
    ,ORIGIN_FROM_ADDRESS
    ,SYMBOL
    ,AMOUNT
    ,AMOUNT_USD
    ,ORIGIN_TO_ADDRESS
    from arbitrum.core.ez_token_transfers
    where CONTRACT_ADDRESS=lower('0x912ce59144191c1204e64559fe8253a0e49e6548')
    and BLOCK_TIMESTAMP::date>='2023-03-23'
    and SYMBOL='ARB'
    and ORIGIN_FROM_ADDRESS=FROM_ADDRESS),
    tab2 as (
    select ADDRESS
    ,PROJECT_NAME
    ,LABEL_TYPE
    from crosschain.core.address_labels
    where LABEL_TYPE='dex')
    select ORIGIN_FROM_ADDRESS as arb_sellers
    from tab1
    left join tab2
    on tab1.ORIGIN_TO_ADDRESS=tab2.ADDRESS),
    act2 as (
    with tab3 as (
    select BLOCK_TIMESTAMP::date as date
    ,ORIGIN_FROM_ADDRESS
    ,SYMBOL
    ,AMOUNT
    ,AMOUNT_USD
    ,ORIGIN_TO_ADDRESS
    from optimism.core.ez_token_transfers
    where CONTRACT_ADDRESS=lower('0x4200000000000000000000000000000000000042')
    and BLOCK_TIMESTAMP::date>='2023-03-23'
    and SYMBOL='OP'
    and ORIGIN_FROM_ADDRESS=FROM_ADDRESS),
    Run a query to Download Data