Polaris_9RSwap Decomposition Example
Updated 2023-12-29
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
›
⌄
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