select delegator_address, sum (event_amount_usd) as delegation_amount, date_trunc ('month', block_timestamp) as DATE

from terra.staking

where tx_status = 'SUCCEEDED'

group by delegator_address, date

),

swapper as (

select trader, sum (offer_amount_usd) as swap_amount, date_trunc ('month', block_timestamp) as time

from terra.swaps

where tx_status = 'SUCCEEDED'

group by trader, time

select count (trader), DATE

from delegators d

inner join swapper s on s.trader = d.delegator_address

where delegation_amount > 100

and swap_amount > 200

group by trader, DATE