AndyCoolPool
Updated 2021-12-07
99
1
2
3
4
5
6
7
8
9
10
11
›
⌄
SELECT sum(amount_usd) as amt, TO_ADDRESS_NAME as pool
FROM polygon.udm_events
WHERE DATEDIFF('day', TO_DATE(block_timestamp), CURRENT_DATE()) <= 30
AND (to_label ILIKE 'sushiswap' OR to_address ILIKE '0x1b02da8cb0d097eb8d57a175b88c7d8b47997506')
AND origin_function_name IN ('removeLiquidityETH', 'addLiquidity', 'removeLiquidityETHSupportingFeeOnTransferTokens', 'removeLiquidity',
'removeLiquidityETHWithPermit', 'removeLiquidityETHWithPermitSupportingFeeOnTransferTokens')
and amount is not null
and TO_ADDRESS_NAME <> 'SushiSwap Router'
--and amt > 100000
group by TO_ADDRESS_NAME
order by amt desc