flipside

    Weekly Aff Fees
    Spot-WiggumWeekly Aff Fees
    Updated 2025-02-18
    -- forked from Daily Affiliate Fees @ https://flipsidecrypto.xyz/studio/queries/41959f50-148d-4d11-a7d6-d1c90fe176ef

    -- forked from banbannard / Affiliate Fee - RUNE @ https://flipsidecrypto.xyz/banbannard/q/Zqikq5qhAE20/affiliate-fee---rune

    WITH base AS (
    SELECT
    tx_id,
    DATE_TRUNC('week',block_timestamp) AS Week,
    affiliate_address,
    affiliate_fee_basis_points,
    split(from_asset, '-')[0] AS from_assets,
    CASE
    WHEN from_assets ILIKE '%/%' THEN split(from_assets, '/')[1]
    ELSE split(from_assets, '.')[1]
    END AS from_asset_names,
    split(to_asset, '-')[0] AS to_assets,
    CASE
    WHEN to_assets ILIKE '%/%' THEN split(to_assets, '/')[1]
    ELSE split(to_assets, '.')[1]
    END AS to_asset_names,
    concat(from_asset_names, ' -> ', to_asset_names) AS assets,
    CASE
    WHEN assets ILIKE '%RUNE' THEN 2
    ELSE 1
    END AS numbering,
    sum(from_amount_usd) AS swap_volume
    FROM
    thorchain.defi.fact_swaps
    WHERE
    week >= '2024-01-01'
    GROUP BY
    tx_id, week, affiliate_address, affiliate_fee_basis_points,
    from_asset, to_asset
    ),

    base2 AS (
    Last run: about 2 months agoAuto-refreshes every 12 hours
    WEEK
    Affiliate
    AFFILIATE_FEE_USD
    Cumulative Affiliate Fees
    WEEKLY_AFFILIATE_FEES
    1
    		2025-02-17 00:00:00.000Trust Wallet363682337902452050
    2
    		2025-02-17 00:00:00.000Asgardex56942337902452050
    3
    		2025-02-17 00:00:00.000Ledger48542337902452050
    4
    		2025-02-17 00:00:00.000-_17392337902452050
    5
    		2025-02-17 00:00:00.000Shapeshift12802337902452050
    6
    		2025-02-17 00:00:00.000Thorswap8362337902452050
    7
    		2025-02-17 00:00:00.000Thorwallet4392337902452050
    8
    		2025-02-17 00:00:00.000Vultisig2722337902452050
    9
    		2025-02-17 00:00:00.000XDEFI2632337902452050
    10
    		2025-02-17 00:00:00.000Zengo1652337902452050
    11
    		2025-02-17 00:00:00.000ro1202337902452050
    12
    		2025-02-17 00:00:00.000Edge Wallet72337902452050
    13
    		2025-02-17 00:00:00.000pxc52337902452050
    14
    		2025-02-17 00:00:00.000unizen-utxo42337902452050
    15
    		2025-02-17 00:00:00.000g132337902452050
    16
    		2025-02-17 00:00:00.000CS12337902452050
    17
    		2025-02-10 00:00:00.000Trust Wallet13721823326974212670
    18
    		2025-02-10 00:00:00.000Shapeshift2033323326974212670
    19
    		2025-02-10 00:00:00.000Asgardex1439223326974212670
    20
    		2025-02-10 00:00:00.000Ledger1049323326974212670
    ...
    1191
    68KB
    288s