m0rt3zaTotal Pooly NFTs
Updated 2022-06-22
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
›
⌄
WITH all_nft AS (
SELECT
nft_address,
tokenid,
sum(mint_price_eth) AS total_eth,
sum(mint_price_usd) AS total_usd
FROM ethereum.core.ez_nft_mints
WHERE
nft_address IN ('0x3545192b340f50d77403dc0a64cf2b32f03d00a9',
'0x5663e3e096f1743e77b8f71b5de0cf9dfd058523',
'0x90b3832e2f2ade2fe382a911805b6933c056d6ed')
GROUP BY nft_address, tokenid
)
SELECT sum(total_eth), sum(total_usd), COUNT(*) as total_nfts
FROM all_nft
Run a query to Download Data