Pool | Farming actions | Total LP users | Net ankrFLOWEVM Liquidity | Net USDC.e Liquidity | Net WFLOW Liquidity | Liquidity ($USD) | |
|---|---|---|---|---|---|---|---|
1 | ankrFLOWEVM-FLOW | 490 | 84 | 1263738.25163082 | 0 | 1441609.73314926 | 1156068.9400166 |
2 | USDC.e-FLOW | 438 | 67 | 0 | 337891.555896 | 364512.169237926 | 484048.032029617 |
adriaparcerisastrado farms by pool 2
Updated 6 hours 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: about 6 hours ago
2
154B
10s