barbodOverall - Assessment
Updated 2022-04-30
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
›
⌄
with tt as (select
s.event_inputs:token as tkn,
b.label as token_name,
s.event_inputs:vault,
sum(s.event_inputs:price)/1e18 as sale_price
from Ethereum_core.fact_event_logs s
left join ethereum_core.dim_labels b on s.event_inputs:token::string = b.address
where contract_address = lower('0x85aa7f78bdb2de8f3e0c0010d99ad5853ffcfc63')
and event_name = 'Mint'
and block_timestamp > CURRENT_DATE - 90
group by 1, 2, 3
)
select sum(sale_price) as total_trading_Volume ,count(tkn) as number_NFT from tt
Run a query to Download Data