With ships_volume AS (

select

--*

--date_trunc('week', block_timestamp::date) as date,

-----------------------------------------------------------------------------------------------------

sum(case when inner_instruction:instructions[2]:parsed:info:mint = 'Ev3xUhc1Leqi4qR2E5VoG9pcxCvHHmnAaSRVPg485xAT' AND inner_instruction:instructions[0]:parsed:info:mint = 'ATLASXmbPQxBUYbxPsV97usA3fPQYEqzQBUHgiFCUsXx' then (inner_instruction:instructions[0]:parsed:info:tokenAmount:uiAmount + inner_instruction:instructions[1]:parsed:info:tokenAmount:uiAmount) when inner_instruction:instructions[1]:parsed:info:mint = 'Ev3xUhc1Leqi4qR2E5VoG9pcxCvHHmnAaSRVPg485xAT' AND inner_instruction:instructions[0]:parsed:info:mint = 'ATLASXmbPQxBUYbxPsV97usA3fPQYEqzQBUHgiFCUsXx' then (inner_instruction:instructions[0]:parsed:info:tokenAmount:uiAmount + inner_instruction:instructions[2]:parsed:info:tokenAmount:uiAmount) end) AS OPALJ_atlas,

sum(case when inner_instruction:instructions[2]:parsed:info:mint = 'Ev3xUhc1Leqi4qR2E5VoG9pcxCvHHmnAaSRVPg485xAT' AND inner_instruction:instructions[0]:parsed:info:mint = 'EPjFWdd5AufqSSqeM2qN1xzybapC8G4wEGGkZwyTDt1v' then (inner_instruction:instructions[0]:parsed:info:tokenAmount:uiAmount + inner_instruction:instructions[1]:parsed:info:tokenAmount:uiAmount) when inner_instruction:instructions[1]:parsed:info:mint = 'Ev3xUhc1Leqi4qR2E5VoG9pcxCvHHmnAaSRVPg485xAT' AND inner_instruction:instructions[0]:parsed:info:mint = 'EPjFWdd5AufqSSqeM2qN1xzybapC8G4wEGGkZwyTDt1v' then (inner_instruction:instructions[0]:parsed:info:tokenAmount:uiAmount + inner_instruction:instructions[2]:parsed:info:tokenAmount:uiAmount) end) AS OPALJ_usdc,

sum(case when inner_instruction:instructions[2]:parsed:info:mint::string = 'Ev3xUhc1Leqi4qR2E5VoG9pcxCvHHmnAaSRVPg485xAT' then inner_instruction:instructions[2]:parsed:info:tokenAmount:uiAmount when inner_instruction:instructions[1]:parsed:info:mint::string = 'Ev3xUhc1Leqi4qR2E5VoG9pcxCvHHmnAaSRVPg485xAT' then inner_instruction:instructions[1]:parsed:info:tokenAmount:uiAmount end) AS OPALJ,

sum(case when inner_instruction:instructions[2]:parsed:info:mint = '267DbhCypYzvTqv72ZG5UKHeFu56qXFsuoz3rw832eC5' AND inner_instruction:instructions[0]:parsed:info:mint = 'ATLASXmbPQxBUYbxPsV97usA3fPQYEqzQBUHgiFCUsXx' then (inner_instruction:instructions[0]:parsed:info:tokenAmount:uiAmount + inner_instruction:instructions[1]:parsed:info:tokenAmount:uiAmount) when inner_instruction:instructions[1]:parsed:info:mint = '267DbhCypYzvTqv72ZG5UKHeFu56qXFsuoz3rw832eC5' AND inner_instruction:instructions[0]:parsed:info:mint = 'ATLASXmbPQxBUYbxPsV97usA3fPQYEqzQBUHgiFCUsXx' then (inner_instruction:instructions[0]:parsed:info:tokenAmount:uiAmount + inner_instruction:instructions[2]:parsed:info:tokenAmount:uiAmount) end) AS PXFIVE_atlas,

sum(case when inner_instruction:instructions[2]:parsed:info:mint = '267DbhCypYzvTqv72ZG5UKHeFu56qXFsuoz3rw832eC5' AND inner_instruction:instructions[0]:parsed:info:mint = 'EPjFWdd5AufqSSqeM2qN1xzybapC8G4wEGGkZwyTDt1v' then (inner_instruction:instructions[0]:parsed:info:tokenAmount:uiAmount + inner_instruction:instructions[1]:parsed:info:tokenAmount:uiAmount) when inner_instruction:instructions[1]:parsed:info:mint = '267DbhCypYzvTqv72ZG5UKHeFu56qXFsuoz3rw832eC5' AND inner_instruction:instructions[0]:parsed:info:mint = 'EPjFWdd5AufqSSqeM2qN1xzybapC8G4wEGGkZwyTDt1v' then (inner_instruction:instructions[0]:parsed:info:tokenAmount:uiAmount + inner_instruction:instructions[2]:parsed:info:tokenAmount:uiAmount) end) AS PXFIVE_usdc,

sum(case when inner_instruction:instructions[2]:parsed:info:mint::string = '267DbhCypYzvTqv72ZG5UKHeFu56qXFsuoz3rw832eC5' then inner_instruction:instructions[2]:parsed:info:tokenAmount:uiAmount when inner_instruction:instructions[1]:parsed:info:mint::string = '267DbhCypYzvTqv72ZG5UKHeFu56qXFsuoz3rw832eC5' then inner_instruction:instructions[1]:parsed:info:tokenAmount:uiAmount end) AS PXFIVE,

sum(case when inner_instruction:instructions[2]:parsed:info:mint = '9czEqEZ4EkRt7N3HWDcw9qqwys3xRRjGdbn8Jhk8Khwj' AND inner_instruction:instructions[0]:parsed:info:mint = 'ATLASXmbPQxBUYbxPsV97usA3fPQYEqzQBUHgiFCUsXx' then (inner_instruction:instructions[0]:parsed:info:tokenAmount:uiAmount + inner_instruction:instructions[1]:parsed:info:tokenAmount:uiAmount) when inner_instruction:instructions[1]:parsed:info:mint = '9czEqEZ4EkRt7N3HWDcw9qqwys3xRRjGdbn8Jhk8Khwj' AND inner_instruction:instructions[0]:parsed:info:mint = 'ATLASXmbPQxBUYbxPsV97usA3fPQYEqzQBUHgiFCUsXx' then (inner_instruction:instructions[0]:parsed:info:tokenAmount:uiAmount + inner_instruction:instructions[2]:parsed:info:tokenAmount:uiAmount) end) AS VZUSOP_atlas,

sum(case when inner_instruction:instructions[2]:parsed:info:mint = '9czEqEZ4EkRt7N3HWDcw9qqwys3xRRjGdbn8Jhk8Khwj' AND inner_instruction:instructions[0]:parsed:info:mint = 'EPjFWdd5AufqSSqeM2qN1xzybapC8G4wEGGkZwyTDt1v' then (inner_instruction:instructions[0]:parsed:info:tokenAmount:uiAmount + inner_instruction:instructions[1]:parsed:info:tokenAmount:uiAmount) when inner_instruction:instructions[1]:parsed:info:mint = '9czEqEZ4EkRt7N3HWDcw9qqwys3xRRjGdbn8Jhk8Khwj' AND inner_instruction:instructions[0]:parsed:info:mint = 'EPjFWdd5AufqSSqeM2qN1xzybapC8G4wEGGkZwyTDt1v' then (inner_instruction:instructions[0]:parsed:info:tokenAmount:uiAmount + inner_instruction:instructions[2]:parsed:info:tokenAmount:uiAmount) end) AS VZUSOP_usdc,

sum(case when inner_instruction:instructions[2]:parsed:info:mint::string = '9czEqEZ4EkRt7N3HWDcw9qqwys3xRRjGdbn8Jhk8Khwj' then inner_instruction:instructions[2]:parsed:info:tokenAmount:uiAmount when inner_instruction:instructions[1]:parsed:info:mint::string = '9czEqEZ4EkRt7N3HWDcw9qqwys3xRRjGdbn8Jhk8Khwj' then inner_instruction:instructions[1]:parsed:info:tokenAmount:uiAmount end) AS VZUSOP,

sum(case when inner_instruction:instructions[2]:parsed:info:mint = 'AkNbg12E9PatjkiAWJ3tAbM479gtcoA1gi6Joa925WKi' AND inner_instruction:instructions[0]:parsed:info:mint = 'ATLASXmbPQxBUYbxPsV97usA3fPQYEqzQBUHgiFCUsXx' then (inner_instruction:instructions[0]:parsed:info:tokenAmount:uiAmount + inner_instruction:instructions[1]:parsed:info:tokenAmount:uiAmount) when inner_instruction:instructions[1]:parsed:info:mint = 'AkNbg12E9PatjkiAWJ3tAbM479gtcoA1gi6Joa925WKi' AND inner_instruction:instructions[0]:parsed:info:mint = 'ATLASXmbPQxBUYbxPsV97usA3fPQYEqzQBUHgiFCUsXx' then (inner_instruction:instructions[0]:parsed:info:tokenAmount:uiAmount + inner_instruction:instructions[2]:parsed:info:tokenAmount:uiAmount) end) AS CALCH_atlas,

sum(case when inner_instruction:instructions[2]:parsed:info:mint = 'AkNbg12E9PatjkiAWJ3tAbM479gtcoA1gi6Joa925WKi' AND inner_instruction:instructions[0]:parsed:info:mint = 'EPjFWdd5AufqSSqeM2qN1xzybapC8G4wEGGkZwyTDt1v' then (inner_instruction:instructions[0]:parsed:info:tokenAmount:uiAmount + inner_instruction:instructions[1]:parsed:info:tokenAmount:uiAmount) when inner_instruction:instructions[1]:parsed:info:mint = 'AkNbg12E9PatjkiAWJ3tAbM479gtcoA1gi6Joa925WKi' AND inner_instruction:instructions[0]:parsed:info:mint = 'EPjFWdd5AufqSSqeM2qN1xzybapC8G4wEGGkZwyTDt1v' then (inner_instruction:instructions[0]:parsed:info:tokenAmount:uiAmount + inner_instruction:instructions[2]:parsed:info:tokenAmount:uiAmount) end) AS CALCH_usdc,

sum(case when inner_instruction:instructions[2]:parsed:info:mint::string = 'AkNbg12E9PatjkiAWJ3tAbM479gtcoA1gi6Joa925WKi' then inner_instruction:instructions[2]:parsed:info:tokenAmount:uiAmount when inner_instruction:instructions[1]:parsed:info:mint::string = 'AkNbg12E9PatjkiAWJ3tAbM479gtcoA1gi6Joa925WKi' then inner_instruction:instructions[1]:parsed:info:tokenAmount:uiAmount end) AS CALCH,

sum(case when inner_instruction:instructions[2]:parsed:info:mint = 'CWxNX9sTexuqvQefqskhP9f6AP5C8hq2VNkicRseqAT5' AND inner_instruction:instructions[0]:parsed:info:mint = 'ATLASXmbPQxBUYbxPsV97usA3fPQYEqzQBUHgiFCUsXx' then (inner_instruction:instructions[0]:parsed:info:tokenAmount:uiAmount + inner_instruction:instructions[1]:parsed:info:tokenAmount:uiAmount) when inner_instruction:instructions[1]:parsed:info:mint = 'CWxNX9sTexuqvQefqskhP9f6AP5C8hq2VNkicRseqAT5' AND inner_instruction:instructions[0]:parsed:info:mint = 'ATLASXmbPQxBUYbxPsV97usA3fPQYEqzQBUHgiFCUsXx' then (inner_instruction:instructions[0]:parsed:info:tokenAmount:uiAmount + inner_instruction:instructions[2]:parsed:info:tokenAmount:uiAmount) end) AS OGKATP_atlas,

sum(case when inner_instruction:instructions[2]:parsed:info:mint = 'CWxNX9sTexuqvQefqskhP9f6AP5C8hq2VNkicRseqAT5' AND inner_instruction:instructions[0]:parsed:info:mint = 'EPjFWdd5AufqSSqeM2qN1xzybapC8G4wEGGkZwyTDt1v' then (inner_instruction:instructions[0]:parsed:info:tokenAmount:uiAmount + inner_instruction:instructions[1]:parsed:info:tokenAmount:uiAmount) when inner_instruction:instructions[1]:parsed:info:mint = 'CWxNX9sTexuqvQefqskhP9f6AP5C8hq2VNkicRseqAT5' AND inner_instruction:instructions[0]:parsed:info:mint = 'EPjFWdd5AufqSSqeM2qN1xzybapC8G4wEGGkZwyTDt1v' then (inner_instruction:instructions[0]:parsed:info:tokenAmount:uiAmount + inner_instruction:instructions[2]:parsed:info:tokenAmount:uiAmount) end) AS OGKATP_usdc,

sum(case when inner_instruction:instructions[2]:parsed:info:mint::string = 'CWxNX9sTexuqvQefqskhP9f6AP5C8hq2VNkicRseqAT5' then inner_instruction:instructions[2]:parsed:info:tokenAmount:uiAmount when inner_instruction:instructions[1]:parsed:info:mint::string = 'CWxNX9sTexuqvQefqskhP9f6AP5C8hq2VNkicRseqAT5' then inner_instruction:instructions[1]:parsed:info:tokenAmount:uiAmount end) AS OGKATP,

sum(case when inner_instruction:instructions[2]:parsed:info:mint = '2iMhgB4pbdKvwJHVyitpvX5z1NBNypFonUgaSAt9dtDt' AND inner_instruction:instructions[0]:parsed:info:mint = 'ATLASXmbPQxBUYbxPsV97usA3fPQYEqzQBUHgiFCUsXx' then (inner_instruction:instructions[0]:parsed:info:tokenAmount:uiAmount + inner_instruction:instructions[1]:parsed:info:tokenAmount:uiAmount) when inner_instruction:instructions[1]:parsed:info:mint = '2iMhgB4pbdKvwJHVyitpvX5z1NBNypFonUgaSAt9dtDt' AND inner_instruction:instructions[0]:parsed:info:mint = 'ATLASXmbPQxBUYbxPsV97usA3fPQYEqzQBUHgiFCUsXx' then (inner_instruction:instructions[0]:parsed:info:tokenAmount:uiAmount + inner_instruction:instructions[2]:parsed:info:tokenAmount:uiAmount) end) AS PXFOUR_atlas,

sum(case when inner_instruction:instructions[2]:parsed:info:mint = '2iMhgB4pbdKvwJHVyitpvX5z1NBNypFonUgaSAt9dtDt' AND inner_instruction:instructions[0]:parsed:info:mint = 'EPjFWdd5AufqSSqeM2qN1xzybapC8G4wEGGkZwyTDt1v' then (inner_instruction:instructions[0]:parsed:info:tokenAmount:uiAmount + inner_instruction:instructions[1]:parsed:info:tokenAmount:uiAmount) when inner_instruction:instructions[1]:parsed:info:mint = '2iMhgB4pbdKvwJHVyitpvX5z1NBNypFonUgaSAt9dtDt' AND inner_instruction:instructions[0]:parsed:info:mint = 'EPjFWdd5AufqSSqeM2qN1xzybapC8G4wEGGkZwyTDt1v' then (inner_instruction:instructions[0]:parsed:info:tokenAmount:uiAmount + inner_instruction:instructions[2]:parsed:info:tokenAmount:uiAmount) end) AS PXFOUR_usdc,

sum(case when inner_instruction:instructions[2]:parsed:info:mint::string = '2iMhgB4pbdKvwJHVyitpvX5z1NBNypFonUgaSAt9dtDt' then inner_instruction:instructions[2]:parsed:info:tokenAmount:uiAmount when inner_instruction:instructions[1]:parsed:info:mint::string = '2iMhgB4pbdKvwJHVyitpvX5z1NBNypFonUgaSAt9dtDt' then inner_instruction:instructions[1]:parsed:info:tokenAmount:uiAmount end) AS PXFOUR,

sum(case when inner_instruction:instructions[2]:parsed:info:mint = '9ABNesWj7NVdkDgko7UjVaDp5pTh8a6wfXHLWz3bZM6W' AND inner_instruction:instructions[0]:parsed:info:mint = 'ATLASXmbPQxBUYbxPsV97usA3fPQYEqzQBUHgiFCUsXx' then (inner_instruction:instructions[0]:parsed:info:tokenAmount:uiAmount + inner_instruction:instructions[1]:parsed:info:tokenAmount:uiAmount) when inner_instruction:instructions[1]:parsed:info:mint = '9ABNesWj7NVdkDgko7UjVaDp5pTh8a6wfXHLWz3bZM6W' AND inner_instruction:instructions[0]:parsed:info:mint = 'ATLASXmbPQxBUYbxPsV97usA3fPQYEqzQBUHgiFCUsXx' then (inner_instruction:instructions[0]:parsed:info:tokenAmount:uiAmount + inner_instruction:instructions[2]:parsed:info:tokenAmount:uiAmount) end) AS OPALJJ_atlas,

sum(case when inner_instruction:instructions[2]:parsed:info:mint = '9ABNesWj7NVdkDgko7UjVaDp5pTh8a6wfXHLWz3bZM6W' AND inner_instruction:instructions[0]:parsed:info:mint = 'EPjFWdd5AufqSSqeM2qN1xzybapC8G4wEGGkZwyTDt1v' then (inner_instruction:instructions[0]:parsed:info:tokenAmount:uiAmount + inner_instruction:instructions[1]:parsed:info:tokenAmount:uiAmount) when inner_instruction:instructions[1]:parsed:info:mint = '9ABNesWj7NVdkDgko7UjVaDp5pTh8a6wfXHLWz3bZM6W' AND inner_instruction:instructions[0]:parsed:info:mint = 'EPjFWdd5AufqSSqeM2qN1xzybapC8G4wEGGkZwyTDt1v' then (inner_instruction:instructions[0]:parsed:info:tokenAmount:uiAmount + inner_instruction:instructions[2]:parsed:info:tokenAmount:uiAmount) end) AS OPALJJ_usdc,

sum(case when inner_instruction:instructions[2]:parsed:info:mint::string = '9ABNesWj7NVdkDgko7UjVaDp5pTh8a6wfXHLWz3bZM6W' then inner_instruction:instructions[2]:parsed:info:tokenAmount:uiAmount when inner_instruction:instructions[1]:parsed:info:mint::string = '9ABNesWj7NVdkDgko7UjVaDp5pTh8a6wfXHLWz3bZM6W' then inner_instruction:instructions[1]:parsed:info:tokenAmount:uiAmount end) AS OPALJJ,

sum(case when inner_instruction:instructions[2]:parsed:info:mint = '7V9C2XUQgCb31n7hGKqKGu4ENcvqXhJLJzU77CAQtXhw' AND inner_instruction:instructions[0]:parsed:info:mint = 'ATLASXmbPQxBUYbxPsV97usA3fPQYEqzQBUHgiFCUsXx' then (inner_instruction:instructions[0]:parsed:info:tokenAmount:uiAmount + inner_instruction:instructions[1]:parsed:info:tokenAmount:uiAmount) when inner_instruction:instructions[1]:parsed:info:mint = '7V9C2XUQgCb31n7hGKqKGu4ENcvqXhJLJzU77CAQtXhw' AND inner_instruction:instructions[0]:parsed:info:mint = 'ATLASXmbPQxBUYbxPsV97usA3fPQYEqzQBUHgiFCUsXx' then (inner_instruction:instructions[0]:parsed:info:tokenAmount:uiAmount + inner_instruction:instructions[2]:parsed:info:tokenAmount:uiAmount) end) AS FBLBPL_atlas,