crypto_edgarTop Holders
    Updated 2024-11-21
    WITH HAPPY_SUPPLY AS (
    SELECT
    VALUE:TOTAL_SUPPLY :: FLOAT AS TOTAL_SUPPLY
    FROM
    (
    select
    livequery.live.udf_api(
    'https://flipsidecrypto.xyz/api/v1/queries/ec58ca0f-194d-4378-8e22-4ecfa546c72a/data/latest'
    ): data as DATA
    ) response,
    LATERAL FLATTEN(INPUT => PARSE_JSON(response.data))
    ),
    daily_balances AS (
    -- Step 1: Calculate net transfers for each wallet per day
    SELECT
    DATE_TRUNC('Day', BLOCK_TIMESTAMP) AS DAY,
    TX_TO AS wallet,
    SUM(AMOUNT) AS net_amount
    FROM
    solana.core.fact_transfers
    WHERE
    AMOUNT > 0
    AND MINT = 'HAPPYwgFcjEJDzRtfWE6tiHE9zGdzpNky2FvjPHsvvGZ'
    AND BLOCK_ID >= 299847317
    GROUP BY
    DAY,
    TX_TO
    UNION
    ALL
    SELECT
    DATE_TRUNC('Day', BLOCK_TIMESTAMP) AS DAY,
    TX_FROM AS wallet,
    - SUM(AMOUNT) AS net_amount
    FROM
    solana.core.fact_transfers
    WHERE
    QueryRunArchived: QueryRun has been archived