MLDZMNsol.open8
    Updated 2022-11-25
    with tb2 as (select block_timestamp::date as day,
    avg (swap_to_amount/swap_from_amount) as price_token
    from solana.fact_swaps
    where swap_from_mint = 'So11111111111111111111111111111111111111112'
    and swap_to_mint in ('EPjFWdd5AufqSSqeM2qN1xzybapC8G4wEGGkZwyTDt1v','Es9vMFrzaCERmJfrF4H2FYD4KCoNkY11McCe8BenwNYB')
    and swap_to_amount > 0
    and swap_from_amount > 0
    and succeeded = 'TRUE'
    group by 1)


    select
    CASE
    WHEN (SALES_AMOUNT*price_token) <= 30 THEN 'a.below 30 USD'
    WHEN (SALES_AMOUNT*price_token) > 30 and (SALES_AMOUNT*price_token) <=100 THEN 'b.30-100 USD'
    WHEN (SALES_AMOUNT*price_token) > 100 and (SALES_AMOUNT*price_token) <=500 THEN 'c.100-500 USD'
    WHEN (SALES_AMOUNT*price_token) > 500 THEN 'd.above 500 USD'
    END as buckets,
    count(distinct TX_ID) as sale_no,
    count(distinct PURCHASER) as buyer_no
    from solana.core.fact_nft_sales x join tb2 y on x.BLOCK_TIMESTAMP::date=y.day
    left outer join solana.core.DIM_NFT_METADATA b on x.mint=b.mint
    where SUCCEEDED='TRUE'
    and BLOCK_TIMESTAMP>=CURRENT_DATE- {{Time_period}}
    and MARKETPLACE = '{{Marketplace}}'
    and SALES_AMOUNT>0
    group by 1
    Run a query to Download Data