Dune Analytics website

Similar Posts

One Comment

  1. I guess the query for the line chart should be something like (the one in the post contains syntax errors):

    SELECT
    date_trunc(‘day’, block_time) AS day,
    SUM(usd_amount) AS usd_volume
    FROM dex.trades
    WHERE block_time > now() – interval ‘7 days’
    AND project = ‘Uniswap’
    GROUP BY 1

Leave a Reply

Your email address will not be published. Required fields are marked *