rackhaelUntitled Query
Updated 2022-07-21
9
1
2
3
4
5
6
7
8
›
⌄
select date_trunc('day', block_timestamp) AS DATE,
sum(sales_amount) AS "Amount SOL"
from solana.core.fact_nft_sales left outer join solana.core.dim_labels
on mint = solana.core.dim_labels.address
where label like 'okay bears'
and succeeded = 'true'
and block_timestamp ' = current_date - 30
group by 1
Run a query to Download Data