gayatridodmaniDegen Apes Sales Graph
Updated 2022-11-26
9
1
2
3
4
5
6
7
8
9
›
⌄
with cte as ( --common table expression used for creating a table with limited attributes
select date(s.block_timestamp) as Date, s.sales_amount, m.project_name as Project, m.creator_name, m.creator_address, m.token_name
from solana.core.dim_nft_metadata m join solana.core.fact_nft_sales s on s.mint=m.mint --Join of the two tables to get sales amount for Degen Apes
)
select cte.Date, cte.sales_amount, cte.Project
from cte
where Project like 'Degen Apes' and Date between '1/1/2021' AND '1/1/2022' --Here we filter out the project for only Degen ape within 2021
order by Date desc
limit 100000;