superflyHistogram
    Updated 2024-10-06
    WITH token_holders AS (
    SELECT
    address,
    SUM(token_amount) AS token_amount
    FROM (
    SELECT
    origin_from_address AS address,
    amount_usd AS token_amount
    FROM ethereum.core.ez_token_transfers
    WHERE block_timestamp >= '2024-01-01' AND block_timestamp <= current_timestamp
    UNION ALL
    SELECT
    origin_from_address AS address,
    amount_usd AS token_amount
    FROM avalanche.core.ez_token_transfers
    WHERE block_timestamp >= '2024-01-01' AND block_timestamp <= current_timestamp
    UNION ALL
    SELECT
    origin_from_address AS address,
    amount_usd AS token_amount
    FROM optimism.core.ez_token_transfers
    WHERE block_timestamp >= '2024-01-01' AND block_timestamp <= current_timestamp
    UNION ALL
    SELECT
    origin_from_address AS address,
    amount_usd AS token_amount
    FROM polygon.core.ez_token_transfers
    WHERE block_timestamp >= '2024-01-01' AND block_timestamp <= current_timestamp
    UNION ALL
    QueryRunArchived: QueryRun has been archived