saadiqMonthly Royalties Estimate
Updated 2023-10-05
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
›
⌄
SELECT
CASE
WHEN nft_address = '0x23581767a106ae21c074b2276d25e5c3e136a68b' THEN 'moonbirds'
WHEN nft_address = '0x13303b4ee819fac204be5ef77523cfcd558c082f' THEN 'mythics eggs'
WHEN nft_address = '0xc0ffee8ff7e5497c2d6f7684859709225fcc5be8' THEN 'mythics'
ELSE 'dunno'
END AS name,
left(date_trunc('month', block_timestamp), 10) AS MONTH,
--SUM(price) AS total_vol_eth,
--SUM(creator_fee) AS total_royalties_eth,
0.35 AS ls_perc,
--total_royalties_eth *.35 AS ls_royalties_eth,
--total_royalties_usd *.35 AS ls_royalties_usd,
0.4 AS est_tax_rate,
SUM(creator_fee) * ls_perc * (1 - est_tax_rate) AS after_taxes_eth
FROM
ethereum.core.ez_nft_sales
WHERE
nft_address IN (
'0x23581767a106ae21c074b2276d25e5c3e136a68b',
'0x13303b4ee819fac204be5ef77523cfcd558c082f',
'0xc0ffee8ff7e5497c2d6f7684859709225fcc5be8'
)
/* MBs, Mythics Eggs, Mythics */
AND block_timestamp >= '2023-03-01'
AND MONTH < date_trunc('month', CURRENT_DATE)
GROUP BY
name,
date_trunc('month', block_timestamp)
ORDER BY
MONTH DESC,
name;
Run a query to Download Data