DAY_OF_MONTH | METRIC | JANUARY | FEBRUARY | |
|---|---|---|---|---|
1 | 1 | Daily Active Users (DAU) | 852 | 2258 |
2 | 1 | Number of New DeFi Contracts | 0 | 3 |
3 | 1 | Total Value Locked (TVL) | 41548.01 | 2292923.86 |
4 | 1 | Transaction Volume | 20.762657199 | 73.975100038 |
5 | 2 | Daily Active Users (DAU) | 889 | 1684 |
6 | 2 | Number of New DeFi Contracts | 2 | 3 |
7 | 2 | Total Value Locked (TVL) | 44471.99 | 2667798.93 |
8 | 2 | Transaction Volume | 41.043037293 | 26.776673037 |
9 | 3 | Daily Active Users (DAU) | 947 | 1120 |
10 | 3 | Number of New DeFi Contracts | 3 | 2 |
11 | 3 | Total Value Locked (TVL) | 70887.85 | 2316743.19 |
12 | 3 | Transaction Volume | 30.816002348 | 62.836645355 |
13 | 4 | Daily Active Users (DAU) | 1173 | 2102 |
14 | 4 | Number of New DeFi Contracts | 3 | 5 |
15 | 4 | Total Value Locked (TVL) | 53341.18 | 2413136.7 |
16 | 4 | Transaction Volume | 48.294949575 | 86.455457112 |
17 | 5 | Daily Active Users (DAU) | 1079 | 1786 |
18 | 5 | Number of New DeFi Contracts | 2 | 3 |
19 | 5 | Total Value Locked (TVL) | 138490.49 | 1462905.48 |
20 | 5 | Transaction Volume | 29.052638416 | 83.213934344 |
kentodaily d
Updated 2025-03-06
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
26
27
28
29
30
31
32
33
34
35
36
›
⌄
WITH defi_contracts AS (
SELECT DISTINCT contract_address
FROM ink.core.ez_decoded_event_logs
WHERE event_name IN ('Swap', 'Deposit', 'Withdraw', 'AddLiquidity', 'RemoveLiquidity') -- Common DeFi events
AND block_timestamp BETWEEN '2025-01-01' AND '2025-02-28'
),
-- Total Value Locked (TVL)
tvl AS (
SELECT
DATE(block_timestamp) AS date,
SUM(amount_usd) AS tvl
FROM ink.core.ez_token_transfers
WHERE to_address IN (SELECT contract_address FROM defi_contracts)
AND block_timestamp BETWEEN '2025-01-01' AND '2025-02-28'
GROUP BY date
),
-- Daily Active Users (DAU)
dau AS (
SELECT
DATE(block_timestamp) AS date,
COUNT(DISTINCT from_address) AS dau
FROM ink.core.fact_transactions
WHERE to_address IN (SELECT contract_address FROM defi_contracts)
AND block_timestamp BETWEEN '2025-01-01' AND '2025-02-28'
GROUP BY date
),
-- Transaction Volume
transaction_volume AS (
SELECT
DATE(block_timestamp) AS date,
SUM(value) AS transaction_volume
FROM ink.core.fact_transactions
WHERE to_address IN (SELECT contract_address FROM defi_contracts)
Last run: 3 months ago
...
124
6KB
3s