flipside

    Thorswap Affiliate Fees (7d)
    Spot-WiggumThorswap Affiliate Fees (7d)
    Updated 2025-02-16
    -- forked from Thorswap Affiliate Fees (30d) @ https://flipsidecrypto.xyz/studio/queries/66f000eb-101d-49f4-bd73-0da1ed2720fa

    -- forked from Thorswap Daily Affiliate Fees @ https://flipsidecrypto.xyz/studio/queries/f40dc6ce-657b-4046-9ef3-a33ea1eb8e93

    -- 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,
    block_timestamp::date AS day,
    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
    block_timestamp >= CURRENT_DATE - INTERVAL '7 days'
    GROUP BY
    tx_id, day, affiliate_address, affiliate_fee_basis_points,
    Last run: 2 months agoAuto-refreshes every 12 hours
    DAY
    Affiliate
    AFFILIATE_FEE_USD
    Cumulative Affiliate Fees
    1
    		2025-02-16 00:00:00.000Thorswap00
    2
    		2025-02-15 00:00:00.000Thorswap00
    3
    		2025-02-14 00:00:00.000Thorswap00
    4
    		2025-02-13 00:00:00.000Thorswap00
    5
    		2025-02-12 00:00:00.000Thorswap00
    6
    		2025-02-11 00:00:00.000Thorswap00
    7
    		2025-02-10 00:00:00.000Thorswap00
    8
    		2025-02-09 00:00:00.000Thorswap00
    8
    345B
    8s