MetiocreSushi fake pools
Updated 2022-05-05
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
›
⌄
with all_sushipools as (
select *
from
ethereum.dex_liquidity_pools
where platform = 'sushiswap' -- ) select sum(amount_usd) as "amount in usd" ,balance_date as "balance date" , platform
)
select
*
from
ethereum.erc20_balances,
all_sushipools
where
user_address = POOL_ADDRESS
and (
contract_address = token0
or contract_address = token1
)
and balance_date >= '2022-01-01'
and
(amount_usd > 500000000 or amount_usd < 50000)
Run a query to Download Data