Sandeshliquidity pool
Updated 2022-03-22
99
1
2
3
4
5
6
7
8
9
10
11
12
›
⌄
SELECT to_address_name as pool, sum(amount_usd) as volume
FROM polygon.udm_events
WHERE date_trunc('day',block_timestamp) > CURRENT_DATE - 365
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 amount_usd > 100000
group by 1
order by 2 desc
limit 10
Run a query to Download Data