CHAIN | # of contracts | Tokens created | Total tokens created per contract | |
|---|---|---|---|---|
1 | Polygon | 2335 | 37521 | 16.068951 |
2 | Ethereum | 504 | 50000 | 99.206349 |
3 | Optimism | 430 | 8234 | 19.148837 |
4 | Arbitrum | 109 | 10176 | 93.357798 |
5 | Avalanche | 74 | 3803 | 51.391892 |
adriaparcerisasFourthwall deployed contracts 4: all
Updated 2024-01-30
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
eth_addresses as (
select distinct decoded_log:proxy as addresses
from ethereum.core.fact_decoded_event_logs x
where x.contract_address=lower('0x5DBC7B840baa9daBcBe9D2492E45D7244B54A2A0')
AND event_name ilike '%proxydeployed%'
),
eth as (
SELECT
count(distinct nft_address) as "# of contracts",
count(distinct tokenid) as "Tokens created",
"Tokens created"/"# of contracts" as "Total tokens created per contract"
from ethereum.nft.ez_nft_transfers
where nft_address in (select * from eth_addresses)
and nft_from_address='0x0000000000000000000000000000000000000000'
and block_timestamp >=current_date-INTERVAL '{{number_of_months}} MONTHS'
),
poly_addresses as (
select distinct decoded_log:proxy as addresses
from polygon.core.fact_decoded_event_logs x
where x.contract_address=lower('0x5DBC7B840baa9daBcBe9D2492E45D7244B54A2A0')
AND event_name ilike '%proxydeployed%'
),
poly as (
SELECT
count(distinct nft_address) as "# of contracts",
count(distinct tokenid) as "Tokens created",
"Tokens created"/"# of contracts" as "Total tokens created per contract"
from polygon.nft.ez_nft_transfers
where nft_address in (select * from poly_addresses)
and nft_from_address='0x0000000000000000000000000000000000000000'
and block_timestamp >=current_date-INTERVAL '{{number_of_months}} MONTHS'
),
Last run: about 1 year agoAuto-refreshes every 3 hours
5
164B
415s