articoloquintoArbitrum Odyssey Bridge
Updated 2022-06-29
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
›
⌄
select (select 'Across') as "bridge", sum(ETH_VALUE) as "ETH bridged to Arbitrum" from arbitrum.core.fact_traces
where FROM_ADDRESS = lower('0xb88690461ddbab6f04dfad7df66b7725942feb9c') AND TX_STATUS = 'SUCCESS' AND BLOCK_TIMESTAMP >= '2022-06-21 17:00:00'
union
select (select 'Hop') as "bridge", sum(ETH_VALUE) as "ETH bridged to Arbitrum" from arbitrum.core.fact_traces
where FROM_ADDRESS = lower('0x33ceb27b39d2Bb7D2e61F7564d3Df29344020417') AND TX_STATUS = 'SUCCESS' AND BLOCK_TIMESTAMP >= '2022-06-21 17:00:00'
union
select (select 'Celer') as "bridge", sum(ETH_VALUE) as "ETH bridged to Arbitrum" from arbitrum.core.fact_traces
where FROM_ADDRESS = lower('0x1619DE6B6B20eD217a58d00f37B9d47C7663feca') AND TX_STATUS = 'SUCCESS' AND BLOCK_TIMESTAMP >= '2022-06-21 17:00:00'
union
select (select 'Hashflow') as "bridge", sum(ETH_VALUE) as "ETH bridged to Arbitrum" from arbitrum.core.fact_traces
where FROM_ADDRESS = lower('0x46C0fe865545353311d61e247201a1DE3Ca0e62e') AND TX_STATUS = 'SUCCESS' AND BLOCK_TIMESTAMP >= '2022-06-21 17:00:00'
union
select (select 'Multichain') as "bridge", sum(ETH_VALUE) as "ETH bridged to Arbitrum" from arbitrum.core.fact_traces
where FROM_ADDRESS = lower('0x650Af55D5877F289837c30b94af91538a7504b76') AND TX_STATUS = 'SUCCESS' AND BLOCK_TIMESTAMP >= '2022-06-21 17:00:00'
order by 2 desc
Run a query to Download Data