TOTAL_UNIQUE_MINTERS | |
|---|---|
1 | 49842 |
datavortexTotal minters
Updated 2025-03-02
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
›
⌄
WITH minters AS (
SELECT origin_from_address
FROM ethereum.core.ez_decoded_event_logs
WHERE
contract_address = LOWER('0x8236a87084f8B84306f72007F36F2618A5634494')
AND decoded_log:from = '0x0000000000000000000000000000000000000000'
AND event_name = 'Transfer'
UNION
SELECT origin_from_address
FROM base.core.ez_decoded_event_logs
WHERE
contract_address = LOWER('0xecAc9C5F704e954931349Da37F60E39f515c11c1')
AND decoded_log:from = '0x0000000000000000000000000000000000000000'
AND event_name = 'Transfer'
UNION
SELECT origin_from_address
FROM bsc.core.ez_decoded_event_logs
WHERE
contract_address = LOWER('0xecAc9C5F704e954931349Da37F60E39f515c11c1')
AND decoded_log:from = '0x0000000000000000000000000000000000000000'
AND event_name = 'Transfer'
)
SELECT COUNT(DISTINCT origin_from_address) AS total_unique_minters
FROM minters;
Last run: 2 months ago
1
9B
29s