WEEK | PLATFORM | ORIGIN_TO | VOLUME | |
|---|---|---|---|---|
1 | 2024-10-15 00:00:00.000 | aerodrome-slipstream | Aerodrome Router | 103300452.8 |
2 | 2024-08-28 00:00:00.000 | aerodrome-slipstream | Aerodrome Router | 97392855.06 |
3 | 2024-10-14 00:00:00.000 | aerodrome-slipstream | Aerodrome Router | 94368045.68 |
4 | 2024-09-26 00:00:00.000 | aerodrome-slipstream | Aerodrome Router | 91542532.24 |
5 | 2024-10-10 00:00:00.000 | aerodrome-slipstream | Aerodrome Router | 90605002.96 |
6 | 2024-09-27 00:00:00.000 | aerodrome-slipstream | Aerodrome Router | 87051208.33 |
7 | 2024-09-30 00:00:00.000 | aerodrome-slipstream | Aerodrome Router | 86173590.65 |
8 | 2024-08-23 00:00:00.000 | aerodrome-slipstream | Aerodrome Router | 86063960.14 |
9 | 2024-10-08 00:00:00.000 | aerodrome-slipstream | Aerodrome Router | 85219079.35 |
10 | 2024-08-12 00:00:00.000 | aerodrome-slipstream | Aerodrome Router | 83560171.92 |
11 | 2024-08-21 00:00:00.000 | aerodrome-slipstream | Aerodrome Router | 83054023.05 |
12 | 2024-10-07 00:00:00.000 | aerodrome-slipstream | Aerodrome Router | 81477236.97 |
13 | 2024-10-11 00:00:00.000 | aerodrome-slipstream | Aerodrome Router | 80913293.26 |
14 | 2024-08-27 00:00:00.000 | aerodrome-slipstream | Aerodrome Router | 80629237.72 |
15 | 2024-10-09 00:00:00.000 | aerodrome-slipstream | Aerodrome Router | 79557251.7 |
16 | 2024-09-23 00:00:00.000 | aerodrome-slipstream | Aerodrome Router | 78038104.95 |
17 | 2024-08-29 00:00:00.000 | aerodrome-slipstream | Aerodrome Router | 77942402.5 |
18 | 2024-08-26 00:00:00.000 | aerodrome-slipstream | Aerodrome Router | 76904651.22 |
19 | 2024-09-19 00:00:00.000 | aerodrome-slipstream | Aerodrome Router | 75770570.53 |
20 | 2024-09-18 00:00:00.000 | aerodrome-slipstream | Aerodrome Router | 73269624.5 |
pecio222Aerodrome WETH-USDC Q3 Q4 without bots
Updated 2025-01-22
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 ALL_DATA as (
SELECT
DATE_TRUNC('DAY', block_timestamp) AS WEEK,
CASE
/*base below */
WHEN ORIGIN_TO_ADDRESS = '0x6cb442acf35158d5eda88fe602221b67b400be3e' THEN 'Aerodrome Router' --UniversalRouter
WHEN ORIGIN_TO_ADDRESS = '0xad3b67bca8935cb510c8d18bd45f0b94f54a968f' THEN '1inch'
WHEN ORIGIN_TO_ADDRESS = '0x2626664c2603336e57b271c5c0b26f421741e481' THEN 'Uniswap' --SwapRouter02
WHEN ORIGIN_TO_ADDRESS = '0x3fc91a3afd70395cd496c647d5a6cc9d4b2b7fad' THEN 'Uniswap' --UniversalRouter
WHEN ORIGIN_TO_ADDRESS = '0x19ceead7105607cd444f5ad10dd51356436095a1' THEN 'OdosRouterV2'
WHEN ORIGIN_TO_ADDRESS = '0xebe78f29fa7f35c13f126f9aa10cf7b4f49f47d2' THEN 'Farm automation'
WHEN ORIGIN_TO_ADDRESS = '0x75d57c8d1d16d1045a33dd127929da4f52d59a16' THEN 'Farm automation'
WHEN ORIGIN_TO_ADDRESS = '0xd261b5f831e0fa4345667c36b3e58463650a9a89' THEN 'UNKNOWN_BOTS'
WHEN ORIGIN_TO_ADDRESS = '0x675883d4e3052b61ffddece848c9cbb02bbe4894' THEN 'UNKNOWN_BOTS'
WHEN ORIGIN_TO_ADDRESS = '0x6fbba99edd2dd9f9de4a6d7b7511752a32470322' THEN 'UNKNOWN_BOTS'
WHEN ORIGIN_TO_ADDRESS = '0x02ee0ed2d75494958996aa360863cc507c9291e3' THEN 'UNKNOWN_BOTS'
WHEN ORIGIN_TO_ADDRESS = '0x758d00d2235bcb30861421b84a3656f29c7d09c1' THEN 'UNKNOWN_BOTS'
WHEN ORIGIN_TO_ADDRESS = '0x1195c8b1c3d2a99be9947c2032d767e2d59352e3' THEN 'UNKNOWN_BOTS'
WHEN ORIGIN_TO_ADDRESS = '0x25ce4b4dcb620b73a78f91cd66f6e3e5ef8f487c' THEN 'UNKNOWN_BOTS'
WHEN ORIGIN_TO_ADDRESS = '0x25ce4b4dcb620b73a78f91cd66f6e3e5ef8f487c' THEN 'UNKNOWN_BOTS'
WHEN ORIGIN_TO_ADDRESS = '0x6fbba99edd2dd9f9de4a6d7b7511752a32470322' THEN 'UNKNOWN_BOTS'
WHEN ORIGIN_TO_ADDRESS = '0x83885cab02a0b906836225442fa17dcfe9cbf797' THEN 'UNKNOWN_BOTS'
WHEN ORIGIN_TO_ADDRESS = '0x64a0dc1655c031fe392abd1b1a8511c0b8b036d4' THEN 'UNKNOWN_BOTS'
WHEN ORIGIN_TO_ADDRESS = '0xfc0abb8b822cbe977567241c19cee3ab5b6e49f1' THEN 'UNKNOWN_BOTS'
WHEN ORIGIN_TO_ADDRESS = '0x09e18da172ce3d09e0107950980f476a9ca7f55b' THEN 'UNKNOWN_BOTS'
WHEN ORIGIN_TO_ADDRESS = '0x323dc0a60428eb4b9eb788f9ae52ecc98933d6a3' THEN 'UNKNOWN_BOTS'
WHEN ORIGIN_TO_ADDRESS = '0x3691a88e5f04c712efa65a812e0622b7d01f5ce5' THEN 'UNKNOWN_BOTS'
WHEN ORIGIN_TO_ADDRESS = '0x2a579606c43eb5346e91d66c73f4a361181916a9' THEN 'UNKNOWN_BOTS'
WHEN ORIGIN_TO_ADDRESS = '0x9715c7f1dbd320ce2d38a5cef616eb8e5b764ddc' THEN 'UNKNOWN_BOTS'
WHEN ORIGIN_TO_ADDRESS = '0xbc57f9deb97a54e80720250df91cc5a13eb749c7' THEN 'UNKNOWN_BOTS'
WHEN ORIGIN_TO_ADDRESS = '0x6d463955399312f41f6e5d9216c5694d2de2b19e' THEN 'UNKNOWN_BOTS'
WHEN ORIGIN_TO_ADDRESS = '0x0d90e61805c101d88ddc614344274c0249b793ef' THEN 'UNKNOWN_BOTS'
WHEN ORIGIN_TO_ADDRESS = '0x2eb1380bf83282ecc1135249f3f2256ea69464b2' THEN 'UNKNOWN_BOTS'
WHEN ORIGIN_TO_ADDRESS = '0xce0f4adc2ad46ba4dc0ca58a053374d21eb2558a' THEN 'UNKNOWN_BOTS'
WHEN ORIGIN_TO_ADDRESS = '0xd1910ad542986304116a85479d37cd541dfe6e11' THEN 'UNKNOWN_BOTS'
WHEN ORIGIN_TO_ADDRESS = '0x8bcab759dae4dcd8410ecd5efc9f1bf7228904ea' THEN 'UNKNOWN_BOTS'
Last run: 3 months ago
...
1688
122KB
22s