mariyaVolume and Cumulative Volume over time (USD)
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
›
⌄
with sol_price AS (
select
date_trunc('day', BLOCK_TIMESTAMP ) as day,
(sum(SWAP_TO_AMOUNT)/sum(SWAP_FROM_AMOUNT)) as price
from solana.core.fact_swaps
where SWAP_FROM_MINT = 'So11111111111111111111111111111111111111112'
and SWAP_TO_MINT = 'EPjFWdd5AufqSSqeM2qN1xzybapC8G4wEGGkZwyTDt1v'
group by 1)
select
date_trunc('{{Timeframe}}',BLOCK_TIMESTAMP) AS date,
sum(SALES_AMOUNT*price) AS Volume,
sum(Volume) over (order by date) AS "Cumulative Volume"
from solana.core.fact_nft_sales inner join sol_price on sol_price.day=date_trunc('day',BLOCK_TIMESTAMP)
where MARKETPLACE='opensea' and SALES_AMOUNT is not NULL and date >= '2022-10-01'
group by 1
Run a query to Download Data