Yousefi_1994New swapper after loss the funds
Updated 2022-08-15Copy Reference Fork
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
›
⌄
with swapper_before_loss_funds as (
select
origin_from_address as wallet_address
from optimism.velodrome.ez_swaps
where block_timestamp::date <= '2022-08-04'
group by wallet_address
),
swapper_after_loss_funds as (
select
origin_from_address as wallet_address
from optimism.velodrome.ez_swaps
where block_timestamp::date > '2022-08-04'
group by wallet_address
),
total_wallet_address as (
select
count(distinct origin_from_address) as number_of_total_wallet_address
from optimism.velodrome.ez_swaps
),
new_swapper as (
select
count(distinct wallet_address) as number_of_new_wallet
from swapper_after_loss_funds
where wallet_address not in (select wallet_address from swapper_before_loss_funds)
)
select
number_of_total_wallet_address,
number_of_new_wallet
from total_wallet_address, new_swapper
Run a query to Download Data