Afonso_Diazfeminist-teal
Updated 2025-01-19
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
›
⌄
with eclipse_addresses as (
select distinct signers[0] as address
from eclipse.core.fact_transactions
where block_timestamp >= '2024-08-25'
),
solana_addresses as (
select distinct signers[0] as address
from solana.core.fact_transactions
where block_timestamp >= '2024-08-25'
),
address_comparison as (
select
count(distinct e.address) as total_eclipse_addresses,
count(distinct s.address) as total_solana_addresses,
count(distinct case when s.address is not null then e.address end) as common_addresses
from
eclipse_addresses e
full outer join
solana_addresses s on e.address = s.address
)
select
total_eclipse_addresses,
total_solana_addresses,
common_addresses,
round(common_addresses * 100.0 / total_eclipse_addresses, 2) as eclipse_overlap_percentage,
round(common_addresses * 100.0 / total_solana_addresses, 2) as solana_overlap_percentage
from
address_comparison
QueryRunArchived: QueryRun has been archived