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 ('terra1mgps0vvjgrqaertyhruwrjhe7s629x27rrd3h7')

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 ('terra1cnth3ullee676gdaa3ejwqycgc2zpdz7snz322')

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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