glass_blossomscrystal nft
    Updated 2022-07-17
    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