Date | # of contracts | Tokens created | Total tokens created per contract | |
|---|---|---|---|---|
1 | 2024-10-06 00:00:00.000 | 1 | 1 | 1 |
2 | 2024-10-22 00:00:00.000 | 1 | 2 | 2 |
3 | 2024-10-23 00:00:00.000 | 2 | 3 | 1.5 |
4 | 2024-10-24 00:00:00.000 | 1 | 1 | 1 |
5 | 2024-10-25 00:00:00.000 | 1 | 1 | 1 |
6 | 2024-10-30 00:00:00.000 | 2 | 51 | 25.5 |
7 | 2024-11-02 00:00:00.000 | 1 | 2 | 2 |
8 | 2024-11-04 00:00:00.000 | 2 | 2 | 1 |
9 | 2024-11-05 00:00:00.000 | 1 | 4 | 4 |
10 | 2024-11-06 00:00:00.000 | 1 | 1 | 1 |
11 | 2024-11-13 00:00:00.000 | 1 | 1 | 1 |
12 | 2024-11-15 00:00:00.000 | 1 | 1 | 1 |
13 | 2024-11-21 00:00:00.000 | 1 | 1 | 1 |
14 | 2024-11-30 00:00:00.000 | 1 | 18 | 18 |
15 | 2024-12-01 00:00:00.000 | 2 | 2 | 1 |
16 | 2024-12-02 00:00:00.000 | 1 | 1 | 1 |
17 | 2024-12-04 00:00:00.000 | 1 | 21 | 21 |
18 | 2024-12-05 00:00:00.000 | 1 | 1 | 1 |
19 | 2024-12-18 00:00:00.000 | 1 | 1 | 1 |
20 | 2024-12-24 00:00:00.000 | 1 | 1 | 1 |
adriaparcerisasFourthwall deployed contracts 3: Ethereum
Updated 2025-03-31
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
›
⌄
with
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%'
)
SELECT
trunc(block_timestamp,'day') as "Date",
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 addresses)
and nft_from_address='0x0000000000000000000000000000000000000000'
and block_timestamp >=current_date-INTERVAL '{{number_of_months}} MONTHS'
group by 1 order by 1 asc
Last run: 29 days agoAuto-refreshes every 3 hours
43
1KB
39s