select

attributes:transfer:amount/1e6 as amount,

attributes:transfer:currency as currency,

attributes:transfer:recipient as recipient,

attributes:transfer:sender as sender,

*

from terra.core.ez_messages

where 1=1

-- and tx_id in ('F4CEEEEB84870A847CA36EB06CB0811D9DD7AD5600C9FB0B090AC3E47EFF1452'

-- ,'6328CE1E11E0938A7040A5BABA51C9224823AABD8FEF18957A61A3BBDF35285B'

-- )

and message_value:msg:execute:proposal_id is not null

and amount > 0

),

proposals as (

select

e.message_value:content:title as title,

e.message_value:content:description as description,

e.message_value:content:recipient as recipient,

p.proposal_id,

p.proposal_type,

p.tx_id as proposal_txn,

p.block_timestamp as proposal_time, *

from terra.core.fact_governance_submit_proposal p

join terra.core.ez_messages e using (tx_id)

-- where p.proposal_type = 'CommunityPoolSpend'

),

tfs as (

select

amount/1e6 as amt,

sum(amt) over (order by block_timestamp asc rows between unbounded preceding and current row) as total_amt,

*

from terra.core.ez_transfers

where sender = 'terra1exqfh9ahyzm9g8z3ce57eyuxx72vem63utepjsf6stqtrztyz58spaf8ew'