glass_blossomscrystal nft
Updated 2022-07-17
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
›
⌄
select
date_trunc('day', block_timestamp) as dates,
count(DISTINCT tx_id) as total_buyings ,
case when mint = 'woodN5KSiHEAhaCrZVh3vScGta7u6r5Vp3UbqDFuD4e' then 'Wood Crystal'
when mint = 'EaRtHRxHp1ftdfnJFds9UrCDNaSGxhdnRUucevNr1DzA' then 'Earth Crystal'
when mint = 'Meta1cQ29N8S4cSwJScHZYtXV6J5Cy55oEA8vRVhh8K' then 'Metal Crystal'
when mint = 'WATErpZ2ZBjgAxyttoEjckuTuCe9pEckSabCeENLTYq' then 'Water Crystal'
when mint = 'FireKR7LgjyzjsLnxaNZwa7dnJncDSidD4cXGhTGz2eU' then 'Fire Crystal'
end as nft_collection
from flipside_prod_db.solana.fact_transfers
where MINT in ('woodN5KSiHEAhaCrZVh3vScGta7u6r5Vp3UbqDFuD4e',
'EaRtHRxHp1ftdfnJFds9UrCDNaSGxhdnRUucevNr1DzA',
'Meta1cQ29N8S4cSwJScHZYtXV6J5Cy55oEA8vRVhh8K',
'WATErpZ2ZBjgAxyttoEjckuTuCe9pEckSabCeENLTYq',
'FireKR7LgjyzjsLnxaNZwa7dnJncDSidD4cXGhTGz2eU'
)
GROUP by 1,3
order by 1
Run a query to Download Data