eferIV > Loyal holders
Updated 2023-04-13
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
›
⌄
WITH claimers AS (
SELECT
TO_ADDRESS AS claimer
FROM
optimism.core.fact_token_transfers
WHERE
FROM_ADDRESS = '0xfedfaf1a10335448b7fa0268f56d2b44dbd357de'
AND ORIGIN_FUNCTION_SIGNATURE = '0x2e7ba6ef'
), senders AS (
SELECT
FROM_ADDRESS AS sender
FROM
optimism.core.fact_token_transfers
WHERE
CONTRACT_ADDRESS = '0x4200000000000000000000000000000000000042'
)
SELECT COUNT(*) FROM claimers
WHERE claimer NOT IN (SELECT * FROM senders)
Run a query to Download Data