msg_value:execute_msg:auto_stake:assets[0]:info:token:contract_addr::string as massets,

sum((msg_value:coins[0]:amount/1e6)*2) as amount_usd,

count(distinct tx_id) as tx_count

from terra.msgs

where msg_value:contract::string = 'terra17f7zu97865jmknk7p2glqvxzhduk78772ezac5' and block_timestamp >= CURRENT_DATE - 30

group by 1,2),

labels as (select address, address_name

from terra.labels

where address in (select massets from raw)

),

price as (select date_trunc('day', block_timestamp) as dt, currency, avg(price_usd) as price

from terra.oracle_prices

where currency in (select massets from raw)

group by 1,2)

select a.dt, b.address_name, c.price

from raw a

join labels b on a.massets = b.address

join price c on a.dt = c.dt and b.address = c.currency