rustygeePooly Minter Experience
Updated 2022-12-28
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
›
⌄
WITH minters AS (
SELECT ORIGIN_FROM_ADDRESS
FROM ETHEREUM.CORE.FACT_EVENT_LOGS
WHERE
contract_address = LOWER('0x90B3832e2F2aDe2FE382a911805B6933C056D6ed')
OR contract_address = LOWER('0x3545192b340F50d77403DC0A64cf2b32F03d00A9')
OR contract_address = LOWER('0x5663e3E096f1743e77B8F71b5DE0CF9Dfd058523')
ORDER BY BLOCK_TIMESTAMP DESC
),
number_of_txs as (
SELECT ORIGIN_FROM_ADDRESS, COUNT(*) as nt
FROM ethereum.core.fact_transactions tx
RIGHT JOIN minters ON minters.ORIGIN_FROM_ADDRESS = tx.FROM_ADDRESS
GROUP BY 1
),
combined as (
SELECT
CASE
WHEN nt < 5 AND nt > 0 THEN 'first time (5 tx)'
WHEN nt > 1 AND nt <= 40 THEN 'average (< 40 txs)'
WHEN nt > 40 AND nt <= 200 THEN 'seasoned (< 200 txs)'
WHEN nt > 200 THEN 'veteran (> 200 txs)'
END as funder_type,
ORIGIN_FROM_ADDRESS,
nt as Total_Transactions
FROM number_of_txs
GROUP BY 1, ORIGIN_FROM_ADDRESS, nt
)
SELECT
funder_type,
COUNT(*) as num_instances
FROM combined
GROUP BY funder_type
Run a query to Download Data