AFFILIATE | START_DATE | END_DATE | TOTAL_SWAPS | TOTAL_VOLUME_USD | TOTAL_AFFILIATE_FEES_USD | AVG_SWAP_VALUE_USD | |
|---|---|---|---|---|---|---|---|
1 | ti,td | 2024-02-01 00:00:00.000 | 2024-02-29 00:00:00.000 | 32806 | 91059073.41998 | 641964.060510209 | 2775.68351582 |
NineRealms(Agg) Affiliate Report Stats
Updated 2 hours ago
999
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
›
⌄
-- forked from (THORSwap) Top 10 Directed Swap Pairs By Affiliate Address @ https://flipsidecrypto.xyz/edit/queries/dd2bdbc7-f3f0-4332-b970-d18ef5cc9822
WITH
affiliates AS (
SELECT
TRIM(f.value) AS affiliate
FROM LATERAL FLATTEN(INPUT => SPLIT('{{affiliates}}', ',')) AS f
)
, date_range AS (
SELECT
(
CASE
WHEN '{{start_date}}' = '' AND '{{end_date}}' = '' THEN DATE_TRUNC('MONTH', CURRENT_DATE)
WHEN '{{start_date}}' = '' THEN DATE_TRUNC('MONTH', '{{end_date}}'::DATE)
ELSE '{{start_date}}'::DATE
END
) AS start_date,
(
CASE
WHEN '{{start_date}}' = '' AND '{{end_date}}' = '' THEN CURRENT_DATE
WHEN '{{end_date}}' = '' THEN DATE_TRUNC('MONTH', '{{start_date}}'::DATE) + INTERVAL '1 MONTH' - INTERVAL '1 DAY'
ELSE '{{end_date}}'::DATE
END
) AS end_date
)
, attempted_txs AS (
SELECT
TX_ID,
SPLIT_PART(MEMO, ':', 4) LIKE '%/%/%' AS IS_STREAMING,
CASE
WHEN split_part(MEMO, ':', 5) != '' THEN split_part(MEMO, ':', 5)
WHEN (MEMO LIKE '%::0' AND MEMO NOT LIKE '+%') THEN 'te-ios'
ELSE NULL
END AS AFFILIATE_ADDRESS,
CASE UPPER(SPLIT_PART(REPLACE(SPLIT_PART(MEMO, ':', 2), '/', '.'), '-', 1))
WHEN 'A' THEN 'AVAX.AVAX'
WHEN 'B' THEN 'BTC.BTC'
Last run: about 2 hours agoAuto-refreshes every 24 hours
1
115B
5s