Cipher009-CpUJ5kPyth_Contracts_1
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
23
24
25
26
27
›
⌄
select 'Arbitrum' as network, count(distinct from_address) as unique_contract_addresses
from arbitrum.core.fact_traces
where to_address = lower('0xFF1A0F4744E8582DF1AE09D5611B887B6A12925C') and tx_status = 'SUCCESS'
union all
select 'Avalanche_C' as network, count(distinct from_address) as unique_contract_addresses
from avalanche.core.fact_traces
where to_address = lower('0x4305FB66699C3B2702D4D05CF36551390A4C69C6') and tx_status = 'SUCCESS'
union all
select 'Blast' as network, count(distinct from_address) as unique_contract_addresses
from blast.core.fact_traces
where to_address = lower('0xA2AA501B19AFF244D90CC15A4CF739D2725B5729') and tx_status = 'SUCCESS'
union all
select 'Binance Smart Chain' as network, count(distinct from_address) as unique_contract_addresses
from bsc.core.fact_traces
where to_address = lower('0x4D7E825F80BDF85E913E0DD2A2D54927E9DE1594') and tx_status = 'SUCCESS'
union all
select 'Base' as network, count(distinct from_address) as unique_contract_addresses
from base.core.fact_traces
where to_address = lower('0x8250F4AF4B972684F7B336503E2D6DFEDEB1487A') and tx_status = 'SUCCESS'
QueryRunArchived: QueryRun has been archived