Updated 2024-07-08
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
›
⌄
with sales as (
select
date_trunc('month', block_timestamp) as date,
sum(price_usd) as volume
from
ethereum.nft.ez_nft_sales
where
nft_address = lower('0xa7d8d9ef8D8Ce8992Df33D8b8CF4Aebabd5bD270')
group by
1
),
mint as(
select
date_trunc('month', block_timestamp) as date,
sum(MINT_PRICE_USD) as volume
from
ethereum.nft.ez_nft_mints
where
nft_address = lower('0xa7d8d9ef8D8Ce8992Df33D8b8CF4Aebabd5bD270')
group by
1
)
select
s.volume,
m.volume
from
sales s
join mint m on s.date = m.date
where
s.date >= '2024-01-01'
QueryRunArchived: QueryRun has been archived