SalehOverall Comparison
    Updated 2025-04-24
    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: about 1 month ago
    ROUTE
    Bridge Count
    Bridgers
    Solana Wallets Engaged in Bridges
    Bridge Volume
    Bridge Volume(USD)
    1
    Near=>Solana3140413474148341098265.915263771291455.19112725
    2
    Solana=>Near283901227013441993890.4401005331185953.83263449
    2
    139B
    154s