adriaparcerisasCryptoys DTE 2.1
Updated 2025-03-24
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
›
⌄
WITH tab1 AS (
SELECT
distinct NFT_TO_ADDRESS AS "Teleporting_Wallet",
min(trunc(BLOCK_TIMESTAMP,'day')) AS "Debut"
FROM
polygon.nft.ez_nft_transfers
WHERE
PROJECT_NAME LIKE '%Cryptoys Bridge 721%'
AND NFT_FROM_ADDRESS = '0x0000000000000000000000000000000000000000'
group by 1
)
SELECT
"Debut",
count(distinct "Teleporting_Wallet") as "New Teleporting Wallets",
sum("New Teleporting Wallets") over (order by "Debut") as "Total Teleporting Wallets"
FROM
tab1
group by 1
ORDER BY
"Debut" DESC
QueryRunArchived: QueryRun has been archived