Asset | Total Liquidity | |
|---|---|---|
1 | USDCE | 1006987.55 |
2 | USDT0 | 366256.54 |
Eman-RazTotal Liquidity By Stablecoin
Updated 7 days 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 overview as (
with pool1 as (with tab1 as (select sum(amount) as output_volume
from ink.core.ez_token_transfers
where from_address=lower('0x317728bcCE5d1C2895b71b01eEBbB6989ae504aE')
and contract_address=lower('0xF1815bd50389c46847f0Bda824eC8da914045D14')),
tab2 as (select sum(amount) as input_volume
from ink.core.ez_token_transfers
where to_address=lower('0x317728bcCE5d1C2895b71b01eEBbB6989ae504aE')
and contract_address=lower('0xF1815bd50389c46847f0Bda824eC8da914045D14'))
select lower('0x317728bcCE5d1C2895b71b01eEBbB6989ae504aE') as "Pool Address",
'Velodrome Finance' as "Platform", 'USD₮0/USDC.e' as "Pool Name", 'USDCE' as "Asset",
input_volume as "Liquidity Provided", output_volume as "Liquidity Removed", input_volume-output_volume as "Balance"
from tab1 , tab2),
-----------------------------------------------------------------------------------------------------------------------
pool2 as (with tab1 as (select sum(amount) as output_volume
from ink.core.ez_token_transfers
where from_address=lower('0x317728bcCE5d1C2895b71b01eEBbB6989ae504aE')
and contract_address=lower('0x0200C29006150606B650577BBE7B6248F58470c1')),
tab2 as (select sum(amount) as input_volume
from ink.core.ez_token_transfers
where to_address=lower('0x317728bcCE5d1C2895b71b01eEBbB6989ae504aE')
and contract_address=lower('0x0200C29006150606B650577BBE7B6248F58470c1'))
select lower('0x317728bcCE5d1C2895b71b01eEBbB6989ae504aE') as "Pool Address", 'Velodrome Finance' as "Platform", 'USD₮0/USDC.e' as "Pool Name", 'USDT0' as "Asset",
input_volume as "Liquidity Provided", output_volume as "Liquidity Removed", input_volume-output_volume as "Balance"
from tab1 , tab2),
-----------------------------------------------------------------------------------------------------------------------
pool3 as (with tab1 as (select sum(amount) as output_volume
from ink.core.ez_token_transfers
where from_address=lower('0x67ce303f24b3841698891Cece349072856B80A9C')
and contract_address=lower('0xF1815bd50389c46847f0Bda824eC8da914045D14')),
tab2 as (select sum(amount) as input_volume
Last run: 7 days ago
2
42B
6s