Eman-RazDistribution of Addresses Based on the Number of Chains Where They Hold SWELL Tokens
    Updated 2025-05-17
    with final_table as (with overview as (with swell as (with tab2 as (with tab1 as
    (SELECT lower(from_data.value:"value"::STRING) AS user --from_address,
    ,-amount_data.value:"value"::NUMBER/pow(10,18) AS amount
    FROM swell.core.ez_decoded_event_logs,
    LATERAL FLATTEN(input => full_decoded_log:"data") from_data,
    LATERAL FLATTEN(input => full_decoded_log:"data") to_data,
    LATERAL FLATTEN(input => full_decoded_log:"data") amount_data
    WHERE from_data.value:"name" = 'from'
    AND to_data.value:"name" = 'to'
    AND amount_data.value:"name" = 'value'
    and event_name='Transfer'
    and tx_succeeded='TRUE'
    and lower(full_decoded_log:"address"::STRING)=lower('0x2826D136F5630adA89C1678b64A61620Aab77Aea')

    union all

    SELECT
    lower(to_data.value:"value"::STRING) AS user --to_address,
    ,amount_data.value:"value"::NUMBER/pow(10,18) AS amount
    FROM swell.core.ez_decoded_event_logs,
    LATERAL FLATTEN(input => full_decoded_log:"data") from_data,
    LATERAL FLATTEN(input => full_decoded_log:"data") to_data,
    LATERAL FLATTEN(input => full_decoded_log:"data") amount_data
    WHERE from_data.value:"name" = 'from'
    AND to_data.value:"name" = 'to'
    AND amount_data.value:"name" = 'value'
    and event_name='Transfer'
    and tx_succeeded='TRUE'
    and lower(full_decoded_log:"address"::STRING)=lower('0x2826D136F5630adA89C1678b64A61620Aab77Aea'))

    select user, sum(amount) as balance
    from tab1
    group by 1)

    select user as "Holder", balance, 'Swell Network' as "Chain"
    from tab2
    Last run: about 2 months ago
    Number of Chain
    Number of Holders
    1
    148740
    2
    23037
    2
    20B
    11s