CHAIN | POOL | TYPE | LIQUIDITY_SHARE | VALUE | |
|---|---|---|---|---|---|
1 | Base | OLAS-USDC Balancer | Protocol-owned liquidity (USD) | 0.9146118096 | 433308.814030746 |
MLDZMNOLAS-USDC Balancer
Updated 9 hours ago
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 tvl_data as (with latest_price as (select
PRICE as token_price_usd
from ethereum.price.ez_prices_hourly
where TOKEN_ADDRESS = lower('0x0001a500a6b18995b03f44bb040a5ffc28e45cb0')
order by HOUR desc
limit 1),
balance as (
select
address,
sum(holding)/1e18 as OLASbalance
from (
select
FROM_ADDRESS as address,
-sum(RAW_AMOUNT) as holding
from base.core.ez_token_transfers
where contract_address = lower ('0x54330d28ca3357F294334BDC454a032e7f353416')
group by FROM_ADDRESS, BLOCK_TIMESTAMP
union all
select
TO_ADDRESS as address,
sum(RAW_AMOUNT) as holding
from base.core.ez_token_transfers
where contract_address = lower('0x54330d28ca3357F294334BDC454a032e7f353416')
group by TO_ADDRESS,BLOCK_TIMESTAMP
) as transfer_summary
where address = lower('0xba12222222228d8ba445958a75a0704d566bf2c8')
group by address ),
combined_info AS (
SELECT
p.token_price_usd AS olas_last_price,
b.OLASbalance AS current_olas_balance
FROM
latest_price p
Last run: about 9 hours agoAuto-refreshes every 12 hours
1
94B
670s