Query editor
1SELECT 2date_trunc('week', block_time) as week 3, sum(price*COALESCE(amount_out, amount_in)/pow(10, decimals)) as swap_usd4FROM query_33797105group by 1
SELECT
date_trunc('week', block_time) as week
, sum(price*COALESCE(amount_out, amount_in)/pow(10, decimals)) as swap_usd
FROM query_3379710
group by 1