TX_COUNT | MINTERS | |
|---|---|---|
1 | 4445 | 3890 |
freemartianBasepaint Paint Minters
Updated 2024-01-30
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 datas AS(
SELECT
DISTINCT from_address AS user
FROM base.core.fact_transactions
UNION
SELECT
DISTINCT to_address AS user
FROM base.core.fact_transactions
),
minters AS (
SELECT
block_timestamp,
tx_hash,
nft_to_address as minter
FROM base.nft.ez_nft_transfers
WHERE nft_address = '0xba5e05cb26b78eda3a2f8e3b3814726305dcac83'
AND event_type = 'mint'
),
users AS (
SELECT
DISTINCT user FROM datas
WHERE user IN (SELECT minter FROM minters)
),
first_users_activities AS(
SELECT
user,
block_timestamp,
tx_hash,
from_address,
to_address,
RANK() OVER (PARTITION BY user ORDER BY block_timestamp ) AS rank
Last run: about 1 year agoAuto-refreshes every 3 hours
1
13B
44s