SELECT address,

address_name

FROM terra.labels

where address_name like 'm%'

and label = 'cw20Token'

),

prices as (

select date_trunc('hour', block_timestamp) as hour,

currency,

avg(price_usd) as price

from terra.oracle_prices

WHERE block_timestamp <= '2021-03-10'

AND block_timestamp >= '2021-02-10'

group by 1,2

),

transfers as (

SELECT

block_timestamp,

msg_value:contract::string as token_contract,

msg_value:execute_msg:transfer:amount / pow(10, 6) as volume

FROM terra.msgs

WHERE msg_value:execute_msg:transfer IS NOT NULL

AND block_timestamp <= '2021-03-10'

AND block_timestamp >= '2021-02-10'

and tx_status = 'SUCCEEDED'

and msg_value:execute_msg:transfer:amount IS NOT NULL

date_trunc('day', block_timestamp) AS date,

address_name,

SUM(coalesce(volume,0) * coalesce(price,0)) AS volumes

FROM transfers