SELECT
date_trunc('day', block_timestamp),
SUM(AMOUNT1_ADJUSTED)
FROM
ethereum.uniswapv3.ez_swaps
WHERE
pool_address = '0xc63b0708e2f7e69cb8a1df0e1389a98c35a76d52' -- FXS/USDC pool
AND block_timestamp > current_timestamp - interval '{{num_days}} days'
AND AMOUNT1_ADJUSTED > 0
GROUP BY
1