select trunc(block_timestamp,'day') as date,

project_name,

sum(amount/pow(10,6)) as volume_transferred

from terra.core.ez_transfers x

join terra.core.dim_address_labels y on x.receiver=y.address

where block_timestamp>=current_date - 30 and currency='uluna'

group by 1,2