Date | # of contracts | Tokens created | Total tokens created per contract | |
|---|---|---|---|---|
1 | 2024-10-29 00:00:00.000 | 1 | 9 | 9 |
2 | 2024-10-30 00:00:00.000 | 1 | 1 | 1 |
3 | 2024-11-01 00:00:00.000 | 1 | 1 | 1 |
4 | 2024-11-04 00:00:00.000 | 2 | 2 | 1 |
5 | 2024-11-05 00:00:00.000 | 1 | 1 | 1 |
6 | 2024-11-06 00:00:00.000 | 2 | 2 | 1 |
7 | 2024-11-07 00:00:00.000 | 2 | 2 | 1 |
8 | 2024-11-08 00:00:00.000 | 1 | 1 | 1 |
9 | 2024-11-09 00:00:00.000 | 4 | 5 | 1.25 |
10 | 2024-11-10 00:00:00.000 | 2 | 2 | 1 |
11 | 2024-11-11 00:00:00.000 | 3 | 10 | 3.333333 |
12 | 2024-11-12 00:00:00.000 | 2 | 3 | 1.5 |
13 | 2024-11-13 00:00:00.000 | 3 | 13 | 4.333333 |
14 | 2024-11-14 00:00:00.000 | 2 | 81 | 40.5 |
15 | 2024-11-15 00:00:00.000 | 3 | 283 | 94.333333 |
16 | 2024-11-16 00:00:00.000 | 4 | 131 | 32.75 |
17 | 2024-11-17 00:00:00.000 | 3 | 106 | 35.333333 |
18 | 2024-11-18 00:00:00.000 | 1 | 85 | 85 |
19 | 2024-11-19 00:00:00.000 | 2 | 9 | 4.5 |
20 | 2024-11-20 00:00:00.000 | 3 | 81 | 27 |
adriaparcerisasFourthwall deployed contracts 3: Polygon
Updated 19 minutes ago
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
›
⌄
with
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%'
)
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 polygon.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: 19 minutes agoAuto-refreshes every 3 hours
...
155
5KB
397s