'Changing timeframe in query from 'now' to a specific date in Dune Analytics

how can I change the "now () - interval '365days'" to a "specific date () - interval '365 days'"? thank you

select avg(usd_volume) from
(
SELECT
    date_trunc('day', block_time) AS day,
    SUM(usd_amount) AS usd_volume
FROM dex.trades
WHERE block_time > now() - interval '365days'
AND project = 'Curve'
GROUP BY 1
ORDER BY 1
)x
sql


Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution Source

Related Questions