Symbol | TVL | TVL (USD) | |
---|---|---|---|
1 | STNEAR | 4498047.67255813 | 31582920.0628036 |
2 | NEAR | 35784099.5897962 | 185012771.957087 |
3 | WOO | 2967803.23398619 | 636863.581874441 |
4 | AURORA | 919899.059891226 | 203990.295999775 |
5 | WBTC | 24.024104403 | 2323698.25016956 |
6 | NearX | 120743.692301004 | 731905.364387661 |
7 | USDC.e | 4671360.05095259 | 4672540.25342136 |
8 | ETH | 825.370929661 | 2799319.79132935 |
9 | LINEAR | 7534291.09072529 | 49734966.8695737 |
10 | USDT.e | 2044694.88340039 | 2042483.65973501 |
11 | pNEAR | 57496.968917543 | 297273.753440995 |
12 | USDC | 1238780.42994344 | 1239093.40340422 |
13 | USDt | 392814.647414826 | 392389.840246028 |
14 | SWEAT | 13216572.2356052 | 91702.052034297 |
15 | DAI | 2147725.05664022 | 2147649.87868482 |
Flipside Teamnear platforms - token total tvl copy
Updated 2024-11-27
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
›
⌄
-- forked from near platforms - token total tvl @ https://flipsidecrypto.xyz/edit/queries/d0adf18d-e41c-4784-8e3b-baf9cf12923b
with
prices as (
select date_trunc(day, TIMESTAMP) as date, TOKEN_CONTRACT, avg(PRICE_USD) as price
from near.price.fact_prices
where TOKEN_CONTRACT!='aurora'
group by 1,2
union all
select date_trunc(day, TIMESTAMP) as date, 'phoenix-bonds.near', avg(PRICE_USD) as price
from near.price.fact_prices
where TOKEN_CONTRACT='wrap.near'
group by 1,2
union all
select date_trunc(day, TIMESTAMP) as date, 'near', avg(PRICE_USD) as price
from near.price.fact_prices
where TOKEN_CONTRACT='wrap.near'
group by 1,2
union all
select date_trunc(day, HOUR) as date, 'token.sweat' TOKEN_ADDRESS, avg(PRICE) as price
from crosschain.price.ez_prices_hourly
where symbol='SWEAT' and BLOCKCHAIN='ethereum'
group by 1,2
union all
select date_trunc(day, HOUR) as date, 'aurora' TOKEN_ADDRESS, avg(PRICE) as price
from crosschain.price.ez_prices_hourly
where TOKEN_ADDRESS='0xc02aaa39b223fe8d0a0e5c4f27ead9083c756cc2' and BLOCKCHAIN='ethereum'
group by 1,2
),
tokens as (
select SYMBOL, CONTRACT_ADDRESS as TOKEN_CONTRACT, DECIMALS
from near.core.dim_ft_contract_metadata
QUALIFY row_number() over (partition by TOKEN_CONTRACT order by SYMBOL desc)=1
union all
select 'pNEAR', 'phoenix-bonds.near', 24
Last run: about 2 months agoAuto-refreshes every 3 hours
15
647B
92s