freemartianBase Criteria - kimia
    Updated 2022-05-05
    with delegators as (
    select delegator_address, sum (event_amount) as amount, date_trunc('day', block_timestamp) as date
    from terra.staking
    group by delegator_address, date
    ),

    Fdelefators as(
    select delegator_address
    from delegators
    WHERE amount > 1
    ),

    traders as (
    select trader, count (tx_id) as count, date_trunc('day', block_timestamp) as date
    from terra.swaps
    group by trader, date
    ),
    ftraders as (
    select trader
    from traders
    where count > 10
    )

    select count(delegator_address), date_trunc('day', block_timestamp) as date
    from Fdelefators
    inner join ftraders on Fdelefators.delegator_address = ftraders.trader

    Run a query to Download Data