SocioCryptoLiFi vs Socket: Metamask- Base
Updated 2024-01-12
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 LiFi vs Socket: Metamask- Optimism @ https://flipsidecrypto.xyz/edit/queries/246c2822-265c-4f71-a9e8-9e34afb25cf2
WITH chains AS (
SELECT
*
FROM
(
VALUES
('Ethereum Mainnet', '1', '0x1', 'ETH'),
('Arbitrum One', '42161', '0xa4b1', 'ETH'),
('BNB Smart Chain Mainnet', '56', '0x38', 'BNB'),
('Avalanche C-Chain', '43114', '0xa86a', 'AVAX'),
('OP Mainnet', '10', '0xa', 'ETH'),
('Polygon Mainnet', '137', '0x89', 'MATIC'),
('BASE', '8453', '0x2105', 'ETH'),
('Gnosis', '100', '0x64', 'XDAI'),
('zkSync Mainnet', '324', '0x144', 'ETH'),
('Solana', '1151111081099710', '', 'SOL'),
('Fantom Opera', '250', '0xfa', 'FTM'),
('Polygon zkEVM', '1101', '0x44d', 'ETH'),
('WEMIX3.0 Mainnet', '111', '0x457', 'WEMIX'),
('Velas EVM Mainnet', '106', '0x6a', 'VLX'),
('EtherInc', '101', '0x65', 'ETI'),
('Linea', '59144', '0xe708', 'ETH')
) as a (chain, chain_id, chain_0x_id, currency)
)
, lifiDiamond as (
SELECT 'lifiDiamond' as contract,
to_varchar(decoded_log:bridgeData:destinationChainId) as chain_id,
to_varchar(decoded_log:bridgeData:sendingAssetId) as token_in,
tx_hash
FROM
base.core.ez_decoded_event_logs
WHERE
block_timestamp >= '2023-11-10'
QueryRunArchived: QueryRun has been archived