DATE | POOL | DAU | N_TXNS | |
|---|---|---|---|---|
1 | 2024-02-26 00:00:00.000 | pangolin png | 4505 | 50910 |
2 | 2024-02-26 00:00:00.000 | stargate usdc lp | 16971 | 40760 |
3 | 2024-02-26 00:00:00.000 | bankerjoe weth.e | 5516 | 36188 |
4 | 2024-02-26 00:00:00.000 | stargate usdt lp | 15474 | 35231 |
5 | 2024-02-26 00:00:00.000 | bankerjoe usdt.e | 5475 | 19844 |
6 | 2024-02-26 00:00:00.000 | bankerjoe usdc.e | 4990 | 17786 |
7 | 2024-02-26 00:00:00.000 | gmx gmx | 1104 | 4285 |
8 | 2024-02-26 00:00:00.000 | bankerjoe mim | 1385 | 3365 |
9 | 2024-02-26 00:00:00.000 | bankerjoe link.e | 874 | 3065 |
10 | 2024-02-26 00:00:00.000 | traderjoe lost-avax lp | 112 | 1247 |
11 | 2024-05-06 00:00:00.000 | bankerjoe weth.e | 3793 | 20756 |
12 | 2024-05-06 00:00:00.000 | stargate usdc lp | 6484 | 15927 |
13 | 2024-05-06 00:00:00.000 | pangolin png | 2125 | 12099 |
14 | 2024-05-06 00:00:00.000 | stargate usdt lp | 4463 | 11392 |
15 | 2024-05-06 00:00:00.000 | bankerjoe usdc.e | 3446 | 10698 |
16 | 2024-05-06 00:00:00.000 | bankerjoe usdt.e | 3377 | 9074 |
17 | 2024-05-06 00:00:00.000 | gmx gmx | 740 | 4019 |
18 | 2024-05-06 00:00:00.000 | bankerjoe mim | 589 | 1565 |
19 | 2024-05-06 00:00:00.000 | bankerjoe link.e | 451 | 1316 |
20 | 2024-05-06 00:00:00.000 | curve dai/usdc/usdt | 470 | 1080 |
SocioAnalyticatxns based on different pool
Updated 2025-02-09
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
›
⌄
SELECT
date_trunc('week', block_timestamp) as date,
substr(address_name,16) as pool,
count(DISTINCT origin_from_address) as DAU,
count(DISTINCT tx_hash) as n_txns
FROM avalanche.core.ez_decoded_event_logs a
JOIN avalanche.core.dim_labels b ON a.contract_address = b.address
where b.project_name ilike '%beefy%'
AND b.label_subtype = 'pool'
AND date >= dateadd('month', -12, current_date)
GROUP BY date, pool
qualify row_number () over (partition by date order by n_txns DESC) <= 10
Last run: 3 months ago
...
520
28KB
9s