PROTOCOL | AVG_VOLUME_SWAPPED | VOLUME_SWAPPED | SWAPS | ACTIVE_TRADERS | |
|---|---|---|---|---|---|
1 | Punchswap | 801.330354987 | 1753310.81671075 | 2188 | 43 |
2 | Trado | 363.95417669 | 205634.109829776 | 565 | 3 |
3 | Increment Finance | 982.812614157 | 364623.479852416 | 386 | 119 |
4 | Others | 50.775583218 | 152.326749654 | 7 | 6 |
adriaparcerisasflow defi swaps 2 7d
Updated 6 days ago
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 swaps AS (
SELECT x.tx_hash,
x.origin_from_address,
x.contract_address,
y.tx_fee,
x.block_timestamp,
CASE
WHEN lower(x.contract_address) = LOWER('0x1b97100ea1d7126c4d60027e231ea4cb25314bdb') THEN 'ankrFLOWEVM'
WHEN lower(x.contract_address) = LOWER('0x7f27352d5f83db87a5a3e00f4b07cc2138d8ee52') THEN 'USDC.e'
WHEN lower(x.contract_address) = LOWER('0x5598c0652b899eb40f169dd5949bdbe0bf36ffde') THEN 'stFlow'
WHEN lower(x.contract_address) = LOWER('0xd3bf53dac106a0290b0483ecbc89d40fcc961f3e') THEN 'WFLOW'
ELSE 'FLOW'
END AS asset,
x.event_index,
x.data,
CASE
WHEN lower(x.contract_address) = LOWER('0x1b97100ea1d7126c4d60027e231ea4cb25314bdb') THEN 18
WHEN lower(x.contract_address) = LOWER('0x7f27352d5f83db87a5a3e00f4b07cc2138d8ee52') THEN 6
WHEN lower(x.contract_address) = LOWER('0x5598c0652b899eb40f169dd5949bdbe0bf36ffde') THEN 18
WHEN lower(x.contract_address) = LOWER('0xd3bf53dac106a0290b0483ecbc89d40fcc961f3e') THEN 18
ELSE '18'
END AS decimals,
FROM flow.core_evm.fact_event_logs x
JOIN flow.core_evm.fact_transactions y
ON x.tx_hash = y.tx_hash
WHERE (lower(y.to_address) = lower('0x3EF68D3f7664b2805D4E88381b64868a56f88bC4')
AND x.origin_function_signature = '0xac9650d8')
AND x.tx_succeeded = 'TRUE'
AND LOWER(x.contract_address) IN (
'0x1b97100ea1d7126c4d60027e231ea4cb25314bdb',
'0x7f27352d5f83db87a5a3e00f4b07cc2138d8ee52',
'0xd3bf53dac106a0290b0483ecbc89d40fcc961f3e',
'0x5598c0652b899eb40f169dd5949bdbe0bf36ffde',
'0x9c7efd8ecd7c5e8b51a3833f6fb67c6e2f4f4a9b',
'0x68eb683a393c8a1c816255b4fc4b89d73c52ad4b',
'0xd8ad8ae8375aa31bff541e17dc4b4917014ebdaa',
Last run: 6 days ago
4
203B
6s