select date_trunc('day', block_timestamp) as dt, msg_value:contract::string as lp_token, sum(msg_value:execute_msg:send:amount/1e6) as vol
from terra.msgs
where msg_value:execute_msg:send:contract::string = 'terra1leadedadm2fguezmd4e445h6fe337yzq8n2dxf'
group by 1,2