freemartianBasepaint Paints Trades
Updated 2023-11-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
›
⌄
-- forked from Basepaint Brush Trades @ https://flipsidecrypto.xyz/edit/queries/0256f422-5f8c-4296-8369-8e71b3c309ff
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
),
paints AS (
SELECT
tx_hash,
seller_address,
buyer_address,
price,
platform_fee,
creator_fee
FROM base.nft.ez_nft_sales
WHERE nft_address = '0xba5e05cb26b78eda3a2f8e3b3814726305dcac83'
AND event_type = 'sale'
),
users AS (
SELECT
DISTINCT user FROM datas
WHERE user IN (SELECT seller_address FROM paints) OR user IN (SELECT buyer_address FROM paints)
),
first_users_activities AS(
SELECT
user,
block_timestamp,
Run a query to Download Data