select

block_timestamp,

tx_id,

voter,

PROPOSAL_ID,

vote_option,

vote_weight,

case

when vote_option = '1' then 'Yes'

when vote_option = '2' then 'Abstain'

when vote_option = '3' then 'No'

when vote_option = '4' then 'No With Veto'

end as vote_type

from terra.core.fact_governance_votes

where tx_succeeded = 'TRUE'

and vote_option is not null

),

lunaPriceTb as (

select

block_timestamp::date as p_date,

median(to_amount/from_amount) as "LUNA2.0 Price($)"

from terra.core.ez_swaps

where from_currency = 'uluna'

and to_currency in ('ibc/CBF67A2BCF6CAE343FDF251E510C8E18C361FC02B23430C121116E0811835DEF',

'ibc/B3504E092456BA618CC28AC671A71FB08C6CA0FD0BE7C8A5B5A3E2DD933CC9E4') --USDC,USDT

and to_amount > 0

and from_amount > 0

and tx_succeeded = TRUE

group by 1

)

, inflow as (

SELECT

block_timestamp::date as date,

RECEIVER as user,

sum(amount/pow(10,6)) as volume_in,