JonasoTHORChain - traders I new
    Updated 2024-10-09
    with

    A as(
    select from_address as trader, blockchain, min(block_timestamp) as time
    from thorchain.defi.fact_swaps
    group by 1,2 ),

    B as(
    select date_trunc('day',time) as time, '(Δ) new traders' as type,
    count(distinct trader) as trader
    from A
    where year(time) = '2024'
    group by 1,2)

    select *,
    '(Σ) new traders' as cate, sum(trader) over(order by time) as total
    from B
    order by 1 desc







    QueryRunArchived: QueryRun has been archived