select

date as date_staked,

sum(balance) as staked_balance

from terra.daily_balances

where (balance_type = 'staked')

and address != 'terra1gr0xesnseevzt3h4nxr64sh5gk4dwrwgszx3nw'

and address != 'terra1dp0taj85ruc299rkdvzp4z5pfg6z6swaed74e6'

and address !='terra1fl48vsnmsdzcv85q5d2q4z5ajdha8yu3nln0mh'

and address != 'terra1wqmfu6w725sal3nvr0ggy49mmtwqgc6tyf4anp'

and address != 'terra1jgp27m8fykex4e4jtt0l7ze8q528ux2lh4zh0f'

and address != 'terra1mtwph2juhj0rvjz7dy92gvl6xvukaxu8rfv8ts'

and address != 'terra1jv65s3grqf6v6jl3dp4t6c9t9rk99cd8pm7utl'

and address != 'terra1tygms3xhhs3yv487phx3dw4a95jn7t7l8l07dr'

and currency = 'LUNA'

and date_staked >= CURRENT_DATE - 30

group by 1

), liquided as (

select

date as date_liquid,

sum(balance) as liquid_balance

from terra.daily_balances

where (balance_type = 'liquid')

and address != 'terra1gr0xesnseevzt3h4nxr64sh5gk4dwrwgszx3nw'

and address != 'terra1dp0taj85ruc299rkdvzp4z5pfg6z6swaed74e6'

and address !='terra1fl48vsnmsdzcv85q5d2q4z5ajdha8yu3nln0mh'

and address != 'terra1wqmfu6w725sal3nvr0ggy49mmtwqgc6tyf4anp'

and address != 'terra1jgp27m8fykex4e4jtt0l7ze8q528ux2lh4zh0f'

and address != 'terra1mtwph2juhj0rvjz7dy92gvl6xvukaxu8rfv8ts'

and address != 'terra1jv65s3grqf6v6jl3dp4t6c9t9rk99cd8pm7utl'

and address != 'terra1tygms3xhhs3yv487phx3dw4a95jn7t7l8l07dr'

and currency = 'LUNA'

and date_liquid >= CURRENT_DATE - 30

group by 1