ChiefMango V4 copy copy
    Updated 2023-04-13
    -- serum3cancelorder order for buying bonk, hence why usdc is being sent back. '2KZ92iqKudqe5s2DJWBQ8ZEm4jpqdMQMfbkVBhTYLDykCiu4dDQ6R7rTYsujevrLcybYgDBR'
    -- limit not fully buy
    -- jump address = 'CTz5UMLQm2SRWHzQnU62Pi4yJqbNGjgRBHqqp6oDHfF7'
    with bonk as(
    SELECT *
    FROM solana.core.fact_transfers t
    JOIN (SELECT tx_id as tx, program_id FROM solana.core.fact_events
    WHERE program_id = '4MangoMjqJ2firMokCjjGgoK8d4MXcrgL7XJaL3w6fVg') e
    ON e.tx = t.tx_id
    where 1=1
    AND block_timestamp > current_date - 4
    AND tx_to = '78b8f4cGCwmZ9ysPFMWLaLTkkaYnUjwMJYStWe5RTSSX'
    -- AND tx_from != '3oQLKk1TyyXMT14p2i8p95v5jKqsQ5qzZGwxZCTnFC7p'
    -- AND tx_from in ('9Jrju2Z5ocTKfV1wf1Dkqc2BSc4Dy3D3raFSwDEX7zpf', '3oQLKk1TyyXMT14p2i8p95v5jKqsQ5qzZGwxZCTnFC7p')
    -- 8BnEgHoWFysVcuFFX7QztDmzuH8r5ZFvyP3sYwn1XTh6 sol-u
    -- AND mint = 'EPjFWdd5AufqSSqeM2qN1xzybapC8G4wEGGkZwyTDt1v'
    -- when tx_to amount = 0 'set_order, not traded'
    -- AND mint = 'DezXAZ8z7PnrnRJjz3wXBoRgixCa6xjnB7YaB1pPB263'
    -- AND mint IN ('DezXAZ8z7PnrnRJjz3wXBoRgixCa6xjnB7YaB1pPB263', -- 'BONK'
    -- 'MangoCzJ36AjZyKwVj3VnYU4GTonjfVEnJmvvWaxLac' -- 'MNGO'
    -- 'HVoJWyPbQn4XikG9BY2A8wP27HJQzHAoDnAs1SfsATes') -- 'MNGO'
    -- WHEN mint = 'Es9vMFrzaCERmJfrF4H2FYD4KCoNkY11McCe8BenwNYB' THEN 'USDT'
    -- WHEN mint = 'EjmyN6qEC1Tf1JxiG1ae7UTJhUxSwk1TCWNWqxWV4J6o' THEN 'DAI'
    -- WHEN mint = 'mSoLzYCxHdYgdzU16g5QSh3i5K3z3KZK7ytfqcJm7So' THEN 'MSOL'
    -- WHEN mint = '7vfCXTUXx5WJV5JADk17DUJ4ksgau7utNKj4b963voxs' THEN 'WETH'
    -- WHEN mint = '3NZ9JMVBmGAqocybic2c7LQCJScmgsAZ6vQqTDzcqmJh' THEN 'wBTC'
    -- WHEN mint = '4r9qgnvhn3xhHWVdnW65oB2pwnEhjDjJDVtkkbiPqPrp' THEN 'alameda_asset'
    -- WHEN mint = 'So11111111111111111111111111111111111111112' THEN 'SOL'
    ),

    agg1 as ( SELECT distinct tx_id,
    mint, index, tx_from, tx_to, amount
    FROM bonk
    )

    -- agg2 as (
    Run a query to Download Data