msgs as (select msg_value:contract::string as address, date_trunc('month', block_timestamp) as month, msg_value[0]:feed_price as price

from terra.msgs

where msg_module = 'wasm'),

mirror as (select address, address_name, label

from terra.labels

where label = 'cw20Token'

group by 1,2,3)

select A.address, A.month, B.address_name, A.price

from msgs A

join mirror B on A.address = B.address