adriaparcerisasThe Next Big Thing lite
    Updated 2021-12-14
    SELECT
    date_trunc('day',BLOCK_TIMESTAMP) as date,
    to_address_name as pool,
    count(to_address_name) as addresses
    FROM ethereum.udm_events
    WHERE DATEDIFF('day', TO_DATE(block_timestamp), CURRENT_DATE()) <= 30
    AND (to_label ILIKE 'sushiswap' OR to_address ILIKE '0xd9e1cE17f2641f24aE83637ab66a2cca9C378B9F')
    AND from_label IS NULL
    AND origin_function_name IN
    (
    'addLiquidity'
    )
    and TO_ADDRESS_NAME <> 'router'
    group by 1,2
    order by 1 desc
    Run a query to Download Data