with gns_protocol as (
select date_trunc('day', block_timestamp)::date as day,
count(distinct(tx_hash)) as gns_txn_number,
count(distinct(origin_from_address)) as gns_unique_users
from polygon.core.fact_event_logs
where 1 = 1
and event_name = 'Transfer'
and contract_address = '0xe5417af564e4bfda1c483642db72007871397896'
and tx_status = 'SUCCESS'
group by day
),
polygon as (
select
date_trunc('day', block_timestamp)::date as day,
count (distinct(tx_hash)) as polygon_txn_number,
count (distinct(from_address)) as polygon_unique_users
from polygon.core.fact_transactions
where 1 = 1
and status = 'SUCCESS'
group by day
)
select day,
gns_protocol.gns_txn_number,
gns_protocol.gns_unique_users,
polygon_txn_number,
polygon_unique_users
from gns_protocol join polygon
using (day)
order by day asc