PROTOCOL | AVG_VOLUME_SWAPPED | VOLUME_SWAPPED | SWAPS | ACTIVE_TRADERS | |
|---|---|---|---|---|---|
1 | Punchswap | 778.028143846 | 3340852.84967426 | 4294 | 31 |
2 | Trado | 218.653227969 | 223682.252212487 | 1023 | 3 |
3 | Increment Finance | 225.196919124 | 63730.728111961 | 293 | 89 |
4 | Others | 52.193010877 | 156.57903263 | 8 | 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
202B
35s