PS0G1vol across
Updated 2022-11-30
99
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
›
⌄
--credit misaghlb
with bridge_data as (
SELECT
a.BLOCK_TIMESTAMP,
a.tx_hash,
SYMBOL,
amount, amount_usd,
b.origin_from_address,
regexp_substr_all(SUBSTR(a.DATA, 3, len(a.DATA)), '.{64}')[2] AS seg_ch2,
ethereum.public.udf_hex_to_int(seg_ch2) as chainid,
case when chainid = '137' THEN 'Polygon'
WHEN chainid = '288' THEN 'Boba'
WHEN chainid = '10' THEN 'Optimism'
WHEN chainid = '42161' THEN 'Arbitrum'
when chainid = '1' then 'Ethereum'
when chainid = '56' then 'BNB'
when chainid = '43114' then 'Avalanche'
when chainid = '288' then 'Boba'
else 'Others'
END as chain
FROM ethereum.core.fact_event_logs a
join ethereum.core.ez_token_transfers b on a.tx_hash = b.tx_hash
where date(a.BLOCK_TIMESTAMP) >= '2022-06-01'
and lower(a.CONTRACT_ADDRESS) = lower('0x4D9079Bb4165aeb4084c526a32695dCfd2F77381')
and a.origin_to_address = lower('0x4D9079Bb4165aeb4084c526a32695dCfd2F77381')
and a.origin_from_address != '0x428ab2ba90eba0a4be7af34c9ac451ab061ac010' -- relayer
and a.origin_from_address != '0xf7bac63fc7ceacf0589f25454ecf5c2ce904997c'
and a.tx_status = 'SUCCESS'
UNION all
SELECT
a.BLOCK_TIMESTAMP,
a.tx_hash,
Run a query to Download Data