flipside

    Possible bounty farmers - Polygon fees
    eferPossible bounty farmers - Polygon fees
    Updated 2022-07-19
    WITH variables AS (
    SELECT '0x9a46f71617f3be4fbd98c61b3de7694b8ee7bd71b10fd2eca44d58074f94cb5c' AS txn_hash
    ), bounty_hunters AS(
    SELECT DISTINCT EVENT_INPUTS:to::STRING FROM ethereum.core.fact_event_logs
    WHERE TX_HASH = (SELECT txn_hash FROM variables)
    ), date AS (
    SELECT DISTINCT BLOCK_TIMESTAMP FROM ethereum.core.fact_event_logs
    WHERE TX_HASH = (SELECT txn_hash FROM variables)
    )

    SELECT * FROM ethereum.core.fact_event_logs
    WHERE BLOCK_TIMESTAMP >= (SELECT * FROM date)
    AND EVENT_INPUTS:from::STRING IN (SELECT * FROM bounty_hunters)
    AND EVENT_INPUTS:from::STRING != '0xd152f549545093347a162dce210e7293f1452150' --Disperse app
    AND EVENT_INPUTS:to::STRING IN (SELECT * FROM bounty_hunters)
    Run a query to Download Data