PS0G1Weekly minted tokens
Updated 2022-11-23
99
1
2
3
4
5
6
7
8
9
10
11
12
›
⌄
select date_trunc(week,block_timestamp) as date,
count (distinct tx_hash) as Mints_Count,
count (distinct nft_to_address) as Minters_Count,
count (distinct tokenid) as Minted_Tokens,
sum(Mints_Count) over (order by date) as cum_Mints,
sum(Minters_Count) over (order by date) as cum_Minters,
sum(Minted_Tokens) over (order by date) as cum_Minted
from ethereum.core.ez_nft_mints
where nft_address = '0x629a673a8242c2ac4b7b8c5d8735fbeac21a6205'
group by 1
order by 1
--inspired by alik110
Run a query to Download Data