feyikemi2024-05-06 01:32 AM
    Updated 2024-05-06
    SELECT
    Tx_from as Sender,
    Tx_to as Receiver,
    Sum(Amount) as Total_Sent_Volume,
    Avg(Amount) as Average_Transaction_Volume

    FROM solana.core.fact_transfers
    WHERE
    mint = 'KMNo3nJsBXfcpJTVhZcXLW7RmTwTt4GVFE7suUBo9sS'
    GROUP BY 1, 2
    ORDER BY 3 DESC
    LIMIT 20
    QueryRunArchived: QueryRun has been archived