Polaris_9RSwap Decomposition Example
    Updated 2023-12-29
    WITH get_memo AS (
    SELECT DISTINCT TX_ID, MEMO
    FROM thorchain.defi.fact_swaps_events
    WHERE BLOCK_TIMESTAMP::DATE >= CURRENT_DATE - INTERVAL '{{days}} DAY'
    )
    SELECT
    s.TX_ID,
    TO_ASSET = SPLIT_PART(MEMO, ':', 2) AS IS_OUTBOUND,
    FROM_ASSET,
    TO_ASSET,
    MEMO,
    COUNT(1) AS tx_count,
    SUM(TO_AMOUNT_USD) AS SUM_TO_AMOUNT
    FROM thorchain.defi.fact_swaps AS s
    JOIN get_memo AS m
    on s.TX_ID = m.TX_ID
    WHERE AFFILIATE_ADDRESS IN ('ss')
    AND BLOCK_TIMESTAMP::DATE >= CURRENT_DATE - INTERVAL '{{days}} DAY'
    GROUP BY 1,2,3,4,5
    ORDER BY 1,2
    QueryRunArchived: QueryRun has been archived