RayyykVultisig Maya (Volume & Fee)
    Updated 11 hours ago
    with table_1 as (select date_trunc('day', block_timestamp) as day,
    affiliate_address,
    affiliate_fee_basis_points,
    from_address,
    tx_id,
    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 '%CACAO' then 2
    else 1
    end as numbering,
    sum(from_amount_usd/cacao_usd) as cacao_volume,
    sum(from_amount_usd) as usd_volume
    from maya.defi.fact_swaps
    where affiliate_address in ('vi', 'va', 'v0')
    group by 1,2,3,4,5,6,7,8),

    table_2 as (select day,
    from_address,
    tx_id,
    affiliate_address,
    affiliate_fee_basis_points,
    array_agg(distinct assets) within group (order by assets desc) as swap_direction,
    sum(cacao_volume) as swap_volume_cacao,
    sum(usd_volume) as swap_volume_usd
    from table_1
    group by 1,2,3,4,5),

    Last run: about 11 hours ago
    DATE
    Affiliates
    SWAPPER_COUNT
    TX_COUNT
    Affiliate Fee in CACAO
    Cumu Affiliate Fee in CACAO
    Affiliate Fee in USD
    Cumu Affiliate Fee in USD
    VOLUME_USD
    CUMU_VOLUME_USD
    TOTAL_VOLUME
    TOTAL_FEE
    TOTAL_TX
    START_DATE
    END_DATE
    1
    2025-03-01 00:00:00.000Vultisig (iOS)1012159669.4757237712610554.91387093220.3207385329910.01257456544064.1477063311982002.514913052538848.6141786212694.24307089350108/01/20242025-03-19 00:00:00.000
    2
    2025-03-01 00:00:00.000Vultisig (Web)226228.0859166511668.8990995018.28206275722.870007251656.412551384574.0014500982538848.6141786212694.24307089350108/01/20242025-03-19 00:00:00.000
    3
    2025-03-01 00:00:00.000Vultisig (Android)5711137.835590678583590.76014265615.5627308972761.3604890773112.546179377552272.0978154762538848.6141786212694.24307089350108/01/20242025-03-19 00:00:00.000
    4
    2025-02-01 00:00:00.000Vultisig (iOS)57101752124.1390076882450885.438147151792.0361665139689.691836034358407.233302661937938.367206722538848.6141786212694.24307089350108/01/20242025-03-19 00:00:00.000
    5
    2025-02-01 00:00:00.000Vultisig (Web)115440.813182855440.8131828514.58794449414.5879444942917.5888987172917.5888987172538848.6141786212694.24307089350108/01/20242025-03-19 00:00:00.000
    6
    2025-02-01 00:00:00.000Vultisig (Android)1951140506.425996991572452.924551977393.2662947762745.7977581878653.258955227549159.5516360992538848.6141786212694.24307089350108/01/20242025-03-19 00:00:00.000
    7
    2025-01-01 00:00:00.000Vultisig (iOS)5291899653.1146720911698761.299139473202.0215811567897.65566952640404.3162312781579531.133904062538848.6141786212694.24307089350108/01/20242025-03-19 00:00:00.000
    8
    2025-01-01 00:00:00.000Vultisig (Android)152485115.853703068431946.498554986334.9282518932352.53146340466985.650378599470506.2926808712538848.6141786212694.24307089350108/01/20242025-03-19 00:00:00.000
    9
    2024-12-01 00:00:00.000Vultisig (iOS)3959398358.337535853799108.1844673752433.7939042024695.634088364486758.780840311939126.8176727842538848.6141786212694.24307089350108/01/20242025-03-19 00:00:00.000
    10
    2024-12-01 00:00:00.000Vultisig (Android)164559071.118951971346830.644851918341.2577797772017.60321151168251.55595537403520.6423022732538848.6141786212694.24307089350108/01/20242025-03-19 00:00:00.000
    11
    2024-11-01 00:00:00.000Vultisig (iOS)101655325.519961792400749.846931522343.3644811482261.84018416268672.896229699452368.0368324732538848.6141786212694.24307089350108/01/20242025-03-19 00:00:00.000
    12
    2024-11-01 00:00:00.000Vultisig (Android)263693125.092844175287759.525899946602.6109255211676.345431735120522.185104207335269.0863469032538848.6141786212694.24307089350108/01/20242025-03-19 00:00:00.000
    13
    2024-10-01 00:00:00.000Vultisig (iOS)1020344444.251969731345424.3269697311912.8109483251918.475703014382562.18966507383695.1406027742538848.6141786212694.24307089350108/01/20242025-03-19 00:00:00.000
    14
    2024-10-01 00:00:00.000Vultisig (Android)1527191549.587848216194634.4330557711055.9325010091073.734506213211186.500201823214746.9012426962538848.6141786212694.24307089350108/01/20242025-03-19 00:00:00.000
    15
    2024-09-01 00:00:00.000Vultisig (iOS)12671.625980.0753.7515497685.664754689750.309953651132.9509377042538848.6141786212694.24307089350108/01/20242025-03-19 00:00:00.000
    16
    2024-09-01 00:00:00.000Vultisig (Android)463084.8452075553084.84520755517.80200520417.8020052043560.4010408733560.4010408732538848.6141786212694.24307089350108/01/20242025-03-19 00:00:00.000
    17
    2024-08-01 00:00:00.000Vultisig (iOS)11308.45308.451.913204921.91320492382.640984054382.6409840542538848.6141786212694.24307089350108/01/20242025-03-19 00:00:00.000
    17
    4KB
    57s