jivalaMetamask Overview
    Updated 2024-07-20
    WITH chains AS (
    SELECT 1 AS chain_id, '6648936' AS chain_domain, 'ethereum' AS chain_name UNION ALL
    SELECT 10, '1869640809' AS chain_domain, 'optimism' UNION ALL
    SELECT 25, '' AS chain_domain, 'cronos' UNION ALL
    SELECT 56, '6450786' AS chain_domain, 'bnb' UNION ALL
    SELECT 66, '' AS chain_domain, 'okx' UNION ALL
    SELECT 100, '6778479' AS chain_domain, 'gnosis' UNION ALL
    SELECT 101, '' AS chain_domain, 'ether inc' UNION ALL
    SELECT 102, '6450786' AS chain_domain, 'bnb' UNION ALL
    SELECT 106, '' AS chain_domain, 'velas' UNION ALL
    SELECT 109, '' AS chain_domain, 'shibarium' UNION ALL
    SELECT 110, '1634886255' AS chain_domain, 'arbitrum' UNION ALL
    SELECT 111, '' AS chain_domain, 'etherlite chain' UNION ALL
    SELECT 122, '' AS chain_domain, 'fuse' UNION ALL
    SELECT 137, '1886350457' AS chain_domain, 'polygon' UNION ALL
    SELECT 184, '1650553709' AS chain_domain, 'base' UNION ALL
    SELECT 250, '' AS chain_domain, 'fantom' UNION ALL
    SELECT 288, '' AS chain_domain, 'boba' UNION ALL
    SELECT 1088, '1835365481' AS chain_domain, 'metis' UNION ALL
    SELECT 1101, '' AS chain_domain, 'polygon zkEVM' UNION ALL
    SELECT 1284, '' AS chain_domain, 'moonbeam' UNION ALL
    SELECT 1285, '' AS chain_domain, 'moonriver' UNION ALL
    SELECT 8453, '1650553709' AS chain_domain, 'base' UNION ALL
    SELECT 9001, '' AS chain_domain, 'evmos' UNION ALL
    SELECT 42161, '1634886255' AS chain_domain, 'arbitrum' UNION ALL
    SELECT 42220, '' AS chain_domain, 'celo' UNION ALL
    SELECT 43114, '' AS chain_domain, 'avalanche' UNION ALL
    SELECT 1313161554, '' AS chain_domain, 'aurora' UNION ALL
    SELECT 1666600000, '' AS chain_domain, 'harmony' UNION ALL
    SELECT 1151111081099710, '' AS chain_domain, 'solana' UNION ALL
    SELECT 59144, '1818848877' AS chain_domain, 'linea' UNION ALL
    SELECT 324, '' AS chain_domain, 'zksync'
    ),
    MM_init AS (
    SELECT tx_hash, src_chain, event_name, decoded_log, block_timestamp AS date
    FROM (
    QueryRunArchived: QueryRun has been archived