ChiefMango Trade Volume
    Updated 2023-04-13
    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