ChiefMango V4 copy copy
Updated 2023-04-13
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
›
⌄
-- 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