freemartianBase NFTs total sales and mints
Updated 2023-08-10
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
33
›
⌄
with mints as(
select
from_address,
name,
symbol,
tx_hash,
eth_value
from base.core.fact_traces t inner join base.core.dim_contracts l
on t.from_address = l.address
where to_address = '0x7777777f279eba3d3ad8f4e708545291a6fdba8b'
and tx_status = 'SUCCESS'
)
-- minters as (
-- select
-- m.from_address,
-- to_address
-- from base.core.fact_traces t2 inner join mints m
-- on t2.to_address = m.from_address
-- where t2.tx_hash in (SELECT tx_hash from mints)
-- )
select
from_address as nft_contract,
name,
symbol,
-- count(distinct mi.from_address),
count(distinct tx_hash) as number_of_mints,
sum(eth_value) as earnings
from mints
group by 1,2,3
order by earnings desc
Run a query to Download Data