from anchor.reward_claims

where 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 sender in (select sender from anc)

group by 1

select *

from prov

order by anc desc