HosseinUntitled Query
Updated 2023-01-18
9
1
2
3
4
5
6
7
8
›
⌄
select
count(distinct tx_id) as txns_count,
count(distinct token_id) as nfts_count,
count(distinct minter) as minters_count,
sum(iff(mint_price is null, 0, mint_price)/ pow(10, 6)) as total_fee,
avg(iff(mint_price is null, 0, mint_price)/ pow(10, 6)) as avg_fee
from terra.core.fact_nft_mints
where year(block_timestamp) >= 2023
Run a query to Download Data