TOKEN | Bridge Count | Bridgers | Solana Wallets Engaged in Bridges | Bridge Volume | Bridge Volume(USD) | |
|---|---|---|---|---|---|---|
1 | USDC | 10723 | 5563 | 5984 | 457649.333026534 | 457649.333026534 |
2 | SOL | 7886 | 4602 | 5024 | 984.906212115 | 194174.952436223 |
3 | USDT | 12805 | 6624 | 7322 | 639681.276613869 | 639681.276613869 |
Salehbridge_near_to_solana
Updated 1 day 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 lst_sol_price as (
select
hour::date as sol_price_date
,avg(price) as Sol_Price
from solana.price.ez_prices_hourly
where token_address = 'So11111111111111111111111111111111111111112'
group by 1
)
,lst_eth_price as (
select
hour::date as eth_price_date
,avg(price) as ETH_Price
from ethereum.price.ez_prices_hourly
where SYMBOL ilike 'ETH'
and NAME = 'ethereum'
group by 1
)
,lst_near_price as (
select
hour::date as near_price_date
,avg(close) as NEAR_Price
from near.price.fact_prices_ohlc_hourly
where ASSET_ID='wrapped-near'
and near_price_date is not null
group by 1
)
,lst_Sol_Contract as (
select '11111111111111111111111111111111' as contract_id , 9 as decimal ,'SOL' as token_name
union all
select 'So11111111111111111111111111111111111111112' as contract_id ,9 as decimal ,'SOL' as token_name
union all
select 'AHW5N8iqZobTcBepkSJzZ61XtAuSzBDcpxtrLG6KUKPk' as contract_id , 9 as decimal ,'BENDOG' as token_name
union all
select 'EPjFWdd5AufqSSqeM2qN1xzybapC8G4wEGGkZwyTDt1v' as contract_id , 6 as decimal ,'USDC' as token_name
union all
select 'BYPsjxa3YuZESQz1dKuBw1QSFCSpecsm8nCQhY5xbU1Z' as contract_id , 9 as decimal ,'wNEAR' as token_name
Last run: 1 day ago
3
173B
86s