adambalaMonthly Swap Volume
    Updated 2022-05-14
    with app as (
    SELECT origin_address ,
    tx_id,
    amount_usd ,
    date_trunc('month',block_timestamp) as date
    FROM ethereum.udm_events
    WHERE tO_LABEL ilike'%paraswap%' or to_address = '0xDEF171Fe48CF0115B1d80b88dc8eAB59176FEe57'
    or to_address = '0x1bd435f3c054b6e901b7b108a0ab7617c808677b' -- paraswap router

    and BLOCK_TIMESTAMP > '2021-01-01'
    )
    select
    count(distinct tx_id) as tx_id_number,
    count(distinct origin_address) as user_number,
    sum(amount_usd) as amount,
    date
    from app
    group by 4
    --having origin_function_name is not null
    Run a query to Download Data