HeminUntitled Query
Updated 2022-11-08Copy Reference Fork
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
›
⌄
with NFT_mint_transaction as (
SELECT *
FROM optimism.core.fact_event_logs
WHERE event_name = 'Transfer'
-- AND event_inputs:from ='0x0000000000000000000000000000000000000000'
AND event_inputs:to is NOT NULL
-- AND event_inputs:tokenId is NOT NULL
AND TX_STATUS = 'SUCCESS'
),
active_user as (
SELECT
COUNT (DISTINCT TX_HASH) as active
FROM optimism.core.fact_transactions
),
mints as (
SELECT
COUNT(DISTINCT TX_HASH) as "Number of minter"
FROM NFT_mint_transaction
)
SELECT
(("Number of minter")/active)*100 as Percentage
FROM mints t1 join active_user t2
Run a query to Download Data