adriaparcerisasSybil Clusters from L0 and EtherFi NUMBERS
Updated 2024-08-14
999
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
31
32
33
34
35
36
›
⌄
WITH
weeth as (
SELECT
min(trunc(block_timestamp,'day')) as deposit_time,
to_address as address,
SUM(amount_usd) as amount_deposited
FROM
ethereum.core.ez_token_transfers
WHERE (contract_address = lower('0x35fA164735182de50811E8e2E824cFb9B6118ac2') or contract_address='0xcd5fe23c85820f7b72d0926fc9b05b43e359b7ee')
and block_timestamp<'2024-03-18' and amount_usd is not null
GROUP BY 2
),
weeth2 as (
SELECT
max(trunc(block_timestamp,'day')) as withdrawal_time,
from_address as address,
SUM(amount_usd) as amount_withdrawn
FROM
ethereum.core.ez_token_transfers
WHERE (contract_address = lower('0x35fA164735182de50811E8e2E824cFb9B6118ac2') or contract_address='0xcd5fe23c85820f7b72d0926fc9b05b43e359b7ee')
and amount_usd is not null
GROUP BY 2
),
ins as (
select distinct nft_to_address, count(distinct tokenid) as nfts_in from ethereum.nft.ez_nft_transfers
where nft_address=lower('0xb49e4420eA6e35F98060Cd133842DbeA9c27e479')
and nft_to_address<>'0x0000000000000000000000000000000000000000'
and block_timestamp<'2024-03-15'
group by 1
),
outs as (
select distinct nft_from_address, count(distinct tokenid) as nfts_out from ethereum.nft.ez_nft_transfers
where nft_address=lower('0xb49e4420eA6e35F98060Cd133842DbeA9c27e479')
and nft_from_address<>'0x0000000000000000000000000000000000000000'
and block_timestamp<'2024-03-15'
group by 1