Distribution of Active Token Holders by Segment

Kruys-CollinsDistribution of Active Token Holders by Segment

Updated 2025-03-17

WITH base_data AS (

WITH

token_params AS (

SELECT lower('0xb2F85b7AB3c2b6f62DF06dE6aE7D09c010a5096E') AS token_address --XSGD token

-- Getting all relevant transfer activity

transfers AS (

SELECT

BLOCK_TIMESTAMP,

FROM_ADDRESS,

TO_ADDRESS,

AMOUNT,

AMOUNT_USD,

TX_HASH

FROM avalanche.core.ez_token_transfers

WHERE CONTRACT_ADDRESS = (SELECT token_address FROM token_params)

-- Get liquidity pools that contain the XSGD token

liquidity_pools AS (

SELECT

POOL_ADDRESS,

PLATFORM

FROM avalanche.defi.dim_dex_liquidity_pools

WHERE

TOKENS:token0::STRING = LOWER((SELECT token_address FROM token_params))

OR TOKENS:token1::STRING = LOWER((SELECT token_address FROM token_params))

-- Calculating metrics per address to enable segmentation

address_metrics AS (

SELECT

address,

SUM(total_volume_out) AS total_sent_volume,

SUM(total_volume_in) AS total_received_volume,

Last run: about 1 month ago

129B

flipside