Sbhn_NPGNS
Updated 2022-11-06
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
›
⌄
--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