jp12Spindl Sandbox - NFT Royalties Totals
Updated 2022-10-02Copy Reference Fork
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
›
⌄
-- SELECT block_timestamp::date as date, SUM(CREATOR_FEE_USD) as cfee_usd
-- FROM ethereum.core.ez_nft_sales
-- WHERE 1=1
-- and nft_address = '0xa342f5d851e866e18ff98f351f2c6637f4478db5'
-- GROUP BY 1
SELECT '1. LAND Royalties' as type, SUM(CREATOR_FEE_USD) as cfee_usd
FROM ethereum.core.ez_nft_sales
WHERE 1=1
and NFT_ADDRESS = '0x5cc5b05a8a13e3fbdb0bb9fccd98d38e50f90c38'
UNION
SELECT '2. ASSET Royalties' as type, SUM(CREATOR_FEE_USD) as cfee_usd
FROM ethereum.core.ez_nft_sales
WHERE 1=1
and NFT_ADDRESS IN ('0xa342f5d851e866e18ff98f351f2c6637f4478db5', '0x067a1eb5e383ed24b66d72aaf80d8d7db3d299a8')
ORDER BY 1 ASC
Run a query to Download Data