date_trunc('day', block_timestamp) AS days,

COUNT(DISTINCT tx_id) AS trade_count,

msg_value:execute_msg:swap:offer_asset:info:native_token:denom::string as swap_pair,

sum(msg_value:execute_msg:swap:offer_asset:amount / POW(10,6)) as trade_volume,

msg_value:contract::string as label

from terra.msgs

where msg_value:execute_msg:swap IS NOT NULL

group by 1,3,5