fabre-basepoolynft-avg
Updated 2022-06-22
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
›
⌄
with nft_rn as (
select
nft_to_address,
nft_address,
tokenid,
row_number() over (partition by nft_address, tokenid order by block_timestamp desc) rn
from ethereum.core.ez_nft_transfers
where
nft_address in (
lower('0x3545192b340F50d77403DC0A64cf2b32F03d00A9'),
lower('0x90B3832e2F2aDe2FE382a911805B6933C056D6ed'),
lower('0x5663e3E096f1743e77B8F71b5DE0CF9Dfd058523'))
)
select
count(1) mints, count(distinct nft_to_address) wallets, mints / wallets *1.0
from nft_rn
where rn = 1
Run a query to Download Data