mohamadreza221166Untitled Query
    Updated 2022-07-27
    -- WITH swims AS(
    -- SELECT
    -- INNER_INSTRUCTION:instructions[0]:parsed:info:source AS wallet,
    -- INNER_INSTRUCTION:instructions[1]:parsed:info:amount AS amount,
    -- amount / 1e6 AS amount_USD
    -- FROM solana.core.fact_events
    -- WHERE PROGRAM_ID = 'SWiMDJYFUGj6cPrQ6QYYYWZtvXQdRChSVAygDZDsCHC'
    -- AND SUCCEEDED = 'TRUE'
    -- )

    -- SELECT wallet, sum(amount_USD) AS amount_USD
    -- FROM swims
    -- WHERE wallet IS NOT NULL
    -- -- AND mint IS NOT NULL
    -- GROUP BY 1
    -- ORDER BY 2 DESC
    -- LIMIT 50

    -- select pre_token_balances from solana.core.fact_transactions where tx_id = '5ii8QJxoUiBvRQEtTxbDCNqmH97GxhDT2W6YQe8Mu8kKKG3wR7QdCavAAcmHLVtQYNSCgQ8NMM6z4nYCteLwzfk8'

    WITH trans as(
    select value:mint as mint_ --, value:owner, value:uiTokenAmount:amount, value:uiTokenAmount:uiAmountString
    from solana.core.fact_transactions, table (flatten (input=> pre_token_balances))
    where tx_id = '5ii8QJxoUiBvRQEtTxbDCNqmH97GxhDT2W6YQe8Mu8kKKG3wR7QdCavAAcmHLVtQYNSCgQ8NMM6z4nYCteLwzfk8'
    )

    select t1.*, label
    from trans t1
    left join solana.core.dim_labels t2 on t2.address = t1.mint_

    Run a query to Download Data