nitsHow many have withdrawn from all the pools?
Updated 2022-02-22
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
›
⌄
with txs as (SELECT *,
CASE when direction = 'IN' then amount_in else amount_out*(-1) end as amt_net,
CASE when direction = 'IN' then amount_usd else amount_usd*(-1) end as amt_usd_net
from ethereum.dex_swaps
where block_timestamp > '2021-01-01' and platform = 'sushiswap')
SELECT count(distinct to_address) as withdrawn_from_atleast_one_pool_completely
from
(SELECT to_address, sum(amt_net) as net_amt_today
from
(SELECT * from
(SELECT tx_id as tx,fee_Usd from ethereum.transactions )
inner join txs
on tx_id = tx)
GROUP by 1)
where net_amt_today >= '-0.01' and net_amt_today <= '0.01'
LIMIT 100
Run a query to Download Data