Monitoring Cross-Chain Paths By Transfers Volume

Eman-RazMonitoring Cross-Chain Paths By Transfers Volume

Updated 5 hours ago

with overview as (with tab1 as (

select date_trunc('hour',block_timestamp) as hour, amount, token_address,

source_chain || '➡' || destination_chain as "Path", tx_id, source_address, destination_address

from flow.defi.ez_bridge_activity

where platform='{{Platform}}'),

tab2 as (select hour, avg(close) as price, case

when asset_id='blocto-token' then 'A.0f9df91c9121c460.BloctoToken'

when asset_id='starly' then 'A.142fa6570b62fd97.StarlyToken'

when asset_id='flow' then 'A.1654653399040a61.FlowToken'

when asset_id='revv' then 'A.d01e482eb680ec9f.REVV'

end as token_address, case

when asset_id='blocto-token' then 'BLT'

when asset_id='starly' then 'STARLY'

when asset_id='flow' then 'FLOW'

when asset_id='revv' then 'REVV'

end as token_symbol

from crosschain.price.fact_prices_ohlc_hourly

where asset_id in ('blocto-token','starly','flow','revv')

group by 1,3,4

union all

select hour, price, case

when token_address=lower('0xf1f955016EcbCd7321c7266BccFB96c68ea5E49b') then 'A.231cc0dbbcffc4b7.RLY'

when token_address=lower('0xb31f66aa3c1e785363f0875a1b74e27b85fd66c7') then 'A.231cc0dbbcffc4b7.ceAVAX'

when token_address=lower('0x418D75f65a02b3D53B2418FB8E1fe493759c7605') then 'A.231cc0dbbcffc4b7.ceBNB'

when token_address=lower('0x4Fabb145d64652a948d72533023f6E7A623C7C53') then 'A.231cc0dbbcffc4b7.ceBUSD'

when token_address=lower('0x6b175474e89094c44da98b954eedeac495271d0f') then 'A.231cc0dbbcffc4b7.ceDAI'

when token_address=lower('0xfd086bc7cd5c481dcc9c85ebe478a1c0b69fcbb9') then 'A.231cc0dbbcffc4b7.ceUSDT'

when token_address=lower('0xdac17f958d2ee523a2206206994597c13d831ec7') then 'A.cfdd90d4a00f7b5b.TeleportedTetherToken'

when token_address=lower('0x56156fb7860d7eb0b4b1a5356c5354b295194a45') then 'A.475755d2c9dccc3a.TeleportedSportiumToken'

when token_address=lower('0xa0b86991c6218b36c1d19d4a2e9eb0ce3606eb48') then 'A.b19436aae4d94622.FiatToken'

when token_address=lower('0xc2132d05d31c914a87c6611c10748aeb04b58e8f') then 'A.9c6f94adf47904b5.UsdcUsdtSwapPair'

when token_address=lower('0x4e15361fd6b4bb609fa63c81a2be19d873717870') then 'A.231cc0dbbcffc4b7.ceFTM '

when token_address=lower('0x7d1afa7b718fb893db30a3abc0cfc608aacfebb0') then 'A.231cc0dbbcffc4b7.ceMATIC'

Last run: about 5 hours agoAuto-refreshes every 24 hours

207B

75s

flipside