shadilTotal wallets that didn't switched yet
Updated 2022-09-12
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
›
⌄
select sum(total) as total_left from
(select count(distinct origin_from_address) as total
from ethereum.core.ez_token_transfers
where contract_address ilike lower('0X3D3F13F2529EC3C84B2940155EFFBF9B39A8F3EC')
and origin_function_signature in('0x8dbdbe6d')
and origin_to_address ilike lower('0XAE1FC3947EE83AEB3B7FEC237BCC1D194C88BC24')
union
select -count(distinct origin_from_address) as total
from ethereum.core.ez_token_transfers
where contract_address ilike lower('0X3D3F13F2529EC3C84B2940155EFFBF9B39A8F3EC')
and origin_function_signature in ('0x8dbdbe6d')
and origin_to_address ilike lower('0XEF0881EC094552B2E128CF945EF17A6752B4EC5D'))
Run a query to Download Data