select date_trunc ('week', block_timestamp) as fecha,

min(price_usd) as min_price,

avg(price_usd) as avg_price,

max(price_usd) as max_price

from terra.oracle_prices

where fecha >= '2021-01-01' and fecha < '2021-12-31'

and currency = 'uluna'

group by 1

order by 1 desc

),

cte_liquid_luna as (

select sum (balance) as liquid_balance, --address as wallet_address_liquid,

date as date_liquid

from terra.daily_balances

where date_liquid >= '2021-01-01' and date_liquid < '2021-12-31'

and currency = 'LUNA'

and balance_type = 'liquid'

and address != 'terra1gr0xesnseevzt3h4nxr64sh5gk4dwrwgszx3nw' -- LFG

and address != 'terra1dp0taj85ruc299rkdvzp4z5pfg6z6swaed74e6' -- TFL

and address != 'terra1wqmfu6w725sal3nvr0ggy49mmtwqgc6tyf4anp' -- A: Luna Incentives Distribution

and address != 'terra1jgp27m8fykex4e4jtt0l7ze8q528ux2lh4zh0f' -- CM: Oracle Rewards

and address != 'terra1fl48vsnmsdzcv85q5d2q4z5ajdha8yu3nln0mh' -- CM: Bonded Luna

--and address != 'terra1mtwph2juhj0rvjz7dy92gvl6xvukaxu8rfv8ts' -- C: BLuna Hub

and address != 'terra1jv65s3grqf6v6jl3dp4t6c9t9rk99cd8pm7utl' -- CM: Account Distribution

and address != 'terra1tygms3xhhs3yv487phx3dw4a95jn7t7l8l07dr' -- CM: Not Bonded Tokens Pool

group by 2

),

cte_staked_luna as (

select sum(balance) as staked_balance, --address as wallet_address_staked,

date as date_staked

from terra.daily_balances

where date_staked >= '2021-01-01' and date_staked < '2021-12-31'

and currency = 'LUNA'