USERTYPE | USERCOUNT | |
|---|---|---|
1 | Existing | 11303 |
2 | New | 10100 |
Spectersquid old and new
Updated 2025-03-01
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
31
32
33
34
35
36
›
⌄
WITH BridgeUsers AS (
SELECT DISTINCT SENDER
FROM axelar.defi.ez_bridge_squid
WHERE BLOCK_TIMESTAMP < '2024-07-05'
),
MintedUsers AS (
SELECT DISTINCT NFT_TO_ADDRESS AS USER_ADDRESS
FROM polygon.nft.ez_nft_transfers
WHERE NFT_ADDRESS = lower('0x436d5567f47e3723313a739d8cfb83d2acc35d15')
AND PROJECT_NAME = 'Squid Scholar'
AND INTRA_EVENT_INDEX = '1'
AND BLOCK_TIMESTAMP >= '2024-07-05'
)
SELECT
'Existing' AS UserType,
COUNT(*) AS UserCount
FROM
BridgeUsers bu
WHERE
EXISTS (
SELECT 1
FROM MintedUsers mu
WHERE bu.SENDER = mu.USER_ADDRESS
)
UNION ALL
SELECT
'New' AS UserType,
COUNT(*) AS UserCount
FROM
MintedUsers mu
WHERE
NOT EXISTS (
SELECT 1
Last run: about 2 months ago
2
34B
7s