date_trunc('week', block_timestamp) as week,

count(distinct tx_id) as tx_count

from terra.core.ez_transfers

where block_timestamp >= current_date - 180

group by week

order by week asc