Deebs-DeFi-j9fRbzSibel ETH balances Moodeng
    Updated 2024-11-09
    -- forked from Rothschild Investigation Part 1 BAR CHART ADJUSTED copy @ https://flipsidecrypto.xyz/studio/queries/355a86c8-bd97-4cf1-abe6-6e4e048ab0b5

    -- forked from Rothschild Investigation Part 1 BAR CHART ADJUSTED @ https://flipsidecrypto.xyz/studio/queries/b2a2f5fc-b95b-4c5a-be90-90524d007c3c

    -- forked from Rothschild Investigation Part 1 PNUT 68 wallets @ https://flipsidecrypto.xyz/studio/queries/6aadb0ee-3702-466e-bf69-4cee15ae0a88

    -- forked from Rothschild Investigation @ https://flipsidecrypto.xyz/studio/queries/718cde45-657d-45f9-b83d-d56c2908a515
    SELECT
    --ROW_NUMBER() OVER (ORDER BY MAX(BALANCE) DESC) AS row_num,
    Owner,
    --MAX(BALANCE) AS top_balance,
    --date_trunc('day', BLOCK_TIMESTAMP)
    BLOCK_TIMESTAMP,
    Balance
    FROM solana.core.fact_token_balances
    WHERE BLOCK_TIMESTAMP BETWEEN '{{start_date}}' AND '{{end_date}}'
    AND MINT='{{CA}}'
    AND OWNER NOT IN('5Q544fKrFoe6tsEbD7S8EmxGTJYAKtTVhAW5Q5pge4j1','2JUXSuq1A1EdBzZj757cXFYuALPxv6vee4X981ajpzo8')
    AND balance=500000
    --GROUP BY 2,4
    --HAVING MAX(Balance)>4000000
    --AND MAX(Balance)<1000000000000
    --ORDER BY top_balance DESC
    LIMIT 100;




    QueryRunArchived: QueryRun has been archived