connorhUniswap Utility Drivers (Public Schema)
    Updated 2021-11-11
    WITH utility_driver_stack AS (

    SELECT tx_hash,"from" AS driver_address
    FROM public.ethereum_events
    WHERE block_timestamp >= '2020-10-15' AND input_method NOT IN ('0xa9059cbb','0xa9059cb')
    AND "to" IN ( '0x1f9840a85d5af5bf1d1762f925bdaddc4201f984',
    '0x5c69bee701ef814a2b6a3edd4b1652cb9cc5aa6f',
    '0xf164fc0ec4e93095b804a4795bbe1e041497b92a')


    )

    SELECT driver_address, COUNT(DISTINCT tx_hash) AS utility_events
    FROM utility_driver_stack
    GROUP BY 1
    ORDER BY 2 DESC
    LIMIT 100

    Run a query to Download Data