from anchor.reward_claims

where block_timestamp between '2022-01-01' and '2022-01-31'

group by 1),

stake as (select msg_value:sender::string as sender, sum(msg_value:execute_msg:send:amount/1e6) as stake_anc

from terra.msgs

where msg_value:sender::string in (select sender from anc) and msg_value:execute_msg:send:contract::string = 'terra1f32xyep306hhcxxxf7mlyh0ucggc00rm2s9da5'

and msg_value:contract::string = 'terra14z56l0fp2lsf86zy3hty2z47ezkhnthtr9yq76' and block_timestamp between '2022-01-01' and '2022-01-31'

group by 1),

prov as (select event_attributes:sender::string as sender, sum(event_attributes:assets[0]:amount/1e6) as anc, sum(event_attributes:assets[1]:amount/1e6) as ust

from terra.msg_events

WHERE event_attributes:"0_contract_address" = 'terra1qr2k6yjjd5p2kaewqvg93ag74k6gyjr7re37fs' AND event_attributes:"0_action" = 'provide_liquidity'

and event_type = 'from_contract' and block_timestamp between '2022-01-01' and '2022-01-31' and tx_status = 'SUCCEEDED' and sender in (select sender from anc)

group by 1

),

sold as (select event_attributes:sender::string as sender, sum(event_attributes:amount/1e6) as ANC_sold

from terra.msg_events

where event_attributes:"1_action"::string = 'swap' and event_attributes:offer_asset::string = 'terra14z56l0fp2lsf86zy3hty2z47ezkhnthtr9yq76'

and block_timestamp between '2022-01-01' and '2022-01-31' and event_attributes:"1_contract_address"::string = 'terra1qr2k6yjjd5p2kaewqvg93ag74k6gyjr7re37fs'

and tx_status = 'SUCCEEDED' and sender in (select sender from anc)

group by 1)

select 'provide_lp' as actions, count(sender) as user_count, sum(anc) as ANC_amount

from prov

group by 1

select 'stake' as actions, count(sender) as user_count, sum(stake_ANC) as ANC_amount

from stake

group by 1

select 'sold' as actions, count(sender) as user_count, sum(anc_sold) as anc_amount

from sold