binhachon3. [Easy] Monthly Swap Volume - Change in volume
    Updated 2021-12-08
    select
    blocktime,
    coalesce(
    volume - lag(volume) over (
    order by
    blocktime
    ),
    0
    ) as change_from_last_month
    from
    (
    select
    date_trunc('Month', block_timestamp) as blocktime,
    sum(amount_usd) as volume
    from
    ethereum.dex_swaps
    where
    token_address = '0xff56cc6b1e6ded347aa0b7676c85ab0b3d08b0fa'
    group by
    blocktime
    )