Sbhn_NPPools Summary by Volume Generated
    Updated 2024-12-21
    select POOL_NAME,
    count(DISTINCT tx_id) as txs,
    count(DISTINCT from_address) as users,
    sum(coalesce(from_amount_usd,to_amount_usd)) AS usd
    from thorchain.defi.fact_swaps
    where block_timestamp::date >= '2024-01-01'
    group by 1
    order by 4 desc
    QueryRunArchived: QueryRun has been archived