sarathUniswap Dominance 2
Updated 2022-04-07
99
1
2
3
4
5
6
7
8
9
10
›
⌄
with data1 as (SELECT balance_date as date,label as label1,sum(amount_usd) as volume from ethereum.erc20_balances where label='uniswap'
GROUP by 1,2),
data2 as (
SELECT balance_date,label,sum(amount_usd) as other_volume from ethereum.erc20_balances
GROUP by 1,2
)
SELECT date,label,label1,volume,other_volume from data2 JOIN data1 on
data2.balance_date=data1.date and data2.other_volume>data1.volume
LIMIT 1000