amelia-leeUntitled Query
Updated 2022-11-24
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
›
⌄
WITH
price as (select HOUR::DATE as TIME, avg (PRICE) as Price from ethereum.core.fact_hourly_token_prices where SYMBOL = 'WETH' GROUP by 1)
select
date_trunc ('month',BLOCK_TIMESTAMP) as date,
count (DISTINCT TX_HASH) as Mint,
count (DISTINCT NFT_TO_ADDRESS) as Minter,
count (DISTINCT TOKENID) as Token,
sum (TX_FEE) as Fee,
sum (TX_FEE * Price) as USD_Fee,
Mint / Minter as Mint_Per_User,
sum (Mint) over (order by Date) as cum_Mint,
sum (Minter) over (order by Date) as cum_Minter,
sum (Token) over (order by Date) as cum_Token,
sum (Fee) over (order by Date) as cum_Fee,
sum (USD_Fee) over (order by Date) as cum_USD_Fee
from ethereum.core.ez_nft_mints LEFT JOIN price ON TIME = BLOCK_TIMESTAMP::DATE
where NFT_ADDRESS = '0x629a673a8242c2ac4b7b8c5d8735fbeac21a6205' and EVENT_TYPE = 'nft_mint'
and NFT_FROM_ADDRESS = '0x0000000000000000000000000000000000000000'
group by 1
Run a query to Download Data