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 | 447 | 17.824161806 | 17.824161806 | 8.912080903 | 8.912080903 | 0 | 2710951.66926679 | 2160499.31063126 |
2 | 2025-04-15 00:00:00.000 | ankrFLOWEVM-FLOW | 1 | 1 | 225 | 2 | 545 | 580.568469167 | 580.568469167 | 290.284234583 | 290.284234583 | 0 | 13373993.1762517 | 13309973.8783188 |
3 | 2025-04-14 00:00:00.000 | USDC.e-FLOW | 1 | 1 | 185 | 2 | 445 | 0.4878779523 | 0.4878779523 | 0.2439389762 | 0.2439389762 | 0 | 2710933.84510498 | 2160481.48646945 |
4 | 2025-04-13 00:00:00.000 | USDC.e-FLOW | 1 | 1 | 184 | 2 | 443 | 0.4949381346 | 0.4949381346 | 0.2474690673 | 0.2474690673 | 0 | 2710933.35722703 | 2160480.9985915 |
5 | 2025-04-10 00:00:00.000 | ankrFLOWEVM-FLOW | 1 | 1 | 224 | 2 | 543 | 0.775794434 | 0.775794434 | 0.387897217 | 0.387897217 | 0 | 13373412.6077825 | 13309393.3098496 |
6 | 2025-04-08 00:00:00.000 | USDC.e-FLOW | 1 | 1 | 183 | 2 | 441 | 2.672668863 | 0 | 1.336334431 | 0 | 2.672668863 | 2710932.86228889 | 2160480.50365337 |
7 | 2025-04-06 00:00:00.000 | ankrFLOWEVM-FLOW | 1 | 1 | 223 | 2 | 541 | 56.00131439 | 56.00131439 | 28.000657195 | 28.000657195 | 0 | 13373411.8319881 | 13309392.5340552 |
8 | 2025-04-05 00:00:00.000 | ankrFLOWEVM-FLOW | 2 | 2 | 222 | 3 | 539 | 110155.703298798 | 110081.51980469 | 36718.567766266 | 36693.839934897 | 74.183494108 | 13373355.8306737 | 13309336.5327408 |
9 | 2025-04-01 00:00:00.000 | ankrFLOWEVM-FLOW | 1 | 1 | 220 | 4 | 536 | 1329.319499 | 1329.319499 | 332.32987475 | 332.32987475 | 0 | 13263200.1273749 | 13199255.0129361 |
10 | 2025-03-31 00:00:00.000 | ankrFLOWEVM-FLOW | 2 | 2 | 219 | 6 | 532 | 20880.828119817 | 20880.828119817 | 3480.138019969 | 3480.138019969 | 0 | 13261870.8078759 | 13197925.6934371 |
11 | 2025-03-28 00:00:00.000 | ankrFLOWEVM-FLOW | 1 | 1 | 217 | 2 | 526 | 44.438707319 | 44.438707319 | 22.219353659 | 22.219353659 | 0 | 13240989.9797561 | 13177044.8653173 |
12 | 2025-03-25 00:00:00.000 | ankrFLOWEVM-FLOW | 1 | 1 | 216 | 4 | 524 | 512.875870833 | 512.875870833 | 128.218967708 | 128.218967708 | 0 | 13240945.5410488 | 13177000.42661 |
13 | 2025-03-24 00:00:00.000 | ankrFLOWEVM-FLOW | 1 | 1 | 215 | 2 | 520 | 41068.110580761 | 41068.110580761 | 20534.05529038 | 20534.05529038 | 0 | 13240432.6651779 | 13176487.5507391 |
14 | 2025-03-23 00:00:00.000 | ankrFLOWEVM-FLOW | 1 | 1 | 214 | 2 | 518 | 85214.468579777 | 85214.468579777 | 42607.234289888 | 42607.234289888 | 0 | 13199364.5545972 | 13135419.4401584 |
15 | 2025-03-22 00:00:00.000 | ankrFLOWEVM-FLOW | 1 | 1 | 213 | 6 | 516 | 232899.974556888 | 232899.974556888 | 38816.662426148 | 38816.662426148 | 0 | 13114150.0860174 | 13050204.9715786 |
16 | 2025-03-21 00:00:00.000 | ankrFLOWEVM-FLOW | 2 | 2 | 212 | 10 | 510 | 122127.029809098 | 122127.029809098 | 12212.70298091 | 12212.70298091 | 0 | 12881250.1114605 | 12817304.9970217 |
17 | 2025-03-19 00:00:00.000 | USDC.e-FLOW | 1 | 1 | 182 | 1 | 439 | 8554.126142154 | 0 | 8554.126142154 | 0 | 8554.126142154 | 2710930.18962003 | 2160480.50365337 |
18 | 2025-03-19 00:00:00.000 | ankrFLOWEVM-FLOW | 1 | 1 | 210 | 2 | 500 | 348.281404168 | 348.281404168 | 174.140702084 | 174.140702084 | 0 | 12759123.0816514 | 12695177.9672126 |
19 | 2025-03-13 00:00:00.000 | ankrFLOWEVM-FLOW | 1 | 1 | 209 | 2 | 498 | 788.400833333 | 788.400833333 | 394.200416667 | 394.200416667 | 0 | 12758774.8002473 | 12694829.6858084 |
20 | 2025-03-11 00:00:00.000 | ankrFLOWEVM-FLOW | 2 | 2 | 208 | 6 | 496 | 12.813345515 | 12.813345515 | 2.135557586 | 2.135557586 | 0 | 12757986.3994139 | 12694041.2849751 |
adriaparcerisastrado farms by pool
Updated 5 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: 5 days ago
...
192
29KB
11s