Cipher009-CpUJ5kPyth_Contracts_2
Updated 2024-06-26
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
›
⌄
select 'Ethereum' as network, count(distinct from_address) as unique_contract_addresses
from ethereum.core.fact_traces
where to_address = lower('0x4305FB66699C3B2702D4D05CF36551390A4C69C6') and tx_status = 'SUCCESS'
union all
select 'Gnosis' as network, count(distinct from_address) as unique_contract_addresses
from gnosis.core.fact_traces
where to_address = lower('0x2880AB155794E7179C9EE2E38200202908C17B43') and tx_status = 'SUCCESS'
union all
select 'Optimism' as network, count(distinct from_address) as unique_contract_addresses
from optimism.core.fact_traces
where to_address = lower('0xFF1A0F4744E8582DF1AE09D5611B887B6A12925C') and tx_status = 'SUCCESS'
union all
select 'Polygon' as network, count(distinct from_address) as unique_contract_addresses
from polygon.core.fact_traces
where to_address = lower('0xFF1A0F4744E8582DF1AE09D5611B887B6A12925C') and tx_status = 'SUCCESS';
QueryRunArchived: QueryRun has been archived