adriaparcerisasPolygon NFTs 2
Updated 2022-07-14
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
›
⌄
--Q3. How popular are NFTs on Polygon? Track daily volume over the past month/year/etc.
WITH
nfts as (
select tx_hash
--trunc(block_timestamp,'month') as months,
--sum(matic_value) as volume,
--count(distinct tx_hash) as transactions
from polygon.core.fact_event_logs x
join polygon.core.dim_labels y on x.contract_address=y.address
where label_type='nft'
)
SELECT
count(distinct from_address) as total_users
from polygon.core.fact_transactions where tx_hash in (select * from nfts) --and block_timestamp>=CURRENT_DATE-INTERVAL '1 YEAR'
--group by 1
--order by 1 asc
Run a query to Download Data