crypto_edgarDaily GST Withdraw & Hold From CEX
    Updated 2024-05-29
    WITH CEX_Addresses as (
    SELECT
    ADDRESS
    FROM
    solana.core.dim_labels
    WHERE
    label_type = 'cex'
    and label_subtype IN ('deposit_wallet', 'hot_wallet')
    ),
    Increases AS (
    SELECT
    TX_TO AS Wallet,
    SUM(AMOUNT) AS TotalIncrease,
    COUNT(*) AS NumIncreaseTransactions,
    MIN(BLOCK_TIMESTAMP) AS FirstIncreaseTransaction,
    MAX(BLOCK_TIMESTAMP) AS LastIncreaseTransaction
    FROM
    solana.core.fact_transfers transfers
    INNER JOIN CEX_Addresses ca ON transfers.TX_FROM = ca.ADDRESS
    WHERE
    MINT = 'AFbX8oGjGpmVFywbVouvhQSRmiW2aR1mohfahi4Y2AdB' -- AND BLOCK_TIMESTAMP >= '2022-06-08'
    AND BLOCK_TIMESTAMP >= '2024-03-04'
    GROUP BY
    TX_TO
    ),
    Decreases AS (
    SELECT
    TX_FROM AS Wallet,
    SUM(AMOUNT) AS TotalDecrease,
    COUNT(*) AS NumDecreaseTransactions,
    MIN(BLOCK_TIMESTAMP) AS FirstDecreaseTransaction,
    MAX(BLOCK_TIMESTAMP) AS LastDecreaseTransaction
    FROM
    solana.core.fact_transfers
    WHERE
    MINT = 'AFbX8oGjGpmVFywbVouvhQSRmiW2aR1mohfahi4Y2AdB' -- AND BLOCK_TIMESTAMP >= '2022-06-08'
    QueryRunArchived: QueryRun has been archived