-- forked from paarug / Total NFT Sales in the last 30 days @ https://flipsidecrypto.xyz/paarug/q/2023-04-05-01-35-pm-XMP1Jm
SELECT
sum(SALES_AMOUNT) as "Total Volume (SOL)"
from
solana.core.fact_nft_sales
where
succeeded
and block_timestamp::date > current_date() - interval '1 month'