mattkstewPRI Swaps 8
    Updated 2023-01-17


    with tab1 as (
    select
    date_trunc('day', block_timestamp) as date2,
    trader,
    count(*) as count1

    from terra.core.ez_swaps
    where to_currency like 'uluna'
    and to_amount/1e6 < 1e6
    and block_timestamp between '2023-01-09' and '2023-01-10'
    group by 1,2
    )


    select
    trader,
    sum(count1)

    from tab1
    where trader is not null
    group by 1
    order by 2 desc
    limit 10

    Run a query to Download Data