TYPE | N_USERS | TOTAL_TRANSACTIONS | TOTAL_AMOUNT_USD | |
|---|---|---|---|---|
1 | Suppliers | 60410 | 340366 | 2185505038.65219 |
2 | Withdrawers | 52700 | 460104 | 2050467290.01133 |
Kruys-Collinsyawning-ivory copy copy
Updated 2025-01-22
99
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
›
⌄
SELECT
'Suppliers' AS type,
COUNT(DISTINCT l.sender_id) AS n_users,
COUNT(*) AS total_transactions,
SUM(l.amount_usd) AS total_amount_usd
FROM
near.defi.ez_lending l
WHERE l.contract_address = 'contract.main.burrow.near'
AND actions in ('deposit_to_reserve', 'deposit')
UNION ALL
SELECT
'Withdrawers' AS type,
COUNT(DISTINCT l.sender_id) AS n_users,
COUNT(*) AS total_transactions,
SUM(l.amount_usd) AS total_amount_usd
FROM
near.defi.ez_lending l
WHERE l.contract_address = 'contract.main.burrow.near'
AND actions = 'withdraw_succeeded'
Last run: about 2 months ago
2
91B
6s