freemartianActive Monthly Wallets - kian
    Updated 2022-05-05
    with delegators as (
    select delegator_address, sum (event_amount) as amount, date_trunc('month', block_timestamp) as time
    from terra.staking
    group by delegator_address, time
    ),

    traders as (
    select trader, count (tx_id) as count, date_trunc('month', block_timestamp) as date
    from terra.swaps
    group by trader, date
    )


    select count(delegator_address), date
    from delegators d
    inner join traders t on d.delegator_address = t.trader
    where d.amount > 1
    and t.count > 10
    group by date


    Run a query to Download Data