TX_COUNT | TRADER | |
|---|---|---|
1 | 409 | 369 |
freemartianBasepaint Brush Trades
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
),
brushes AS (
SELECT
tx_hash,
seller_address,
buyer_address,
price,
platform_fee,
creator_fee
FROM base.nft.ez_nft_sales
WHERE nft_address = '0xd68fe5b53e7e1abeb5a4d0a6660667791f39263a'
),
users AS (
SELECT
DISTINCT user FROM datas
WHERE user IN (SELECT seller_address FROM brushes) OR user IN (SELECT buyer_address FROM brushes)
),
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: about 1 year agoAuto-refreshes every 3 hours
1
11B
26s