StangFAST003 - daily holder [ change ]
    Updated 2023-12-11

    with

    --- outflow
    tab1 AS
    (
    SELECT
    a.tx_from AS tx_sg
    , sum( a.amount ) AS am_ac
    FROM
    solana.core.fact_transfers a
    WHERE
    a.mint = '5MAYDfq5yxtudAhtfyuMBuHZjgAbaS9tbEyEQYAhDS5y'
    GROUP BY 1
    ORDER BY 1 DESC
    )
    ,
    --- inflow
    tab2 AS
    (
    SELECT
    a.tx_to AS tx_sg
    , sum( a.amount ) AS am_ac
    FROM
    solana.core.fact_transfers a
    WHERE
    a.mint = '5MAYDfq5yxtudAhtfyuMBuHZjgAbaS9tbEyEQYAhDS5y'
    GROUP BY 1
    ORDER BY 1 DESC
    )
    ,
    --- holder
    tab3 AS
    (
    SELECT
    case
    Run a query to Download Data