gayatridodmaniToken Analysis for Bored Ape
Updated 2022-12-24
99
1
2
3
4
5
6
7
8
9
10
11
›
⌄
with cte as(
select m.token_id, m.token_name, m.creator_name, e.tokenid, e.price, e.currency_symbol, e.price_usd, e.block_timestamp, e.seller_address, e.project_name
from ethereum.core.ez_nft_sales e join ethereum.core.dim_nft_metadata m on e.tokenid= m.token_id
)
select cte.token_id, token_name, sum(cte.price_usd) as Price
from cte
where cte.token_name like 'bayc%' or cte.token_name like 'bored ape%' or cte.token_name like 'boredape%'
and creator_name is not null
and Price is not null
group by token_name, token_id
order by sum(cte.price_usd) desc;
Run a query to Download Data