POOL_NAME | POOL_ADDRESS | BALANCE_USD | |
|---|---|---|---|
1 | USDC-AERO | 0x6cdcb1c4a4d1c3c6d054b27ac5b77e89eafb971d | 35855408.7058542 |
2 | WETH-USDC | 0xcdac0d6c6c59727a65f871236188350531885c43 | 15079271.4879974 |
3 | Other | 0x5fede9d65714907381a76aa9bf949219dd1c5023 | 8792550.75740236 |
4 | WETH-WELL | 0x89d0f320ac73dd7d9513ffc5bc58d1161452a657 | 8486269.66727 |
5 | Other | 0x01784ef301d79e4b2df3a21ad9a536d4cf09a5ce | 7000195.11576295 |
6 | Other | 0x875d4cc8f0d91d9f2d985a64a3aa6624313e5fc3 | 5294815.27527337 |
7 | Other | 0xde4fb30ccc2f1210fce2c8ad66410c586c8d1f9a | 4926324.74534386 |
8 | Other | 0x5447f7fe76894d98753a0a6d69b9cb840037c13d | 4772154.41967788 |
9 | Other | 0xd9edc75a3a797ec92ca370f19051babebfb2edee | 4483747.64132237 |
10 | Other | 0x3d36cf85a0c275cf4894315a6c1d6c558d6d984c | 4338920.2769365 |
11 | Other | 0xcefc8b799a8ee5d9b312aeca73262645d664aaf7 | 4171672.51614586 |
12 | Other | 0x2578365b3dfa7ffe60108e181efb79feddec2319 | 3977411.92276478 |
13 | Other | 0xb909f567c5c2bb1a4271349708cc4637d7318b4a | 3890352.03887142 |
14 | Other | 0x21594b992f68495dd28d605834b58889d0a727c7 | 3852626.71082609 |
15 | USDC-MAI | 0x2a1463cebe85315224c536afd389b381b43f3206 | 3828874.39035091 |
16 | hyUSD-eUSD | 0xb5e331615fdba7df49e05cdeaceb14acdd5091c3 | 3613905.27466733 |
17 | DOLA-USDC | 0xf213f2d02837012dc0236cc105061e121bb03e37 | 3251667.60787749 |
18 | Other | 0x488d6ea6064eee9352fdcdb7bc50d98a7ff3ad4e | 2767682.31834241 |
19 | Other | 0x91f0f34916ca4e2cce120116774b0e4fa0cdcaa8 | 2719591.04258317 |
20 | Other | 0x9c38b55f9a9aba91bbcedeb12bf4428f47a6a0b8 | 2561753.31133918 |
Pine AnalyticsTVL Overall (Pool)
Updated 2025-04-11
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 tab1 as (
select
distinct contract_address as pool_address,
POOL_NAME
from base.defi.ez_dex_swaps
where platform ILIKE 'aerodrome'
)
, tab_price as (
SELECT
date_trunc('day', hour) as Date,
token_address,
symbol,
avg(price) as price
from base.price.ez_prices_hourly
where hour > current_date
group by 1,2,3
)
, tab2 as (
select
to_address as Pool,
contract_address as Token_address,
sum(raw_amount/power(10, DECIMALS)) as Amount
from base.core.ez_token_transfers
where to_address in (select pool_address from tab1)
group by 1,2
UNION ALL
select
from_address as Pool,
Last run: 15 days ago
...
4017
271KB
77s