Skip to content
Dune Analytics

@k06a / DEX gas comparison

SQL query

1SELECT
2    CASE
3        WHEN zzz.to = '\xA2B47E3D5c44877cca798226B7B8118F9BFb7A56' THEN 'Curve Compound'
4        WHEN zzz.to = '\x52EA46506B9CC5Ef470C5bf89f17Dc28bB35D85C' THEN 'Curve USDT'
5        WHEN zzz.to = '\x45F783CCE6B7FF23B2ab2D70e416cdb7D6055f51' THEN 'Curve Y'
6        WHEN zzz.to = '\x79a8C46DeA5aDa233ABaFFD40F3A0A2B1e5A4F27' THEN 'Curve Binance'
7        WHEN zzz.to = '\xA5407eAE9Ba41422680e2e00537571bcC53efBfD' THEN 'Curve Synthetix'
8        WHEN zzz.to = '\x06364f10B501e868329afBc005b3492902d6C763' THEN 'Curve PAX'
9        WHEN zzz.to = '\x8474c1236F0Bc23830A23a41aBB81B2764bA9f4F' THEN 'Curve renBTC'
10        WHEN zzz.to = '\x9726e9314eF1b96E45f40056bEd61A088897313E' THEN 'Curve tBTC'
11        WHEN zzz.to = '\x03eF3f37856bD08eb47E2dE7ABc4Ddd2c19B60F2' THEN 'dForce XSwap'
12        WHEN zzz.to = '\x818E6FECD516Ecc3849DAf6845e3EC868087B755' THEN 'Kyber'
13        WHEN zzz.to IN (SELECT exchange_address FROM uniswap."view_new_exchange") THEN 'Uniswap'
14        WHEN zzz.to IN (SELECT contract_address FROM compound."view_ctokens") THEN 'Compound'
15        WHEN zzz.to = '\x398eC7346DcD622eDc5ae82352F02bE94C62d119' OR zzz.to IN (SELECT contract_address FROM aave."view_atokens") THEN 'Aave'
16        WHEN zzz.to IN (SELECT pool FROM balancer."BFactory_evt_LOG_NEW_POOL") THEN 'Balancer'
17        WHEN zzz.to IN (SELECT pair FROM uniswap_v2."Factory_evt_PairCreated") THEN 'Uniswap V2'
18        WHEN zzz.to = '\x6a4FFAafa8DD400676Df8076AD6c724867b0e2e8' THEN 'BDAI'
19        WHEN zzz.to = '\x06AF07097C9Eeb7fD685c692751D5C66dB49c215' THEN 'CHAI'
20        WHEN zzz.to IN (SELECT DISTINCT contract_address FROM fulcrum."iToken_evt_OwnershipTransferred") THEN 'Fulcrum'
21        WHEN zzz.to IN ( -- IDLE
22            '\x78751b12da02728f467a44eac40f5cbc16bd7934',
23            '\x12B98C621E8754Ae70d0fDbBC73D6208bC3e3cA6',
24            '\x63D27B3DA94A9E871222CB0A32232674B02D2f2D',
25            '\x1846bdfDB6A0f5c473dEc610144513bd071999fB',...

SQL query results

Loading