Sbhn_NP2024-07-06 07:50 PM
    Updated 5 days ago
    --credits to Rayyyk for Affiliate addresses
    select
    count(DISTINCT tx_id) as txs,
    count(DISTINCT from_address) as users,
    sum(from_amount_usd) as usd_volume
    from thorchain.defi.fact_swaps
    where block_timestamp >= current_date-30
    and affiliate_address in ('t', 'T', 'thor160yye65pf9rzwrgqmtgav69n6zlsyfpgm9a7xk')

    Last run: 5 days ago
    TXS
    USERS
    USD_VOLUME
    1
    1728719773856.816370483
    1
    29B
    24s