flipside

    ratio_GNS vs Polygon
    bertaratio_GNS vs Polygon
    Updated 2022-11-07
    with p1 as (select 'GNS' as type,
    count (distinct tx_hash) as count_TransactionsGNS
    from polygon.core.fact_event_logs
    where contract_address ilike '0xe5417af564e4bfda1c483642db72007871397896'
    and event_name ilike 'transfer'
    and tx_status ilike 'SUCCESS'),
    p2 as (select 'Polygon' as type,
    count (distinct tx_hash) as count_TransactionsPolygon
    from polygon.core.fact_transactions
    where status ilike 'SUCCESS')
    select count_TransactionsGNS*100/count_TransactionsPolygon as percent from p1,p2

    Run a query to Download Data