flipside

    DUST Price
    NCAnalyticsDUST Price
    Updated 2023-01-18
    /*SELECT --*
    date_trunc('day', block_timestamp) as day,
    median(swap_to_amount / swap_from_amount) as DUST_price
    FROM solana.core.fact_swaps
    WHERE swap_from_mint LIKE 'DUSTawucrTsGU8hcqRdHDCbuYhCPADMLM2VcCb8VnFnQ'
    AND swap_to_mint LIKE 'EPjFWdd5AufqSSqeM2qN1xzybapC8G4wEGGkZwyTDt1v'
    AND NOT SWAP_FROM_AMOUNT = 0
    GROUP BY 1
    --LIMIT 100
    */

    WITH tab1 as (
    SELECT
    TX_TO,
    sum(amount) as volume,
    count(DISTINCT tx_from) as senders,
    count(DISTINCT tx_id) as events
    FROM solana.core.fact_transfers
    WHERE mint LIKE 'DUSTawucrTsGU8hcqRdHDCbuYhCPADMLM2VcCb8VnFnQ'
    GROUP BY 1
    HAVING NOT volume is NULL
    ORDER by 2 DESC
    LIMIT 10
    )


    SELECT *
    FROM tab1
    LEFT outer JOIN solana.core.dim_labels
    ON address = tx_to
    Run a query to Download Data