Spot-WiggumThorswap/ SwapKit Daily Volume
    Updated 2 days ago
    -- forked from SwapKit Affiliates Daily Volumes @ https://flipsidecrypto.xyz/studio/queries/1fe30f14-c134-4e6d-ab12-7f2b5e4f6b84

    -- forked from SwapKit Affiliates Daily Volumes @ https://flipsidecrypto.xyz/studio/queries/68248f53-fea9-40d9-a15a-d5a6efcd4ef4

    WITH attempted_txs AS (
    SELECT
    DISTINCT tx_id,
    block_timestamp,
    from_address,
    from_amount_usd,
    affiliate_address
    FROM
    thorchain.defi.fact_swaps
    WHERE
    block_timestamp >= '2024-01-01'
    ),
    successful_txs AS (
    SELECT *
    FROM attempted_txs AS a
    WHERE NOT EXISTS (
    SELECT 1
    FROM thorchain.defi.fact_refund_events AS r
    WHERE r.tx_id = a.tx_id
    )
    ),
    affiliate_swaps AS (
    SELECT
    DISTINCT tx_id,
    block_timestamp::date AS day,
    from_address,
    from_amount_usd,
    affiliate_address,
    CASE
    WHEN affiliate_address IN ('t', 'T', 'ts', 'thor160yye65pf9rzwrgqmtgav69n6zlsyfpgm9a7xk','thor17suv0n437snv68axkx64whutkrvefv7pzq7xep') THEN 'Thorswap'
    WHEN affiliate_address IN ('tl','ej','lifi','okw','sy','oky','xdf','cb','pl','zengo','bqx','bp','ELD') THEN 'SwapKit'
    ELSE 'Unknown Affiliate'
    Last run: 2 days agoAuto-refreshes every 12 hours
    DAY
    AFFILIATE_NAME
    SWAP_COUNT
    Swap Volume
    1
    2025-02-16 00:00:00.000SwapKit1202161339
    2
    2025-02-16 00:00:00.000Thorswap223893
    3
    2025-02-15 00:00:00.000SwapKit1974960134
    4
    2025-02-15 00:00:00.000Thorswap264417
    5
    2025-02-14 00:00:00.000SwapKit2924250836
    6
    2025-02-14 00:00:00.000Thorswap33384598
    7
    2025-02-13 00:00:00.000SwapKit4824428817
    8
    2025-02-13 00:00:00.000Thorswap264199
    9
    2025-02-12 00:00:00.000SwapKit2563571298
    10
    2025-02-12 00:00:00.000Thorswap38295784
    11
    2025-02-11 00:00:00.000SwapKit2024591281
    12
    2025-02-11 00:00:00.000Thorswap416167
    13
    2025-02-10 00:00:00.000SwapKit1701976124
    14
    2025-02-10 00:00:00.000Thorswap335459
    15
    2025-02-09 00:00:00.000SwapKit1982318502
    16
    2025-02-09 00:00:00.000Thorswap344368
    17
    2025-02-08 00:00:00.000SwapKit1212361450
    18
    2025-02-08 00:00:00.000Thorswap42146660
    19
    2025-02-07 00:00:00.000SwapKit1943661807
    20
    2025-02-07 00:00:00.000Thorswap283604
    ...
    826
    40KB
    10s