sallarWETH/THOR Pool,old pool number of wallets total
Updated 2022-09-12
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
›
⌄
with initial_data as
(
select
'deposits' as status,
count(distinct origin_from_address) as number_of_wallets,
sum(raw_amount)/1e18 as total_amount
from ethereum.core.fact_token_transfers
where contract_address = '0x3d3f13f2529ec3c84b2940155effbf9b39a8f3ec'
and to_address = '0xae1fc3947ee83aeb3b7fec237bcc1d194c88bc24'
and origin_to_address = to_address
UNION
select
'withdraws' as status,
count(distinct origin_from_address) as number_of_wallets,
sum(raw_amount)/1e18 as total_amount
from ethereum.core.fact_token_transfers
where contract_address = '0x3d3f13f2529ec3c84b2940155effbf9b39a8f3ec'
and from_address = '0xae1fc3947ee83aeb3b7fec237bcc1d194c88bc24'
and origin_to_address = from_address
)
select status, number_of_wallets from initial_data
Run a query to Download Data