select

date(block_timestamp) as date,

count(distinct(msg_value:sender::string)) as stakers,

sum((msg_value:coins[0]:amount::float)/POW(10,6)) as delegated

from terra.msgs

where

(msg_value:contract::string in ('terra1lcxlju5rz80n3aw47mmh8yrfx2e57emk0gslne')

or msg_value:contract::string in ('terra1alp4kyegj3amt8v27h7rnlz8tajqrv5afgyf4t')

or msg_value:contract::string in ('terra1437hnjajlgmcwzyqw58r03he3smhz90u6j7j3y')

or msg_value:contract::string in ('terra15jlw2ac884q4j2mt8ytwzk4v5xhgkm0pj6gkqf')

--or msg_value:contract::string in ('terra1yd3s7nrcus38pm6spzjs8gdlmfwezu3g93mpmf')

or msg_value:contract::string in ('terra1r2txa0skwmfgvf5ytefzfzhrkrkadp7v0jue27')

or msg_value:contract::string in ('terra1cpkk48dug6gc23kq4tqp4w7qe4pf3n898dujr8')

or msg_value:contract::string in ('terra167szfqgnqpezer5tfzf9f0uqj3lw6t59y2f3ej')

or msg_value:contract::string in ('terra1smgqsx87cd9q62pa6mrvmydayxd2jegys3cd2d')

or msg_value:contract::string in ('terra1wtxc4vfk8r9rdullaqm5euxvqs3javdkyy0pz9')

or msg_value:contract::string in ('terra1ndfl6uwa2ws3c85yz957r2hrjd0z32mstdusfm'))

and msg_value:execute_msg:deposit is not NULL

and tx_status = 'SUCCEEDED'

and date(block_timestamp) >= date('2022-02-16')

--and date(block_timestamp) >= current_date - INTERVAL '30 days'

group by 1

having delegated > 0

order by 1

),

plus_undelegations as (

select

date(block_timestamp) as date,

count(distinct(msg_value:sender::string)) as unstakers,

sum((msg_value:execute_msg:queue_undelegate:amount::float)/POW(10,6)) as undelegated

from terra.msgs

where

(msg_value:contract::string in ('terra1lcxlju5rz80n3aw47mmh8yrfx2e57emk0gslne')

or msg_value:contract::string in ('terra1alp4kyegj3amt8v27h7rnlz8tajqrv5afgyf4t')