select

date(block_timestamp) as day,

label_type,

project_name,

tx_id,

tx:body:messages[0]:amount[0]:amount/1e6 as volume

from

terra.core.fact_transactions a join

terra.core.dim_address_labels b on

a.tx:body:messages[0]:to_address = b.address

where

tx_succeeded

select

day,

project_name,

count(distinct tx_id) as number_of_transactions,

sum(volume) as total_volume

from

dapp_trans

group by

day,

project_name