TRANSACTION | AMOUNT_RANGE | |
|---|---|---|
1 | 1025 | 5 or 6 NFT |
2 | 3347 | 2 or 3 NFT |
3 | 3179 | 4 or 5 NFT |
4 | 30642 | Above 7 NFT |
5 | 84679 | 1 NFT |
SpecterCBTC distribution tx
Updated 2025-02-22
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
›
⌄
WITH CbBtcBase AS (
SELECT tx_hash, COUNT(TOKENID) AS mints
FROM base.nft.ez_nft_transfers
WHERE nft_address = '0xf50a84399290bba75e4a11317009bb45a36c5831'
AND event_type = 'mint'
AND block_timestamp >= '2024-09-12'
GROUP BY tx_hash
)
SELECT
COUNT(DISTINCT tx_hash) AS transaction,
CASE
WHEN mints = 1 THEN '1 NFT'
WHEN mints BETWEEN 2 AND 3 THEN '2 or 3 NFT'
WHEN mints BETWEEN 4 AND 5 THEN '4 or 5 NFT'
WHEN mints BETWEEN 6 AND 7 THEN '5 or 6 NFT'
WHEN mints > 7 THEN 'Above 7 NFT'
END AS amount_range
FROM CbBtcBase
GROUP BY amount_range
Last run: about 2 months ago
5
99B
4s