freemartianOn-Chain Summer NFTs Total - Day 0 to 3
Updated 2023-09-04
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
34
35
36
›
⌄
-- forked from Bridge to Base NFT #1 quest Totals @ https://flipsidecrypto.xyz/edit/queries/b1903ab4-23a4-4c2d-b07a-d93fa3b0443b
with mints as (
select * from base.core.ez_nft_transfers
where nft_address in (
'0x7d5861cfe1c74aaa0999b7e2651bf2ebd2a62d89',
'0xea2a41c02fa86a4901826615f9796e603c6a4491',
'0xc9cca8e570f81a7476760279b5b19cc1130b7580',
'0x05b8ee5658f3ad6c268c08b7a70f2fb4b10cf348')
-- '0x0c664a85521d5721bca047d29238d9e2a9e9e861',
-- '0x33ed5107f821bb1465da30b7dce4fb7105b0ad16',
-- '0x8b2937ead425ccc91fc0ad884638dc2129c51cb2')
and event_type = 'mint')
-- parallel as (
-- select
-- 'Parallel' as project_name,
-- count(tx_hash) as Total_mints,
-- count(distinct from_address) as Unique_minters
-- from base.core.fact_transactions
-- where to_address = '0x1f9248b193806d7bb7f04945bc8f35dfeeffca34'
-- and origin_function_signature = '0x3510dfa6'
-- group by 1
-- )
select
project_name as Quest_NFT,
count(distinct nft_to_address) as Unique_minters,
count(tx_hash) as Total_mints
from mints
group by 1
union
SELECT
'Parallel' as Quest_NFT,
Run a query to Download Data