adriaparcerisasFourthwall deployed contracts: all
Updated 2023-10-04
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 as (
select
-- x.*
distinct decoded_log:proxy as "Wallet address", x.block_timestamp as "Date time"
from ethereum.core.fact_decoded_event_logs x
join ethereum.core.fact_event_logs xx on x.tx_hash=xx.tx_hash
join ethereum.core.dim_function_signatures y on xx.origin_function_signature=y.bytes_signature
where x.contract_address=lower('0x5DBC7B840baa9daBcBe9D2492E45D7244B54A2A0')
and text_signature='deployProxyByImplementation(address,bytes,bytes32)'
--group by 1 order by 2 desc
order by 2 desc
),
poly as (
select
-- x.*
distinct decoded_log:proxy as "Wallet address", x.block_timestamp as "Date time"
from polygon.core.fact_decoded_event_logs x
join polygon.core.fact_event_logs xx on x.tx_hash=xx.tx_hash
join ethereum.core.dim_function_signatures y on xx.origin_function_signature=y.bytes_signature
where x.contract_address=lower('0x5DBC7B840baa9daBcBe9D2492E45D7244B54A2A0')
and text_signature='deployProxyByImplementation(address,bytes,bytes32)'
--group by 1 order by 2 desc
order by 2 desc
),
avax as (
select
-- x.*
distinct decoded_log:proxy as "Wallet address", x.block_timestamp as "Date time"
from avalanche.core.fact_decoded_event_logs x
join avalanche.core.fact_event_logs xx on x.tx_hash=xx.tx_hash
join ethereum.core.dim_function_signatures y on xx.origin_function_signature=y.bytes_signature
where x.contract_address=lower('0x5DBC7B840baa9daBcBe9D2492E45D7244B54A2A0')
and text_signature='deployProxyByImplementation(address,bytes,bytes32)'
--group by 1 order by 2 desc
order by 2 desc
Run a query to Download Data