LTirrellUntitled Query
Updated 2022-12-11
999
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 royalty_payments AS (
SELECT
*
FROM
solana.core.fact_transfers
WHERE
mint = 'So11111111111111111111111111111111111111112'
AND tx_to = '9uBX3ASjxWvNBAD1xjbVaKA74mWGZys3RGSF7DdeDD3F'
AND block_timestamp :: DATE >= '2022-10-07'
)
SELECT
s.block_timestamp,
s.tx_id,
s.marketplace,
s.mint,
s.sales_amount,
COALESCE(
t.amount,
0
) AS royalty_amount
FROM
solana.core.fact_nft_sales s
LEFT JOIN royalty_payments t
ON (
s.block_timestamp = t.block_timestamp
AND s.tx_id = t.tx_id
AND t.mint = 'So11111111111111111111111111111111111111112'
AND t.tx_to = '9uBX3ASjxWvNBAD1xjbVaKA74mWGZys3RGSF7DdeDD3F'
)
WHERE
s.block_timestamp :: DATE >= '2022-10-07'
AND s.succeeded='TRUE'
AND s.mint IN (
'9H9Kbk3GCBtQZEBcXwZ6wxUfwcmJSS9m2uNn2NDwpAVm',
'Drmask8NifXEwQv5byqSzpaB9rzVnUupuDm1zZjyKh4t',
'65SunndgcxPUQBn82AA8yJsgZHehedZgdn9RADVaUdvT',
Run a query to Download Data