gigiokobashocked-magenta
    Updated 8 days ago
    WITH native_transfers AS (
    SELECT
    DATE_TRUNC('day', block_timestamp) AS date,
    SUM(CASE
    WHEN to_address = LOWER('0xa5990322C9710F1277A37Ef7F8aFA9a3f4eA2D47') THEN amount
    WHEN from_address = LOWER('0xa5990322C9710F1277A37Ef7F8aFA9a3f4eA2D47') THEN -amount
    ELSE 0
    END) AS daily_net_bnb_flow,
    COUNT(CASE
    WHEN to_address = LOWER('0xa5990322C9710F1277A37Ef7F8aFA9a3f4eA2D47') THEN 1
    ELSE NULL
    END) AS inflow_count,
    COUNT(CASE
    WHEN from_address = LOWER('0xa5990322C9710F1277A37Ef7F8aFA9a3f4eA2D47') THEN 1
    ELSE NULL
    END) AS outflow_count
    FROM bsc.core.ez_native_transfers
    WHERE
    (from_address = LOWER('0xa5990322C9710F1277A37Ef7F8aFA9a3f4eA2D47')
    OR to_address = LOWER('0xa5990322C9710F1277A37Ef7F8aFA9a3f4eA2D47'))
    AND block_timestamp >= DATEADD(day, -30, CURRENT_DATE()) -- ✅ Fixed missing filter
    GROUP BY 1
    ),

    token_transfers AS (
    SELECT
    DATE_TRUNC('day', block_timestamp) AS date,
    contract_address,
    symbol,
    SUM(CASE
    WHEN to_address = LOWER('0xa5990322C9710F1277A37Ef7F8aFA9a3f4eA2D47') THEN amount
    WHEN from_address = LOWER('0xa5990322C9710F1277A37Ef7F8aFA9a3f4eA2D47') THEN -amount
    ELSE 0
    END) AS daily_net_token_flow,
    COUNT(CASE
    WHEN to_address = LOWER('0xa5990322C9710F1277A37Ef7F8aFA9a3f4eA2D47') THEN 1
    Last run: 8 days ago
    DATE
    DAILY_NET_BNB_FLOW
    CUMULATIVE_BNB_BALANCE
    BNB_INFLOW_COUNT
    BNB_OUTFLOW_COUNT
    SYMBOL
    DAILY_NET_TOKEN_FLOW
    CUMULATIVE_TOKEN_BALANCE
    TOKEN_INFLOW_COUNT
    TOKEN_OUTFLOW_COUNT
    1
    2025-02-24 00:00:00.0000.140.8710AKITA-292-590813601
    2
    2025-02-24 00:00:00.0000.140.8710USDT14560.49071254062.43164191212
    3
    2025-02-24 00:00:00.0000.140.8710USDТ-5792.3173-17032.367303
    4
    2025-02-10 00:00:00.0000.150.4510AKITA-5907844-590784404
    5
    2025-02-10 00:00:00.0000.150.4510USDT39501.94092939501.9409296910
    6
    2025-02-10 00:00:00.0000.150.4510USDТ-11240.05-11240.0502
    6
    455B
    4s