0xaimanlabel and poool
    Updated 2022-08-21
    with raw as (with pool_address as
    (select address from ethereum.core.dim_labels
    where label_type= 'dex' and label ='sushiswap' and label_subtype='pool'
    )

    Select bLOCK_TIMESTAMP as t, TX_HASH, ORIGIN_FROM_ADDRESS as sender,
    ORIGIN_TO_ADDRESS,
    CONTRACT_ADDRESS as pool_address, EVENT_NAME, EVENT_INPUTS, EVENT_INPUTS:amount0 as a0, TX_STATUS
    from ethereum.core.fact_event_logs el inner join pool_address
    on el.contract_address=pool_address.address
    where event_name = 'Mint' and tx_status ='SUCCESS'


    )


    select sender, l.label, pool_address , tx_hash
    from raw left join ethereum.core.dim_labels l on
    raw.sender=l.address

    limit 1000
    Run a query to Download Data