yasmin-n-d-r-hUntitled Query copy copy
Updated 2023-11-20
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
›
⌄
-- forked from Untitled Query copy @ https://flipsidecrypto.xyz/edit/queries/d0acc3bc-9d0a-4b8b-9c74-d5880afd3e30
with GalacticGeckos as (
SELECT TOKEN_ID FROM solana.nft.dim_nft_metadata
WHERE PROJECT_NAME ilike 'galactic geckos')
SELECT
sum(SALES_AMOUNT) as sale_volume
from solana.nft.fact_nft_sales
where mint in (SELECT TOKEN_ID from GalacticGeckos)
and BLOCK_TIMESTAMP :: date BETWEEN '{{Start_date}}'
and '{{End_date}}'
Run a query to Download Data