binhachon2. [Medium] Monthly Swap Volume - Percentage wise
    Updated 2021-12-12
    with paraswap_contracts as(
    select
    '0x86969d29f5fd327e1009ba66072be22db6017cc6' as contract_address --Source: https://twitter.com/paraswap/status/1268915221906808832 'Paraswap v1'
    union
    select
    '0x9509665d015bfe3c77aa5ad6ca20c8afa1d98989' as contract_address --Source: Paraswap deployer 2 https://etherscan.io/address/0xe6b692dcc972b9a5c3c414ac75ddc420b9edc92d 'Paraswap v2'
    union
    select
    '0xf90e98f3d8dce44632e5020abf2e122e0f99dfab' as contract_address --Source: Paraswap deployer 2 https://etherscan.io/address/0xe6b692dcc972b9a5c3c414ac75ddc420b9edc92d 'Paraswap v3'
    union
    select
    '0x1bd435f3c054b6e901b7b108a0ab7617c808677b' as contract_address --Source: Paraswap deployer 2 https://etherscan.io/address/0xe6b692dcc972b9a5c3c414ac75ddc420b9edc92d 'Paraswap v4'
    union
    select
    '0xdef171fe48cf0115b1d80b88dc8eab59176fee57' as contract_address --'Paraswap v5'
    union
    select
    distinct from_address as contract_address
    from
    ethereum.udm_events
    where
    from_label = 'paraswap'
    ),
    paraswap_transactions as(
    select
    distinct tx_id
    from
    ethereum.udm_events
    where
    from_address in (
    select
    contract_address
    from
    paraswap_contracts
    )
    )