hyoeisemanCopy of G9
Updated 2022-11-05Copy Reference Fork
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
›
⌄
with tab1 as (select
count (distinct origin_from_address) as count_users_GNS,
count (distinct tx_hash) as count_transactions_GNS,
'GNS' as type
from polygon.core.fact_event_logs
where contract_address = '0xe5417af564e4bfda1c483642db72007871397896'
and event_name ilike 'transfer'
and tx_status ilike 'SUCCESS'
),
tab2 as (select
count (distinct from_address) as count_users_POLYGON,
count (distinct tx_hash) as count_transactions_POLYGON, 'Polygon' as type
from polygon.core.fact_transactions
where status ilike 'SUCCESS'
)
SELECT count_users_GNS*100/count_users_POLYGON AS USER_PERCENTAGE,
count_transactions_GNS*100/count_transactions_POLYGON AS TRANSACTION_PERCENTAGE from tab1, tab2
Run a query to Download Data