DATE | POOL | ACTIVE_LP_USERS | NEW_LP_USERS | UNIQUE_LP_USERS | FARMING_ACTIONS | TOTAL_ACTIONS | AMOUNT_IN_USD | AMOUNT_OUT_USD | AVG_AMOUNT_IN_USD | AVG_AMOUNT_OUT_USD | NET_AMOUNT_SUPPLIED | TOTAL_AMOUNT_IN_USD | TOTAL_AMOUNT_OUT_USD | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1 | 2025-04-23 00:00:00.000 | USDC.e-FLOW | 1 | 1 | 186 | 2 | 443 | 17.824161806 | 17.824161806 | 8.912080903 | 8.912080903 | 0 | 2710951.66926679 | 2068201.31959431 |
2 | 2025-04-15 00:00:00.000 | ankrFLOWEVM-FLOW | 1 | 1 | 225 | 1 | 513 | 580.568469167 | 0 | 580.568469167 | 0 | 580.568469167 | 13373993.1762517 | 13046060.0421746 |
3 | 2025-04-14 00:00:00.000 | USDC.e-FLOW | 1 | 1 | 185 | 2 | 441 | 0.4878779523 | 0.4878779523 | 0.2439389762 | 0.2439389762 | 0 | 2710933.84510498 | 2068183.4954325 |
4 | 2025-04-13 00:00:00.000 | USDC.e-FLOW | 1 | 1 | 184 | 2 | 439 | 0.4949381346 | 0.4949381346 | 0.2474690673 | 0.2474690673 | 0 | 2710933.35722703 | 2068183.00755455 |
5 | 2025-04-10 00:00:00.000 | ankrFLOWEVM-FLOW | 1 | 1 | 224 | 2 | 512 | 0.775794434 | 0.775794434 | 0.387897217 | 0.387897217 | 0 | 13373412.6077825 | 13046060.0421746 |
6 | 2025-04-08 00:00:00.000 | USDC.e-FLOW | 1 | 1 | 183 | 2 | 437 | 2.672668863 | 0 | 1.336334431 | 0 | 2.672668863 | 2710932.86228889 | 2068182.51261641 |
7 | 2025-04-06 00:00:00.000 | ankrFLOWEVM-FLOW | 1 | 1 | 223 | 2 | 510 | 56.00131439 | 56.00131439 | 28.000657195 | 28.000657195 | 0 | 13373411.8319881 | 13046059.2663802 |
8 | 2025-04-05 00:00:00.000 | ankrFLOWEVM-FLOW | 2 | 2 | 222 | 2 | 508 | 110155.703298798 | 0 | 55077.851649399 | 0 | 110155.703298798 | 13373355.8306737 | 13046003.2650658 |
9 | 2025-04-01 00:00:00.000 | ankrFLOWEVM-FLOW | 1 | 1 | 220 | 2 | 506 | 1329.319499 | 0 | 664.6597495 | 0 | 1329.319499 | 13263200.1273749 | 13046003.2650658 |
10 | 2025-03-31 00:00:00.000 | ankrFLOWEVM-FLOW | 2 | 2 | 219 | 6 | 504 | 20880.828119817 | 20880.828119817 | 3480.138019969 | 3480.138019969 | 0 | 13261870.8078759 | 13046003.2650658 |
11 | 2025-03-28 00:00:00.000 | ankrFLOWEVM-FLOW | 1 | 1 | 217 | 2 | 498 | 44.438707319 | 44.438707319 | 22.219353659 | 22.219353659 | 0 | 13240989.9797561 | 13025122.4369459 |
12 | 2025-03-25 00:00:00.000 | ankrFLOWEVM-FLOW | 1 | 1 | 216 | 4 | 496 | 512.875870833 | 512.875870833 | 128.218967708 | 128.218967708 | 0 | 13240945.5410488 | 13025077.9982386 |
13 | 2025-03-24 00:00:00.000 | ankrFLOWEVM-FLOW | 1 | 1 | 215 | 2 | 492 | 41068.110580761 | 41068.110580761 | 20534.05529038 | 20534.05529038 | 0 | 13240432.6651779 | 13024565.1223678 |
14 | 2025-03-23 00:00:00.000 | ankrFLOWEVM-FLOW | 1 | 1 | 214 | 2 | 490 | 85214.468579777 | 85214.468579777 | 42607.234289888 | 42607.234289888 | 0 | 13199364.5545972 | 12983497.011787 |
15 | 2025-03-22 00:00:00.000 | ankrFLOWEVM-FLOW | 1 | 1 | 213 | 6 | 488 | 232899.974556888 | 232899.974556888 | 38816.662426148 | 38816.662426148 | 0 | 13114150.0860174 | 12898282.5432073 |
16 | 2025-03-21 00:00:00.000 | ankrFLOWEVM-FLOW | 2 | 2 | 212 | 9 | 482 | 122127.029809098 | 120295.650442433 | 13569.669978789 | 13366.183382493 | 1831.379366665 | 12881250.1114605 | 12665382.5686504 |
17 | 2025-03-19 00:00:00.000 | USDC.e-FLOW | 1 | 1 | 182 | 1 | 435 | 8554.126142154 | 0 | 8554.126142154 | 0 | 8554.126142154 | 2710930.18962003 | 2068182.51261641 |
18 | 2025-03-19 00:00:00.000 | ankrFLOWEVM-FLOW | 1 | 1 | 210 | 1 | 473 | 348.281404168 | 0 | 348.281404168 | 0 | 348.281404168 | 12759123.0816514 | 12545086.9182079 |
19 | 2025-03-13 00:00:00.000 | ankrFLOWEVM-FLOW | 1 | 1 | 209 | 2 | 472 | 788.400833333 | 788.400833333 | 394.200416667 | 394.200416667 | 0 | 12758774.8002473 | 12545086.9182079 |
20 | 2025-03-11 00:00:00.000 | ankrFLOWEVM-FLOW | 2 | 2 | 208 | 6 | 470 | 12.813345515 | 12.813345515 | 2.135557586 | 2.135557586 | 0 | 12757986.3994139 | 12544298.5173746 |
adriaparcerisastrado farms by pool
Updated 3 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')
Last run: 3 days ago
...
192
29KB
42s