JimMyersTechminter profiles: other chains 90 days copy
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
›
⌄
-- forked from theericstone / minter profiles: other chains 90 days @ https://flipsidecrypto.xyz/theericstone/q/lRKapgZu71qy/minter-profiles-other-chains-90-days
with nftaddys as (
select nft_address, count(1)
from base.core.ez_nft_transfers
where project_name = '{{project}}'
group by 1
),
minters as (
select
nft_to_address as minter,
count(distinct(tx_hash)) as n_mints
from base.core.ez_nft_transfers
where nft_address in ( select nft_address from nftaddys )
and event_type = 'mint'
group by 1
),
select
DISTINCT
address,
blockchain,
n_mints
from crosschain.core.address_tags tags
join minters on minters.minter = tags.address
where end_date IS NULL
or start_date > current_date() - 90;
Run a query to Download Data