Abbas_ra21Total Stats 2
    Updated 2024-10-06
    select
    COUNT(*) AS total_swaps,
    sum(case when FROM_AMOUNT_USD is null then TO_AMOUNT_USD else FROM_AMOUNT_USD end) AS Volume,
    count(DISTINCT FROM_ADDRESS) AS Swappers
    FROM
    thorchain.defi.fact_swaps where block_timestamp::date between '{{START_DATE}}' and '{{END_DATE}}'


    Last run: 2 months ago
    TOTAL_SWAPS
    VOLUME
    SWAPPERS
    1
    1852111545736438635.0224294712
    1
    36B
    3s