BlockTrackersocket total
    Updated 2024-08-30
    WITH chains as (
    select * from (
    VALUES
    ('Ethereum', 1),
    ('Arbitrum', 42161),
    ('Optimism ', 10),
    ('BNB Smart chain', 56),
    ('Avalanche_C', 43114),
    ('Polygon', 137),
    ('Base', 8453),
    ('Gnosis', 100),
    ('Polygon zkEVM',1101),
    ('zkSync Era', 324),
    ('Fantom', 250),
    ('Linea', 59144),
    ('Aurora',1313161554),
    ('Mantle',5000),
    ('Scroll', 534352),
    ('Blast', 81457)
    ) as a (chain, chain_id)
    )
    -- ,
    -- aurora_chain_data as (
    -- select
    -- 'aurora' as src_chain ,
    -- 'Socket' as aggregator,
    -- block_timestamp,
    -- tx_hash,
    -- origin_from_address,
    -- livequery.utils.udf_hex_to_int(
    -- REGEXP_SUBSTR_ALL(SUBSTR(data, 3, len(data)), '.{64}')[2] :: string) :: int as dest_chain_id ,
    -- livequery.utils.udf_hex_to_int(
    -- REGEXP_SUBSTR_ALL(SUBSTR(data, 3, len(data)), '.{64}')[0]::string) :: int as amount_raw ,
    -- lower('0x' || substr(
    -- REGEXP_SUBSTR_ALL(SUBSTR(data, 3, len(data)), '.{64}')[1]::string, 25, 40) :: string) as token
    -- from aurora.core.fact_logs
    QueryRunArchived: QueryRun has been archived