maybeyonassushiswap_poly_top10_lps
Updated 2021-12-08
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
›
⌄
with eth_lps as (
select * from (
select
pool_name,
count(tx_id) as swaps,
sum(amount_usd) as swap_usd_vol
from ethereum.dex_swaps
where platform = 'sushiswap'
-- and tx_id = '0x248127092c1a6274e0749f043cb6adbc73290ef78e832231b1d5de4f18d72255'
and direction = 'IN'
group by 1
)
where swap_usd_vol is not null
order by swap_usd_vol desc
),
poly_lps as (
select * from (
select
from_address_name as pool_name,
count(tx_id) as swaps,
sum(amount_usd) as swap_usd_vol
from polygon.udm_events
where split(from_address_name,' ')[0]::string = 'SushiSwap'
-- and tx_id = '0x048d8e1f43f5a4235565112f9759f382046f1a1834d3aba5ddcb405db61373aa' --0x048d8e1f43f5a4235565112f9759f382046f1a1834d3aba5ddcb405db61373aa
group by 1
)
where swap_usd_vol is not null
order by swap_usd_vol desc
)
select * from poly_lps
where pool_name not in (
'SushiSwap WMATIC/TITAN Pool',
'SushiSwap TITAN/IRON Pool',
'SushiSwap USDC/TITAN Pool',
'SushiSwap Router',
Run a query to Download Data