niloMonthly Swap Volume on ParaSwap
    Updated 2022-05-09
    select
    date_trunc('month',block_timestamp) as monthly,
    sum(amount_usd) as swap_volume
    from ethereum.dex_swaps
    where (from_address ilike '0x1bD435F3C054b6e901B7b108a0ab7617C808677b' or -- ILIKE, For case-insensitive matching
    from_address ilike '0x86969d29f5fd327e1009ba66072be22db6017cc6' or
    from_address ilike '0x9509665d015bfe3c77aa5ad6ca20c8afa1d98989' or
    from_address ilike '0xf90e98f3d8dce44632e5020abf2e122e0f99dfab' or
    from_address ilike '0xdef171fe48cf0115b1d80b88dc8eab59176fee57'
    ) --- paraswap contract address v1+v2+v3+v4+v5
    and block_timestamp >= CURRENT_DATE - 365
    group by 1
    order by 1 DESC
    Run a query to Download Data