TOKEN | BORROW_ACTIONS | REPAY_ACTIONS | UNIQUE_SUPPLIERS | UNIQUE_REPAYERS | TOTAL_BORROW_USD | TOTAL_REPAY_USD | NET_AMOUNT_USD | |
|---|---|---|---|---|---|---|---|---|
1 | WFLOW | 1060 | 103 | 31 | 15 | 10336919.6617613 | 260681.043496731 | 10076238.6182645 |
2 | USDF | 115 | 29 | 25 | 14 | 921576.7649115 | 109590.4880105 | 811986.276901 |
3 | stgUSDC | 47 | 33 | 26 | 15 | 682408.171696 | 79351.499702 | 603056.671994 |
4 | ankrFLOWEVM | 15 | 8 | 7 | 5 | 118.373777276 | 105.199351799 | 13.174425477 |
5 | WETH | 2 | 1 | 1 | 1 | 2.643927682 | 2.841437215e-9 | 2.643927679 |
adriaparcerisasmore markets borrow and repay by token totals
Updated 2025-04-09
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 borrow AS (
SELECT
tx_hash,
date_trunc('week', block_timestamp) as week,
block_timestamp,
origin_from_address as wallet,
utils.udf_hex_to_int(data) / pow(10, CASE
WHEN topic_1 IN ('0x000000000000000000000000d10cd10260e87efdf36618621458eeaa996b8267','0x00000000000000000000000002bf4bd075c1b7c8d85f54777eaaa3638135c059','0x000000000000000000000000ad412305cf8ad9545759466f3d889438598f773f') THEN 18
ELSE 6
END) as amount,
CASE
WHEN topic_1 ='0x000000000000000000000000d10cd10260e87efdf36618621458eeaa996b8267' THEN 'ankrFLOWEVM'
WHEN topic_1='0x00000000000000000000000002bf4bd075c1b7c8d85f54777eaaa3638135c059' THEN 'WFLOW'
WHEN topic_1='0x000000000000000000000000e43fe00aea059f3a756cf556655b5a27faf9bec5' THEN 'USDF'
WHEN topic_1='0x00000000000000000000000049c6b2799af2db7404b930f24471dd961cfe18b7' THEN 'stgUSDC'
WHEN topic_1='0x000000000000000000000000ad412305cf8ad9545759466f3d889438598f773f' THEN 'WETH'
END as token
FROM flow.core_evm.fact_event_logs
WHERE origin_function_signature in ('0xa415bcad','0x66514c97')
AND tx_succeeded='TRUE'
AND topic_0='0xddf252ad1be2c89b69c2b068fc378daa952ba7f163c4a11628f55a4df523b3ef'
AND topic_1 IN (
'0x000000000000000000000000d10cd10260e87efdf36618621458eeaa996b8267',
'0x00000000000000000000000002bf4bd075c1b7c8d85f54777eaaa3638135c059',
'0x000000000000000000000000e43fe00aea059f3a756cf556655b5a27faf9bec5',
'0x00000000000000000000000049c6b2799af2db7404b930f24471dd961cfe18b7',
'0x000000000000000000000000ad412305cf8ad9545759466f3d889438598f773f'
)
),
repay AS (
SELECT
tx_hash,
date_trunc('week', block_timestamp) as week,
block_timestamp,
origin_from_address as wallet,
Last run: 20 days ago
5
330B
50s