crypto_edgarWallet Interactions - Behavioral Patterns
    Updated 2025-06-14
    -- FACC
    -- 0x4d754910d570b30f9a0150eeb7281cb3ce0cf42f - Gnosis Safe Proxy
    -- 0x67976cea42d4831cf0b17ac3173e90496388fbf4 - iFACC Staking Contract
    -- 0x35bce29f52f51f547998717cd598068afa2b29b7 - StakedLockingCrowdSale
    -- 0x30efee8d51a949813d1dd40e68f18c4e2147c760 - Uniswap V3 Pool
    -- 0x6c20d622d0bc3ec86e6536995ae444ce09da7cf3 - Safe Proxy
    WITH TOKEN_SUPPLY_INFO_RAW as (
    select
    livequery.live.udf_api(
    'https://flipsidecrypto.xyz/api/v1/queries/2f5a6445-f5ff-4cd1-9c1f-16cd94fcb136/data/latest'
    ): data as data
    ),
    TOKEN_SUPPLY_INFO as (
    SELECT
    VALUE:CONTRACT_ADDRESS :: STRING AS CONTRACT_ADDRESS,
    VALUE:SYMBOL :: STRING AS SYMBOL,
    VALUE:NAME :: STRING AS NAME,
    VALUE:TOTAL_AMOUNT_MINTED :: STRING AS TOTAL_AMOUNT_MINTED
    FROM
    (
    select
    *
    from
    TOKEN_SUPPLY_INFO_RAW
    ) response,
    LATERAL FLATTEN(INPUT => PARSE_JSON(response.data))
    ),
    TOP_HOLDERS AS (
    SELECT
    LAST_ACTIVITY_BLOCK_TIMESTAMP,
    USER_ADDRESS,
    CURRENT_BAL,
    SYMBOL
    FROM
    ethereum.core.ez_current_balances
    WHERE
    QueryRunArchived: QueryRun has been archived