0xHaM-dmagic-violet
    Updated 2025-02-24
    with token_map as (
    SELECT
    token_address,symbol, decimals
    FROM (
    VALUES
    ('AKEWE7Bgh87GPp171b4cJPSSZfmZwQ3KaqYqXoKLNAEE', 'USDC', 6)
    ,('B22CdjMnZ9jDvn8wGWrfZARHqQWExBAneEqiebL2Vrfn', 'HORSE', 6)
    ,('EK9ZhX3f9mXyUJJFYFZtd7nAC7uhsfvescFbobi63Huf', 'mUSDC', 9)
    ,('68k4DoV9igvoroc4TJZqzXT9bPF2vvovvDu14uDALGRg', 'mSOLAR', 9)
    ,('CwrZKtPiZJrAK3tTjNPP22rD9VzeoxQv8iHd6EeyNoze', 'SOLAR', 9)
    ,('So11111111111111111111111111111111111111112', 'ETH', 9)
    ,('GU7NS9xCwgNPiAdJ69iusFrRfawjDDPjeMBovhV1d4kn', 'tETH', 9)
    ,('GV7HnZPs5vVsrJbVpYh8797EfHZnKDdYJK2gHJnaJAqc', 'MEGA', 9)
    ,('HgD4Dc6qYCj3UanMDiuC4qANheeTsAvk6DY91B3F8gnL', 'MOON', 5)
    ,('LaihKXA47apnS599tyEyasY2REfEzBNe4heunANhsMx', 'LAIKA', 5)
    ,('HK159wmPEnVS9PyN4aHBCaPmhF7aR2n2amk9V6dKL3vg', 'IDC', 6)
    ,('7vfVV2XRyhnQHkX9zxBxWoWAC3JCwpsqScAbJrw43dRq', 'NATA2', 6)
    ,('trbts2EsWyMdnCjsHUFBKLtgudmBD7Rfbz8zCg1s4EK', 'Turbo', 9)
    ,('5SnR4c3JMdFxMnbPLppuzSc3V4AVkdoJ6GfuHdc9vLQZ', 'TWIF', 9)
    ,('2up33jshcxDvxmcQC72bBsQxkS2yYze6uGVnxmQdicvc', 'We Love Eclipse (❤️)', 9)
    ,('8tyFL4H3hEQLFxaoupEd4ERFbnPmegaMjQ9BuQXW8kH7', 'YUMI', 9)
    ) AS t (token_address,symbol, decimals)
    )
    ,
    txsTb as (
    SELECT
    tx_id,
    signers
    FROM
    eclipse.core.fact_transactions t,
    TABLE(FLATTEN(log_messages)) f
    where
    value ilike 'Program log: Instruction: SwapBaseInput'
    and SUCCEEDED
    )
    ,
    Last run: about 1 month ago
    No Data to Display
    0
    2B
    240s