mariaaTotal Swap
    Updated 2024-10-21
    select
    SUM(COALESCE(FROM_AMOUNT_USD, TO_AMOUNT_USD)) as "Volume USD",
    COUNT(*) as swaps,
    count(distinct from_address) as users
    from thorchain.defi.fact_swaps
    where block_timestamp::DATE >= '2024-01-01'
    and affiliate_address in ('td','ti','tr','te')
    QueryRunArchived: QueryRun has been archived