date_trunc('day', block_timestamp) AS date,

count(tx_id) as total_transactions

FROM terra.msgs

WHERE (msg_value:contract = 'terra1jsxngqasf2zynj5kyh0tgq9mj3zksa5gk35j4k'

OR msg_value:contract = 'terra1h8arz2k547uvmpxctuwush3jzc8fun4s96qgwt'

OR msg_value:contract = 'terra165nd2qmrtszehcfrntlplzern7zl4ahtlhd5t2'

OR msg_value:contract = 'terra1vxtwu4ehgzz77mnfwrntyrmgl64qjs75mpwqaz'

OR msg_value:contract = 'terra1g4x2pzmkc9z3mseewxf758rllg08z3797xly0n'

OR msg_value:contract = 'terra1qelfthdanju7wavc5tq0k5r0rhsyzyyrsn09qy'

OR msg_value:contract = 'terra18ej5nsuu867fkx4tuy2aglpvqjrkcrjjslap3z'

OR msg_value:contract = 'terra1qqfx5jph0rsmkur2zgzyqnfucra45rtjae5vh6'

OR msg_value:contract = 'terra1w7zgkcyt7y4zpct9dw8mw362ywvdlydnum2awa'

OR msg_value:contract = 'terra18wayjpyq28gd970qzgjfmsjj7dmgdk039duhph'

OR msg_value:contract = 'terra1rhhvx8nzfrx5fufkuft06q5marfkucdqwq5sjw'

OR msg_value:contract = 'terra19ya4jpvjvvtggepvmmj6ftmwly3p7way0tt08r'

OR msg_value:contract = 'terra1dk3g53js3034x4v5c3vavhj2738une880yu6kx'

OR msg_value:contract = 'terra1l5lrxtwd98ylfy09fn866au6dp76gu8ywnudls'

OR msg_value:contract = 'terra10h7ry7apm55h4ez502dqdv9gr53juu85nkd4aq'

OR msg_value:contract = 'terra1m6j6j9gw728n82k78s0j9kq8l5p6ne0xcc820p'

OR msg_value:contract = 'terra137drsu8gce5thf6jr5mxlfghw36rpljt3zj73v'

OR msg_value:contract = 'terra1csk6tc7pdmpr782w527hwhez6gfv632tyf72cp'

OR msg_value:contract = 'terra1kscs6uhrqwy6rx5kuw5lwpuqvm3t6j2d6uf2lp'

OR msg_value:contract = 'terra1aa00lpfexyycedfg5k2p60l9djcmw0ue5l8fhc'

OR msg_value:contract = 'terra1u43zu5amjlsgty5j64445fr9yglhm53m576ugh'

OR msg_value:contract = 'terra14y5affaarufk3uscy2vr6pe6w6zqf2wpjzn5sh'

OR msg_value:contract = 'terra1cc3enj9qgchlrj34cnzhwuclc4vl2z3jl7tkqg'

OR msg_value:contract = 'terra19cmt6vzvhnnnfsmccaaxzy2uaj06zjktu6yzjx'

OR msg_value:contract = 'terra1lvmx8fsagy70tv0fhmfzdw9h6s3sy4prz38ugf'

OR msg_value:contract = 'terra1mqsjugsugfprn3cvgxsrr8akkvdxv2pzc74us7'

OR msg_value:contract = 'terra1jxazgm67et0ce260kvrpfv50acuushpjsz2y0p'

OR msg_value:contract = 'terra1pn20mcwnmeyxf68vpt3cyel3n57qm9mp289jta'

OR msg_value:contract = 'terra178jydtjvj4gw8earkgnqc80c3hrmqj4kw2welz'

OR msg_value:contract = 'terra1tn8ejzw8kpuc87nu42f6qeyen4c7qy35tl8t20'

OR msg_value:contract = 'terra1gm5p3ner9x9xpwugn9sp6gvhd0lwrtkyrecdn3'

OR msg_value:contract = 'terra1tndcaqxkpc5ce9qee5ggqf430mr2z3pefe5wj6'