pier123-b7LIiixeth5
Updated 2022-09-30Copy Reference Fork
99
1
2
3
4
5
6
7
8
9
10
11
›
⌄
select date_trunc('day', BLOCK_TIMESTAMP) as day, platform_name, tb2.PROJECT_NAME,
count(distinct tx_hash) as transactions,
count(distinct tokenid) as nfts,
count(distinct buyer_address) as buyers,
count(distinct seller_address) as sellers,
sum(price_usd)/pow(10,3) as volume
from
ethereum.core.ez_nft_sales tb1 join ethereum.core.dim_nft_metadata tb2 on tb1.nft_address = tb2.CONTRACT_ADDRESS
where
platform_name = 'x2y2'
group by 1, 2, 3
Run a query to Download Data