ChiefMango Trade Volume
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
›
⌄
with agg as (
SELECT tx_id, e.index, program_id, accounts.value as value
FROM solana.core.fact_events e, lateral flatten (input => instruction:accounts) as accounts
-- instruction:accounts:'8PhnCfgqpgFM7ZJvttGdBVMXHuU4Q23ACxCvWkbs1M71'
where program_id = '4MangoMjqJ2firMokCjjGgoK8d4MXcrgL7XJaL3w6fVg'
AND block_timestamp > current_date - 1
-- AND accounts.value = '8BnEgHoWFysVcuFFX7QztDmzuH8r5ZFvyP3sYwn1XTh6'
AND accounts.value = 'BbJgE7HZMaDp5NTYvRh5jZSkQPVDTU8ubPFtpogUkEj4' -- ETH-USDC
-- AND accounts.value = '8PhnCfgqpgFM7ZJvttGdBVMXHuU4Q23ACxCvWkbs1M71' -- BONK-USDC
-- AND accounts.value = '3NnxQvDcZXputNMxaxsGvqiKpqgPfSYXpNigZNFcknmD' -- Mango-usdc
-- AND accounts.value = '8PhnCfgqpgFM7ZJvttGdBVMXHuU4Q23ACxCvWkbs1M71' -- BONK-USDC
-- AND accounts.value = '3BAKsQd3RuhZKES2DGysMhjBdwjZYKYmxRqnSMtZ4KSN' -- BTC-USDC
-- AND accounts.value = '9Lyhks5bQQxb9EyyX55NtgKQzpM4WK7JCmeaWuQ5MoXD' -- mSOL-USDC
)
SELECT t.tx_id, agg.index, program_id, value, tx_from, tx_to, amount, mint
FROM agg
JOIN solana.core.fact_transfers t
ON agg.tx_id = t.tx_id
WHERE tx_to = '78b8f4cGCwmZ9ysPFMWLaLTkkaYnUjwMJYStWe5RTSSX'
-- 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 tx_id = '5qhBwEmPp5QYgiDvUPSSBhr5JcXeD31EFHK9xU3XejYaM1fP27vjgNmDZdG9ctJk5NhDkqZrGZu7wf4EyByFS9xj'
-- AND block_timestamp BETWEEN current_date - 6 AND current_date - 3
-- AND tx_to IN ('3oQLKk1TyyXMT14p2i8p95v5jKqsQ5qzZGwxZCTnFC7p''78b8f4cGCwmZ9ysPFMWLaLTkkaYnUjwMJYStWe5RTSSX')
-- )
-- SELECT distinct tx_id, index, tx_from, tx_to, amount
-- FROM bonk
-- SELECT
Run a query to Download Data