binhachon2. [Medium] Monthly Swap Volume - Percentage wise
Updated 2021-12-12
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
›
⌄
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
)
)