Updated 2022-11-06
    --credit : alik110
    with gnstable as (
    select block_timestamp::date as day,
    sum (event_inputs:value/1e18) as GNS_Volume,
    count (distinct tx_hash) as GNS_Transactions
    from polygon.core.fact_event_logs
    where contract_address = '0xe5417af564e4bfda1c483642db72007871397896'
    and event_name = 'Transfer'
    and tx_status= 'SUCCESS'
    group by 1)

    select block_timestamp::date as date,
    GNS_Volume,
    GNS_Transactions,
    count (distinct tx_hash) as Polygon_Transactions,
    count (distinct from_address) as Polygon_Active_Users
    from polygon.core.fact_transactions t1 join gnstable t2 on t1.block_timestamp::Date = t2.DAY
    where status = 'SUCCESS'
    group by 1,2,3
    order by 1
    Run a query to Download Data