Pool | Farming actions | Total LP users | Net ankrFLOWEVM Liquidity | Net USDC.e Liquidity | Net WFLOW Liquidity | Liquidity ($USD) | |
|---|---|---|---|---|---|---|---|
1 | USDC.e-FLOW | 443 | 67 | 0 | 321620.021731 | 332597.16886964 | 445940.802398869 |
2 | ankrFLOWEVM-FLOW | 513 | 84 | 297996.421799221 | 0 | 336541.674184948 | 251590.377657985 |
adriaparcerisastrado farms by pool 2
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 all_farms_in AS (
SELECT
x.tx_hash,
x.block_timestamp,
x.origin_from_address,
x.origin_to_address,
contract_address,
utils.udf_hex_to_int(x.topic_1) AS nft_id,
'0x' || SUBSTR(data, 27, 40) as pool_address,
case
when origin_to_address='0x45b534b329d1410f37026e50014c37bd140b055d' then utils.udf_hex_to_int(SUBSTR(data, 131, 64)) / pow(10,18)
else 0 end as ankrflowevm_amount,
case
when origin_to_address='0x8981c60ff02cdbbf2a6ac1a9f150814f9cf68f62' then utils.udf_hex_to_int(SUBSTR(data, 131, 64)) / pow(10,6)
else 0 end as usdce_amount,
utils.udf_hex_to_int(SUBSTR(data, 195, 64)) / pow(10,18) as wflow_amount
FROM flow.core_evm.fact_event_logs x
WHERE x.origin_function_signature in ('0x33aa6991')
AND contract_address='0x19b683a2f45012318d9b2ae1280d68d3ec54d663'
AND topic_0='0xf565fdd70b3936f0ae8efc41c2e0822f9de5ecb4dc162b153b129ec4bb9cd93c'
AND origin_to_address in ('0x45b534b329d1410f37026e50014c37bd140b055d','0x8981c60ff02cdbbf2a6ac1a9f150814f9cf68f62')
AND tx_succeeded='TRUE'
),
all_farms_out AS (
SELECT
x.tx_hash,
x.block_timestamp,
x.origin_from_address,
x.origin_to_address,
contract_address,
utils.udf_hex_to_int(x.data) AS nft_id
FROM flow.core_evm.fact_event_logs x
WHERE x.origin_function_signature in ('0x92930b45')
AND topic_0='0x884edad9ce6fa2440d8a54cc123490eb96d2768479d49ff9c7366125a9424364'
AND contract_address in ('0x45b534b329d1410f37026e50014c37bd140b055d','0x8981c60ff02cdbbf2a6ac1a9f150814f9cf68f62')
Last run: 6 days ago
2
154B
50s