NakedCollectorCourtyard
Updated 2023-12-05
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
›
⌄
with secondary as (
select
date_trunc('month', block_timestamp) as date,
sum(price_usd) as "Volume (USD)"
from
polygon.nft.ez_nft_sales
where
NFT_ADDRESS in (
'0x251be3a17af4892035c37ebf5890f4a4d889dcad',
'0xd4ac3ce8e1e14cd60666d49ac34ff2d2937cf6fa'
)
group by
1
),
mint as (
select
date_trunc('month', block_timestamp) as date,
count(TOKENID) as count
from
polygon.nft.ez_nft_mints
where
NFT_ADDRESS in (
'0x251be3a17af4892035c37ebf5890f4a4d889dcad',
'0xd4ac3ce8e1e14cd60666d49ac34ff2d2937cf6fa'
)
group by
1
)
select
s.date,
s."Volume (USD)",
m.count
from
secondary s
join mint m on s.date = m.date
Run a query to Download Data