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),

labels as

(select address, address_name

from terra.labels

group by 1,2)

select A.days, A.trade_count, A.swap_pair, A.trade_volume, B.address_name

from volume A

join labels B on A.label = B.address

where B.address_name = 'Terraswap mSPY-UST Pair'