SocioCryptoLiFi vs Socket: Metamask- Base
    Updated 2024-01-12
    -- 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