mohamadreza221166Most popular stablecoins and non-stablecoins on swimming protocol
    Updated 2022-07-27
    WITH
    swims AS(
    SELECT DISTINCT TX_ID
    FROM solana.core.fact_events
    WHERE PROGRAM_ID = 'SWiMDJYFUGj6cPrQ6QYYYWZtvXQdRChSVAygDZDsCHC'
    AND SUCCEEDED = 'TRUE'
    AND BLOCK_TIMESTAMP::DATE > '2022-06-01'
    ),
    trans AS(
    SELECT value:mint AS mint
    FROM solana.core.fact_transactions, table (flatten (input=> pre_token_balances))
    WHERE TX_ID IN(SELECT TX_ID FROM swims)
    )

    SELECT label AS coin, COUNT(*) AS number_of_usage
    FROM trans t1
    JOIN solana.core.dim_labels t2 on t2.address = t1.mint
    GROUP BY 1
    ORDER BY 2 DESC
    LIMIT 10


    SELECT CURRENT_DATE




    -- WITH swims AS(
    -- SELECT BLOCK_TIMESTAMP,
    -- INNER_INSTRUCTION:instructions[0]:parsed:info:source AS wallet,
    -- INNER_INSTRUCTION:instructions[1]:parsed:info:amount AS amount,
    -- INNER_INSTRUCTION:instructions[1]:parsed:info:authority AS authority,
    -- amount / 1e6 AS amount_USD
    -- FROM solana.core.fact_events
    -- WHERE PROGRAM_ID = 'SWiMDJYFUGj6cPrQ6QYYYWZtvXQdRChSVAygDZDsCHC'
    -- AND SUCCEEDED = 'TRUE'
    Run a query to Download Data