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