pecio222AOA ANY with bots
Updated 2025-01-16
999
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 lfj_frontend_odos as (
select
tx_hash
from
avalanche.core.ez_decoded_event_logs
where
contract_address = '0x88de50b233052e4fb783d4f6db78cc34fea3e9fc'
and DECODED_LOG ['referralCode'] = 1061215132
),
ALL_DATA as (
SELECT
DATE_TRUNC('DAY', block_timestamp) AS DAY,
CASE
WHEN ORIGIN_TO_ADDRESS = '0x22c81c051a134c81ce370d82fa26975ae9d100b4' THEN 'Pharaoh native'
WHEN ORIGIN_TO_ADDRESS = '0xc0315638c75564e1e9ac26584d4251fd170a54cc' THEN 'Trading vault1'
WHEN ORIGIN_TO_ADDRESS = '0xf669de31ddda51c43fe1620ff1fb9d0ac65c5329' THEN 'Trading vault2'
WHEN ORIGIN_TO_ADDRESS = '0xd77aaf23784948e914d295b1c6098b7405ab9a68' THEN 'UNKNOWN_BOTS'
WHEN ORIGIN_TO_ADDRESS = '0xb14b5603fdf365d435395d89ab4b1ca6f58e79fe' THEN 'UNKNOWN_BOTS'
WHEN ORIGIN_TO_ADDRESS = '0xfbb60699757967fa695766e1ddbbc345bfc1f030' THEN 'ODOS Limit Order' --OdosLimitOrderRouter
WHEN ORIGIN_TO_ADDRESS = '0x45a62b090df48243f12a21897e7ed91863e2c86b' THEN 'LFJ Aggregator' --Joe Aggregator
/*ETH L1 below */
WHEN ORIGIN_TO_ADDRESS = '0x9008d19f58aabd9ed0d60971565aa8510560ab41' THEN 'COWSWAP'
WHEN ORIGIN_TO_ADDRESS = '0x663dc15d3c1ac63ff12e45ab68fea3f0a883c251' THEN 'DEBRIDGE'
WHEN ORIGIN_TO_ADDRESS = '0x881d40237659c251811cec9c364ef91dc08d300c' THEN 'Metamask Swap Router'
WHEN ORIGIN_TO_ADDRESS = '0x87870bca3f3fd6335c3f4ce8392d69350b4fa4e2' THEN 'AAVE'
WHEN ORIGIN_TO_ADDRESS = '0xadc0a53095a0af87f3aa29fe0715b5c28016364e' THEN 'AAVE'
WHEN ORIGIN_TO_ADDRESS = '0x7d2768de32b0b80b7a3454c06bdac94a69ddc7a9' THEN 'AAVE'
WHEN ORIGIN_TO_ADDRESS = '0x03f34be1bf910116595db1b11e9d1b2ca5d59659' THEN 'Tokelon DEX'
WHEN ORIGIN_TO_ADDRESS = '0x70bf6634ee8cb27d04478f184b9b8bb13e5f4710' THEN '0x exchange'
WHEN ORIGIN_TO_ADDRESS = '0x12d737470fb3ec6c3deec9b518100bec9d520144' THEN '0x exchange'
WHEN ORIGIN_TO_ADDRESS = '0xce16f69375520ab01377ce7b88f5ba8c48f8d666' THEN 'Squid Router'
WHEN ORIGIN_TO_ADDRESS = '0xf3de3c0d654fda23dad170f0f320a92172509127' THEN 'OKX'
WHEN ORIGIN_TO_ADDRESS = '0xcf5540fffcdc3d510b18bfca6d2b9987b0772559' THEN 'OdosRouterV2'
WHEN ORIGIN_TO_ADDRESS = '0x3c11f6265ddec22f4d049dde480615735f451646' THEN 'mimic.fi' --mimic.fi
WHEN ORIGIN_TO_ADDRESS = '0xad3b67bca8935cb510c8d18bd45f0b94f54a968f' THEN '1inch' -- resolver
WHEN ORIGIN_TO_ADDRESS = '0xfc99f58a8974a4bc36e60e2d490bb8d72899ee9f' THEN 'OKX'