LI.FICCTP Extractor - Unlabelled
Updated 2024-05-27
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
›
⌄
-- forked from CCTP Extractor @ https://flipsidecrypto.xyz/edit/queries/7276a369-5b8f-4c8f-881e-a962af31a672
WITH eth AS (
SELECT
'ethereum' AS src_chain,
a.block_timestamp,
CASE
when a.origin_to_address = '0x4cb69fae7e7af841e44e1a1c30af640739378bb2' then 'Wormhole'
when a.origin_to_address = '0x3a23f943181408eac424116af7b7790c94cb97a5' then 'Socket'
when a.origin_to_address = '0x7e77461ca2a9d82d26fd5e0da2243bf72ea45747' then 'Hop'
when a.origin_to_address = '0xd5a597d6e7ddf373a92c8f477daaa673b0902f48' then 'Synapse'
when a.origin_to_address = '0xc51397b75b783e31469bfaade79913f3f82210d6' then 'Allbridge'
when a.origin_to_address = '0xd814d5f567cd4d130b4087c9b7d6d18d29bccac2' then 'MayanFinance'
when a.origin_to_address = '0x1231deb6f5749ef6ce6943a275a1d3e7486f4eae' then 'LiFi'
when a.origin_to_address = '0xbd3fa81b58ba92a82136038b25adec7066af3155' then 'CCTP'
when a.origin_to_address = '0x0439e60f02a8900a951603950d8d4527f400c3f1' then 'MetaMask'
else 'unlabeled'
end as wrappers,
a.origin_to_address as wrapper,
decoded_log:destinationDomain as dest_domain,
a.tx_hash,
a.decoded_log:amount/pow(10,6) as tx_size,
gas_used
FROM
ethereum.core.ez_decoded_event_logs as a
LEFT JOIN ethereum.core.fact_transactions as b
ON a.tx_hash = b.tx_hash
WHERE
contract_address='0xbd3fa81b58ba92a82136038b25adec7066af3155' -- CCTP Contract for Ethereum
and event_name in ('DepositForBurn') -- CCTP Deposit Event Name
AND a.block_timestamp >= current_date - 30
),
arb AS (
SELECT
'arbitrum' AS src_chain,
a.block_timestamp,
QueryRunArchived: QueryRun has been archived