adriaparcerisasSushiswap WBTC-WETH pool distribution on Polygon
    Updated 2021-12-20

    SELECT
    distinct (from_address) as address,
    sum(amount_usd) as volume
    FROM polygon.udm_events
    WHERE (to_label ILIKE 'sushiswap' OR to_address ILIKE '0x1b02da8cb0d097eb8d57a175b88c7d8b47997506') AND origin_function_name IN ('removeLiquidityETH', 'addLiquidity', 'removeLiquidityETHSupportingFeeOnTransferTokens', 'removeLiquidity',
    'removeLiquidityETHWithPermit', 'removeLiquidityETHWithPermitSupportingFeeOnTransferTokens')
    AND to_address_name='SushiSwap WBTC/WETH Pool'
    and amount_usd is not null
    and to_address_name <> 'SushiSwap Router'
    group by 1
    order by 2 desc

    Run a query to Download Data