TX_COUNT | MINTERS | |
|---|---|---|
1 | 1237 | 1232 |
freemartianBasepaint Brush Minters
Updated 2024-01-29
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 = '0xd68fe5b53e7e1abeb5a4d0a6660667791f39263a'
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
FROM base.core.fact_transactions t
Last run: over 1 year agoAuto-refreshes every 3 hours
1
13B
71s