with score_in as ( select signers[0] as wallet, sum(case when value:parsed:info:mint = 'Ev3xUhc1Leqi4qR2E5VoG9pcxCvHHmnAaSRVPg485xAT' then value:parsed:info:tokenAmount:uiAmount ELSE 0 end) AS OPALJ_in, sum(case when value:parsed:info:mint = '267DbhCypYzvTqv72ZG5UKHeFu56qXFsuoz3rw832eC5' then value:parsed:info:tokenAmount:uiAmount ELSE 0 end) AS PX5_in, sum(case when value:parsed:info:mint = '9czEqEZ4EkRt7N3HWDcw9qqwys3xRRjGdbn8Jhk8Khwj' then value:parsed:info:tokenAmount:uiAmount ELSE 0 end) AS VZUSOP_in, sum(case when value:parsed:info:mint = 'AkNbg12E9PatjkiAWJ3tAbM479gtcoA1gi6Joa925WKi' then value:parsed:info:tokenAmount:uiAmount ELSE 0 end) AS CALCH_in, sum(case when value:parsed:info:mint = 'CWxNX9sTexuqvQefqskhP9f6AP5C8hq2VNkicRseqAT5' then value:parsed:info:tokenAmount:uiAmount ELSE 0 end) AS OGKATP_in, sum(case when value:parsed:info:mint = '2iMhgB4pbdKvwJHVyitpvX5z1NBNypFonUgaSAt9dtDt' then value:parsed:info:tokenAmount:uiAmount ELSE 0 end) AS PX4_in, sum(case when value:parsed:info:mint = '9ABNesWj7NVdkDgko7UjVaDp5pTh8a6wfXHLWz3bZM6W' then value:parsed:info:tokenAmount:uiAmount ELSE 0 end) AS OPALJJ_in, sum(case when value:parsed:info:mint = '7V9C2XUQgCb31n7hGKqKGu4ENcvqXhJLJzU77CAQtXhw' then value:parsed:info:tokenAmount:uiAmount ELSE 0 end) AS FBLBPL_in, sum(case when value:parsed:info:mint = 'DdpXnnYsyUQgJby8TDHbmPwkKyGF4U6bXwCXTQZsrfKP' then value:parsed:info:tokenAmount:uiAmount ELSE 0 end) AS CALG_in, sum(case when value:parsed:info:mint = '9MvZS3TVfv4DZL9W2pT12po384aBHf7wi89KXQ9Z7uwW' then value:parsed:info:tokenAmount:uiAmount ELSE 0 end) AS PF4_in, sum(case when value:parsed:info:mint = 'FpwV1Da6BZJnYPr1JSLUm14UwBmZHA7J5WLY4TXgbde8' then value:parsed:info:tokenAmount:uiAmount ELSE 0 end) AS FBLEGR_in, sum(case when value:parsed:info:mint = 'HzBx8PP86pyPrrboTHqPYWhxnEB5vXDHDBP8femWfPTS' then value:parsed:info:tokenAmount:uiAmount ELSE 0 end) AS OM_in, sum(case when value:parsed:info:mint = '2bCgKTo11QayWBy6QryHZMqZL2ZgWd5LEAZKiTGQi4g7' then value:parsed:info:tokenAmount:uiAmount ELSE 0 end) AS PR8_in, sum(case when value:parsed:info:mint = 'H2jHqvXA2oxSpEp6dKkpK7WeszQEdFW5n25mNfrJFAc1' then value:parsed:info:tokenAmount:uiAmount ELSE 0 end) AS VZUSAM_in, sum(case when value:parsed:info:mint = '5f1jUARhtSypVA4uTpgpLp76WYGdB2dGr8zMbh4WjYRf' then value:parsed:info:tokenAmount:uiAmount ELSE 0 end) AS PC9_in, sum(case when value:parsed:info:mint = '9ifQ16N5DdUFoejCwsgR73ihUwadAe3srCo9HhQe2zL2' then value:parsed:info:tokenAmount:uiAmount ELSE 0 end) AS PC11_in, sum(case when value:parsed:info:mint = 'DsJHgpnNovjJ981QJJnqMggexAekNawbSavfV1QuTpis' then value:parsed:info:tokenAmount:uiAmount ELSE 0 end) AS CHI_in, sum(case when value:parsed:info:mint = 'HJBmBYyGR8z1oajAM4jiK46uobuxeJoKDYpFwzWHBvhb' then value:parsed:info:tokenAmount:uiAmount ELSE 0 end) AS OGKAJA_in, sum(case when value:parsed:info:mint = '4txpjHspP4usEsQTr3AcrpyHVjN4fi3d4taM6cmKJnd1' then value:parsed:info:tokenAmount:uiAmount ELSE 0 end) AS CALEV_in, sum(case when value:parsed:info:mint = 'HsdbLvZrEgN2ZhsrZs5ag4F2FNFCHjjuXPfbVAhkeJBZ' then value:parsed:info:tokenAmount:uiAmount ELSE 0 end) AS TUFAFE_in, sum(case when value:parsed:info:mint = '6SqLuwHNRC1qjo9KATLKJLszFHMWyYaNxDXraCEUtfdR' then value:parsed:info:tokenAmount:uiAmount ELSE 0 end) AS FBLBEA_in, sum(case when value:parsed:info:mint = '8RveLFEyteyL1vbCKPQJxjf3JT1ACyrzs46TXbJStrHG' then value:parsed:info:tokenAmount:uiAmount ELSE 0 end) AS PX6_in, sum(case when value:parsed:info:mint = '7M6RHgPiHXiZAin5ManH63cLYGt3miQ54KaGynUQoERS' then value:parsed:info:tokenAmount:uiAmount ELSE 0 end) AS FBLEBO_in, sum(case when value:parsed:info:mint = 'HqPN13pLUVJRiuGSsKjfWZvGKAagK98PshuKu51bnG4E' then value:parsed:info:tokenAmount:uiAmount ELSE 0 end) AS FBLETR_in, sum(case when value:parsed:info:mint = 'Fw8PqtznYtg4swMk7Yjj89Tsj23u5CJLfW5Bk8ro4G1s' then value:parsed:info:tokenAmount:uiAmount ELSE 0 end) AS FBLAIR_in, sum(case when value:parsed:info:mint = 'FMHHwUB6amLWYhWxtiZHC2g5azy9usPTLMq46N3HEgFU' then value:parsed:info:tokenAmount:uiAmount ELSE 0 end) AS OGKAMK_in, sum(case when value:parsed:info:mint = '9zrgra3XQkZPt8XNs4fowbqmj7B8bBx76aEmsKSnm9BW' then value:parsed:info:tokenAmount:uiAmount ELSE 0 end) AS FBLEUN_in, sum(case when value:parsed:info:mint = 'EbLBLN44BVLjifLNBbchXFr8QjEkAGYENKuNEaDuyVPL' then value:parsed:info:tokenAmount:uiAmount ELSE 0 end) AS ARC_in, sum(case when value:parsed:info:mint = '7Xs3yt9eJPuEexZrKSGVbQMXHwWUKHGeDZnM4ZksZmyS' then value:parsed:info:tokenAmount:uiAmount ELSE 0 end) AS FBLLOW_in, sum(case when value:parsed:info:mint = 'FTk1E5UoWkiZEUttCWSYYaVokxWNNp3yJ42HbNDCAkdt' then value:parsed:info:tokenAmount:uiAmount ELSE 0 end) AS THRILL_in, sum(case when value:parsed:info:mint = 'FFkPvwLDYuKDW9eAAr5UNfuX3U9PcTGeSk7gqNX7EpNc' then value:parsed:info:tokenAmount:uiAmount ELSE 0 end) AS VZUSBA_in, sum(case when value:parsed:info:mint = '4gR3ChfdQxR4BTbgeWSdf6b8kD8Ysu6WBAQqtJ9oLgbF' then value:parsed:info:tokenAmount:uiAmount ELSE 0 end) AS CALMED_in, sum(case when value:parsed:info:mint = '8pPDsMNcz4m8jaajFMFXHGcvaeVeiQhcenvSD6a4XNyq' then value:parsed:info:tokenAmount:uiAmount ELSE 0 end) AS OPALBB_in, sum(case when value:parsed:info:mint = '2XYd22LSFGxN7kWgoEeaXVZqgrsPeQLHLEgNhnS12Mny' then value:parsed:info:tokenAmount:uiAmount ELSE 0 end) AS CALATS_in, sum(case when value:parsed:info:mint = 'Fys8J53cquYsg5zYfeZStVGNwM9FopFw8QFkiE9CCR1J' then value:parsed:info:tokenAmount:uiAmount ELSE 0 end) AS PR6_in, sum(case when value:parsed:info:mint = '6HzZJwrcuBBmrE7SLDfxheZGAD3NYJ531C9JsNesL9BP' then value:parsed:info:tokenAmount:uiAmount ELSE 0 end) AS HEART_in, sum(case when value:parsed:info:mint = 'J8Q6jYsrhhaeczyPBo9xzVyy4GpfCnJwj14LJn2HnuKp' then value:parsed:info:tokenAmount:uiAmount ELSE 0 end) AS OGKATU_in, sum(case when value:parsed:info:mint = '6Zj61HuX1E7SCUCf9WsKXw1jdJCobAwK4RSjZvbv35tM' then value:parsed:info:tokenAmount:uiAmount ELSE 0 end) AS FBLMAM_in, sum(case when value:parsed:info:mint = 'HjFijcGWKgfDwGpFX2rqFwEU9jtEgFuRQAJe1ERXFsA3' then value:parsed:info:tokenAmount:uiAmount ELSE 0 end) AS VZUSSO_in, sum(case when value:parsed:info:mint = '4ns3shP4WunCtJbr2HFu31RjjxSJxDymEFcBZxiHr11s' then value:parsed:info:tokenAmount:uiAmount ELSE 0 end) AS FBLBTA_in, sum(case when value:parsed:info:mint = '4b4mhSySBcryzBPamw8v4xeneFRA6xTUA4JA99w6vqey' then value:parsed:info:tokenAmount:uiAmount ELSE 0 end) AS OGKASP_in, sum(case when value:parsed:info:mint = 'H3cgBXWpUiNsYjUWS7cNR5Bmehh7k5CgpJccc5wSfRbJ' then value:parsed:info:tokenAmount:uiAmount ELSE 0 end) AS PD9_in, sum(case when value:parsed:info:mint = 'DB8CSxoakPRtXhHcc2cA3iETWfGaYY6zE2T8huJTE2Nw' then value:parsed:info:tokenAmount:uiAmount ELSE 0 end) AS STAND_in, sum(case when value:parsed:info:mint = '2BMTgfgapuqYBwSRGu6HCafwDGRVTxMkQVhYrNWQGTWH' then value:parsed:info:tokenAmount:uiAmount ELSE 0 end) AS SUPER_in, sum(case when value:parsed:info:mint = '56nh4FvMJnSpkWJcmXc1nJtYhSQXuqb7nVMGALr31RVc' then value:parsed:info:tokenAmount:uiAmount ELSE 0 end) AS T1TAN_in, sum(case when value:parsed:info:mint = 'F3HitKsp52UPqBMEWSeTFqrGgnfYbS9DMrJCz9dM3w6D' then value:parsed:info:tokenAmount:uiAmount ELSE 0 end) AS CALSCD_in, sum(case when value:parsed:info:mint = 'GxpbUDxYYvxiUejHcAMzeV2rzdHf6KZZvT86ACrpFgXa' then value:parsed:info:tokenAmount:uiAmount ELSE 0 end) AS CALMAX_in, sum(case when value:parsed:info:mint = '7SUoWHWWJCxCe5g9XqZkCRufGHXRV8nauuz69HPjuewr' then value:parsed:info:tokenAmount:uiAmount ELSE 0 end) AS OGKANR_in, sum(case when value:parsed:info:mint = 'DTbNmLWfu1pm4AuXRKYTApnDNfxMz73VET7nW5wizG5t' then value:parsed:info:tokenAmount:uiAmount ELSE 0 end) AS IMP1_in, sum(case when value:parsed:info:mint = 'ARNZXUQoBKx3JCX3UJB4aitSnvcjMMphN9YVDFy1PdKq' then value:parsed:info:tokenAmount:uiAmount ELSE 0 end) AS IMP2_in, sum(case when value:parsed:info:mint = 'GmVKV9W3qZcERxk7hjqwRDcn9Kgtz3XDi7KfFLdGqyaW' then value:parsed:info:tokenAmount:uiAmount ELSE 0 end) AS IMP3_in, sum(case when value:parsed:info:mint = 'MEXfyQHowwqoTHsN6yjfeXVaxZxALUFJAHuzY8gFiUu' then value:parsed:info:tokenAmount:uiAmount ELSE 0 end) AS FBLMEX_in, sum(case when value:parsed:info:mint = 'BBUTCn3jcXKjFYuuYtY8MNo8bDg9VsZaKwaSYnRr2Qse' then value:parsed:info:tokenAmount:uiAmount ELSE 0 end) AS FBLBBU_in, sum(case when value:parsed:info:mint = 'RaYfM1RLfxQJWF8RZravTshKj1aHaWBNXF94VWToY9n' then value:parsed:info:tokenAmount:uiAmount ELSE 0 end) AS OPALRF_in, sum(case when value:parsed:info:mint = 'SLEDkN916vvcpucY9Vn7tAzNXRcxsq71kkXzaj1cxoX' then value:parsed:info:tokenAmount:uiAmount ELSE 0 end) AS FBLSLE_in, sum(case when value:parsed:info:mint = 'RUCHH4AcvodBcndmcT17KUBbd5ee5LQtmpsfvBVNnPH' then value:parsed:info:tokenAmount:uiAmount ELSE 0 end) AS OGKARU_in, sum(case when value:parsed:info:mint = 'phi4PYgmxeTMLLpGkU87T16VUZ6AjWZESkfT1JGJ635' then value:parsed:info:tokenAmount:uiAmount ELSE 0 end) AS PHI_in, sum(case when value:parsed:info:mint = 'CALSHIPEZcCoyXEKqw9ovCdYeNzck9uVbb1KCcsHaGhc' then value:parsed:info:tokenAmount:uiAmount ELSE 0 end) AS CALSHIP_in from solana.core.fact_events,lateral flatten(input => inner_instruction:instructions) WHERE program_id = 'FLEET1qqzpexyaDpqb2DGsSzE2sDCizewCg9WjrA6DBW' AND succeeded = 'true' AND value:parsed:info:authority = signers[0]::string AND block_timestamp >= '2021-12-16' --AND block_timestamp < '2023-06-01' GROUP BY 1 ), score_out as ( select signers[0] as wallet, sum(case when value:parsed:info:mint = 'Ev3xUhc1Leqi4qR2E5VoG9pcxCvHHmnAaSRVPg485xAT' then value:parsed:info:tokenAmount:uiAmount ELSE 0 end) AS OPALJ_out, sum(case when value:parsed:info:mint = '267DbhCypYzvTqv72ZG5UKHeFu56qXFsuoz3rw832eC5' then value:parsed:info:tokenAmount:uiAmount ELSE 0 end) AS PX5_out, sum(case when value:parsed:info:mint = '9czEqEZ4EkRt7N3HWDcw9qqwys3xRRjGdbn8Jhk8Khwj' then value:parsed:info:tokenAmount:uiAmount ELSE 0 end) AS VZUSOP_out, sum(case when value:parsed:info:mint = 'AkNbg12E9PatjkiAWJ3tAbM479gtcoA1gi6Joa925WKi' then value:parsed:info:tokenAmount:uiAmount ELSE 0 end) AS CALCH_out, sum(case when value:parsed:info:mint = 'CWxNX9sTexuqvQefqskhP9f6AP5C8hq2VNkicRseqAT5' then value:parsed:info:tokenAmount:uiAmount ELSE 0 end) AS OGKATP_out, sum(case when value:parsed:info:mint = '2iMhgB4pbdKvwJHVyitpvX5z1NBNypFonUgaSAt9dtDt' then value:parsed:info:tokenAmount:uiAmount ELSE 0 end) AS PX4_out, sum(case when value:parsed:info:mint = '9ABNesWj7NVdkDgko7UjVaDp5pTh8a6wfXHLWz3bZM6W' then value:parsed:info:tokenAmount:uiAmount ELSE 0 end) AS OPALJJ_out, sum(case when value:parsed:info:mint = '7V9C2XUQgCb31n7hGKqKGu4ENcvqXhJLJzU77CAQtXhw' then value:parsed:info:tokenAmount:uiAmount ELSE 0 end) AS FBLBPL_out, sum(case when value:parsed:info:mint = 'DdpXnnYsyUQgJby8TDHbmPwkKyGF4U6bXwCXTQZsrfKP' then value:parsed:info:tokenAmount:uiAmount ELSE 0 end) AS CALG_out, sum(case when value:parsed:info:mint = '9MvZS3TVfv4DZL9W2pT12po384aBHf7wi89KXQ9Z7uwW' then value:parsed:info:tokenAmount:uiAmount ELSE 0 end) AS PF4_out, sum(case when value:parsed:info:mint = 'FpwV1Da6BZJnYPr1JSLUm14UwBmZHA7J5WLY4TXgbde8' then value:parsed:info:tokenAmount:uiAmount ELSE 0 end) AS FBLEGR_out, sum(case when value:parsed:info:mint = 'HzBx8PP86pyPrrboTHqPYWhxnEB5vXDHDBP8femWfPTS' then value:parsed:info:tokenAmount:uiAmount ELSE 0 end) AS OM_out, sum(case when value:parsed:info:mint = '2bCgKTo11QayWBy6QryHZMqZL2ZgWd5LEAZKiTGQi4g7' then value:parsed:info:tokenAmount:uiAmount ELSE 0 end) AS PR8_out, sum(case when value:parsed:info:mint = 'H2jHqvXA2oxSpEp6dKkpK7WeszQEdFW5n25mNfrJFAc1' then value:parsed:info:tokenAmount:uiAmount ELSE 0 end) AS VZUSAM_out, sum(case when value:parsed:info:mint = '5f1jUARhtSypVA4uTpgpLp76WYGdB2dGr8zMbh4WjYRf' then value:parsed:info:tokenAmount:uiAmount ELSE 0 end) AS PC9_out, sum(case when value:parsed:info:mint = '9ifQ16N5DdUFoejCwsgR73ihUwadAe3srCo9HhQe2zL2' then value:parsed:info:tokenAmount:uiAmount ELSE 0 end) AS PC11_out, sum(case when value:parsed:info:mint = 'DsJHgpnNovjJ981QJJnqMggexAekNawbSavfV1QuTpis' then value:parsed:info:tokenAmount:uiAmount ELSE 0 end) AS CHI_out, sum(case when value:parsed:info:mint = 'HJBmBYyGR8z1oajAM4jiK46uobuxeJoKDYpFwzWHBvhb' then value:parsed:info:tokenAmount:uiAmount ELSE 0 end) AS OGKAJA_out, sum(case when value:parsed:info:mint = '4txpjHspP4usEsQTr3AcrpyHVjN4fi3d4taM6cmKJnd1' then value:parsed:info:tokenAmount:uiAmount ELSE 0 end) AS CALEV_out, sum(case when value:parsed:info:mint = 'HsdbLvZrEgN2ZhsrZs5ag4F2FNFCHjjuXPfbVAhkeJBZ' then value:parsed:info:tokenAmount:uiAmount ELSE 0 end) AS TUFAFE_out, sum(case when value:parsed:info:mint = '6SqLuwHNRC1qjo9KATLKJLszFHMWyYaNxDXraCEUtfdR' then value:parsed:info:tokenAmount:uiAmount ELSE 0 end) AS FBLBEA_out, sum(case when value:parsed:info:mint = '8RveLFEyteyL1vbCKPQJxjf3JT1ACyrzs46TXbJStrHG' then value:parsed:info:tokenAmount:uiAmount ELSE 0 end) AS PX6_out, sum(case when value:parsed:info:mint = '7M6RHgPiHXiZAin5ManH63cLYGt3miQ54KaGynUQoERS' then value:parsed:info:tokenAmount:uiAmount ELSE 0 end) AS FBLEBO_out, sum(case when value:parsed:info:mint = 'HqPN13pLUVJRiuGSsKjfWZvGKAagK98PshuKu51bnG4E' then value:parsed:info:tokenAmount:uiAmount ELSE 0 end) AS FBLETR_out, sum(case when value:parsed:info:mint = 'Fw8PqtznYtg4swMk7Yjj89Tsj23u5CJLfW5Bk8ro4G1s' then value:parsed:info:tokenAmount:uiAmount ELSE 0 end) AS FBLAIR_out, sum(case when value:parsed:info:mint = 'FMHHwUB6amLWYhWxtiZHC2g5azy9usPTLMq46N3HEgFU' then value:parsed:info:tokenAmount:uiAmount ELSE 0 end) AS OGKAMK_out, sum(case when value:parsed:info:mint = '9zrgra3XQkZPt8XNs4fowbqmj7B8bBx76aEmsKSnm9BW' then value:parsed:info:tokenAmount:uiAmount ELSE 0 end) AS FBLEUN_out, sum(case when value:parsed:info:mint = 'EbLBLN44BVLjifLNBbchXFr8QjEkAGYENKuNEaDuyVPL' then value:parsed:info:tokenAmount:uiAmount ELSE 0 end) AS ARC_out, sum(case when value:parsed:info:mint = '7Xs3yt9eJPuEexZrKSGVbQMXHwWUKHGeDZnM4ZksZmyS' then value:parsed:info:tokenAmount:uiAmount ELSE 0 end) AS FBLLOW_out, sum(case when value:parsed:info:mint = 'FTk1E5UoWkiZEUttCWSYYaVokxWNNp3yJ42HbNDCAkdt' then value:parsed:info:tokenAmount:uiAmount ELSE 0 end) AS THRILL_out, sum(case when value:parsed:info:mint = 'FFkPvwLDYuKDW9eAAr5UNfuX3U9PcTGeSk7gqNX7EpNc' then value:parsed:info:tokenAmount:uiAmount ELSE 0 end) AS VZUSBA_out, sum(case when value:parsed:info:mint = '4gR3ChfdQxR4BTbgeWSdf6b8kD8Ysu6WBAQqtJ9oLgbF' then value:parsed:info:tokenAmount:uiAmount ELSE 0 end) AS CALMED_out, sum(case when value:parsed:info:mint = '8pPDsMNcz4m8jaajFMFXHGcvaeVeiQhcenvSD6a4XNyq' then value:parsed:info:tokenAmount:uiAmount ELSE 0 end) AS OPALBB_out, sum(case when value:parsed:info:mint = '2XYd22LSFGxN7kWgoEeaXVZqgrsPeQLHLEgNhnS12Mny' then value:parsed:info:tokenAmount:uiAmount ELSE 0 end) AS CALATS_out, sum(case when value:parsed:info:mint = 'Fys8J53cquYsg5zYfeZStVGNwM9FopFw8QFkiE9CCR1J' then value:parsed:info:tokenAmount:uiAmount ELSE 0 end) AS PR6_out, sum(case when value:parsed:info:mint = '6HzZJwrcuBBmrE7SLDfxheZGAD3NYJ531C9JsNesL9BP' then value:parsed:info:tokenAmount:uiAmount ELSE 0 end) AS HEART_out, sum(case when value:parsed:info:mint = 'J8Q6jYsrhhaeczyPBo9xzVyy4GpfCnJwj14LJn2HnuKp' then value:parsed:info:tokenAmount:uiAmount ELSE 0 end) AS OGKATU_out, sum(case when value:parsed:info:mint = '6Zj61HuX1E7SCUCf9WsKXw1jdJCobAwK4RSjZvbv35tM' then value:parsed:info:tokenAmount:uiAmount ELSE 0 end) AS FBLMAM_out, sum(case when value:parsed:info:mint = 'HjFijcGWKgfDwGpFX2rqFwEU9jtEgFuRQAJe1ERXFsA3' then value:parsed:info:tokenAmount:uiAmount ELSE 0 end) AS VZUSSO_out, sum(case when value:parsed:info:mint = '4ns3shP4WunCtJbr2HFu31RjjxSJxDymEFcBZxiHr11s' then value:parsed:info:tokenAmount:uiAmount ELSE 0 end) AS FBLBTA_out, sum(case when value:parsed:info:mint = '4b4mhSySBcryzBPamw8v4xeneFRA6xTUA4JA99w6vqey' then value:parsed:info:tokenAmount:uiAmount ELSE 0 end) AS OGKASP_out, sum(case when value:parsed:info:mint = 'H3cgBXWpUiNsYjUWS7cNR5Bmehh7k5CgpJccc5wSfRbJ' then value:parsed:info:tokenAmount:uiAmount ELSE 0 end) AS PD9_out, sum(case when value:parsed:info:mint = 'DB8CSxoakPRtXhHcc2cA3iETWfGaYY6zE2T8huJTE2Nw' then value:parsed:info:tokenAmount:uiAmount ELSE 0 end) AS STAND_out, sum(case when value:parsed:info:mint = '2BMTgfgapuqYBwSRGu6HCafwDGRVTxMkQVhYrNWQGTWH' then value:parsed:info:tokenAmount:uiAmount ELSE 0 end) AS SUPER_out, sum(case when value:parsed:info:mint = '56nh4FvMJnSpkWJcmXc1nJtYhSQXuqb7nVMGALr31RVc' then value:parsed:info:tokenAmount:uiAmount ELSE 0 end) AS T1TAN_out, sum(case when value:parsed:info:mint = 'F3HitKsp52UPqBMEWSeTFqrGgnfYbS9DMrJCz9dM3w6D' then value:parsed:info:tokenAmount:uiAmount ELSE 0 end) AS CALSCD_out, sum(case when value:parsed:info:mint = 'GxpbUDxYYvxiUejHcAMzeV2rzdHf6KZZvT86ACrpFgXa' then value:parsed:info:tokenAmount:uiAmount ELSE 0 end) AS CALMAX_out, sum(case when value:parsed:info:mint = '7SUoWHWWJCxCe5g9XqZkCRufGHXRV8nauuz69HPjuewr' then value:parsed:info:tokenAmount:uiAmount ELSE 0 end) AS OGKANR_out, sum(case when value:parsed:info:mint = 'DTbNmLWfu1pm4AuXRKYTApnDNfxMz73VET7nW5wizG5t' then value:parsed:info:tokenAmount:uiAmount ELSE 0 end) AS IMP1_out, sum(case when value:parsed:info:mint = 'ARNZXUQoBKx3JCX3UJB4aitSnvcjMMphN9YVDFy1PdKq' then value:parsed:info:tokenAmount:uiAmount ELSE 0 end) AS IMP2_out, sum(case when value:parsed:info:mint = 'GmVKV9W3qZcERxk7hjqwRDcn9Kgtz3XDi7KfFLdGqyaW' then value:parsed:info:tokenAmount:uiAmount ELSE 0 end) AS IMP3_out, sum(case when value:parsed:info:mint = 'MEXfyQHowwqoTHsN6yjfeXVaxZxALUFJAHuzY8gFiUu' then value:parsed:info:tokenAmount:uiAmount ELSE 0 end) AS FBLMEX_out, sum(case when value:parsed:info:mint = 'BBUTCn3jcXKjFYuuYtY8MNo8bDg9VsZaKwaSYnRr2Qse' then value:parsed:info:tokenAmount:uiAmount ELSE 0 end) AS FBLBBU_out, sum(case when value:parsed:info:mint = 'RaYfM1RLfxQJWF8RZravTshKj1aHaWBNXF94VWToY9n' then value:parsed:info:tokenAmount:uiAmount ELSE 0 end) AS OPALRF_out, sum(case when value:parsed:info:mint = 'SLEDkN916vvcpucY9Vn7tAzNXRcxsq71kkXzaj1cxoX' then value:parsed:info:tokenAmount:uiAmount ELSE 0 end) AS FBLSLE_out, sum(case when value:parsed:info:mint = 'RUCHH4AcvodBcndmcT17KUBbd5ee5LQtmpsfvBVNnPH' then value:parsed:info:tokenAmount:uiAmount ELSE 0 end) AS OGKARU_out, sum(case when value:parsed:info:mint = 'phi4PYgmxeTMLLpGkU87T16VUZ6AjWZESkfT1JGJ635' then value:parsed:info:tokenAmount:uiAmount ELSE 0 end) AS PHI_out, sum(case when value:parsed:info:mint = 'CALSHIPEZcCoyXEKqw9ovCdYeNzck9uVbb1KCcsHaGhc' then value:parsed:info:tokenAmount:uiAmount ELSE 0 end) AS CALSHIP_out from solana.core.fact_events,lateral flatten(input => inner_instruction:instructions) WHERE program_id = 'FLEET1qqzpexyaDpqb2DGsSzE2sDCizewCg9WjrA6DBW' AND succeeded = 'true' AND value:parsed:info:authority != signers[0]::string AND block_timestamp > '2021-12-16' --AND block_timestamp < '2023-06-01' GROUP BY 1 ), fc_in as ( select signers[0] as wallet, sum(case when instruction::string LIKE '%HzUBawF9xxTy4mTuvSkk1a4voJcm65tSHZz6voCDUB33%' then value:parsed:info:amount ELSE 0 end) as CS1_in, sum(case when instruction::string LIKE '%2piSPCxbuibsraBnnK4M5rGeHSraNe2oiD8hDw42bPKq%' then value:parsed:info:amount ELSE 0 end) as CS2_in, sum(case when instruction::string LIKE '%C2uF4fECabWryVCV1bDuxP7jMspbf2gei3YAP2UBn292%' then value:parsed:info:amount ELSE 0 end) as CS3_in, sum(case when instruction::string LIKE '%EBEJj1LKuo1k1J2ZvNJxsXATdGYnfaLWzqxck5p4PXSz%' then value:parsed:info:amount ELSE 0 end) as CS4_in, sum(case when instruction::string LIKE '%3aTW9zvPz5f7vt2Mfnr5zWA2RcgNTtDSSrBwaxyZ6t7d%' then value:parsed:info:amount ELSE 0 end) as CS5_in, sum(case when instruction::string LIKE '%DTbNmLWfu1pm4AuXRKYTApnDNfxMz73VET7nW5wizG5t%' then value:parsed:info:amount ELSE 0 end) as IMP1_in, sum(case when instruction::string LIKE '%ARNZXUQoBKx3JCX3UJB4aitSnvcjMMphN9YVDFy1PdKq%' then value:parsed:info:amount ELSE 0 end) as IMP2_in, sum(case when instruction::string LIKE '%GmVKV9W3qZcERxk7hjqwRDcn9Kgtz3XDi7KfFLdGqyaW%' then value:parsed:info:amount ELSE 0 end) as IMP3_in from solana.core.fact_events,lateral flatten(input => inner_instruction:instructions) WHERE program_id = 'STAKEr4Bh8sbBMoAVmTDBRqouPzgdocVrvtjmhJhd65' AND succeeded = 'true' AND value:parsed:info:authority = signers[0]::string AND block_timestamp > '2023-04-12' --AND block_timestamp < '2023-05-01' group by 1 ), fc_out as ( select signers[0] as wallet, sum(case when instruction::string LIKE '%HzUBawF9xxTy4mTuvSkk1a4voJcm65tSHZz6voCDUB33%' then value:parsed:info:amount ELSE 0 end) as CS1_out, sum(case when instruction::string LIKE '%2piSPCxbuibsraBnnK4M5rGeHSraNe2oiD8hDw42bPKq%' then value:parsed:info:amount ELSE 0 end) as CS2_out, sum(case when instruction::string LIKE '%C2uF4fECabWryVCV1bDuxP7jMspbf2gei3YAP2UBn292%' then value:parsed:info:amount ELSE 0 end) as CS3_out, sum(case when instruction::string LIKE '%EBEJj1LKuo1k1J2ZvNJxsXATdGYnfaLWzqxck5p4PXSz%' then value:parsed:info:amount ELSE 0 end) as CS4_out, sum(case when instruction::string LIKE '%3aTW9zvPz5f7vt2Mfnr5zWA2RcgNTtDSSrBwaxyZ6t7d%' then value:parsed:info:amount ELSE 0 end) as CS5_out, sum(case when instruction::string LIKE '%DTbNmLWfu1pm4AuXRKYTApnDNfxMz73VET7nW5wizG5t%' then value:parsed:info:amount ELSE 0 end) as IMP1_out, sum(case when instruction::string LIKE '%ARNZXUQoBKx3JCX3UJB4aitSnvcjMMphN9YVDFy1PdKq%' then value:parsed:info:amount ELSE 0 end) as IMP2_out, sum(case when instruction::string LIKE '%GmVKV9W3qZcERxk7hjqwRDcn9Kgtz3XDi7KfFLdGqyaW%' then value:parsed:info:amount ELSE 0 end) as IMP3_out from solana.core.fact_events,lateral flatten(input => inner_instruction:instructions) WHERE program_id = 'STAKEr4Bh8sbBMoAVmTDBRqouPzgdocVrvtjmhJhd65' AND succeeded = 'true' AND value:parsed:info:source::string NOT IN ('4RoeBTjsMyMf7wJ1a3Hi3NsppphgvpVLHaC5Tb4FKUQ8', 'Fj1fDGX77KoFLbB7tLL5xg9xR7DvJxNmU3yo3QR1hgm', '9Dp9Rjh6mmDFPDkLVhp6SbJp2Xj2EDGAWy46yVrfzAFG', 'CdQHUngrpj21e5Pi7WD21Uj5w6wDWX4AK1McuedHMDga') AND value:parsed:info:authority != signers[0] AND block_timestamp > '2023-04-12' --AND block_timestamp < '2023-05-01' group by 1 ), ------------------------------------------------------------------- sage_in AS ( SELECT Case when signers[0] = 'FUnDSXuqNmhZxoeE4PC7F199HhrxX3kSBC21XgVRoUxG' then signers[1] else signers[0] end as wallet, sum(case when instruction:accounts[3] IN ('4uyaUz4Uuyn4JCfx9e3oCrHrZ9SHyBEL49pC8A6s5AUw', '9cZi3HuvF6D5A8Y99fZgMeRYauuKL9FTHuvXRbuLT1F8', '8pnGgULgCL2112EtYj741y1xsk3nG2ihZaqShmgXFLZJ', 'EH9HN9caHzw1XBP2Pga4QNqLfuhA1GMkjpYfS4YfN5Ee') then value:parsed:info:amount ELSE 0 end) as OPALJ_in, sum(case when instruction:accounts[3] IN ('4XXUwx53awPMT3PLzHAWEpMJnX6NYQNnX8vYvfemvrFq', '53dfbbrV7ap3qymV6MEmRnaz7HYGRYjfXTk2BULu92zw', 'Hmyfv5bkr5U1Jr41oACvmD42BvRq7uLjGMBJogB8hi8k', '6bFMa1ZxYEGfYgmc1BQUUofmoUPcgRdrPW4yLmd79EQX') then value:parsed:info:amount ELSE 0 end) as PX5_in, sum(case when instruction:accounts[3] IN ('4nUbaNLtyHinoJpQuhRqRjJR9nFncbbEXpNC8okyC8aj', '68kUH4uqyWLzA6Gv8o7DmKNFE2c1uazoKPWPRnKHtr2U', 'GhWZKSBjAEAURMGdwt2dy9pTAbNmXV2eg36uSjF28N5d', 'Ar1ZFmCRiqAjAEYjr3xTNHgsMSUUwKRxiKVYVJcu2GZL') then value:parsed:info:amount ELSE 0 end) as VZUSOP_in, sum(case when instruction:accounts[3] IN ('9ZipbjKfK95rm8t9gmik9G2NpSWfMoCJRbQ8Qo8kYGva', '8rr5pHmdwPjrZpHGqz14Jbdnrat9cFA8SSBwM5gRnWpt', '9tnAnUMYWRXuv6XT1i7a1tR1qns7wo5FFWZ2YUA37ynq', '5kzn1g9jeQEu6NsaChDYp3fvwG1YJnZHzJg5CXLEMYvi') then value:parsed:info:amount ELSE 0 end) as CALCH_in, sum(case when instruction:accounts[3] IN ('G3pW5zHyTcsETPCsWS8oCpSnoPs5CobCtfFw3Emtydah', 'DtbABZgitbfyCup3wvEHc3h4xsYTzxaeTTGi9vhLVQcU', '3iER3WmG1n35VLYXzx3QG8e7V7Bhp7N1wcqCzhXvjAUA', '77qLg5b8ivd7ViCjruFz4v8xT5NMDiLmx8D6pCkEepYq') then value:parsed:info:amount ELSE 0 end) as OGKATP_in, sum(case when instruction:accounts[3] IN ('BxXXdXFSCbYdM6jNceuWjVcVg6v1Rx2m18ZYX157MJa7', 'CFuzC4svkZuN3Q3FJ9znkcFs3wQ45FyKX9a5HpVZ4fdg', 'WKfiFXLpJAvze9hmYBNa7DiUsxQohCwJnTE9a6MAR1J', '5ynN1V8zD3hX7L7URTQvQeoMJ3xNFWKexngnzWU7AwQM') then value:parsed:info:amount ELSE 0 end) as PX4_in, sum(case when instruction:accounts[3] IN ('CrFYXsVFr6witxBR21DdtifHS5sfzwmwqFcXPhBXftRr', '75bF9D2PRuncAEZFp2SjHuYTSNAwLggddeM7ghz348zb', '6gHEL57L5HNAqswqH9yRqteSGG9x3mwau6hozSnoyQju', 'AYT3i3A8Xxm7HJqXCd4jCWWQNXPUK9fuPjyfBqnp9FgB') then value:parsed:info:amount ELSE 0 end) as OPALJJ_in, sum(case when instruction:accounts[3] IN ('5egr6rWmL4Lwap5V18EQkXAr4whJnYEhUzF9GX1uMZBi', '9P9eYSBrxchK6TW2WtRRpj3dxoHGiAbWtP8ST99SVXG5', '7zY8BDTitYCnGnPyk9miwrTnniTWuPwxsUGrwNgNsaUG', '6JQc6ke4ujTufiv9R775NKKHeqYLAGiHmMwRCDJHi1zF') then value:parsed:info:amount ELSE 0 end) as FBLBPL_in, sum(case when instruction:accounts[3] IN ('HA3oFqXLBSh8JsxswRC6hwfoHLs3cre64rsB2X3dM1EV', '9gZSvca5erz2P9t9XngThfsAp5UL3ibsvLgq678n2m3n', 'DJVQTvDsZjsrWZZXEHJG6SvLN7p98n3eNm9z7egvodqf', 'BdpG52ijY4PWSLovnYEcmT33r6WWW8X996vaYx8izFgk') then value:parsed:info:amount ELSE 0 end) as CALG_in, sum(case when instruction:accounts[3] IN ('F8iGnycgWtSfWPXeAYfNLKmFLrFayGnoByZ6gwtbSEV', '64VyMPac1sDzBUayjqggFsT8N74HcKLDkYjVwxXnD5jK', '6U2LSzLQDZDvxRXDhXFktoFJ7qKV5n1d5qi4M2ujeysT', '4XeT8A55RRLxubfcDeNC97WrRbBvuSmkUCjCMF2ZSR6q') then value:parsed:info:amount ELSE 0 end) as PF4_in, sum(case when instruction:accounts[3] IN ('Ha93CftoBiVhaiqDWAuh5AfDLjk3QbkC1twzdJeCd4Wt', '5cacXtgHTbgp2uSUnNGaWAwyE4yKWqYjR4EXfutYExPR', 'fknnLCQSjSCAZQ5WVEAri7jTy3TgVgVbcSiXboMavRu', 'FaYPPt39mtnZqoyzo7KGYMNQAF78gWBRXPJ8KSgTdc1s') then value:parsed:info:amount ELSE 0 end) as FBLEGR_in, sum(case when instruction:accounts[3] IN ('AW6VceBYuWVfewBgqM94HZ6tA971an8Fpp6wqBYswzij', '2afGL24tNkJVeqrDDEo3gpHS2sSpXRcLfvT24Phrms4Z', 'BiqPvH3JkNaVutB3RqxPfP1Jvop2MUuai4HvEkaBdxsj', '95BuMZfGuiSEzvexZrXhSLMjLA7k1MTKpNpMWW7zirwX') then value:parsed:info:amount ELSE 0 end) as OM_in, sum(case when instruction:accounts[3] IN ('HJSkbTrKYmrmL89HKWkRy3XeGu4ajs4QivfF1h49qDHe', '9f6RirXWCB6qwXyjv1gGizUMQ3LY5ooQGPwrnCW2oh2u', '8AHQFx1tms8Yq96viVupsLbx5Fq25uvRLzpwG3QC25dv', '79yFYsL811c6VwbbcQuRgMxgHtWcH85HBUBkdDb51X5d') then value:parsed:info:amount ELSE 0 end) as PR8_in, sum(case when instruction:accounts[3] IN ('2jkpNadkAQmqVZS3xxNzJgny3Fko5WerRf3KqxWkNxSB', '32qaabmuw74hvTZadeXjMumYD99AMrpNqyPuKn3HVe8J', '9ygAgXqvnSqLyX9GzHcaDuKL26cbnEAmZEthbD6FgFtF', '9av3JMHqcF2vr91AQ85bHHv5cmwcZAjna3ZV9mU4G8wc') then value:parsed:info:amount ELSE 0 end) as VZUSAM_in, sum(case when instruction:accounts[3] IN ('CnayPwJZTLSbuxHmt1id9iJWzUJDd2tDVtQdAccC8afL', '8AC8wukkW7muCbEWLxWs3FSJE9WyMudfGGbj6RW7mYar', '8sXv8iDr87Lz8iaRocLzPrKE256gAk2d5UpAmzDLfBCz', 'ASNRGuyNkozXy2tAF66F2tnPqqnTkVJzEFVw4ZeviG7P') then value:parsed:info:amount ELSE 0 end) as PC9_in, sum(case when instruction:accounts[3] IN ('9V52st9wdob3ey9QvX59cS3zv7MxARLZ3hHTqedBumfa', 'vwozwkJNsjMLTeVUs1iRxeUVJbWaWrW2eKESUHRZ7LB', '7bE5zg1DrixWjfuypikJygoE768zGrDre1w3yq5Tkj7F', '5REcrxQL5MbQyiaMx3mC1mVFjUSK3kmBrvzey9i7Azcc') then value:parsed:info:amount ELSE 0 end) as PC11_in, sum(case when instruction:accounts[3] IN ('DthP7zqzf97mAcsDRVJ6xfkGxWoxKcFCCRf9xNucUh2B', 'EXjCsJy9KSsug3DnpLmALuWKujidjNHSnHrd8RJUX3ub', '95sNiGDCfaxc7rECxdExLkQmJrtkHXpPMrxy9hmYhHBW', '55fAt5M8KdKf7gHVMfQ52ueFfFTiVGW8A9UgJcETgMCo') then value:parsed:info:amount ELSE 0 end) as CHI_in, sum(case when instruction:accounts[3] IN ('6iCR5C8S9VxZXbioAjAeabUq2XkKWi2U9Zb9vmbWeuzG', '2ytUYaB5SRXys6sWTLrLGp7qWDtprXL8ezqjzp7SAbLS', 'DpbCSTcqypiLWpKRMZnNHsZVj7s3y8kM82p7aBfsJFKr', 'HGLYFJZqcA45PR2sCvctzPPTY5DQzzioDE4y4qNN24GG') then value:parsed:info:amount ELSE 0 end) as OGKAJA_in, sum(case when instruction:accounts[3] IN ('8Qi5zpQfff9FeDSFkb9XfiuF6gq2dwDxLBRGx3EdSaEW', 'BumzJhBXSnFkgPfhz25GEP4FkcLVLTRUpLtfrjhULJFk', '54p1Uh4USSxPiwuo4i3bghTjZJZneYtHhaS6tMRc9vX1', 'Dm8MvmfarBWumoJY9gE9V6uuewV5g4BKevPWX18hmZn1') then value:parsed:info:amount ELSE 0 end) as CALEV_in, sum(case when instruction:accounts[3] IN ('54TDYdVgtq2b4tBwoHdoo17uYFJUJckCrRGqKxyFkj7g', '7wuBJfProCr3bNUXPjRY96Kpzur85nb987Sa5V2x7KNB', 'DD6j2HT31ciq8hkfYgLJZ8sJ31zQP1aBsp3k1MdiC4z9', 'BD1kBHCchsmSzsQ53hum8AcptkaJphbBUqxNQT8Z4nar') then value:parsed:info:amount ELSE 0 end) as TUFAFE_in, sum(case when instruction:accounts[3] IN ('GnZ69gx49ddSwjQotvRvBpR4q3yJ5tM3PdYaffxPtBm2', 'DZKSM9zTDTd71yJroAmBaC8Hy5Fje6F6oDy7nGxJhdrS', '6VfrG3ry62tK3Vstm7rUmpmjj2ME4sLnTtMQWQCkQi3y', '9Xv3HfGv6A8R31kennLL5Ys2GuqDQavxXL9FNCBQHAbR') then value:parsed:info:amount ELSE 0 end) as FBLBEA_in, sum(case when instruction:accounts[3] IN ('9bP5YJLYJtzntr8ovW6L8ynBAi5J6QEt1rwCmcWcGyPm', 'Cd9j4F5i9WJFXaCxZpLRreV3gixwvaZdCNCauHz8vn3L', '9ZptmxoQ1NSn1nX563JJREZUhAD2XJiiTB8NT78qdShN', '9p2CyjbpZdpUKUnxKW2S5PehHtHcjmdb6W99R28VYRyY') then value:parsed:info:amount ELSE 0 end) as PX6_in, sum(case when instruction:accounts[3] IN ('2fxfiHW2m7gZ19h2PaApSwkTbV18sEvPq54qhyawP8Pi', '5xVBszKPwfJ6wWsCjxQNRhDpVhAR3cEC32HtLz4GZsz4', 'D4PAVuy9JMEw4d6eo8WRqt8TVQFHGCiWhsXhkiSruZyK', '33xq6jQGPTUCtcn5bc7GPRqdCMC5pLR8vdBs4xhLB3x3') then value:parsed:info:amount ELSE 0 end) as FBLEBO_in, sum(case when instruction:accounts[3] IN ('CRk4X9f6CURLVAwHsgTHasBjGK917meeaMPubVpkhMA9', 'HEPNiu3h5WN6U4xZuYZWySV85iwS6RSK4hsZohPGs3Pv', '6tvT4oW85Fi6HyaXrNtzYp9EtFLyPETuKQWdRfFFDsgG', '7HShvz72Rct4Jg1oYpfCTGK9HGWzcXJgfbgLpt4bCdS1') then value:parsed:info:amount ELSE 0 end) as FBLETR_in, sum(case when instruction:accounts[3] IN ('4J94Fm5xwFBbt8hj33FhA27T1FsUgUGNi7Qq7BXMZNpT', '481zPGcmwAimVrFSCqJFbAEUQFLsPAynk3JyV6TvYawZ', '4BjUbBuo4FQm7Yr4jb75MxTkkRDmwxgqQ7xyL5Q2bBq9', 'ABH4s13LqbDBrPJPCDUJaSVJFSbDDBYfJzw89M1KCQLe') then value:parsed:info:amount ELSE 0 end) as FBLAIR_in, sum(case when instruction:accounts[3] IN ('5xAZAHJQHWVpXMk3N1Sx1DqqVGLtuHdBjDDNG5TeCxno', 'DM6pH1xtRRcEWiq2MGPRhh39H5qxoQttzX2WeRvrajFS', '96dgvxnjGRuTVXF64xNDabgpHUHYTKF1fTokGR8buwht', '7bvdYt3LeV88GLkwfX73J9E6CuqvHXN9YJPejRXSVLLW') then value:parsed:info:amount ELSE 0 end) as OGKAMK_in, sum(case when instruction:accounts[3] IN ('Fxz49GMh2f6wHbaQbDpfRNz6sfMbq8XbS6YAbidV62qC', 'GKCqT5tq2YD7XMMbd51ApQT1xxy3xV2pQ8buYR7po8vd', '4ybcv8FjVvw8urT5KKfBnBwJKjrWx5DnKZ4gDEb4KCW2', 'Gx51StJ2tgqSEDK56243dZCoEawHF2p5Ykmw2Qs5xSDX') then value:parsed:info:amount ELSE 0 end) as FBLEUN_in, sum(case when instruction:accounts[3] IN ('5bTtEaWn42TkZStyf8B733aNUucSJdCvcSMtFpWtuHdR', 'HW29dyU3CyKNPWc5mAyooRiYsmBLnoZLycVE9ve3ASSH', 'GxzSpXVqUwZiZ2epfCVaMCkVZcjPL62gZdAFftcoEpcP', 'Azx28rV6tVSCodkbWbcyuddB1azA3N3zf5o9EYTG36UU') then value:parsed:info:amount ELSE 0 end) as ARC_in, sum(case when instruction:accounts[3] IN ('4vaQucwJsCf1eZKncpSgvqaMSznqXvqxUXrrGNka8EeK', '3UMp2MEakphLGtWmpGjzdcDLM5Yrht1chAtQJD4VUikp', '69JP1ZkbQveWeed8snWg3eJTo5BFZXyTS3F1aNdCxF4x', 'F6JBrBAgBxAF2XfiZ2XCWNr2aez9qR1jepBNJhdA3f1G') then value:parsed:info:amount ELSE 0 end) as FBLLOW_in, sum(case when instruction:accounts[3] IN ('9naezTVoJzKHU6cCtm9o2PZQgcLaRp1VKUCFywJ6BB98', 'Ds3zjkhTLX9T9SRaWWPhcGd7kJZ8e1kNZBzZqW6DtjU8', 'FNqUeukeMb2aDtSFuGNq7vRtnfN4ugsS2cFMVfyKjKJF', 'GKEUXMY1WQgem6yy3YmsUmgyFRcHiL4UQ21AjCZZ3Gne') then value:parsed:info:amount ELSE 0 end) as THRILL_in, sum(case when instruction:accounts[3] IN ('AWYrWer9tXeQHLBcubvRAobUkGnqu92xMQ23rcZDyb7S', '2HMJfou9NVSg3Tiu8txNQytg3EAXu1XAYDpPGmwvMkZ9', 'ENnjXSo3Zs3tsgeybKv7rzaRok8q1thjC2sja5t2fd8u', '3c9poKM6Gv2J5TrW11kd8cPQEXYVUjQ7xnjyNPxah3or') then value:parsed:info:amount ELSE 0 end) as VZUSBA_in, sum(case when instruction:accounts[3] IN ('HG4TPVTBxicorkpbRMwcshhJiBRd3DAyBWS75zjdEyhc', '2mJmuXFQ82Ur5udzV89KkC8dfSRpwy3TEMisP6p59qkG', '53FRSKCas2NFBqriRdUMcdDNWV9Uz5VBPqsULzhZhN1K', 'GwJufyFNdjLVdL4ihTWi5n2hKkjKhTcfFfXCgPtJFamj') then value:parsed:info:amount ELSE 0 end) as CALMED_in, sum(case when instruction:accounts[3] IN ('BiC6pXszsk3FXsYVu6CkXpzKbZKGbsoaarqmiFvuX8G1', 'GoEDxKAtshk6HBYJKH1nBXzhfQhjy7zbgpT1GuSEGAhK', 'FfwUP2EgXNEi1BM2crz4qHmUiDqZo11ZtLK4k8XTz3nr', 'BmLcQ6HDF7Y68iqTSeRzxwGuRqemtCr55w9YSXTk3eMT') then value:parsed:info:amount ELSE 0 end) as OPALBB_in, sum(case when instruction:accounts[3] IN ('Hc8aaPfq5dX5SgHvRUm6WzpLZfKmKBTSBSGmeQSceTgF', '8Vjm42qD2XLRyCeLkfaRMSV8ZARMk8XU7n5QP7K6ryNb', '2meFiRGyNf7D8d5GVpMkPSb9ZLk4pn4BVQHeQjHohX4U', 'Ekgd41LEoDmG7Pb99idQxTV3pWdFjabxxxg2Gdt4xbgY') then value:parsed:info:amount ELSE 0 end) as CALATS_in, sum(case when instruction:accounts[3] IN ('EpE8bSBjXxaz9qDLGsraoLt7ZParCZmpHiVTuTgJ7RGH', '8LMzsiGLAL4xJHoWGbZrD9o1heUAjbwHgJ1P3ArFBQbu', 'CZb4ZMoUJMvvGTfG37T3UjoDsJrVAMR6DKpvKPo9ZY5g', '39X27PexwT46hwz7FrDE2qywzyH2cPeFECxiwCgEZbW3') then value:parsed:info:amount ELSE 0 end) as PR6_in, sum(case when instruction:accounts[3] IN ('FVDUszyERm5koTVnLuegVt6NmSyespJLWWCf7JnRNu9Q', 'AgyXPBb4ScDW8mFqkSwsrtenyzNtd8P8poKazXfPKAph', '7CsMzsqDVEBcqY4sTsFyima7qtvyuHSybidy8GQgHcnx', 'H8HipQiux2xyTathhU2ow3i5ZR79jqokbr3L1zBbLdrX') then value:parsed:info:amount ELSE 0 end) as HEART_in, sum(case when instruction:accounts[3] IN ('2DWADKpPdn1cPzSWNkbYDPTod7CcmrND1qg8UByrxRZX', '4jQ3ZEfBv9TcsRcZALruTH4XQJRVtaDe5RrFL74hKVjK', '5NCRSzoj93mfbewwGJrGMyneZCyMLe5tctDBUJ5hwGkP', 'H8MT3cQh32wKJyqTiGXKF8XnGzndZG75TXnfrjvdvfu7') then value:parsed:info:amount ELSE 0 end) as OGKATU_in, sum(case when instruction:accounts[3] IN ('AdHKZykUeMq5DaGr6XhAz7paCjiKrjiuE71P47A2F7XS', 'BLy7xx74mnygp8u1eX1qTyHChQAjj8AUpaZpH2st5TpJ', 'H2swdthjddQmti4MLZ9VsdGgyfSfZCqTe9oXgp3u7Z3M', 'Bc8NWWYxtLWFCTHHdnWcBuTreiDMZCY6HuiKiqSofrLD') then value:parsed:info:amount ELSE 0 end) as FBLMAM_in, sum(case when instruction:accounts[3] IN ('HJidhRXfWfm86ciZbyThMJ67sKL9piQgbJk5UpdSd9t4', '2p57ETgYXxycQmyYvfxYk3BHLoUcitBXyt1yNiV7xswd', 'FN8GVkKaEbn11trT2sUi1GfCAz2w9YoXQTokren9ubM6', 'CmJVzGjVZL61iZsy8k9RnNu46cK8TD5Neh7XiVGe29yZ') then value:parsed:info:amount ELSE 0 end) as VZUSSO_in, sum(case when instruction:accounts[3] IN ('J3Jri3uPhXWt8sa8LWBTkNaAbY7wArBq2Gn4R81fGG6f', '6W5WCyKqAs7yGdnwhEuSfySguFYqLK6wvWDJ1jwQrkVc', '89zCTnAe7ubvt2SG4qgaQLQmR8dtBTYiiLpRKDDjC6qd', '46DmGY6e6xgmGoD9crVAruHphQUUGxLqZv2zFEic531e') then value:parsed:info:amount ELSE 0 end) as FBLBTA_in, sum(case when instruction:accounts[3] IN ('CcrgdGfpe2fZrRc28WbGbE7bV1JLpF2b55wAREnN9UTL', 'F5m38CFFmdJBhedVeK25CQ2NohFyheuy8KkCbpjv6Quq', '4fytMaWSpxDxyL98UmXoufXWsizYNFkGLDLFCZ1PWRtX', 'CNnqYsbnxW6yZv3vmVhszv1FALAatyTfZegCiH1baYe') then value:parsed:info:amount ELSE 0 end) as OGKASP_in, sum(case when instruction:accounts[3] IN ('9qGugLVTXSZpTyAfBvPuJUxqngsBhhE2C72XmzHQMfv8', 'HND3ivP5n4hRKcF4TJQPxEBKm45MC1qcvzvZUXRX7FTm', 'TWa4Sf3zhWhN2zNf2M61WvbtpdsGA3H2kktEBNdkpNu', 'GA2Ad4xrb4QP9sUhrkpVEEyB34Wzf5MNBXwKQg5WVZgA') then value:parsed:info:amount ELSE 0 end) as PD9_in, sum(case when instruction:accounts[3] IN ('6DUuNmUFyaKqNRNEww8iT7xdbgFtHxaChxzGUmhNKffH', 'Gzss5T8snHFDuHTEYrHcvvzDuMzdz5VTZCwWZ9jdMFG6', '7Sb23t6EEecii2sSz4VDscvgFT4LkXNWYMyCbazkZoCP', 'CPzUv2ftc5K1SF3AYVDrt8CExdt8z2TVAcUd7eo4MPQJ') then value:parsed:info:amount ELSE 0 end) as STAND_in, sum(case when instruction:accounts[3] IN ('5xsT8KvYdmjSdByC7WkS7mkBqLr4vqMABZPaZXMbtLWb', 'CpQRfvwUhzPzRYF2xvfok7EoX8ck4mPQwSQpb8MNvwa8', 'Ahv2QBPVhHy4612KEhEmxHt56vAHwV6gHyKumJw4z1Yk', '9EeGpXY5qUG6Yho8giBf4WhzyX4R2cZ7B7xVq5GSCqsM') then value:parsed:info:amount ELSE 0 end) as SUPER_in, sum(case when instruction:accounts[3] IN ('Bp2ZDiediKaAnYYvPovXCnsCEnqv2ZAivHVXfsGFwh5g', 'cCeshLbHjxdeF8zCb6id9zBBy3ZVARsnqAGBHGbPZFA', 'Hc2saJjAuUNmQWvQ6VJzFWywyW5cQaGzGTq9HtjEU2kq', 'DhUcDdgdJPaY9sdprC1GixvVMYCHSxsQsecqL8dH5j7s') then value:parsed:info:amount ELSE 0 end) as T1TAN_in, sum(case when instruction:accounts[3] IN ('6Vm9BAcC55SkzaT1Z2zu87A8UivA9LGhhfoAMNyy9C5x', 'A4V7cgLshhx98JaNjYyrER7o9wBQ9WEaCaAN79veUKxy', '6eXJX8B5KX6p5xhsRT2jYM8Z9aSxv4RFChK3vpKcE1Be', 'HcNSqnR16RGBKeNm32Nbr3LyeEBfiDosMUSMtbaF9xpo') then value:parsed:info:amount ELSE 0 end) as CALSCD_in, sum(case when instruction:accounts[3] IN ('6UJgUGEVaSJ26mBxWLsk4YbX3jnUSreF8NqEFBy7pyrJ', '8RYDHoMuQYR4QP5Egp8yJNQTfEk9PEFr4euTUnWdYhWZ', 'm7B6bnQBJfhZrph9qbe5QAfTN8QjPeUsaUYLxHAYAuD', '8BiKMH9wiLCwKRRpL1cRNbjSqeESqLD44KUxyCtDLsb7') then value:parsed:info:amount ELSE 0 end) as CALMAX_in, sum(case when instruction:accounts[3] IN ('CjVhrqyHT5RcVLJJDhvr9GaC5bsvjiGQ1BCRTzkx5Lbi', '9fCE1rnwVUNLLwMTqyCMZFBjxyXXQnfMvT3ZB1RD3JP5', '51TDmJzqa7PMbXkwuWYpqCeL3Dje4YN4bcrVwvmZ76WF', 'FFzH8WYnZ8fY1kuev7EU46ThXwzT6P7M3sSCuaJWRRvv') then value:parsed:info:amount ELSE 0 end) as OGKANR_in, sum(case when instruction:accounts[3] IN ('EJnH2PDKqHShN5YN9pj2iuCufqxpAQ1i5rWHn1AnYgLb', 'E5b94UNMfqDbkzk1GFwmTbRCbG8cUUY8NgRMyWM3Bnen', 'BkKwywija7sW9tYvcT3MmZcZs9imymoFLk9MofBF7uVU', '7pZso3pbbZ786BPcvzJJa7PyzaZL7r6u35sW79BtWNbm') then value:parsed:info:amount ELSE 0 end) as IMP1_in, sum(case when instruction:accounts[3] IN ('46pnnTWn8JyEVVLS7TXg5cUXiYdaEw9Pb3qEVQTdYJTG', '5x3JztnXF6jPKRVjrZHeTnVN5mDJQXimG6JDfTT4AdGC', '5YcnLXgCZ1K227e9kd2hVhqX1NtvpvhxFCNTdHsWDEhf', '3iVucNFkrYTTPUZ5FDUpjXZDUyTKAUFiHbbQczEu76Ed') then value:parsed:info:amount ELSE 0 end) as IMP2_in, sum(case when instruction:accounts[3] IN ('GwmpLgN8TrpTRoqkwBQaZ9ab3EiiAS2xj7rsbxqhdN1x', 'nTgbBGHaY2hsoqhA9jQt3NPAAeRUoiqj6dCdazUtRxw', '5nNgLsuLPQbrBrsNT2ohkCm6gEukoCgrzvGCvNaLCcBd', 'nLEAQJcys5TQWdcyKDJiBQaNzuuCnMHnYjj6ZEyQGQg') then value:parsed:info:amount ELSE 0 end) as IMP3_in, sum(case when instruction:accounts[3] IN ('AWQ1wsCmH5Exx7ERPJApT4CFHfZeHyaaUun7jtNWQZ29', '5ofAbiN1uM1cHCkwXtw223yxqWNMVWB139txk2JKcrBd', '143e4xYb255yULC8Ripgo3CYFFZKttwiaRYBR2bhY2fW', 'GcQuTQmVQUjmzNonjUKLBjXazuMmB1W2E9HzmDzcWgv3') then value:parsed:info:amount ELSE 0 end) as FBLMEX_in, sum(case when instruction:accounts[3] IN ('DbTZJcnYzFUTnXH5ZzgQ9HZauJK6iS4jtZFxzs9FwYZk', 'G7Bt1fixiw8hCJ7yD7ehofToZS5RdACqofZVdyqwkjw7', 'BS7pqvdqk2aXSnBXfs1qA6Tz2MFoAbrPQbHTQETCEVi9', '3x2aX2RGZmw64rBj4Xkjdey1hhwcNhoRyfHxENrKSS1G') then value:parsed:info:amount ELSE 0 end) as FBLBBU_in, sum(case when instruction:accounts[3] IN ('GMmxLD1WL7GEhvW9ecTFuR9EjVLapTVjdNRzWoR3UrYd', 'EkQ6yigxiGQzgfxFnzCX5uUbpxfJqRf6N9xQjnuD89uy') then value:parsed:info:amount ELSE 0 end) as OPALRF_in, sum(case when instruction:accounts[3] IN ('DMphYjcgH5X4pmQneDgrHUg5gaSryKSNYPcXr4DmCdjm') then value:parsed:info:amount ELSE 0 end) as FBLSLE_in, sum(case when instruction:accounts[3] IN ('G7zUEmxy1ADcLwnK3duBYPkXZjh5x7A52owA2kmuoN9f') then value:parsed:info:amount ELSE 0 end) as OGKARU_in, sum(case when instruction:accounts[3] IN ('FnZUgT1A86UFuZfrEsDARZE3Hgf9emMJH1WgjiSh5oFd') then value:parsed:info:amount ELSE 0 end) as PHI_in, sum(case when instruction:accounts[3] IN ('') then value:parsed:info:amount ELSE 0 end) as CALSHIP_in, --- count(tx_id) as txs, --- sum(case when instruction:accounts[8] IN ('4uyaUz4Uuyn4JCfx9e3oCrHrZ9SHyBEL49pC8A6s5AUw', '9cZi3HuvF6D5A8Y99fZgMeRYauuKL9FTHuvXRbuLT1F8', '8pnGgULgCL2112EtYj741y1xsk3nG2ihZaqShmgXFLZJ', 'EH9HN9caHzw1XBP2Pga4QNqLfuhA1GMkjpYfS4YfN5Ee') then value:parsed:info:amount ELSE 0 end) as OPALJ_out, sum(case when instruction:accounts[8] IN ('4XXUwx53awPMT3PLzHAWEpMJnX6NYQNnX8vYvfemvrFq', '53dfbbrV7ap3qymV6MEmRnaz7HYGRYjfXTk2BULu92zw', 'Hmyfv5bkr5U1Jr41oACvmD42BvRq7uLjGMBJogB8hi8k', '6bFMa1ZxYEGfYgmc1BQUUofmoUPcgRdrPW4yLmd79EQX') then value:parsed:info:amount ELSE 0 end) as PX5_out, sum(case when instruction:accounts[8] IN ('4nUbaNLtyHinoJpQuhRqRjJR9nFncbbEXpNC8okyC8aj', '68kUH4uqyWLzA6Gv8o7DmKNFE2c1uazoKPWPRnKHtr2U', 'GhWZKSBjAEAURMGdwt2dy9pTAbNmXV2eg36uSjF28N5d', 'Ar1ZFmCRiqAjAEYjr3xTNHgsMSUUwKRxiKVYVJcu2GZL') then value:parsed:info:amount ELSE 0 end) as VZUSOP_out, sum(case when instruction:accounts[8] IN ('9ZipbjKfK95rm8t9gmik9G2NpSWfMoCJRbQ8Qo8kYGva', '8rr5pHmdwPjrZpHGqz14Jbdnrat9cFA8SSBwM5gRnWpt', '9tnAnUMYWRXuv6XT1i7a1tR1qns7wo5FFWZ2YUA37ynq', '5kzn1g9jeQEu6NsaChDYp3fvwG1YJnZHzJg5CXLEMYvi') then value:parsed:info:amount ELSE 0 end) as CALCH_out, sum(case when instruction:accounts[8] IN ('G3pW5zHyTcsETPCsWS8oCpSnoPs5CobCtfFw3Emtydah', 'DtbABZgitbfyCup3wvEHc3h4xsYTzxaeTTGi9vhLVQcU', '3iER3WmG1n35VLYXzx3QG8e7V7Bhp7N1wcqCzhXvjAUA', '77qLg5b8ivd7ViCjruFz4v8xT5NMDiLmx8D6pCkEepYq') then value:parsed:info:amount ELSE 0 end) as OGKATP_out, sum(case when instruction:accounts[8] IN ('BxXXdXFSCbYdM6jNceuWjVcVg6v1Rx2m18ZYX157MJa7', 'CFuzC4svkZuN3Q3FJ9znkcFs3wQ45FyKX9a5HpVZ4fdg', 'WKfiFXLpJAvze9hmYBNa7DiUsxQohCwJnTE9a6MAR1J', '5ynN1V8zD3hX7L7URTQvQeoMJ3xNFWKexngnzWU7AwQM') then value:parsed:info:amount ELSE 0 end) as PX4_out, sum(case when instruction:accounts[8] IN ('CrFYXsVFr6witxBR21DdtifHS5sfzwmwqFcXPhBXftRr', '75bF9D2PRuncAEZFp2SjHuYTSNAwLggddeM7ghz348zb', '6gHEL57L5HNAqswqH9yRqteSGG9x3mwau6hozSnoyQju', 'AYT3i3A8Xxm7HJqXCd4jCWWQNXPUK9fuPjyfBqnp9FgB') then value:parsed:info:amount ELSE 0 end) as OPALJJ_out, sum(case when instruction:accounts[8] IN ('5egr6rWmL4Lwap5V18EQkXAr4whJnYEhUzF9GX1uMZBi', '9P9eYSBrxchK6TW2WtRRpj3dxoHGiAbWtP8ST99SVXG5', '7zY8BDTitYCnGnPyk9miwrTnniTWuPwxsUGrwNgNsaUG', '6JQc6ke4ujTufiv9R775NKKHeqYLAGiHmMwRCDJHi1zF') then value:parsed:info:amount ELSE 0 end) as FBLBPL_out, sum(case when instruction:accounts[8] IN ('HA3oFqXLBSh8JsxswRC6hwfoHLs3cre64rsB2X3dM1EV', '9gZSvca5erz2P9t9XngThfsAp5UL3ibsvLgq678n2m3n', 'DJVQTvDsZjsrWZZXEHJG6SvLN7p98n3eNm9z7egvodqf', 'BdpG52ijY4PWSLovnYEcmT33r6WWW8X996vaYx8izFgk') then value:parsed:info:amount ELSE 0 end) as CALG_out, sum(case when instruction:accounts[8] IN ('F8iGnycgWtSfWPXeAYfNLKmFLrFayGnoByZ6gwtbSEV', '64VyMPac1sDzBUayjqggFsT8N74HcKLDkYjVwxXnD5jK', '6U2LSzLQDZDvxRXDhXFktoFJ7qKV5n1d5qi4M2ujeysT', '4XeT8A55RRLxubfcDeNC97WrRbBvuSmkUCjCMF2ZSR6q') then value:parsed:info:amount ELSE 0 end) as PF4_out, sum(case when instruction:accounts[8] IN ('Ha93CftoBiVhaiqDWAuh5AfDLjk3QbkC1twzdJeCd4Wt', '5cacXtgHTbgp2uSUnNGaWAwyE4yKWqYjR4EXfutYExPR', 'fknnLCQSjSCAZQ5WVEAri7jTy3TgVgVbcSiXboMavRu', 'FaYPPt39mtnZqoyzo7KGYMNQAF78gWBRXPJ8KSgTdc1s') then value:parsed:info:amount ELSE 0 end) as FBLEGR_out, sum(case when instruction:accounts[8] IN ('AW6VceBYuWVfewBgqM94HZ6tA971an8Fpp6wqBYswzij', '2afGL24tNkJVeqrDDEo3gpHS2sSpXRcLfvT24Phrms4Z', 'BiqPvH3JkNaVutB3RqxPfP1Jvop2MUuai4HvEkaBdxsj', '95BuMZfGuiSEzvexZrXhSLMjLA7k1MTKpNpMWW7zirwX') then value:parsed:info:amount ELSE 0 end) as OM_out, sum(case when instruction:accounts[8] IN ('HJSkbTrKYmrmL89HKWkRy3XeGu4ajs4QivfF1h49qDHe', '9f6RirXWCB6qwXyjv1gGizUMQ3LY5ooQGPwrnCW2oh2u', '8AHQFx1tms8Yq96viVupsLbx5Fq25uvRLzpwG3QC25dv', '79yFYsL811c6VwbbcQuRgMxgHtWcH85HBUBkdDb51X5d') then value:parsed:info:amount ELSE 0 end) as PR8_out, sum(case when instruction:accounts[8] IN ('2jkpNadkAQmqVZS3xxNzJgny3Fko5WerRf3KqxWkNxSB', '32qaabmuw74hvTZadeXjMumYD99AMrpNqyPuKn3HVe8J', '9ygAgXqvnSqLyX9GzHcaDuKL26cbnEAmZEthbD6FgFtF', '9av3JMHqcF2vr91AQ85bHHv5cmwcZAjna3ZV9mU4G8wc') then value:parsed:info:amount ELSE 0 end) as VZUSAM_out, sum(case when instruction:accounts[8] IN ('CnayPwJZTLSbuxHmt1id9iJWzUJDd2tDVtQdAccC8afL', '8AC8wukkW7muCbEWLxWs3FSJE9WyMudfGGbj6RW7mYar', '8sXv8iDr87Lz8iaRocLzPrKE256gAk2d5UpAmzDLfBCz', 'ASNRGuyNkozXy2tAF66F2tnPqqnTkVJzEFVw4ZeviG7P') then value:parsed:info:amount ELSE 0 end) as PC9_out, sum(case when instruction:accounts[8] IN ('9V52st9wdob3ey9QvX59cS3zv7MxARLZ3hHTqedBumfa', 'vwozwkJNsjMLTeVUs1iRxeUVJbWaWrW2eKESUHRZ7LB', '7bE5zg1DrixWjfuypikJygoE768zGrDre1w3yq5Tkj7F', '5REcrxQL5MbQyiaMx3mC1mVFjUSK3kmBrvzey9i7Azcc') then value:parsed:info:amount ELSE 0 end) as PC11_out, sum(case when instruction:accounts[8] IN ('DthP7zqzf97mAcsDRVJ6xfkGxWoxKcFCCRf9xNucUh2B', 'EXjCsJy9KSsug3DnpLmALuWKujidjNHSnHrd8RJUX3ub', '95sNiGDCfaxc7rECxdExLkQmJrtkHXpPMrxy9hmYhHBW', '55fAt5M8KdKf7gHVMfQ52ueFfFTiVGW8A9UgJcETgMCo') then value:parsed:info:amount ELSE 0 end) as CHI_out, sum(case when instruction:accounts[8] IN ('6iCR5C8S9VxZXbioAjAeabUq2XkKWi2U9Zb9vmbWeuzG', '2ytUYaB5SRXys6sWTLrLGp7qWDtprXL8ezqjzp7SAbLS', 'DpbCSTcqypiLWpKRMZnNHsZVj7s3y8kM82p7aBfsJFKr', 'HGLYFJZqcA45PR2sCvctzPPTY5DQzzioDE4y4qNN24GG') then value:parsed:info:amount ELSE 0 end) as OGKAJA_out, sum(case when instruction:accounts[8] IN ('8Qi5zpQfff9FeDSFkb9XfiuF6gq2dwDxLBRGx3EdSaEW', 'BumzJhBXSnFkgPfhz25GEP4FkcLVLTRUpLtfrjhULJFk', '54p1Uh4USSxPiwuo4i3bghTjZJZneYtHhaS6tMRc9vX1', 'Dm8MvmfarBWumoJY9gE9V6uuewV5g4BKevPWX18hmZn1') then value:parsed:info:amount ELSE 0 end) as CALEV_out, sum(case when instruction:accounts[8] IN ('54TDYdVgtq2b4tBwoHdoo17uYFJUJckCrRGqKxyFkj7g', '7wuBJfProCr3bNUXPjRY96Kpzur85nb987Sa5V2x7KNB', 'DD6j2HT31ciq8hkfYgLJZ8sJ31zQP1aBsp3k1MdiC4z9', 'BD1kBHCchsmSzsQ53hum8AcptkaJphbBUqxNQT8Z4nar') then value:parsed:info:amount ELSE 0 end) as TUFAFE_out, sum(case when instruction:accounts[8] IN ('GnZ69gx49ddSwjQotvRvBpR4q3yJ5tM3PdYaffxPtBm2', 'DZKSM9zTDTd71yJroAmBaC8Hy5Fje6F6oDy7nGxJhdrS', '6VfrG3ry62tK3Vstm7rUmpmjj2ME4sLnTtMQWQCkQi3y', '9Xv3HfGv6A8R31kennLL5Ys2GuqDQavxXL9FNCBQHAbR') then value:parsed:info:amount ELSE 0 end) as FBLBEA_out, sum(case when instruction:accounts[8] IN ('9bP5YJLYJtzntr8ovW6L8ynBAi5J6QEt1rwCmcWcGyPm', 'Cd9j4F5i9WJFXaCxZpLRreV3gixwvaZdCNCauHz8vn3L', '9ZptmxoQ1NSn1nX563JJREZUhAD2XJiiTB8NT78qdShN', '9p2CyjbpZdpUKUnxKW2S5PehHtHcjmdb6W99R28VYRyY') then value:parsed:info:amount ELSE 0 end) as PX6_out, sum(case when instruction:accounts[8] IN ('2fxfiHW2m7gZ19h2PaApSwkTbV18sEvPq54qhyawP8Pi', '5xVBszKPwfJ6wWsCjxQNRhDpVhAR3cEC32HtLz4GZsz4', 'D4PAVuy9JMEw4d6eo8WRqt8TVQFHGCiWhsXhkiSruZyK', '33xq6jQGPTUCtcn5bc7GPRqdCMC5pLR8vdBs4xhLB3x3') then value:parsed:info:amount ELSE 0 end) as FBLEBO_out, sum(case when instruction:accounts[8] IN ('CRk4X9f6CURLVAwHsgTHasBjGK917meeaMPubVpkhMA9', 'HEPNiu3h5WN6U4xZuYZWySV85iwS6RSK4hsZohPGs3Pv', '6tvT4oW85Fi6HyaXrNtzYp9EtFLyPETuKQWdRfFFDsgG', '7HShvz72Rct4Jg1oYpfCTGK9HGWzcXJgfbgLpt4bCdS1') then value:parsed:info:amount ELSE 0 end) as FBLETR_out, sum(case when instruction:accounts[8] IN ('4J94Fm5xwFBbt8hj33FhA27T1FsUgUGNi7Qq7BXMZNpT', '481zPGcmwAimVrFSCqJFbAEUQFLsPAynk3JyV6TvYawZ', '4BjUbBuo4FQm7Yr4jb75MxTkkRDmwxgqQ7xyL5Q2bBq9', 'ABH4s13LqbDBrPJPCDUJaSVJFSbDDBYfJzw89M1KCQLe') then value:parsed:info:amount ELSE 0 end) as FBLAIR_out, sum(case when instruction:accounts[8] IN ('5xAZAHJQHWVpXMk3N1Sx1DqqVGLtuHdBjDDNG5TeCxno', 'DM6pH1xtRRcEWiq2MGPRhh39H5qxoQttzX2WeRvrajFS', '96dgvxnjGRuTVXF64xNDabgpHUHYTKF1fTokGR8buwht', '7bvdYt3LeV88GLkwfX73J9E6CuqvHXN9YJPejRXSVLLW') then value:parsed:info:amount ELSE 0 end) as OGKAMK_out, sum(case when instruction:accounts[8] IN ('Fxz49GMh2f6wHbaQbDpfRNz6sfMbq8XbS6YAbidV62qC', 'GKCqT5tq2YD7XMMbd51ApQT1xxy3xV2pQ8buYR7po8vd', '4ybcv8FjVvw8urT5KKfBnBwJKjrWx5DnKZ4gDEb4KCW2', 'Gx51StJ2tgqSEDK56243dZCoEawHF2p5Ykmw2Qs5xSDX') then value:parsed:info:amount ELSE 0 end) as FBLEUN_out, sum(case when instruction:accounts[8] IN ('5bTtEaWn42TkZStyf8B733aNUucSJdCvcSMtFpWtuHdR', 'HW29dyU3CyKNPWc5mAyooRiYsmBLnoZLycVE9ve3ASSH', 'GxzSpXVqUwZiZ2epfCVaMCkVZcjPL62gZdAFftcoEpcP', 'Azx28rV6tVSCodkbWbcyuddB1azA3N3zf5o9EYTG36UU') then value:parsed:info:amount ELSE 0 end) as ARC_out, sum(case when instruction:accounts[8] IN ('4vaQucwJsCf1eZKncpSgvqaMSznqXvqxUXrrGNka8EeK', '3UMp2MEakphLGtWmpGjzdcDLM5Yrht1chAtQJD4VUikp', '69JP1ZkbQveWeed8snWg3eJTo5BFZXyTS3F1aNdCxF4x', 'F6JBrBAgBxAF2XfiZ2XCWNr2aez9qR1jepBNJhdA3f1G') then value:parsed:info:amount ELSE 0 end) as FBLLOW_out, sum(case when instruction:accounts[8] IN ('9naezTVoJzKHU6cCtm9o2PZQgcLaRp1VKUCFywJ6BB98', 'Ds3zjkhTLX9T9SRaWWPhcGd7kJZ8e1kNZBzZqW6DtjU8', 'FNqUeukeMb2aDtSFuGNq7vRtnfN4ugsS2cFMVfyKjKJF', 'GKEUXMY1WQgem6yy3YmsUmgyFRcHiL4UQ21AjCZZ3Gne') then value:parsed:info:amount ELSE 0 end) as THRILL_out, sum(case when instruction:accounts[8] IN ('AWYrWer9tXeQHLBcubvRAobUkGnqu92xMQ23rcZDyb7S', '2HMJfou9NVSg3Tiu8txNQytg3EAXu1XAYDpPGmwvMkZ9', 'ENnjXSo3Zs3tsgeybKv7rzaRok8q1thjC2sja5t2fd8u', '3c9poKM6Gv2J5TrW11kd8cPQEXYVUjQ7xnjyNPxah3or') then value:parsed:info:amount ELSE 0 end) as VZUSBA_out, sum(case when instruction:accounts[8] IN ('HG4TPVTBxicorkpbRMwcshhJiBRd3DAyBWS75zjdEyhc', '2mJmuXFQ82Ur5udzV89KkC8dfSRpwy3TEMisP6p59qkG', '53FRSKCas2NFBqriRdUMcdDNWV9Uz5VBPqsULzhZhN1K', 'GwJufyFNdjLVdL4ihTWi5n2hKkjKhTcfFfXCgPtJFamj') then value:parsed:info:amount ELSE 0 end) as CALMED_out, sum(case when instruction:accounts[8] IN ('BiC6pXszsk3FXsYVu6CkXpzKbZKGbsoaarqmiFvuX8G1', 'GoEDxKAtshk6HBYJKH1nBXzhfQhjy7zbgpT1GuSEGAhK', 'FfwUP2EgXNEi1BM2crz4qHmUiDqZo11ZtLK4k8XTz3nr', 'BmLcQ6HDF7Y68iqTSeRzxwGuRqemtCr55w9YSXTk3eMT') then value:parsed:info:amount ELSE 0 end) as OPALBB_out, sum(case when instruction:accounts[8] IN ('Hc8aaPfq5dX5SgHvRUm6WzpLZfKmKBTSBSGmeQSceTgF', '8Vjm42qD2XLRyCeLkfaRMSV8ZARMk8XU7n5QP7K6ryNb', '2meFiRGyNf7D8d5GVpMkPSb9ZLk4pn4BVQHeQjHohX4U', 'Ekgd41LEoDmG7Pb99idQxTV3pWdFjabxxxg2Gdt4xbgY') then value:parsed:info:amount ELSE 0 end) as CALATS_out, sum(case when instruction:accounts[8] IN ('EpE8bSBjXxaz9qDLGsraoLt7ZParCZmpHiVTuTgJ7RGH', '8LMzsiGLAL4xJHoWGbZrD9o1heUAjbwHgJ1P3ArFBQbu', 'CZb4ZMoUJMvvGTfG37T3UjoDsJrVAMR6DKpvKPo9ZY5g', '39X27PexwT46hwz7FrDE2qywzyH2cPeFECxiwCgEZbW3') then value:parsed:info:amount ELSE 0 end) as PR6_out, sum(case when instruction:accounts[8] IN ('FVDUszyERm5koTVnLuegVt6NmSyespJLWWCf7JnRNu9Q', 'AgyXPBb4ScDW8mFqkSwsrtenyzNtd8P8poKazXfPKAph', '7CsMzsqDVEBcqY4sTsFyima7qtvyuHSybidy8GQgHcnx', 'H8HipQiux2xyTathhU2ow3i5ZR79jqokbr3L1zBbLdrX') then value:parsed:info:amount ELSE 0 end) as HEART_out, sum(case when instruction:accounts[8] IN ('2DWADKpPdn1cPzSWNkbYDPTod7CcmrND1qg8UByrxRZX', '4jQ3ZEfBv9TcsRcZALruTH4XQJRVtaDe5RrFL74hKVjK', '5NCRSzoj93mfbewwGJrGMyneZCyMLe5tctDBUJ5hwGkP', 'H8MT3cQh32wKJyqTiGXKF8XnGzndZG75TXnfrjvdvfu7') then value:parsed:info:amount ELSE 0 end) as OGKATU_out, sum(case when instruction:accounts[8] IN ('AdHKZykUeMq5DaGr6XhAz7paCjiKrjiuE71P47A2F7XS', 'BLy7xx74mnygp8u1eX1qTyHChQAjj8AUpaZpH2st5TpJ', 'H2swdthjddQmti4MLZ9VsdGgyfSfZCqTe9oXgp3u7Z3M', 'Bc8NWWYxtLWFCTHHdnWcBuTreiDMZCY6HuiKiqSofrLD') then value:parsed:info:amount ELSE 0 end) as FBLMAM_out, sum(case when instruction:accounts[8] IN ('HJidhRXfWfm86ciZbyThMJ67sKL9piQgbJk5UpdSd9t4', '2p57ETgYXxycQmyYvfxYk3BHLoUcitBXyt1yNiV7xswd', 'FN8GVkKaEbn11trT2sUi1GfCAz2w9YoXQTokren9ubM6', 'CmJVzGjVZL61iZsy8k9RnNu46cK8TD5Neh7XiVGe29yZ') then value:parsed:info:amount ELSE 0 end) as VZUSSO_out, sum(case when instruction:accounts[8] IN ('J3Jri3uPhXWt8sa8LWBTkNaAbY7wArBq2Gn4R81fGG6f', '6W5WCyKqAs7yGdnwhEuSfySguFYqLK6wvWDJ1jwQrkVc', '89zCTnAe7ubvt2SG4qgaQLQmR8dtBTYiiLpRKDDjC6qd', '46DmGY6e6xgmGoD9crVAruHphQUUGxLqZv2zFEic531e') then value:parsed:info:amount ELSE 0 end) as FBLBTA_out, sum(case when instruction:accounts[8] IN ('CcrgdGfpe2fZrRc28WbGbE7bV1JLpF2b55wAREnN9UTL', 'F5m38CFFmdJBhedVeK25CQ2NohFyheuy8KkCbpjv6Quq', '4fytMaWSpxDxyL98UmXoufXWsizYNFkGLDLFCZ1PWRtX', 'CNnqYsbnxW6yZv3vmVhszv1FALAatyTfZegCiH1baYe') then value:parsed:info:amount ELSE 0 end) as OGKASP_out, sum(case when instruction:accounts[8] IN ('9qGugLVTXSZpTyAfBvPuJUxqngsBhhE2C72XmzHQMfv8', 'HND3ivP5n4hRKcF4TJQPxEBKm45MC1qcvzvZUXRX7FTm', 'TWa4Sf3zhWhN2zNf2M61WvbtpdsGA3H2kktEBNdkpNu', 'GA2Ad4xrb4QP9sUhrkpVEEyB34Wzf5MNBXwKQg5WVZgA') then value:parsed:info:amount ELSE 0 end) as PD9_out, sum(case when instruction:accounts[8] IN ('6DUuNmUFyaKqNRNEww8iT7xdbgFtHxaChxzGUmhNKffH', 'Gzss5T8snHFDuHTEYrHcvvzDuMzdz5VTZCwWZ9jdMFG6', '7Sb23t6EEecii2sSz4VDscvgFT4LkXNWYMyCbazkZoCP', 'CPzUv2ftc5K1SF3AYVDrt8CExdt8z2TVAcUd7eo4MPQJ') then value:parsed:info:amount ELSE 0 end) as STAND_out, sum(case when instruction:accounts[8] IN ('5xsT8KvYdmjSdByC7WkS7mkBqLr4vqMABZPaZXMbtLWb', 'CpQRfvwUhzPzRYF2xvfok7EoX8ck4mPQwSQpb8MNvwa8', 'Ahv2QBPVhHy4612KEhEmxHt56vAHwV6gHyKumJw4z1Yk', '9EeGpXY5qUG6Yho8giBf4WhzyX4R2cZ7B7xVq5GSCqsM') then value:parsed:info:amount ELSE 0 end) as SUPER_out, sum(case when instruction:accounts[8] IN ('Bp2ZDiediKaAnYYvPovXCnsCEnqv2ZAivHVXfsGFwh5g', 'cCeshLbHjxdeF8zCb6id9zBBy3ZVARsnqAGBHGbPZFA', 'Hc2saJjAuUNmQWvQ6VJzFWywyW5cQaGzGTq9HtjEU2kq', 'DhUcDdgdJPaY9sdprC1GixvVMYCHSxsQsecqL8dH5j7s') then value:parsed:info:amount ELSE 0 end) as T1TAN_out, sum(case when instruction:accounts[8] IN ('6Vm9BAcC55SkzaT1Z2zu87A8UivA9LGhhfoAMNyy9C5x', 'A4V7cgLshhx98JaNjYyrER7o9wBQ9WEaCaAN79veUKxy', '6eXJX8B5KX6p5xhsRT2jYM8Z9aSxv4RFChK3vpKcE1Be', 'HcNSqnR16RGBKeNm32Nbr3LyeEBfiDosMUSMtbaF9xpo') then value:parsed:info:amount ELSE 0 end) as CALSCD_out, sum(case when instruction:accounts[8] IN ('6UJgUGEVaSJ26mBxWLsk4YbX3jnUSreF8NqEFBy7pyrJ', '8RYDHoMuQYR4QP5Egp8yJNQTfEk9PEFr4euTUnWdYhWZ', 'm7B6bnQBJfhZrph9qbe5QAfTN8QjPeUsaUYLxHAYAuD', '8BiKMH9wiLCwKRRpL1cRNbjSqeESqLD44KUxyCtDLsb7') then value:parsed:info:amount ELSE 0 end) as CALMAX_out, sum(case when instruction:accounts[8] IN ('CjVhrqyHT5RcVLJJDhvr9GaC5bsvjiGQ1BCRTzkx5Lbi', '9fCE1rnwVUNLLwMTqyCMZFBjxyXXQnfMvT3ZB1RD3JP5', '51TDmJzqa7PMbXkwuWYpqCeL3Dje4YN4bcrVwvmZ76WF', 'FFzH8WYnZ8fY1kuev7EU46ThXwzT6P7M3sSCuaJWRRvv') then value:parsed:info:amount ELSE 0 end) as OGKANR_out, sum(case when instruction:accounts[8] IN ('EJnH2PDKqHShN5YN9pj2iuCufqxpAQ1i5rWHn1AnYgLb', 'E5b94UNMfqDbkzk1GFwmTbRCbG8cUUY8NgRMyWM3Bnen', 'BkKwywija7sW9tYvcT3MmZcZs9imymoFLk9MofBF7uVU', '7pZso3pbbZ786BPcvzJJa7PyzaZL7r6u35sW79BtWNbm') then value:parsed:info:amount ELSE 0 end) as IMP1_out, sum(case when instruction:accounts[8] IN ('46pnnTWn8JyEVVLS7TXg5cUXiYdaEw9Pb3qEVQTdYJTG', '5x3JztnXF6jPKRVjrZHeTnVN5mDJQXimG6JDfTT4AdGC', '5YcnLXgCZ1K227e9kd2hVhqX1NtvpvhxFCNTdHsWDEhf', '3iVucNFkrYTTPUZ5FDUpjXZDUyTKAUFiHbbQczEu76Ed') then value:parsed:info:amount ELSE 0 end) as IMP2_out, sum(case when instruction:accounts[8] IN ('GwmpLgN8TrpTRoqkwBQaZ9ab3EiiAS2xj7rsbxqhdN1x', 'nTgbBGHaY2hsoqhA9jQt3NPAAeRUoiqj6dCdazUtRxw', '5nNgLsuLPQbrBrsNT2ohkCm6gEukoCgrzvGCvNaLCcBd', 'nLEAQJcys5TQWdcyKDJiBQaNzuuCnMHnYjj6ZEyQGQg') then value:parsed:info:amount ELSE 0 end) as IMP3_out, sum(case when instruction:accounts[8] IN ('AWQ1wsCmH5Exx7ERPJApT4CFHfZeHyaaUun7jtNWQZ29', '5ofAbiN1uM1cHCkwXtw223yxqWNMVWB139txk2JKcrBd', '143e4xYb255yULC8Ripgo3CYFFZKttwiaRYBR2bhY2fW', 'GcQuTQmVQUjmzNonjUKLBjXazuMmB1W2E9HzmDzcWgv3') then value:parsed:info:amount ELSE 0 end) as FBLMEX_out, sum(case when instruction:accounts[8] IN ('DbTZJcnYzFUTnXH5ZzgQ9HZauJK6iS4jtZFxzs9FwYZk', 'G7Bt1fixiw8hCJ7yD7ehofToZS5RdACqofZVdyqwkjw7', 'BS7pqvdqk2aXSnBXfs1qA6Tz2MFoAbrPQbHTQETCEVi9', '3x2aX2RGZmw64rBj4Xkjdey1hhwcNhoRyfHxENrKSS1G') then value:parsed:info:amount ELSE 0 end) as FBLBBU_out, sum(case when instruction:accounts[8] IN ('GMmxLD1WL7GEhvW9ecTFuR9EjVLapTVjdNRzWoR3UrYd', 'EkQ6yigxiGQzgfxFnzCX5uUbpxfJqRf6N9xQjnuD89uy') then value:parsed:info:amount ELSE 0 end) as OPALRF_out, sum(case when instruction:accounts[8] IN ('DMphYjcgH5X4pmQneDgrHUg5gaSryKSNYPcXr4DmCdjm') then value:parsed:info:amount ELSE 0 end) as FBLSLE_out, sum(case when instruction:accounts[8] IN ('G7zUEmxy1ADcLwnK3duBYPkXZjh5x7A52owA2kmuoN9f') then value:parsed:info:amount ELSE 0 end) as OGKARU_out, sum(case when instruction:accounts[8] IN ('FnZUgT1A86UFuZfrEsDARZE3Hgf9emMJH1WgjiSh5oFd') then value:parsed:info:amount ELSE 0 end) as PHI_out, sum(case when instruction:accounts[8] IN ('') then value:parsed:info:amount ELSE 0 end) as CALSHIP_out from solana.core.fact_events s ,lateral flatten(input => inner_instruction:instructions) WHERE program_id = 'SAGEqqFewepDHH6hMDcmWy7yjHPpyKLDnRXKb3Ki8e6' AND succeeded = 'true' AND block_timestamp > '2023-09-22' AND block_timestamp < current_date group by 1 ), -- ON dac_reg.wallet = s.signers[0] OR dac_reg.wallet = s.signers[1], sb_in AS ( SELECT Case when signers[0] = 'FEEPAYye6DtaJhSXFR65ENXMroiseL1jqYT4QxHKRoZr' then signers[1] else signers[0] end as wallet, ----------------------------------------------------------------------------------------------------- sum(case when instruction:accounts[3] IN ('FKK3HYskEgGjkY8psiJDpmMdqqWy28tteZ3UFq6AFiq8', 'ACZ6HXoEkjFE29gD3VvsXh1RNshN8ZCdrhrwcGAZXtxz') then value:parsed:info:amount ELSE 0 end) as OPALJ_in, sum(case when instruction:accounts[3] IN ('3yFBUPCLZFUi5yndH1BvHUJYfnzKxztexho4oMvtNnrL', '7RvFfCzNiYCppJuvwq9WB4qowAReeo5NSx2GAqa5yYey') then value:parsed:info:amount ELSE 0 end) as PX5_in, sum(case when instruction:accounts[3] IN ('4onqoVdr6YsHHKxoDEzKjMs6cM6iw8mxSq68gDkxuHPP', '6FxoF49ZgkMU3nn668G1Wh1MDZ5jEh3cRnfXcohpqsLu') then value:parsed:info:amount ELSE 0 end) as VZUSOP_in, sum(case when instruction:accounts[3] IN ('77s8XdW6zNZmdDtNuVjy2DT5bjB7KffRtPLyjKXBooiD', 'FQp5t6wUyaVJEdChpcMRDiPmYtTzybw5Nz8CdM3y1CSU') then value:parsed:info:amount ELSE 0 end) as CALCH_in, sum(case when instruction:accounts[3] IN ('8RLk2uxENe7TCpdsLrb7ezmc9zR7eipgmNaPDP5a2UL7', 'zJ9tt3PNsn2uz8sHUPk4TGAnAAbbEsCwyxo6gzCUttt') then value:parsed:info:amount ELSE 0 end) as OGKATP_in, sum(case when instruction:accounts[3] IN ('F6uyNBB93ELQUJAqrgAbC5ro3ng5ms5b8egxNZ25T6Sz', 'C2TNgSpv1k2g35wUV6ZaUiXkyKATF4fLFFbGCuutzyz2') then value:parsed:info:amount ELSE 0 end) as PX4_in, sum(case when instruction:accounts[3] IN ('8Rm9WbUMJWx7RaRpoyQVSPV5zMKTpDesR7nMbpZwF4Zo', '4d6F3cGir7t7vKZqCojKzLy9JuHwM53jC2MWcebaSfL5') then value:parsed:info:amount ELSE 0 end) as OPALJJ_in, sum(case when instruction:accounts[3] IN ('3AGhSz9HkLFtq8DgEriso3st5yDExgA3hGLaXLCMfYmo', 'qCPVfiXJZdJEgK4eQPezMDyvMRQ5hvbcsb4VKk8ov5N') then value:parsed:info:amount ELSE 0 end) as FBLBPL_in, sum(case when instruction:accounts[3] IN ('pjB5kESCJq1VenTdtuDkh8zgCKRKQqw4rnhxpW2z6Mu', '9otdnvnenktP3rgs87j92GGEMJaWEy3HpaLpPMSEp1Xk') then value:parsed:info:amount ELSE 0 end) as CALG_in, sum(case when instruction:accounts[3] IN ('DxgAykP664BwPSyJ6xG5bQG5i3xen1qyzpz7bPL4cUEq', 'HE3vdsUR74xhF2PQsYCWNRSCDvY2ReaaSVgVafgJwNny') then value:parsed:info:amount ELSE 0 end) as PF4_in, sum(case when instruction:accounts[3] IN ('AjAn7tRFgW4TKZKdBL3v7HvMytQdoHxcwGecnjuq7bZb', 'EPzAXZkno5RdaSVtwuPoGCaKBHr52JZgR14Vrpv29qqW') then value:parsed:info:amount ELSE 0 end) as FBLEGR_in, sum(case when instruction:accounts[3] IN ('HSsMBukTSBxESvd9odf5eXoC4g7L6b7jkwMHP8oowrFr', '6h3182YH3KhVfX6r57MbUm1Jmm8z1Kc3jHXviRG3bLzH') then value:parsed:info:amount ELSE 0 end) as OM_in, sum(case when instruction:accounts[3] IN ('FNsGhAQA8wbknyRPpma3W9SFB6MV9GAPxPqSKU4XLTpL', '3DVtYxwveebsLsKrurRuF9EWwx78JzAPD923CeUZtpJb') then value:parsed:info:amount ELSE 0 end) as PR8_in, sum(case when instruction:accounts[3] IN ('D2m4rpPKKNRtogJ4nNt3QhiT45GCVN1yenknVwaduywi', 'LMsa5kntz3HRqfV3seragyys5oQj1k5S1sNhvmxRsoM') then value:parsed:info:amount ELSE 0 end) as VZUSAM_in, sum(case when instruction:accounts[3] IN ('EpyFrbArVSc4rLmcWbeYyq4i73vzpV5dirjVmxwdDf58', '5cTYGD6GsfKqUZvV2NYCUbN1QjmfxUXnjhE3P5L6ZJ4w') then value:parsed:info:amount ELSE 0 end) as PC9_in, sum(case when instruction:accounts[3] IN ('AX5Q2byXdf6APtvRzkTGf3iSvT7UXzWkexUBJgGMTEQc', 'FDMzLuxKW5fMkgSwz8EEj7VpX6R9aLHFwySEHB1uNtxk') then value:parsed:info:amount ELSE 0 end) as PC11_in, sum(case when instruction:accounts[3] IN ('GsKzNomuH6VRpP8bGgAma2UWeEZhom3WvdupZSPTB7EE', '92ZHZMvEKgzfRx8XVbR9zkzw9pcUSzJuudMjRovGkmLF') then value:parsed:info:amount ELSE 0 end) as CHI_in, sum(case when instruction:accounts[3] IN ('AZP4tSm5hocgv1NFcfKW2CveTrWK3kUFwjSSaNiou838', '5fxoHDbi9YxBiqEYvos9Xi32mUUPpHnJdX3emJcBkmZQ') then value:parsed:info:amount ELSE 0 end) as OGKAJA_in, sum(case when instruction:accounts[3] IN ('DaasSWQpw9TtNEssDfTdZFNZkEvMNFi7poYgydW6im4W', 'DAvxCPqyDywdLXiEPXT9riTaZ1Lds6TeuVBJgCH3F4fF') then value:parsed:info:amount ELSE 0 end) as CALEV_in, sum(case when instruction:accounts[3] IN ('BAin7fE4YKZG9FRK4deHit56iKdshqsNKqZmv7fLVBvw', '7DSLoedynSJYR4StC2vzqAc24TH9NSgGu4nzvu1GApEp') then value:parsed:info:amount ELSE 0 end) as TUFAFE_in, sum(case when instruction:accounts[3] IN ('7mXrU4enKTgFajhFycG85RZBDtgsHBxvKy3NAu356d7c', '35rK8ogKhkst94dYmBW5VSzPKQU5B1Vm9aiYVG9e8Exz') then value:parsed:info:amount ELSE 0 end) as FBLBEA_in, sum(case when instruction:accounts[3] IN ('cZ8A15hf2U69YGM8NtcSZN1y3hbvkPYQoEAhcuAXbxB', '4mpvBDevhrCg1JMpSHZ7RB1gMNEpFLNFG4h5pBYztfUK') then value:parsed:info:amount ELSE 0 end) as PX6_in, sum(case when instruction:accounts[3] IN ('2yJ8PZmUhbLcX49pncgqJXWMcEQ3ZYxFsGTt49Xy6i57', 'HkemS9qcuxtH1QSo7VZ4VBShgqwXJCUPfzY6gCHyJH6q') then value:parsed:info:amount ELSE 0 end) as FBLEBO_in, sum(case when instruction:accounts[3] IN ('8hGoQrxQLhvaczY6DiasQG6TspKw9E3zXQ14KAwtXgZj', 'CmRafW8hhMGAytUcU7QgGLcZDsP3YmVnaSTSsTywQ7jz') then value:parsed:info:amount ELSE 0 end) as FBLETR_in, sum(case when instruction:accounts[3] IN ('4kugk4roXBDDjqcvJFoji1hBmCWhDkovqCstU2fKXFEw', '8ga4FdC1uQQjYoDMTbNUwmNVmNyrKnDWCYZCbx9cLJEs') then value:parsed:info:amount ELSE 0 end) as FBLAIR_in, sum(case when instruction:accounts[3] IN ('AL3LULe6my2TRNptS1PhQFq3G7hvQsYUuqm6kBgvcT7z', 'Ekg9cnCp19rtjfm318ErRHS3FQyuuk9xKeTVGSbK52TB') then value:parsed:info:amount ELSE 0 end) as OGKAMK_in, sum(case when instruction:accounts[3] IN ('Gcurud4rgbh82oyuqrEqywEA6dECg7VnvLS6MJfYQGtS', 'GAqySWLhkokwWCcSiePEruVzmjrthudM9PeY5NZ6CnVv') then value:parsed:info:amount ELSE 0 end) as FBLEUN_in, sum(case when instruction:accounts[3] IN ('5TMSoVeH23REeARahfBGwCqpmCwwiJWwnYDPGTBxZNWn', 'GJbiXfjQoziuTgkwWAkaGVeJRhGBhPBZdA5c7jXjVXTb') then value:parsed:info:amount ELSE 0 end) as ARC_in, sum(case when instruction:accounts[3] IN ('D8h7joa1hBsHGpDQUmdasfNkyju56cYM6JsjzCGZVp6N', 'ADmJiwDzA21AyK2ReuGsNbERwdjNCbYVYHbAcmEJr5WV') then value:parsed:info:amount ELSE 0 end) as FBLLOW_in, sum(case when instruction:accounts[3] IN ('F5rhD6dD2iPdgEXg5fUCzDCcsrmZgEvQGEGMNewFpZVK', 'BpMLGQBi5sFv3AxJjHNxrhtrfaoWuYkmABVvbwunGf7n') then value:parsed:info:amount ELSE 0 end) as THRILL_in, sum(case when instruction:accounts[3] IN ('Cu5qZbr8YRDwPAiUxy1zy5Re7E16BqbP4HRrttLX2Xrt', '7p36nvhahnYkYEx3WHzT4r7w9E5zg3qyeyfVSDwZdfGY') then value:parsed:info:amount ELSE 0 end) as VZUSBA_in, sum(case when instruction:accounts[3] IN ('F1GdCKWbqsenbNmwYDqv9uFf2j5ZmC7CM8MfFnfs5xeu', '4FU3jxogvMHLgRhdNAkePF4CGgcAvzNH4joFP5XqRfs5') then value:parsed:info:amount ELSE 0 end) as CALMED_in, sum(case when instruction:accounts[3] IN ('VYeXPN2NuJqAiXETpQKQcc4Yf45jZ9zJeGpZLG5NizE', '6iWJGqZBnVAfZMhGsqUSaWUY2cK998Gs1LF6ks8cqXvd') then value:parsed:info:amount ELSE 0 end) as OPALBB_in, sum(case when instruction:accounts[3] IN ('FZJiBC8JAxM1PYU2G2aD3ZjAJXCb1eJoKUkBvLb1yuq3', '6mELFyNhLZ4X7TDAdLKNb7bvH8NE711qoeTEMoGdT5yA') then value:parsed:info:amount ELSE 0 end) as CALATS_in, sum(case when instruction:accounts[3] IN ('DwSHWUFEocJKfwvv6MdB35iNtVR62ayxAKkDAxdCayDQ', 'D8fpfnY7oqK6DdmrFB4T3weMYKs35RQqZiezJm8Fchxy') then value:parsed:info:amount ELSE 0 end) as PR6_in, sum(case when instruction:accounts[3] IN ('J7yb7vkeKQqZxzNDAQcTTRQ9RU9UvyFgQdNakSEymA4W', '44Ck1CTZrBACaRdw9j9qT575NsbJ7LpgrsX4kxGecdbd') then value:parsed:info:amount ELSE 0 end) as HEART_in, sum(case when instruction:accounts[3] IN ('6MWibB5vbjberyQdoiT4ghkponRLYFw3eGMCmUTAev7q', 'EnEsWSGQxmiegT6ZT1eStNv29BAvUydBBC1RLZcbYBSL') then value:parsed:info:amount ELSE 0 end) as OGKATU_in, sum(case when instruction:accounts[3] IN ('CRzosUaKosztiYLC46xv2xHKyxf6HkttAuZYQUUMCTR3', 'An6qNYmy89kz5KgekPBESNJZGohAy1YnE9eKyRw2N4Je') then value:parsed:info:amount ELSE 0 end) as FBLMAM_in, sum(case when instruction:accounts[3] IN ('AtTRG8JsmWgW8mmjrHEd13bSGk7sUsrPXLw1YuLxNFXk', 'DkGKUpCPixTUMvA1zTYWX5iq7Rb8gs9JtSuLTeBpHVCK') then value:parsed:info:amount ELSE 0 end) as VZUSSO_in, sum(case when instruction:accounts[3] IN ('2vCZ1JwAmPmALnozMazbsa8eFe3LmgNLpjB2JP7vM8JH', 'BwnzeTBjkarLcY2wwCGDB3Ukc16SEYUH4q8EGDsKbHn4') then value:parsed:info:amount ELSE 0 end) as FBLBTA_in, sum(case when instruction:accounts[3] IN ('4spbRSBxUyPcXTCd6UuZKU9i6td64dy3m7ZBF9HkM6s8', '6VuWCMdYXTWmpcQXZCbjb25nnonwNqcwiaBwHj5CMQdB') then value:parsed:info:amount ELSE 0 end) as OGKASP_in, sum(case when instruction:accounts[3] IN ('DAF73sFyYmU5FVbN6g6Pv1jNnuajd4j3KjCXfQPVkdDR', 'CRTRByUmS3AxsREL8zoGtA3XE2HTtF6HSEMEoSrg3Mw1') then value:parsed:info:amount ELSE 0 end) as PD9_in, sum(case when instruction:accounts[3] IN ('AnYKKt6FJkduJaeuqcA6HcUJV513D3kGgePtFbkvTf8z', '96k8aLvx5jyAUmKeVPjeUbT3p6q6MYfQqixwbkQ6PVJA') then value:parsed:info:amount ELSE 0 end) as STAND_in, sum(case when instruction:accounts[3] IN ('7VvnWHfMdRJgzkx3Dq1WABxNbNVUH22RTmi4kDumJg6s', 'HdSM9puUFMqYSoqJraFbDggmRrYa4qkaj6qYua2kjnTh') then value:parsed:info:amount ELSE 0 end) as SUPER_in, sum(case when instruction:accounts[3] IN ('79Vnjq26W4yoADGYijZGcrTVUR5CY39HmcxfEo8XhAiV', '6gD3R2TmpkHchmHJqe9h2hWvSMdQNAJTttLdYd92Cqr') then value:parsed:info:amount ELSE 0 end) as T1TAN_in, sum(case when instruction:accounts[3] IN ('5zM4hMpf3fRsxPaVWh3qfutGQUryKARmQpYcaxyKd7ai', 'GmRzVz3CF193X1q4jHdGaPwCZqXYYv2d9sopv2qLjwrx') then value:parsed:info:amount ELSE 0 end) as CALSCD_in, sum(case when instruction:accounts[3] IN ('GUPLfiYUd9ncMFo5ZJEXahEbW45AFuJ1bM7GtAEmLter', 'FGsDR65N7hgwcNJ9LdjFzeBy2gexBCqRzKEP7b6kjHTg') then value:parsed:info:amount ELSE 0 end) as CALMAX_in, sum(case when instruction:accounts[3] IN ('EosYsejYMjxBLcSiRT3kfXnaowARCCSBMXYBi5Vcw9gr', 'CJviPrzuCNecx8uTboyegQncjJwA9gPTjxBXyHCiqCfR') then value:parsed:info:amount ELSE 0 end) as OGKANR_in, sum(case when instruction:accounts[3] IN ('5KepAtd3pgkpuMdew2eLL19V6dcvubCgciobV57FYyFM', 'BWP7tM5S5KvQzz9u8iRbR5QVysK9JbSfagYs4Y3NfvD6') then value:parsed:info:amount ELSE 0 end) as IMP1_in, sum(case when instruction:accounts[3] IN ('8bVmKHUgbb2vo6rCQKKyAZUQwxTNQ7baMnJmQzkCoW62', 'FvKDF8k5u1y2awPqrkCiWdwS4NzNjvtwB72jZHYfeRKG') then value:parsed:info:amount ELSE 0 end) as IMP2_in, sum(case when instruction:accounts[3] IN ('GmynV3HXfeMu4qhjHpJPsCbucR4eRuyhCgq8oJpsgWdB', '4KxPc22D3owBVFJx2wKAvq5qFAmRpDSa53HXjGqjrELi') then value:parsed:info:amount ELSE 0 end) as IMP3_in, sum(case when instruction:accounts[3] IN ('BGL4UHYsM7YwfN5pLGMDtv29UVi4B2NiYjuycuADkB8H', '4ZYhfpzdWszBdeT68AmTopzFqEQus9BpYS2DzegunP5b') then value:parsed:info:amount ELSE 0 end) as FBLMEX_in, sum(case when instruction:accounts[3] IN ('9UKuxVa2tzTSRf93qmKTLVCMFLdY6i1t3bTCHNJeuJdt', '4rWALPyYQxXf3ow3HypiCmBivmyUFXr9Y7HhVg5fZsWX') then value:parsed:info:amount ELSE 0 end) as FBLBBU_in, sum(case when instruction:accounts[3] IN ('3FvJVMzq8gQbH74sdVpqCK4v9FojzAXvRDxcAPWssQ15', 'FJW9UTg5H64hXnFtDbmPs5PcoLGxAJv8ck5T3AUNfXND') then value:parsed:info:amount ELSE 0 end) as OPALRF_in, sum(case when instruction:accounts[3] IN ('DTgtFKaAEUGMLHso6SUpjWdUhxfaYAMomPEJUeg7EkcJ', 'E2VjjXhY97JVEkYczA6Zb85ixQ96NCp4db3Ux9mcunJn') then value:parsed:info:amount ELSE 0 end) as FBLSLE_in, sum(case when instruction:accounts[3] IN ('7YCgLj3H8xmXr787rqD61Nx2jRcXAX8fTW8Gbo6teacP', 'BLtCkSds4JZWVkYf5Tx6YftZNgF71my8FzQnvPuBu8mz') then value:parsed:info:amount ELSE 0 end) as OGKARU_in, sum(case when instruction:accounts[3] IN ('AW4pHtJzxHj1fr6Y1To27yN1R5ZfrB5oXcLGXTrkGKxR', 'FbgfUXa3jxeR7Aah8BFgECCa2Rez39kbaJv7g2F778mr') then value:parsed:info:amount ELSE 0 end) as PHI_in, sum(case when instruction:accounts[3] IN ('5nC3HbDTZeJnKsKo1gGjRHkaix3ZA778vMkz5UeWzQzD', '5nC3HbDTZeJnKsKo1gGjRHkaix3ZA778vMkz5UeWzQzD') then value:parsed:info:amount ELSE 0 end) as CALSHIP_in, sum(case when instruction:accounts[3] IN ('8KED2P84CWdVT5iLycK1BcXCCoHQV2pDAoZMpgx9Qpg1', 'GuhVdeVSkeGh77n6kJc146TqNxZ9PNRoXWCnq7LyXfpV') then value:parsed:info:amount ELSE 0 end) as FBLBRA_in, sum(case when instruction:accounts[8] IN ('FKK3HYskEgGjkY8psiJDpmMdqqWy28tteZ3UFq6AFiq8', 'ACZ6HXoEkjFE29gD3VvsXh1RNshN8ZCdrhrwcGAZXtxz') then value:parsed:info:amount ELSE 0 end) as OPALJ_out, sum(case when instruction:accounts[8] IN ('3yFBUPCLZFUi5yndH1BvHUJYfnzKxztexho4oMvtNnrL', '7RvFfCzNiYCppJuvwq9WB4qowAReeo5NSx2GAqa5yYey') then value:parsed:info:amount ELSE 0 end) as PX5_out, sum(case when instruction:accounts[8] IN ('4onqoVdr6YsHHKxoDEzKjMs6cM6iw8mxSq68gDkxuHPP', '6FxoF49ZgkMU3nn668G1Wh1MDZ5jEh3cRnfXcohpqsLu') then value:parsed:info:amount ELSE 0 end) as VZUSOP_out, sum(case when instruction:accounts[8] IN ('77s8XdW6zNZmdDtNuVjy2DT5bjB7KffRtPLyjKXBooiD', 'FQp5t6wUyaVJEdChpcMRDiPmYtTzybw5Nz8CdM3y1CSU') then value:parsed:info:amount ELSE 0 end) as CALCH_out, sum(case when instruction:accounts[8] IN ('8RLk2uxENe7TCpdsLrb7ezmc9zR7eipgmNaPDP5a2UL7', 'zJ9tt3PNsn2uz8sHUPk4TGAnAAbbEsCwyxo6gzCUttt') then value:parsed:info:amount ELSE 0 end) as OGKATP_out, sum(case when instruction:accounts[8] IN ('F6uyNBB93ELQUJAqrgAbC5ro3ng5ms5b8egxNZ25T6Sz', 'C2TNgSpv1k2g35wUV6ZaUiXkyKATF4fLFFbGCuutzyz2') then value:parsed:info:amount ELSE 0 end) as PX4_out, sum(case when instruction:accounts[8] IN ('8Rm9WbUMJWx7RaRpoyQVSPV5zMKTpDesR7nMbpZwF4Zo', '4d6F3cGir7t7vKZqCojKzLy9JuHwM53jC2MWcebaSfL5') then value:parsed:info:amount ELSE 0 end) as OPALJJ_out, sum(case when instruction:accounts[8] IN ('3AGhSz9HkLFtq8DgEriso3st5yDExgA3hGLaXLCMfYmo', 'qCPVfiXJZdJEgK4eQPezMDyvMRQ5hvbcsb4VKk8ov5N') then value:parsed:info:amount ELSE 0 end) as FBLBPL_out, sum(case when instruction:accounts[8] IN ('pjB5kESCJq1VenTdtuDkh8zgCKRKQqw4rnhxpW2z6Mu', '9otdnvnenktP3rgs87j92GGEMJaWEy3HpaLpPMSEp1Xk') then value:parsed:info:amount ELSE 0 end) as CALG_out, sum(case when instruction:accounts[8] IN ('DxgAykP664BwPSyJ6xG5bQG5i3xen1qyzpz7bPL4cUEq', 'HE3vdsUR74xhF2PQsYCWNRSCDvY2ReaaSVgVafgJwNny') then value:parsed:info:amount ELSE 0 end) as PF4_out, sum(case when instruction:accounts[8] IN ('AjAn7tRFgW4TKZKdBL3v7HvMytQdoHxcwGecnjuq7bZb', 'EPzAXZkno5RdaSVtwuPoGCaKBHr52JZgR14Vrpv29qqW') then value:parsed:info:amount ELSE 0 end) as FBLEGR_out, sum(case when instruction:accounts[8] IN ('HSsMBukTSBxESvd9odf5eXoC4g7L6b7jkwMHP8oowrFr', '6h3182YH3KhVfX6r57MbUm1Jmm8z1Kc3jHXviRG3bLzH') then value:parsed:info:amount ELSE 0 end) as OM_out, sum(case when instruction:accounts[8] IN ('FNsGhAQA8wbknyRPpma3W9SFB6MV9GAPxPqSKU4XLTpL', '3DVtYxwveebsLsKrurRuF9EWwx78JzAPD923CeUZtpJb') then value:parsed:info:amount ELSE 0 end) as PR8_out, sum(case when instruction:accounts[8] IN ('D2m4rpPKKNRtogJ4nNt3QhiT45GCVN1yenknVwaduywi', 'LMsa5kntz3HRqfV3seragyys5oQj1k5S1sNhvmxRsoM') then value:parsed:info:amount ELSE 0 end) as VZUSAM_out, sum(case when instruction:accounts[8] IN ('EpyFrbArVSc4rLmcWbeYyq4i73vzpV5dirjVmxwdDf58', '5cTYGD6GsfKqUZvV2NYCUbN1QjmfxUXnjhE3P5L6ZJ4w') then value:parsed:info:amount ELSE 0 end) as PC9_out, sum(case when instruction:accounts[8] IN ('AX5Q2byXdf6APtvRzkTGf3iSvT7UXzWkexUBJgGMTEQc', 'FDMzLuxKW5fMkgSwz8EEj7VpX6R9aLHFwySEHB1uNtxk') then value:parsed:info:amount ELSE 0 end) as PC11_out, sum(case when instruction:accounts[8] IN ('GsKzNomuH6VRpP8bGgAma2UWeEZhom3WvdupZSPTB7EE', '92ZHZMvEKgzfRx8XVbR9zkzw9pcUSzJuudMjRovGkmLF') then value:parsed:info:amount ELSE 0 end) as CHI_out, sum(case when instruction:accounts[8] IN ('AZP4tSm5hocgv1NFcfKW2CveTrWK3kUFwjSSaNiou838', '5fxoHDbi9YxBiqEYvos9Xi32mUUPpHnJdX3emJcBkmZQ') then value:parsed:info:amount ELSE 0 end) as OGKAJA_out, sum(case when instruction:accounts[8] IN ('DaasSWQpw9TtNEssDfTdZFNZkEvMNFi7poYgydW6im4W', 'DAvxCPqyDywdLXiEPXT9riTaZ1Lds6TeuVBJgCH3F4fF') then value:parsed:info:amount ELSE 0 end) as CALEV_out, sum(case when instruction:accounts[8] IN ('BAin7fE4YKZG9FRK4deHit56iKdshqsNKqZmv7fLVBvw', '7DSLoedynSJYR4StC2vzqAc24TH9NSgGu4nzvu1GApEp') then value:parsed:info:amount ELSE 0 end) as TUFAFE_out, sum(case when instruction:accounts[8] IN ('7mXrU4enKTgFajhFycG85RZBDtgsHBxvKy3NAu356d7c', '35rK8ogKhkst94dYmBW5VSzPKQU5B1Vm9aiYVG9e8Exz') then value:parsed:info:amount ELSE 0 end) as FBLBEA_out, sum(case when instruction:accounts[8] IN ('cZ8A15hf2U69YGM8NtcSZN1y3hbvkPYQoEAhcuAXbxB', '4mpvBDevhrCg1JMpSHZ7RB1gMNEpFLNFG4h5pBYztfUK') then value:parsed:info:amount ELSE 0 end) as PX6_out, sum(case when instruction:accounts[8] IN ('2yJ8PZmUhbLcX49pncgqJXWMcEQ3ZYxFsGTt49Xy6i57', 'HkemS9qcuxtH1QSo7VZ4VBShgqwXJCUPfzY6gCHyJH6q') then value:parsed:info:amount ELSE 0 end) as FBLEBO_out, sum(case when instruction:accounts[8] IN ('8hGoQrxQLhvaczY6DiasQG6TspKw9E3zXQ14KAwtXgZj', 'CmRafW8hhMGAytUcU7QgGLcZDsP3YmVnaSTSsTywQ7jz') then value:parsed:info:amount ELSE 0 end) as FBLETR_out, sum(case when instruction:accounts[8] IN ('4kugk4roXBDDjqcvJFoji1hBmCWhDkovqCstU2fKXFEw', '8ga4FdC1uQQjYoDMTbNUwmNVmNyrKnDWCYZCbx9cLJEs') then value:parsed:info:amount ELSE 0 end) as FBLAIR_out, sum(case when instruction:accounts[8] IN ('AL3LULe6my2TRNptS1PhQFq3G7hvQsYUuqm6kBgvcT7z', 'Ekg9cnCp19rtjfm318ErRHS3FQyuuk9xKeTVGSbK52TB') then value:parsed:info:amount ELSE 0 end) as OGKAMK_out, sum(case when instruction:accounts[8] IN ('Gcurud4rgbh82oyuqrEqywEA6dECg7VnvLS6MJfYQGtS', 'GAqySWLhkokwWCcSiePEruVzmjrthudM9PeY5NZ6CnVv') then value:parsed:info:amount ELSE 0 end) as FBLEUN_out, sum(case when instruction:accounts[8] IN ('5TMSoVeH23REeARahfBGwCqpmCwwiJWwnYDPGTBxZNWn', 'GJbiXfjQoziuTgkwWAkaGVeJRhGBhPBZdA5c7jXjVXTb') then value:parsed:info:amount ELSE 0 end) as ARC_out, sum(case when instruction:accounts[8] IN ('D8h7joa1hBsHGpDQUmdasfNkyju56cYM6JsjzCGZVp6N', 'ADmJiwDzA21AyK2ReuGsNbERwdjNCbYVYHbAcmEJr5WV') then value:parsed:info:amount ELSE 0 end) as FBLLOW_out, sum(case when instruction:accounts[8] IN ('F5rhD6dD2iPdgEXg5fUCzDCcsrmZgEvQGEGMNewFpZVK', 'BpMLGQBi5sFv3AxJjHNxrhtrfaoWuYkmABVvbwunGf7n') then value:parsed:info:amount ELSE 0 end) as THRILL_out, sum(case when instruction:accounts[8] IN ('Cu5qZbr8YRDwPAiUxy1zy5Re7E16BqbP4HRrttLX2Xrt', '7p36nvhahnYkYEx3WHzT4r7w9E5zg3qyeyfVSDwZdfGY') then value:parsed:info:amount ELSE 0 end) as VZUSBA_out, sum(case when instruction:accounts[8] IN ('F1GdCKWbqsenbNmwYDqv9uFf2j5ZmC7CM8MfFnfs5xeu', '4FU3jxogvMHLgRhdNAkePF4CGgcAvzNH4joFP5XqRfs5') then value:parsed:info:amount ELSE 0 end) as CALMED_out, sum(case when instruction:accounts[8] IN ('VYeXPN2NuJqAiXETpQKQcc4Yf45jZ9zJeGpZLG5NizE', '6iWJGqZBnVAfZMhGsqUSaWUY2cK998Gs1LF6ks8cqXvd') then value:parsed:info:amount ELSE 0 end) as OPALBB_out, sum(case when instruction:accounts[8] IN ('FZJiBC8JAxM1PYU2G2aD3ZjAJXCb1eJoKUkBvLb1yuq3', '6mELFyNhLZ4X7TDAdLKNb7bvH8NE711qoeTEMoGdT5yA') then value:parsed:info:amount ELSE 0 end) as CALATS_out, sum(case when instruction:accounts[8] IN ('DwSHWUFEocJKfwvv6MdB35iNtVR62ayxAKkDAxdCayDQ', 'D8fpfnY7oqK6DdmrFB4T3weMYKs35RQqZiezJm8Fchxy') then value:parsed:info:amount ELSE 0 end) as PR6_out, sum(case when instruction:accounts[8] IN ('J7yb7vkeKQqZxzNDAQcTTRQ9RU9UvyFgQdNakSEymA4W', '44Ck1CTZrBACaRdw9j9qT575NsbJ7LpgrsX4kxGecdbd') then value:parsed:info:amount ELSE 0 end) as HEART_out, sum(case when instruction:accounts[8] IN ('6MWibB5vbjberyQdoiT4ghkponRLYFw3eGMCmUTAev7q', 'EnEsWSGQxmiegT6ZT1eStNv29BAvUydBBC1RLZcbYBSL') then value:parsed:info:amount ELSE 0 end) as OGKATU_out, sum(case when instruction:accounts[8] IN ('CRzosUaKosztiYLC46xv2xHKyxf6HkttAuZYQUUMCTR3', 'An6qNYmy89kz5KgekPBESNJZGohAy1YnE9eKyRw2N4Je') then value:parsed:info:amount ELSE 0 end) as FBLMAM_out, sum(case when instruction:accounts[8] IN ('AtTRG8JsmWgW8mmjrHEd13bSGk7sUsrPXLw1YuLxNFXk', 'DkGKUpCPixTUMvA1zTYWX5iq7Rb8gs9JtSuLTeBpHVCK') then value:parsed:info:amount ELSE 0 end) as VZUSSO_out, sum(case when instruction:accounts[8] IN ('2vCZ1JwAmPmALnozMazbsa8eFe3LmgNLpjB2JP7vM8JH', 'BwnzeTBjkarLcY2wwCGDB3Ukc16SEYUH4q8EGDsKbHn4') then value:parsed:info:amount ELSE 0 end) as FBLBTA_out, sum(case when instruction:accounts[8] IN ('4spbRSBxUyPcXTCd6UuZKU9i6td64dy3m7ZBF9HkM6s8', '6VuWCMdYXTWmpcQXZCbjb25nnonwNqcwiaBwHj5CMQdB') then value:parsed:info:amount ELSE 0 end) as OGKASP_out, sum(case when instruction:accounts[8] IN ('DAF73sFyYmU5FVbN6g6Pv1jNnuajd4j3KjCXfQPVkdDR', 'CRTRByUmS3AxsREL8zoGtA3XE2HTtF6HSEMEoSrg3Mw1') then value:parsed:info:amount ELSE 0 end) as PD9_out, sum(case when instruction:accounts[8] IN ('AnYKKt6FJkduJaeuqcA6HcUJV513D3kGgePtFbkvTf8z', '96k8aLvx5jyAUmKeVPjeUbT3p6q6MYfQqixwbkQ6PVJA') then value:parsed:info:amount ELSE 0 end) as STAND_out, sum(case when instruction:accounts[8] IN ('7VvnWHfMdRJgzkx3Dq1WABxNbNVUH22RTmi4kDumJg6s', 'HdSM9puUFMqYSoqJraFbDggmRrYa4qkaj6qYua2kjnTh') then value:parsed:info:amount ELSE 0 end) as SUPER_out, sum(case when instruction:accounts[8] IN ('79Vnjq26W4yoADGYijZGcrTVUR5CY39HmcxfEo8XhAiV', '6gD3R2TmpkHchmHJqe9h2hWvSMdQNAJTttLdYd92Cqr') then value:parsed:info:amount ELSE 0 end) as T1TAN_out, sum(case when instruction:accounts[8] IN ('5zM4hMpf3fRsxPaVWh3qfutGQUryKARmQpYcaxyKd7ai', 'GmRzVz3CF193X1q4jHdGaPwCZqXYYv2d9sopv2qLjwrx') then value:parsed:info:amount ELSE 0 end) as CALSCD_out, sum(case when instruction:accounts[8] IN ('GUPLfiYUd9ncMFo5ZJEXahEbW45AFuJ1bM7GtAEmLter', 'FGsDR65N7hgwcNJ9LdjFzeBy2gexBCqRzKEP7b6kjHTg') then value:parsed:info:amount ELSE 0 end) as CALMAX_out, sum(case when instruction:accounts[8] IN ('EosYsejYMjxBLcSiRT3kfXnaowARCCSBMXYBi5Vcw9gr', 'CJviPrzuCNecx8uTboyegQncjJwA9gPTjxBXyHCiqCfR') then value:parsed:info:amount ELSE 0 end) as OGKANR_out, sum(case when instruction:accounts[8] IN ('5KepAtd3pgkpuMdew2eLL19V6dcvubCgciobV57FYyFM', 'BWP7tM5S5KvQzz9u8iRbR5QVysK9JbSfagYs4Y3NfvD6') then value:parsed:info:amount ELSE 0 end) as IMP1_out, sum(case when instruction:accounts[8] IN ('8bVmKHUgbb2vo6rCQKKyAZUQwxTNQ7baMnJmQzkCoW62', 'FvKDF8k5u1y2awPqrkCiWdwS4NzNjvtwB72jZHYfeRKG') then value:parsed:info:amount ELSE 0 end) as IMP2_out, sum(case when instruction:accounts[8] IN ('GmynV3HXfeMu4qhjHpJPsCbucR4eRuyhCgq8oJpsgWdB', '4KxPc22D3owBVFJx2wKAvq5qFAmRpDSa53HXjGqjrELi') then value:parsed:info:amount ELSE 0 end) as IMP3_out, sum(case when instruction:accounts[8] IN ('BGL4UHYsM7YwfN5pLGMDtv29UVi4B2NiYjuycuADkB8H', '4ZYhfpzdWszBdeT68AmTopzFqEQus9BpYS2DzegunP5b') then value:parsed:info:amount ELSE 0 end) as FBLMEX_out, sum(case when instruction:accounts[8] IN ('9UKuxVa2tzTSRf93qmKTLVCMFLdY6i1t3bTCHNJeuJdt', '4rWALPyYQxXf3ow3HypiCmBivmyUFXr9Y7HhVg5fZsWX') then value:parsed:info:amount ELSE 0 end) as FBLBBU_out, sum(case when instruction:accounts[8] IN ('3FvJVMzq8gQbH74sdVpqCK4v9FojzAXvRDxcAPWssQ15', 'FJW9UTg5H64hXnFtDbmPs5PcoLGxAJv8ck5T3AUNfXND') then value:parsed:info:amount ELSE 0 end) as OPALRF_out, sum(case when instruction:accounts[8] IN ('DTgtFKaAEUGMLHso6SUpjWdUhxfaYAMomPEJUeg7EkcJ', 'E2VjjXhY97JVEkYczA6Zb85ixQ96NCp4db3Ux9mcunJn') then value:parsed:info:amount ELSE 0 end) as FBLSLE_out, sum(case when instruction:accounts[8] IN ('7YCgLj3H8xmXr787rqD61Nx2jRcXAX8fTW8Gbo6teacP', 'BLtCkSds4JZWVkYf5Tx6YftZNgF71my8FzQnvPuBu8mz') then value:parsed:info:amount ELSE 0 end) as OGKARU_out, sum(case when instruction:accounts[8] IN ('AW4pHtJzxHj1fr6Y1To27yN1R5ZfrB5oXcLGXTrkGKxR', 'FbgfUXa3jxeR7Aah8BFgECCa2Rez39kbaJv7g2F778mr') then value:parsed:info:amount ELSE 0 end) as PHI_out, sum(case when instruction:accounts[8] IN ('5nC3HbDTZeJnKsKo1gGjRHkaix3ZA778vMkz5UeWzQzD', '5nC3HbDTZeJnKsKo1gGjRHkaix3ZA778vMkz5UeWzQzD') then value:parsed:info:amount ELSE 0 end) as CALSHIP_out, sum(case when instruction:accounts[8] IN ('8KED2P84CWdVT5iLycK1BcXCCoHQV2pDAoZMpgx9Qpg1', 'GuhVdeVSkeGh77n6kJc146TqNxZ9PNRoXWCnq7LyXfpV') then value:parsed:info:amount ELSE 0 end) as FBLBRA_out from solana.core.fact_events, lateral flatten(input => inner_instruction:instructions)--, ship_escrow_accounts WHERE program_id = 'SAGE2HAwep459SNq61LHvjxPk4pLPEJLoMETef7f7EE' AND succeeded = 'true' AND block_timestamp > '2024-04-01' --AND block_timestamp < current_date group by 1 order by 1 desc ), ships_data AS ( SELECT ----------------------------------------------------------------------------------------------------- 20 as opalj_vwap, 2 as opalj_fp, 'racer' as opalj_role, 0.85 as opalj_rewards, ----------------------------------------------------------------------------------------------------- 140.48 as PX5_vwap, 16.33 as PX5_fp, 'fighter' as PX5_role, 6.25 as PX5_rewards, ----------------------------------------------------------------------------------------------------- 1666.67 as vzusop_vwap, 100.74 as vzusop_fp, 'data runner' as vzusop_role, 69.51 as vzusop_rewards, ----------------------------------------------------------------------------------------------------- 3786.67 as calch_vwap, 120.89 as calch_fp, 'multi-role' as calch_role, 146.87 as calch_rewards, ----------------------------------------------------------------------------------------------------- 8506.43 as ogkatp_vwap, 438.59 as ogkatp_fp, 'fighter' as ogkatp_role, 360.67 as ogkatp_rewards, ----------------------------------------------------------------------------------------------------- 22.66 as PX4_vwap, 4 as PX4_fp, 'fighter' as PX4_role, 0.97 as PX4_rewards, ----------------------------------------------------------------------------------------------------- 308.91 as OPALJJ_vwap, 8.16 as OPALJJ_fp, 'racer' as OPALJJ_role, 12.24 as opaljj_rewards, ----------------------------------------------------------------------------------------------------- 3513.13 as FBLBPL_vwap, 80.59 as FBLBPL_fp, 'freight' as FBLBPL_role, 138.94 as FBLBPL_rewards, ----------------------------------------------------------------------------------------------------- 30883.91 as CALG_vwap, 1044.27 as CALG_fp, 'multi-role' as CALG_role, 1174.47 as CALG_rewards, ----------------------------------------------------------------------------------------------------- 2840.35 as PF4_vwap, 190.24 as PF4_fp, 'fighter' as PF4_role, 118.98 as PF4_rewards, ----------------------------------------------------------------------------------------------------- 8603.14 as FBLEGR_vwap, 419.25 as FBLEGR_fp, 'bomber' as FBLEGR_role, 352.98 as FBLEGR_rewards, ----------------------------------------------------------------------------------------------------- 2807.16 as OM_vwap, 95.4 as OM_fp, 'freight' as OM_role, 111.64 as OM_rewards, ----------------------------------------------------------------------------------------------------- 11104.67 as PR8_vwap, 219.3 as PR8_fp, 'refuel/repair' as PR8_role, 434 as PR8_rewards, ----------------------------------------------------------------------------------------------------- 1200 as VZUSAM_vwap, 35.06 as VZUSAM_fp, 'bounty hunter' as VZUSAM_role, 47.74 as VZUSAM_rewards, ----------------------------------------------------------------------------------------------------- 31829.19 as PC9_vwap, 1926.25 as PC9_fp, 'fighter' as PC9_role, 1210.45 as PC9_rewards, ----------------------------------------------------------------------------------------------------- 90090.83 as PC11_vwap, 4790.85 as PC11_fp, 'fighter' as PC11_role, 3462.06 as PC11_rewards, ----------------------------------------------------------------------------------------------------- 995 as CHI_vwap, 44.43 as CHI_fp, 'fighter' as CHI_role, 40.12 as CHI_rewards, ----------------------------------------------------------------------------------------------------- 30920.58 as OGKAJA_vwap, 895.09 as OGKAJA_fp, 'transport' as OGKAJA_role, 1145.28 as OGKAJA_rewards, ----------------------------------------------------------------------------------------------------- 2601.1 as CALEV_vwap, 55.10 as CALEV_fp, 'rescue' as CALEV_role, 106.56 as CALEV_rewards, ----------------------------------------------------------------------------------------------------- 795 as TUFAFE_vwap, 37.02 as TUFAFE_fp, 'fighter' as TUFAFE_role, 33.95 as TUFAFE_rewards, ----------------------------------------------------------------------------------------------------- 895 as FBLBEA_vwap, 55.1 as FBLBEA_fp, 'fighter' as FBLBEA_role, 36.99 as FBLBEA_rewards, ----------------------------------------------------------------------------------------------------- 930 as PX6_vwap, 55.31 as PX6_fp, 'fighter' as PX6_role, 38.56 as PX6_rewards, ----------------------------------------------------------------------------------------------------- 36563.69 as FBLEBO_vwap, 517.66 as FBLEBO_fp, 'bomber' as FBLEBO_role, 1374.6 as FBLEBO_rewards, ----------------------------------------------------------------------------------------------------- 105250 as FBLETR_vwap, 3475.07 as FBLETR_fp, 'bomber' as FBLETR_role, 3980.10 as FBLETR_rewards, ----------------------------------------------------------------------------------------------------- 16.5 as FBLAIR_vwap, 0 as FBLAIR_fp, 'racer' as FBLAIR_role, 0.74 as FBLAIR_rewards, ----------------------------------------------------------------------------------------------------- 770 as OGKAMK_vwap, 27.66 as OGKAMK_fp, 'fighter' as OGKAMK_role, 33.19 as OGKAMK_rewards, ----------------------------------------------------------------------------------------------------- 35 as FBLEUN_vwap, 2 as FBLEUN_fp, 'bomber' as FBLEUN_role, 1.37 as FBLEUN_rewards, ----------------------------------------------------------------------------------------------------- 13721.40 as ARC_vwap, 259.59 as ARC_fp, 'freight' as ARC_role, 516.44 as ARC_rewards, ----------------------------------------------------------------------------------------------------- 60 as FBLLOW_vwap, 0 as FBLLOW_fp, 'transport' as FBLLOW_role, 3.30 as FBLLOW_rewards, ----------------------------------------------------------------------------------------------------- 946 as THRILL_vwap, 44.43 as THRILL_fp, 'fighter' as THRILL_role, 39.01 as THRILL_rewards, ----------------------------------------------------------------------------------------------------- 33286 as VZUSBA_vwap, 1926.25 as VZUSBA_fp, 'fighter' as VZUSBA_role, 1282 as VZUSBA_rewards, ----------------------------------------------------------------------------------------------------- 942.8 as CALMED_vwap, 10.88 as CALMED_fp, 'rescue' as CALMED_role, 37.81 as CALMED_rewards, ----------------------------------------------------------------------------------------------------- 10728 as OPALBB_vwap, 328.94 as OPALBB_fp, 'transport' as OPALBB_role, 421.73 as OPALBB_rewards, ----------------------------------------------------------------------------------------------------- 2423 as CALATS_vwap, 270.07 as CALATS_fp, 'fighter' as CALATS_role, 104.99 as CALATS_rewards, ----------------------------------------------------------------------------------------------------- 1091.8 as PR6_vwap, 20.25 as PR6_fp, 'repair' as PR6_role, 43.05 as PR6_rewards, ----------------------------------------------------------------------------------------------------- 32585.75 as HEART_vwap, 1114.38 as HEART_fp, 'fighter' as HEART_role, 1255.05 as HEART_rewards, ----------------------------------------------------------------------------------------------------- 2772 as OGKATU_vwap, 110.21 as OGKATU_fp, 'fighter' as OGKATU_role, 115.74 as OGKATU_rewards, ----------------------------------------------------------------------------------------------------- 1881 as FBLMAM_vwap, 190.24 as FBLMAM_fp, 'bounty hunter' as FBLMAM_role, 87.39 as FBLMAM_rewards, ----------------------------------------------------------------------------------------------------- 20 as VZUSSO_vwap, 2.53 as VZUSSO_fp, 'racer' as VZUSSO_role, 0.85 as VZUSSO_rewards, ----------------------------------------------------------------------------------------------------- 102118 as FBLBTA_vwap, 5653.28 as FBLBTA_fp, 'fighter' as FBLBTA_role, 3890.04 as FBLBTA_rewards, ----------------------------------------------------------------------------------------------------- 10176 as OGKASP_vwap, 161.18 as OGKASP_fp, 'freight' as OGKASP_role, 408.59 as OGKASP_rewards, ----------------------------------------------------------------------------------------------------- 31043.48 as PD9_vwap, 580.43 as PD9_fp, 'salvage' as PD9_role, 1165.77 as PD9_rewards, ----------------------------------------------------------------------------------------------------- 5000000 as STAND_vwap, 13794 as STAND_fp, 'fighter' as STAND_role, 172499.17 as STAND_rewards, ----------------------------------------------------------------------------------------------------- 5000000 as SUPER_vwap, 13914 as SUPER_fp, 'bomber' as SUPER_role, 172506.99 as SUPER_rewards, ----------------------------------------------------------------------------------------------------- 5000000 as T1TAN_vwap, 16377.75 as T1TAN_fp, 'fighter' as T1TAN_role, 172665.58 as T1TAN_rewards, ----------------------------------------------------------------------------------------------------- 175 as CALSCD_vwap, --estimation from net profit in SCORE 7 as CALSCD_fp, 'racer' as CALSCD_role, 7.2 as CALSCD_rewards, ----------------------------------------------------------------------------------------------------- 155 as CALMAX_vwap, --estimation from net profit in SCORE 10.67 as CALMAX_fp, 'transport' as CALMAX_role, 6.46 as CALMAX_rewards, ----------------------------------------------------------------------------------------------------- 195 as OGKANR_vwap, --estimation from net profit in SCORE 7.78 as OGKANR_fp, 'transport' as OGKANR_role, 7.78 as OGKANR_rewards, ----------------------------------------------------------------------------------------------------- 928.8 as IMP1_vwap, 0 as IMP1_fp, 'miner' as IMP1_role, 36.235 as IMP1_rewards, ----------------------------------------------------------------------------------------------------- 2624.4 as IMP2_vwap, 0 as IMP2_fp, 'miner' as IMP2_role, 104.443 as IMP2_rewards, ----------------------------------------------------------------------------------------------------- 29700 as IMP3_vwap, 0 as IMP3_fp, 'miner' as IMP3_role, 1107.804 as IMP3_rewards, ----------------------------------------------------------------------------------------------------- 1881 as FBLMEX_vwap, 190.24 as FBLMEX_fp, 'bounty hunter' as FBLMEX_role, 87.39 as FBLMEX_rewards, ----------------------------------------------------------------------------------------------------- 10526 as FBLBBU_vwap, --estimation from net profit in SCORE 480.7 as FBLBBU_fp, 'fighter' as FBLBBU_role, 429.01 as FBLBBU_rewards, ----------------------------------------------------------------------------------------------------- 860 as OPALRF_vwap, --estimation from net profit in SCORE 41.2 as OPALRF_fp, 'data runner' as OPALRF_role, 33.48 as OPALRF_rewards, ----------------------------------------------------------------------------------------------------- 22287 as FBLSLE_vwap, --estimation from net profit in SCORE 0 as FBLSLE_fp, 'freight' as FBLSLE_role, 33.48 as FBLSLE_rewards, ----------------------------------------------------------------------------------------------------- 15 as OGKARU_vwap, --estimation from net profit in SCORE 0 as OGKARU_fp, 'racer' as OGKARU_role, 33.48 as OGKARU_rewards, ----------------------------------------------------------------------------------------------------- 5000000 as PHI_vwap, 0 as PHI_fp, 'fighter' as PHI_role, 0 as PHI_rewards, ----------------------------------------------------------------------------------------------------- 860 as CALSHIP_vwap, 0 as CALSHIP_fp, 'freight' as CALSHIP_role, 0 as CALSHIP_rewards ), CS_data AS ( SELECT 23875 as CS1_supply, 3855 as CS2_supply, 1477 as CS3_supply, 477 as CS4_supply, 186 as CS5_supply, 10200 as IMP1_supply, 4115 as IMP2_supply, 370 as IMP3_supply, ----- 32 as CS1_vwap, 243 as CS2_vwap, 1024 as CS3_vwap, 3125 as CS4_vwap, 7776 as CS5_vwap ), prices1 AS ( select DATE_TRUNC('day', block_timestamp) AS date, 'ATLASXmbPQxBUYbxPsV97usA3fPQYEqzQBUHgiFCUsXx' as mints, sum(case when (swap_from_mint = 'ATLASXmbPQxBUYbxPsV97usA3fPQYEqzQBUHgiFCUsXx' AND swap_to_mint = 'EPjFWdd5AufqSSqeM2qN1xzybapC8G4wEGGkZwyTDt1v') then swap_from_amount when (swap_to_mint = 'ATLASXmbPQxBUYbxPsV97usA3fPQYEqzQBUHgiFCUsXx' AND swap_from_mint = 'EPjFWdd5AufqSSqeM2qN1xzybapC8G4wEGGkZwyTDt1v') then swap_to_amount end) as ATLAS, sum(case when (swap_from_mint = 'ATLASXmbPQxBUYbxPsV97usA3fPQYEqzQBUHgiFCUsXx' AND swap_to_mint = 'EPjFWdd5AufqSSqeM2qN1xzybapC8G4wEGGkZwyTDt1v') then swap_to_amount when (swap_to_mint = 'ATLASXmbPQxBUYbxPsV97usA3fPQYEqzQBUHgiFCUsXx' AND swap_from_mint = 'EPjFWdd5AufqSSqeM2qN1xzybapC8G4wEGGkZwyTDt1v') then swap_from_amount end) as USDC, USDC/ATLAS as close from solana.defi.fact_swaps WHERE succeeded = 'true' -- AND program_id IN ( -- 'JUP6LkbZbjS1jKKwapdHNy74zcZ3tLUZoi5QNyVTaV4', -- 'JUP5cHjnnCx2DppVsufsLrXs8EBZeEZzGtEK9Gdz6ow', -- 'JUP4Fb2cqiRUcaTHdrPC8h2gNsA2ETXiPDD33WcGuJB', -- 'JUP3c2Uh3WA4Ng34tw6kPd2G4C5BB21Xo36Je1s32Ph', -- 'JUP2jxvXaqu7NQY1GmNF4m1vodw12LVXYxbFL2uJvfo') AND block_timestamp >= current_date - 30 --AND block_timestamp < current_date group by 1 ), prices2 AS ( select date, 'EPjFWdd5AufqSSqeM2qN1xzybapC8G4wEGGkZwyTDt1v' as mints, 1 as close from prices1 ), prices as ( SELECT date,mints,close FROM prices1 UNION SELECT date,mints,close FROM prices2 ), w2 as ( select block_timestamp, tx_id, signers[0] as signer, value:parsed:info:mint::string as item_mint, value:parsed:info:authority as seller, CASE WHEN value:parsed:info:mint::string IN ('fueL3hBZjLLLJHiFH9cqZoozTG3XQZ53diwFPwbzNim', 'foodQJAztMzX1DKpLaiounNe2BDMds5RNuPC6jsNrDG', 'ammoK8AkX2wnebQb35cDAZtTkvsXQbi82cGeTnUvvfK', 'tooLsNYLiVqzg8o4m3L2Uetbn62mvMWRqkog6PQeYKL') then 'R4' WHEN value:parsed:info:mint::string in ('ARCoQ9dndpg6wE2rRexzfwgJR3NoWWhpcww3xQcQLukg', 'MASS9GqtJz6ABisAxcUn3FeR4phMqH1XfG6LPKJePog', 'CARBWKWvxEuMcq3MqCxYfi7UoFVpL9c4rsQS99tw6i4X', 'CUore1tNkiubxSwDEtLc3Ybs1xfWLs8uGjyydUYZ25xc', 'DMNDKqygEN3WXKVrAD4ofkYBc4CKNRhFUbXP4VK7a944', 'HYDR4EPHJcDPcaLYUcNCtrXUdt1PnaN4MvE655pevBYp', 'FeorejFjRRAfusN9Fg3WjEZ1dRCf74o6xwT5vDt3R34J', 'LUMACqD5LaKjs1AeuJYToybasTXoYQ7YkxJEc4jowNj', 'RCH1Zhg4zcSSQK8rw2s6rDMVsgBEWa4kiv1oLFndrN5', 'SUBSVX9LYiPrzHeg2bZrqFSDSKkrQkiCesr6SjtdHaX', 'EMAGoQSP89CJV5focVjrpEuE4CeqJ4k1DouQW7gUu7yX', 'FMWKb7YJA5upZHbu5FjVRRoxdDw2FYFAu284VqUGF9C2', 'PoWRYJnw3YDSyXgNtN3mQ3TKUMoUSsLAbvE8Ejade3u', 'PTCLSWbwZ3mqZqHAporphY2ofio8acsastaHfoP87Dc', 'RABSXX6RcqJ1L5qsGY64j91pmbQVbsYRQuw1mmxhxFe', 'CoNDDRCNxXAMGscCdejioDzb6XKxSzonbWb36wzSgp5T', 'EMiTWSLgjDVkBbLFaMcGU6QqFWzX9JX6kqs1UtUjsmJA', 'CRYSNnUd7cZvVfrEVtVNKmXiCPYdZ1S5pM5qG2FDVZHF', 'cwirGHLB2heKjCeTy4Mbp4M443fU4V7vy2JouvYbZna', 'CPPRam7wKuBkYzN5zCffgNU17RKaeMEns4ZD83BqBVNR', 'ELECrjC8m9GxCqcm4XCNpFvkS8fHStAvymS6MJbe3XLZ', 'GRAPHKGoKtXtdPBx17h6fWopdT5tLjfAP8cDJ1SvvDn4', 'HYCBuSWCJ5ZEyANexU94y1BaBPtAX2kzBgGD2vES2t6M', 'ironxrUhTEaBiR9Pgp6hy4qWx6V2FirDoXhsFP25GFP', 'MAGNMDeDJLvGAnriBvzWruZHfXNwWHhxnoNF75AQYM5', 'PoLYs2hbRt5iDibrkPT9e6xWuhSS45yZji5ChgJBvcB', 'STEELXLJ8nfJy3P4aNuGxyNRbWPohqHSwxY75NsJRGG') THEN 'R9' WHEN value:parsed:info:mint::string = 'SDUsgfSZaDhhZ76U3ZgvtFiXsfnHbf2VrzYxjBZ5YbM' THEN 'SDU' ELSE 'other' -- You can define a default label for other cases END AS resource_type, sum(value:parsed:info:tokenAmount:uiAmount) as quantity from solana.core.fact_events, lateral flatten(input => inner_instruction:instructions) WHERE program_id = 'traderDnaR5w6Tcoi3NFm53i48FTDNbGjBSZwWXDRrg' AND succeeded = 'true' AND value:parsed:info:mint::string IN ('fueL3hBZjLLLJHiFH9cqZoozTG3XQZ53diwFPwbzNim', 'foodQJAztMzX1DKpLaiounNe2BDMds5RNuPC6jsNrDG', 'ammoK8AkX2wnebQb35cDAZtTkvsXQbi82cGeTnUvvfK', 'tooLsNYLiVqzg8o4m3L2Uetbn62mvMWRqkog6PQeYKL', 'ARCoQ9dndpg6wE2rRexzfwgJR3NoWWhpcww3xQcQLukg', 'MASS9GqtJz6ABisAxcUn3FeR4phMqH1XfG6LPKJePog', 'CARBWKWvxEuMcq3MqCxYfi7UoFVpL9c4rsQS99tw6i4X', 'CUore1tNkiubxSwDEtLc3Ybs1xfWLs8uGjyydUYZ25xc', 'DMNDKqygEN3WXKVrAD4ofkYBc4CKNRhFUbXP4VK7a944', 'HYDR4EPHJcDPcaLYUcNCtrXUdt1PnaN4MvE655pevBYp', 'FeorejFjRRAfusN9Fg3WjEZ1dRCf74o6xwT5vDt3R34J', 'LUMACqD5LaKjs1AeuJYToybasTXoYQ7YkxJEc4jowNj', 'RCH1Zhg4zcSSQK8rw2s6rDMVsgBEWa4kiv1oLFndrN5', 'SUBSVX9LYiPrzHeg2bZrqFSDSKkrQkiCesr6SjtdHaX', 'EMAGoQSP89CJV5focVjrpEuE4CeqJ4k1DouQW7gUu7yX', 'FMWKb7YJA5upZHbu5FjVRRoxdDw2FYFAu284VqUGF9C2', 'PoWRYJnw3YDSyXgNtN3mQ3TKUMoUSsLAbvE8Ejade3u', 'PTCLSWbwZ3mqZqHAporphY2ofio8acsastaHfoP87Dc', 'RABSXX6RcqJ1L5qsGY64j91pmbQVbsYRQuw1mmxhxFe', 'CoNDDRCNxXAMGscCdejioDzb6XKxSzonbWb36wzSgp5T', 'EMiTWSLgjDVkBbLFaMcGU6QqFWzX9JX6kqs1UtUjsmJA', 'CRYSNnUd7cZvVfrEVtVNKmXiCPYdZ1S5pM5qG2FDVZHF', 'cwirGHLB2heKjCeTy4Mbp4M443fU4V7vy2JouvYbZna', 'CPPRam7wKuBkYzN5zCffgNU17RKaeMEns4ZD83BqBVNR', 'ELECrjC8m9GxCqcm4XCNpFvkS8fHStAvymS6MJbe3XLZ', 'GRAPHKGoKtXtdPBx17h6fWopdT5tLjfAP8cDJ1SvvDn4', 'HYCBuSWCJ5ZEyANexU94y1BaBPtAX2kzBgGD2vES2t6M', 'ironxrUhTEaBiR9Pgp6hy4qWx6V2FirDoXhsFP25GFP', 'MAGNMDeDJLvGAnriBvzWruZHfXNwWHhxnoNF75AQYM5', 'PoLYs2hbRt5iDibrkPT9e6xWuhSS45yZji5ChgJBvcB', 'STEELXLJ8nfJy3P4aNuGxyNRbWPohqHSwxY75NsJRGG', 'SDUsgfSZaDhhZ76U3ZgvtFiXsfnHbf2VrzYxjBZ5YbM') AND block_timestamp >= current_date - 30 --AND block_timestamp < current_date group by 1,2,3,4,5,6 ), wx as ( SELECT tx_to as seller, tx_from as buyer, mint as currency, resource_type, sum(amount*prices.close) as usd_value FROM w2 left JOIN solana.core.fact_transfers using (tx_id,block_timestamp) left join prices on date_trunc('day', w2.block_timestamp) = prices.date and fact_transfers.mint = prices.mints WHERE mint in ('EPjFWdd5AufqSSqeM2qN1xzybapC8G4wEGGkZwyTDt1v','ATLASXmbPQxBUYbxPsV97usA3fPQYEqzQBUHgiFCUsXx') AND block_timestamp >= current_date - 30 --AND block_timestamp < current_date group by 1,2,3,4), -- s1 as ( SELECT seller as wallet, resource_type, sum(usd_value) as usd_value_sold FROM wx GROUP BY 1,2 ), s2 as ( SELECT buyer as wallet, resource_type, sum(usd_value) as usd_value_purchased FROM wx GROUP BY 1,2 ), xx_atlas as ( select block_timestamp, signers[0] as wallet, value:parsed:info:amount/pow(10,8) as score_rwds from solana.core.fact_events, lateral flatten(input => inner_instruction:instructions) WHERE program_id = 'FLEET1qqzpexyaDpqb2DGsSzE2sDCizewCg9WjrA6DBW' AND value:parsed:info:authority != signers[0] AND value:parsed:info:authority = '2ahn5m4zeujE56qKMuEeyX2jktEuJPH5UzoznHKmUMka' and value:parsed:info:amount > 0 AND block_timestamp >= current_date - 30 --AND block_timestamp < current_date ), s3 as ( SELECT wallet, sum(zeroifnull(score_rwds*prices.close)) as score_usd FROM xx_atlas left join prices on date_trunc('day', xx_atlas.block_timestamp) = prices.date WHERE prices.mints = 'ATLASXmbPQxBUYbxPsV97usA3fPQYEqzQBUHgiFCUsXx' GROUP BY 1 ), a5a AS ( SELECT block_timestamp, value:parsed:info:authority as wallet, value:parsed:info:amount/pow(10,8) as value from solana.core.fact_events, lateral flatten(input => inner_instruction:instructions) WHERE program_id = 'SAGEqqFewepDHH6hMDcmWy7yjHPpyKLDnRXKb3Ki8e6' AND value:parsed:info:authority = signers[0] AND value:parsed:info:destination = 'FdHkzP8eWeFpNSreMiZCWzJYrcZG2GJAPSyb3gENL8fS' and value:parsed:info:amount > 0 AND block_timestamp >= current_date - 30 --AND block_timestamp < current_date ), s4 as ( SELECT wallet, sum(zeroifnull(value*prices.close)) as sage_sinks FROM a5a left join prices on date_trunc('day', a5a.block_timestamp) = prices.date WHERE prices.mints = 'ATLASXmbPQxBUYbxPsV97usA3fPQYEqzQBUHgiFCUsXx' GROUP BY 1 ), -- crfr AS ( -- select -- block_timestamp, -- signers[0] as wallet, -- value:parsed:info:tokenAmount:uiAmount as value -- from solana.core.fact_events, lateral flatten(input => inner_instruction:instructions) -- WHERE program_id = 'traderDnaR5w6Tcoi3NFm53i48FTDNbGjBSZwWXDRrg' -- AND succeeded = 'true' -- AND value:parsed:info:authority = 'CPnhL83FXTgvRXXtZ2SvDfvNMiJWCqG9rFS75gqoyucP' -- AND value:parsed:info:mint::string in ('EPjFWdd5AufqSSqeM2qN1xzybapC8G4wEGGkZwyTDt1v','ATLASXmbPQxBUYbxPsV97usA3fPQYEqzQBUHgiFCUsXx') -- AND block_timestamp >= current_date - 30 --AND block_timestamp < current_date -- ), -- s5 as ( -- SELECT -- wallet, -- sum(zeroifnull(value*prices.close)) as crfr -- FROM crfr -- left join prices on date_trunc('day', crfr.block_timestamp) = prices.date -- WHERE prices.mints = 'ATLASXmbPQxBUYbxPsV97usA3fPQYEqzQBUHgiFCUsXx' -- GROUP BY 1 -- ), a1a as ( SELECT block_timestamp, value:parsed:info:authority as wallet, (value:parsed:info:tokenAmount:uiAmount) as value from solana.core.fact_events, lateral flatten(input => inner_instruction:instructions) WHERE program_id = 'traderDnaR5w6Tcoi3NFm53i48FTDNbGjBSZwWXDRrg' and value:parsed:info:destination = '4JNeLiZwa9AQz6iqfRXAbtZesNrfAHcM6cA7GHCicu6G' AND block_timestamp >= current_date - 30 --AND block_timestamp < current_date ), s6 as ( SELECT wallet, sum(zeroifnull(value*prices.close)) as mkt_fees FROM a1a left join prices on date_trunc('day', a1a.block_timestamp) = prices.date WHERE prices.mints = 'ATLASXmbPQxBUYbxPsV97usA3fPQYEqzQBUHgiFCUsXx' GROUP BY 1 ), a1b as ( SELECT block_timestamp, value:parsed:info:authority as wallet, value:parsed:info:tokenAmount:uiAmount as value from solana.core.fact_events, lateral flatten(input => inner_instruction:instructions) WHERE program_id = 'traderDnaR5w6Tcoi3NFm53i48FTDNbGjBSZwWXDRrg' and value:parsed:info:destination = 'XPqzMnL4K8fvtEeyfu4P6xtBsihXH3QbdQnB6kvp6HK' AND block_timestamp >= current_date - 30 --AND block_timestamp < current_date ), s13 as ( SELECT wallet, sum(zeroifnull(value)) as mkt_fees_usd FROM a1b GROUP BY 1 ), fr as ( select block_timestamp, signers[0] as wallet, value:parsed:info:amount/POW(10,8) as value FROM solana.core.fact_events, lateral flatten(input => inner_instruction:instructions) WHERE program_id = 'PsToRxhEPScGt1Bxpm7zNDRzaMk31t8Aox7fyewoVse' AND succeeded = 'true' AND value:parsed:info:authority in ('9R9d6BA3JUb1ZveiwY3SJ3YrqQpvcDzD5RUz9QHBE3vP','2ErrAbYcgd2NSh61wf1kVRZGCfkGGFxreuAhtt1stVnv','2N8aQdNGjPzLa4br5t3Eeu3afKj29bnwQLVHsSKSaj1V') AND block_timestamp >= current_date - 30 --AND block_timestamp < current_date ), s7 as ( SELECT wallet, sum(zeroifnull(value*prices.close)) as fac_rwds FROM fr left join prices on date_trunc('day', fr.block_timestamp) = prices.date WHERE prices.mints = 'ATLASXmbPQxBUYbxPsV97usA3fPQYEqzQBUHgiFCUsXx' GROUP BY 1 ), xxg AS ( select block_timestamp, signers[0] as wallet, zeroifnull(((value:parsed:info:amount / POW(10,8) ))) as value from solana.core.fact_events, lateral flatten(input => inner_instruction:instructions) WHERE program_id = 'gateVwTnKyFrE8nxUUgfzoZTPKgJQZUbLsEidpG4Dp2' AND block_timestamp >= current_date - 30 --AND block_timestamp < current_date AND value:parsed:info:authority = '2Jo8wqijXveVjra1DAknfoH1imS7XaJqLA1eQF5hzRUE' ), s10 as ( SELECT wallet, sum(zeroifnull(value*price.price)) as polis_locker_rwds FROM xxg left join solana.price.ez_prices_hourly price on date_trunc('hour', xxg.block_timestamp) = price.hour WHERE price.token_address = 'poLisWXnNRwC6oBu1vHiuKQzFjGL4XDSu4g9qjz9qVk' GROUP BY 1 ), xxxk AS ( select block_timestamp, signers[0] as wallet, zeroifnull(((value:parsed:info:tokenAmount:amount / POW(10,8) ))) as value from solana.core.fact_events, lateral flatten(input => inner_instruction:instructions) WHERE program_id = 'ATLocKpzDbTokxgvnLew3d7drZkEzLzDpzwgrgWKDbmc' AND block_timestamp >= current_date - 30 --AND block_timestamp < current_date AND value:parsed:info:mint = 'poLisWXnNRwC6oBu1vHiuKQzFjGL4XDSu4g9qjz9qVk' AND value:parsed:info:authority = 'J5GhV1WKcEU98c1kZt36ixjaErrrPNWbZhg3JQDg114E' ), s11 as ( SELECT wallet, sum(zeroifnull(value*price.price)) as atlas_locker_rwds FROM xxxk left join solana.price.ez_prices_hourly price on date_trunc('hour', xxxk.block_timestamp) = price.hour WHERE price.token_address = 'poLisWXnNRwC6oBu1vHiuKQzFjGL4XDSu4g9qjz9qVk' GROUP BY 1 ), xx10a as( SELECT tx_id, signers[0] as wallet FROM solana.core.fact_events WHERE program_id= 'SAGE2HAwep459SNq61LHvjxPk4pLPEJLoMETef7f7EE' AND block_timestamp >= current_date - 30 --AND block_timestamp < current_date ), ac1 as ( SELECT DISTINCT * FROM ( SELECT wallet FROM s1 UNION SELECT wallet FROM s2 UNION SELECT wallet FROM xx_atlas UNION SELECT wallet FROM s4 -- UNION -- SELECT wallet FROM s5 UNION SELECT wallet FROM s7 UNION SELECT wallet FROM xx10a UNION SELECT wallet FROM s10 UNION SELECT wallet FROM s11 UNION SELECT wallet FROM score_in UNION SELECT wallet FROM score_out UNION SELECT wallet FROM fc_out UNION SELECT wallet FROM fc_in )), ships_staked as ( select ac1.wallet, zeroifnull(x.OPALJ_IN ) - zeroifnull(y.OPALJ_OUT) + zeroifnull(c.OPALJ_IN) - zeroifnull(c.OPALJ_out) + zeroifnull(e.OPALJ_in) - zeroifnull(e.OPALJ_out) AS OPALJ, zeroifnull(x.PX5_IN ) - zeroifnull(y.PX5_OUT) + zeroifnull(c.PX5_IN) - zeroifnull(c.PX5_out) + zeroifnull(e.PX5_in) - zeroifnull(e.PX5_out) AS PX5, zeroifnull(x.VZUSOP_IN ) - zeroifnull(y.VZUSOP_OUT) + zeroifnull(c.VZUSOP_IN) - zeroifnull(c.VZUSOP_out) + zeroifnull(e.VZUSOP_in) - zeroifnull(e.VZUSOP_out) AS VZUSOP, zeroifnull(x.CALCH_IN ) - zeroifnull(y.CALCH_OUT) + zeroifnull(c.CALCH_IN) - zeroifnull(c.CALCH_out) + zeroifnull(e.CALCH_in) - zeroifnull(e.CALCH_out) AS CALCH, zeroifnull(x.OGKATP_IN ) - zeroifnull(y.OGKATP_OUT) + zeroifnull(c.OGKATP_IN) - zeroifnull(c.OGKATP_out) + zeroifnull(e.OGKATP_in) - zeroifnull(e.OGKATP_out) AS OGKATP, zeroifnull(x.PX4_IN ) - zeroifnull(y.PX4_OUT) + zeroifnull(c.PX4_IN) - zeroifnull(c.PX4_out) + zeroifnull(e.PX4_in) - zeroifnull(e.PX4_out) AS PX4, zeroifnull(x.OPALJJ_IN ) - zeroifnull(y.OPALJJ_OUT) + zeroifnull(c.OPALJJ_IN) - zeroifnull(c.OPALJJ_out) + zeroifnull(e.OPALJJ_in) - zeroifnull(e.OPALJJ_out) AS OPALJJ, zeroifnull(x.FBLBPL_IN ) - zeroifnull(y.FBLBPL_OUT) + zeroifnull(c.FBLBPL_IN) - zeroifnull(c.FBLBPL_out) + zeroifnull(e.FBLBPL_in) - zeroifnull(e.FBLBPL_out) AS FBLBPL, zeroifnull(x.CALG_IN ) - zeroifnull(y.CALG_OUT) + zeroifnull(c.CALG_IN) - zeroifnull(c.CALG_out) + zeroifnull(e.CALG_in) - zeroifnull(e.CALG_out) AS CALG, zeroifnull(x.PF4_IN ) - zeroifnull(y.PF4_OUT) + zeroifnull(c.PF4_IN) - zeroifnull(c.PF4_out) + zeroifnull(e.PF4_in) - zeroifnull(e.PF4_out) AS PF4, zeroifnull(x.FBLEGR_IN ) - zeroifnull(y.FBLEGR_OUT) + zeroifnull(c.FBLEGR_IN) - zeroifnull(c.FBLEGR_out) + zeroifnull(e.FBLEGR_in) - zeroifnull(e.FBLEGR_out) AS FBLEGR, zeroifnull(x.OM_IN ) - zeroifnull(y.OM_OUT) + zeroifnull(c.OM_IN) - zeroifnull(c.OM_out) + zeroifnull(e.OM_in) - zeroifnull(e.OM_out) AS OM, zeroifnull(x.PR8_IN ) - zeroifnull(y.PR8_OUT) + zeroifnull(c.PR8_IN) - zeroifnull(c.PR8_out) + zeroifnull(e.PR8_in) - zeroifnull(e.PR8_out) AS PR8, zeroifnull(x.VZUSAM_IN ) - zeroifnull(y.VZUSAM_OUT) + zeroifnull(c.VZUSAM_IN) - zeroifnull(c.VZUSAM_out) + zeroifnull(e.VZUSAM_in) - zeroifnull(e.VZUSAM_out) AS VZUSAM, zeroifnull(x.PC9_IN ) - zeroifnull(y.PC9_OUT) + zeroifnull(c.PC9_IN) - zeroifnull(c.PC9_out) + zeroifnull(e.PC9_in) - zeroifnull(e.PC9_out) AS PC9, zeroifnull(x.PC11_IN ) - zeroifnull(y.PC11_OUT) + zeroifnull(c.PC11_IN) - zeroifnull(c.PC11_out) + zeroifnull(e.PC11_in) - zeroifnull(e.PC11_out) AS PC11, zeroifnull(x.CHI_IN ) - zeroifnull(y.CHI_OUT) + zeroifnull(c.CHI_IN) - zeroifnull(c.CHI_out) + zeroifnull(e.CHI_in) - zeroifnull(e.CHI_out) AS CHI, zeroifnull(x.OGKAJA_IN ) - zeroifnull(y.OGKAJA_OUT) + zeroifnull(c.OGKAJA_IN) - zeroifnull(c.OGKAJA_out) + zeroifnull(e.OGKAJA_in) - zeroifnull(e.OGKAJA_out) AS OGKAJA, zeroifnull(x.CALEV_IN ) - zeroifnull(y.CALEV_OUT) + zeroifnull(c.CALEV_IN) - zeroifnull(c.CALEV_out) + zeroifnull(e.CALEV_in) - zeroifnull(e.CALEV_out) AS CALEV, zeroifnull(x.TUFAFE_IN ) - zeroifnull(y.TUFAFE_OUT) + zeroifnull(c.TUFAFE_IN) - zeroifnull(c.TUFAFE_out) + zeroifnull(e.TUFAFE_in) - zeroifnull(e.TUFAFE_out) AS TUFAFE, zeroifnull(x.FBLBEA_IN ) - zeroifnull(y.FBLBEA_OUT) + zeroifnull(c.FBLBEA_IN) - zeroifnull(c.FBLBEA_out) + zeroifnull(e.FBLBEA_in) - zeroifnull(e.FBLBEA_out) AS FBLBEA, zeroifnull(x.PX6_IN ) - zeroifnull(y.PX6_OUT) + zeroifnull(c.PX6_IN) - zeroifnull(c.PX6_out) + zeroifnull(e.PX6_in) - zeroifnull(e.PX6_out) AS PX6, zeroifnull(x.FBLEBO_IN ) - zeroifnull(y.FBLEBO_OUT) + zeroifnull(c.FBLEBO_IN) - zeroifnull(c.FBLEBO_out) + zeroifnull(e.FBLEBO_in) - zeroifnull(e.FBLEBO_out) AS FBLEBO, zeroifnull(x.FBLETR_IN ) - zeroifnull(y.FBLETR_OUT) + zeroifnull(c.FBLETR_IN) - zeroifnull(c.FBLETR_out) + zeroifnull(e.FBLETR_in) - zeroifnull(e.FBLETR_out) AS FBLETR, zeroifnull(x.FBLAIR_IN ) - zeroifnull(y.FBLAIR_OUT) + zeroifnull(c.FBLAIR_IN) - zeroifnull(c.FBLAIR_out) + zeroifnull(e.FBLAIR_in) - zeroifnull(e.FBLAIR_out) AS FBLAIR, zeroifnull(x.OGKAMK_IN ) - zeroifnull(y.OGKAMK_OUT) + zeroifnull(c.OGKAMK_IN) - zeroifnull(c.OGKAMK_out) + zeroifnull(e.OGKAMK_in) - zeroifnull(e.OGKAMK_out) AS OGKAMK, zeroifnull(x.FBLEUN_IN ) - zeroifnull(y.FBLEUN_OUT) + zeroifnull(c.FBLEUN_IN) - zeroifnull(c.FBLEUN_out) + zeroifnull(e.FBLEUN_in) - zeroifnull(e.FBLEUN_out) AS FBLEUN, zeroifnull(x.ARC_IN ) - zeroifnull(y.ARC_OUT) + zeroifnull(c.ARC_IN) - zeroifnull(c.ARC_out) + zeroifnull(e.ARC_in) - zeroifnull(e.ARC_out) AS ARC, zeroifnull(x.FBLLOW_IN ) - zeroifnull(y.FBLLOW_OUT) + zeroifnull(c.FBLLOW_IN) - zeroifnull(c.FBLLOW_out) + zeroifnull(e.FBLLOW_in) - zeroifnull(e.FBLLOW_out) AS FBLLOW, zeroifnull(x.THRILL_IN ) - zeroifnull(y.THRILL_OUT) + zeroifnull(c.THRILL_IN) - zeroifnull(c.THRILL_out) + zeroifnull(e.THRILL_in) - zeroifnull(e.THRILL_out) AS THRILL, zeroifnull(x.VZUSBA_IN ) - zeroifnull(y.VZUSBA_OUT) + zeroifnull(c.VZUSBA_IN) - zeroifnull(c.VZUSBA_out) + zeroifnull(e.VZUSBA_in) - zeroifnull(e.VZUSBA_out) AS VZUSBA, zeroifnull(x.CALMED_IN ) - zeroifnull(y.CALMED_OUT) + zeroifnull(c.CALMED_IN) - zeroifnull(c.CALMED_out) + zeroifnull(e.CALMED_in) - zeroifnull(e.CALMED_out) AS CALMED, zeroifnull(x.OPALBB_IN ) - zeroifnull(y.OPALBB_OUT) + zeroifnull(c.OPALBB_IN) - zeroifnull(c.OPALBB_out) + zeroifnull(e.OPALBB_in) - zeroifnull(e.OPALBB_out) AS OPALBB, zeroifnull(x.CALATS_IN ) - zeroifnull(y.CALATS_OUT) + zeroifnull(c.CALATS_IN) - zeroifnull(c.CALATS_out) + zeroifnull(e.CALATS_in) - zeroifnull(e.CALATS_out) AS CALATS, zeroifnull(x.PR6_IN ) - zeroifnull(y.PR6_OUT) + zeroifnull(c.PR6_IN) - zeroifnull(c.PR6_out) + zeroifnull(e.PR6_in) - zeroifnull(e.PR6_out) AS PR6, zeroifnull(x.HEART_IN ) - zeroifnull(y.HEART_OUT) + zeroifnull(c.HEART_IN) - zeroifnull(c.HEART_out) + zeroifnull(e.HEART_in) - zeroifnull(e.HEART_out) AS HEART, zeroifnull(x.OGKATU_IN ) - zeroifnull(y.OGKATU_OUT) + zeroifnull(c.OGKATU_IN) - zeroifnull(c.OGKATU_out) + zeroifnull(e.OGKATU_in) - zeroifnull(e.OGKATU_out) AS OGKATU, zeroifnull(x.FBLMAM_IN ) - zeroifnull(y.FBLMAM_OUT) + zeroifnull(c.FBLMAM_IN) - zeroifnull(c.FBLMAM_out) + zeroifnull(e.FBLMAM_in) - zeroifnull(e.FBLMAM_out) AS FBLMAM, zeroifnull(x.VZUSSO_IN ) - zeroifnull(y.VZUSSO_OUT) + zeroifnull(c.VZUSSO_IN) - zeroifnull(c.VZUSSO_out) + zeroifnull(e.VZUSSO_in) - zeroifnull(e.VZUSSO_out) AS VZUSSO, zeroifnull(x.FBLBTA_IN ) - zeroifnull(y.FBLBTA_OUT) + zeroifnull(c.FBLBTA_IN) - zeroifnull(c.FBLBTA_out) + zeroifnull(e.FBLBTA_in) - zeroifnull(e.FBLBTA_out) AS FBLBTA, zeroifnull(x.OGKASP_IN ) - zeroifnull(y.OGKASP_OUT) + zeroifnull(c.OGKASP_IN) - zeroifnull(c.OGKASP_out) + zeroifnull(e.OGKASP_in) - zeroifnull(e.OGKASP_out) AS OGKASP, zeroifnull(x.PD9_IN ) - zeroifnull(y.PD9_OUT) + zeroifnull(c.PD9_IN) - zeroifnull(c.PD9_out) + zeroifnull(e.PD9_in) - zeroifnull(e.PD9_out) AS PD9, zeroifnull(x.STAND_IN ) - zeroifnull(y.STAND_OUT) + zeroifnull(c.STAND_IN) - zeroifnull(c.STAND_out) + zeroifnull(e.STAND_in) - zeroifnull(e.STAND_out) AS STAND, zeroifnull(x.SUPER_IN ) - zeroifnull(y.SUPER_OUT) + zeroifnull(c.SUPER_IN) - zeroifnull(c.SUPER_out) + zeroifnull(e.SUPER_in) - zeroifnull(e.SUPER_out) AS SUPER, zeroifnull(x.T1TAN_IN ) - zeroifnull(y.T1TAN_OUT) + zeroifnull(c.T1TAN_IN) - zeroifnull(c.T1TAN_out) + zeroifnull(e.T1TAN_in) - zeroifnull(e.T1TAN_out) AS T1TAN, zeroifnull(x.CALSCD_IN ) - zeroifnull(y.CALSCD_OUT) + zeroifnull(c.CALSCD_IN) - zeroifnull(c.CALSCD_out) + zeroifnull(e.CALSCD_in) - zeroifnull(e.CALSCD_out) AS CALSCD, zeroifnull(x.CALMAX_IN ) - zeroifnull(y.CALMAX_OUT) + zeroifnull(c.CALMAX_IN) - zeroifnull(c.CALMAX_out) + zeroifnull(e.CALMAX_in) - zeroifnull(e.CALMAX_out) AS CALMAX, zeroifnull(x.OGKANR_IN ) - zeroifnull(y.OGKANR_OUT) + zeroifnull(c.OGKANR_IN) - zeroifnull(c.OGKANR_out) + zeroifnull(e.OGKANR_in) - zeroifnull(e.OGKANR_out) AS OGKANR, zeroifnull(x.IMP1_IN ) - zeroifnull(y.IMP1_OUT) + zeroifnull(c.IMP1_IN) - zeroifnull(c.IMP1_out) + zeroifnull(e.IMP1_in) - zeroifnull(e.IMP1_out) AS IMP1, zeroifnull(x.IMP2_IN ) - zeroifnull(y.IMP2_OUT) + zeroifnull(c.IMP2_IN) - zeroifnull(c.IMP2_out) + zeroifnull(e.IMP2_in) - zeroifnull(e.IMP2_out) AS IMP2, zeroifnull(x.IMP3_IN ) - zeroifnull(y.IMP3_OUT) + zeroifnull(c.IMP3_IN) - zeroifnull(c.IMP3_out) + zeroifnull(e.IMP3_in) - zeroifnull(e.IMP3_out) AS IMP3, zeroifnull(x.FBLMEX_IN ) - zeroifnull(y.FBLMEX_OUT) + zeroifnull(c.FBLMEX_IN) - zeroifnull(c.FBLMEX_out) + zeroifnull(e.FBLMEX_in) - zeroifnull(e.FBLMEX_out) AS FBLMEX, zeroifnull(x.FBLBBU_IN ) - zeroifnull(y.FBLBBU_OUT) + zeroifnull(c.FBLBBU_IN) - zeroifnull(c.FBLBBU_out) + zeroifnull(e.FBLBBU_in) - zeroifnull(e.FBLBBU_out) AS FBLBBU, zeroifnull(x.OPALRF_IN ) - zeroifnull(y.OPALRF_OUT) + zeroifnull(c.OPALRF_IN) - zeroifnull(c.OPALRF_out) + zeroifnull(e.OPALRF_in) - zeroifnull(e.OPALRF_out) AS OPALRF, zeroifnull(x.FBLSLE_IN ) - zeroifnull(y.FBLSLE_OUT) + zeroifnull(c.FBLSLE_IN) - zeroifnull(c.FBLSLE_out) + zeroifnull(e.FBLSLE_in) - zeroifnull(e.FBLSLE_out) AS FBLSLE, zeroifnull(x.OGKARU_IN ) - zeroifnull(y.OGKARU_OUT) + zeroifnull(c.OGKARU_IN) - zeroifnull(c.OGKARU_out) + zeroifnull(e.OGKARU_in) - zeroifnull(e.OGKARU_out) AS OGKARU, zeroifnull(x.PHI_IN ) - zeroifnull(y.PHI_OUT) + zeroifnull(c.PHI_IN) - zeroifnull(c.PHI_out) + zeroifnull(e.PHI_in) - zeroifnull(e.PHI_out) AS PHI, zeroifnull(x.CALSHIP_IN ) - zeroifnull(y.CALSHIP_OUT) + zeroifnull(c.CALSHIP_IN) - zeroifnull(c.CALSHIP_out) + zeroifnull(e.CALSHIP_in) - zeroifnull(e.CALSHIP_out) AS CALSHIP, zeroifnull(x.OPALJ_IN) - zeroifnull(y.OPALJ_OUT) AS OPALJ_score, zeroifnull(x.PX5_IN) - zeroifnull(y.PX5_OUT) AS PX5_score, zeroifnull(x.VZUSOP_IN) - zeroifnull(y.VZUSOP_OUT) AS VZUSOP_score, zeroifnull(x.CALCH_IN) - zeroifnull(y.CALCH_OUT) AS CALCH_score, zeroifnull(x.OGKATP_IN) - zeroifnull(y.OGKATP_OUT) AS OGKATP_score, zeroifnull(x.PX4_IN) - zeroifnull(y.PX4_OUT) AS PX4_score, zeroifnull(x.OPALJJ_IN) - zeroifnull(y.OPALJJ_OUT) AS OPALJJ_score, zeroifnull(x.FBLBPL_IN) - zeroifnull(y.FBLBPL_OUT) AS FBLBPL_score, zeroifnull(x.CALG_IN) - zeroifnull(y.CALG_OUT) AS CALG_score, zeroifnull(x.PF4_IN) - zeroifnull(y.PF4_OUT) AS PF4_score, zeroifnull(x.FBLEGR_IN) - zeroifnull(y.FBLEGR_OUT) AS FBLEGR_score, zeroifnull(x.OM_IN) - zeroifnull(y.OM_OUT) AS OM_score, zeroifnull(x.PR8_IN) - zeroifnull(y.PR8_OUT) AS PR8_score, zeroifnull(x.VZUSAM_IN) - zeroifnull(y.VZUSAM_OUT) AS VZUSAM_score, zeroifnull(x.PC9_IN) - zeroifnull(y.PC9_OUT) AS PC9_score, zeroifnull(x.PC11_IN) - zeroifnull(y.PC11_OUT) AS PC11_score, zeroifnull(x.CHI_IN) - zeroifnull(y.CHI_OUT) AS CHI_score, zeroifnull(x.OGKAJA_IN) - zeroifnull(y.OGKAJA_OUT) AS OGKAJA_score, zeroifnull(x.CALEV_IN) - zeroifnull(y.CALEV_OUT) AS CALEV_score, zeroifnull(x.TUFAFE_IN) - zeroifnull(y.TUFAFE_OUT) AS TUFAFE_score, zeroifnull(x.FBLBEA_IN) - zeroifnull(y.FBLBEA_OUT) AS FBLBEA_score, zeroifnull(x.PX6_IN) - zeroifnull(y.PX6_OUT) AS PX6_score, zeroifnull(x.FBLEBO_IN) - zeroifnull(y.FBLEBO_OUT) AS FBLEBO_score, zeroifnull(x.FBLETR_IN) - zeroifnull(y.FBLETR_OUT) AS FBLETR_score, zeroifnull(x.FBLAIR_IN) - zeroifnull(y.FBLAIR_OUT) AS FBLAIR_score, zeroifnull(x.OGKAMK_IN) - zeroifnull(y.OGKAMK_OUT) AS OGKAMK_score, zeroifnull(x.FBLEUN_IN) - zeroifnull(y.FBLEUN_OUT) AS FBLEUN_score, zeroifnull(x.ARC_IN) - zeroifnull(y.ARC_OUT) AS ARC_score, zeroifnull(x.FBLLOW_IN) - zeroifnull(y.FBLLOW_OUT) AS FBLLOW_score, zeroifnull(x.THRILL_IN) - zeroifnull(y.THRILL_OUT) AS THRILL_score, zeroifnull(x.VZUSBA_IN) - zeroifnull(y.VZUSBA_OUT) AS VZUSBA_score, zeroifnull(x.CALMED_IN) - zeroifnull(y.CALMED_OUT) AS CALMED_score, zeroifnull(x.OPALBB_IN) - zeroifnull(y.OPALBB_OUT) AS OPALBB_score, zeroifnull(x.CALATS_IN) - zeroifnull(y.CALATS_OUT) AS CALATS_score, zeroifnull(x.PR6_IN) - zeroifnull(y.PR6_OUT) AS PR6_score, zeroifnull(x.HEART_IN) - zeroifnull(y.HEART_OUT) AS HEART_score, zeroifnull(x.OGKATU_IN) - zeroifnull(y.OGKATU_OUT) AS OGKATU_score, zeroifnull(x.FBLMAM_IN) - zeroifnull(y.FBLMAM_OUT) AS FBLMAM_score, zeroifnull(x.VZUSSO_IN) - zeroifnull(y.VZUSSO_OUT) AS VZUSSO_score, zeroifnull(x.FBLBTA_IN) - zeroifnull(y.FBLBTA_OUT) AS FBLBTA_score, zeroifnull(x.OGKASP_IN) - zeroifnull(y.OGKASP_OUT) AS OGKASP_score, zeroifnull(x.PD9_IN) - zeroifnull(y.PD9_OUT) AS PD9_score, zeroifnull(x.STAND_IN) - zeroifnull(y.STAND_OUT) AS STAND_score, zeroifnull(x.SUPER_IN) - zeroifnull(y.SUPER_OUT) AS SUPER_score, zeroifnull(x.T1TAN_IN) - zeroifnull(y.T1TAN_OUT) AS T1TAN_score, zeroifnull(x.CALSCD_IN) - zeroifnull(y.CALSCD_OUT) AS CALSCD_score, zeroifnull(x.CALMAX_IN) - zeroifnull(y.CALMAX_OUT) AS CALMAX_score, zeroifnull(x.OGKANR_IN) - zeroifnull(y.OGKANR_OUT) AS OGKANR_score, zeroifnull(x.IMP1_IN) - zeroifnull(y.IMP1_OUT) AS IMP1_score, zeroifnull(x.IMP2_IN) - zeroifnull(y.IMP2_OUT) AS IMP2_score, zeroifnull(x.IMP3_IN) - zeroifnull(y.IMP3_OUT) AS IMP3_score, zeroifnull(x.FBLMEX_IN) - zeroifnull(y.FBLMEX_OUT) AS FBLMEX_score, zeroifnull(x.FBLBBU_IN) - zeroifnull(y.FBLBBU_OUT) AS FBLBBU_score, zeroifnull(x.OPALRF_IN) - zeroifnull(y.OPALRF_OUT) AS OPALRF_score, zeroifnull(x.FBLSLE_IN) - zeroifnull(y.FBLSLE_OUT) AS FBLSLE_score, zeroifnull(x.OGKARU_IN) - zeroifnull(y.OGKARU_OUT) AS OGKARU_score, zeroifnull(x.PHI_IN) - zeroifnull(y.PHI_OUT) AS PHI_score, zeroifnull(x.CALSHIP_IN) - zeroifnull(y.CALSHIP_OUT) AS CALSHIP_score, --- zeroifnull(c.OPALJ_IN) - zeroifnull(c.OPALJ_out) AS OPALJ_sage, zeroifnull(c.PX5_IN) - zeroifnull(c.PX5_out) AS PX5_sage, zeroifnull(c.VZUSOP_IN) - zeroifnull(c.VZUSOP_out) AS VZUSOP_sage, zeroifnull(c.CALCH_IN) - zeroifnull(c.CALCH_out) AS CALCH_sage, zeroifnull(c.OGKATP_IN) - zeroifnull(c.OGKATP_out) AS OGKATP_sage, zeroifnull(c.PX4_IN) - zeroifnull(c.PX4_out) AS PX4_sage, zeroifnull(c.OPALJJ_IN) - zeroifnull(c.OPALJJ_out) AS OPALJJ_sage, zeroifnull(c.FBLBPL_IN) - zeroifnull(c.FBLBPL_out) AS FBLBPL_sage, zeroifnull(c.CALG_IN) - zeroifnull(c.CALG_out) AS CALG_sage, zeroifnull(c.PF4_IN) - zeroifnull(c.PF4_out) AS PF4_sage, zeroifnull(c.FBLEGR_IN) - zeroifnull(c.FBLEGR_out) AS FBLEGR_sage, zeroifnull(c.OM_IN) - zeroifnull(c.OM_out) AS OM_sage, zeroifnull(c.PR8_IN) - zeroifnull(c.PR8_out) AS PR8_sage, zeroifnull(c.VZUSAM_IN) - zeroifnull(c.VZUSAM_out) AS VZUSAM_sage, zeroifnull(c.PC9_IN) - zeroifnull(c.PC9_out) AS PC9_sage, zeroifnull(c.PC11_IN) - zeroifnull(c.PC11_out) AS PC11_sage, zeroifnull(c.CHI_IN) - zeroifnull(c.CHI_out) AS CHI_sage, zeroifnull(c.OGKAJA_IN) - zeroifnull(c.OGKAJA_out) AS OGKAJA_sage, zeroifnull(c.CALEV_IN) - zeroifnull(c.CALEV_out) AS CALEV_sage, zeroifnull(c.TUFAFE_IN) - zeroifnull(c.TUFAFE_out) AS TUFAFE_sage, zeroifnull(c.FBLBEA_IN) - zeroifnull(c.FBLBEA_out) AS FBLBEA_sage, zeroifnull(c.PX6_IN) - zeroifnull(c.PX6_out) AS PX6_sage, zeroifnull(c.FBLEBO_IN) - zeroifnull(c.FBLEBO_out) AS FBLEBO_sage, zeroifnull(c.FBLETR_IN) - zeroifnull(c.FBLETR_out) AS FBLETR_sage, zeroifnull(c.FBLAIR_IN) - zeroifnull(c.FBLAIR_out) AS FBLAIR_sage, zeroifnull(c.OGKAMK_IN) - zeroifnull(c.OGKAMK_out) AS OGKAMK_sage, zeroifnull(c.FBLEUN_IN) - zeroifnull(c.FBLEUN_out) AS FBLEUN_sage, zeroifnull(c.ARC_IN) - zeroifnull(c.ARC_out) AS ARC_sage, zeroifnull(c.FBLLOW_IN) - zeroifnull(c.FBLLOW_out) AS FBLLOW_sage, zeroifnull(c.THRILL_IN) - zeroifnull(c.THRILL_out) AS THRILL_sage, zeroifnull(c.VZUSBA_IN) - zeroifnull(c.VZUSBA_out) AS VZUSBA_sage, zeroifnull(c.CALMED_IN) - zeroifnull(c.CALMED_out) AS CALMED_sage, zeroifnull(c.OPALBB_IN) - zeroifnull(c.OPALBB_out) AS OPALBB_sage, zeroifnull(c.CALATS_IN) - zeroifnull(c.CALATS_out) AS CALATS_sage, zeroifnull(c.PR6_IN) - zeroifnull(c.PR6_out) AS PR6_sage, zeroifnull(c.HEART_IN) - zeroifnull(c.HEART_out) AS HEART_sage, zeroifnull(c.OGKATU_IN) - zeroifnull(c.OGKATU_out) AS OGKATU_sage, zeroifnull(c.FBLMAM_IN) - zeroifnull(c.FBLMAM_out) AS FBLMAM_sage, zeroifnull(c.VZUSSO_IN) - zeroifnull(c.VZUSSO_out) AS VZUSSO_sage, zeroifnull(c.FBLBTA_IN) - zeroifnull(c.FBLBTA_out) AS FBLBTA_sage, zeroifnull(c.OGKASP_IN) - zeroifnull(c.OGKASP_out) AS OGKASP_sage, zeroifnull(c.PD9_IN) - zeroifnull(c.PD9_out) AS PD9_sage, zeroifnull(c.STAND_IN) - zeroifnull(c.STAND_out) AS STAND_sage, zeroifnull(c.SUPER_IN) - zeroifnull(c.SUPER_out) AS SUPER_sage, zeroifnull(c.T1TAN_IN) - zeroifnull(c.T1TAN_out) AS T1TAN_sage, zeroifnull(c.CALSCD_IN) - zeroifnull(c.CALSCD_out) AS CALSCD_sage, zeroifnull(c.CALMAX_IN) - zeroifnull(c.CALMAX_out) AS CALMAX_sage, zeroifnull(c.OGKANR_IN) - zeroifnull(c.OGKANR_out) AS OGKANR_sage, zeroifnull(c.IMP1_IN) - zeroifnull(c.IMP1_out) AS IMP1_sage, zeroifnull(c.IMP2_IN) - zeroifnull(c.IMP2_out) AS IMP2_sage, zeroifnull(c.IMP3_IN) - zeroifnull(c.IMP3_out) AS IMP3_sage, zeroifnull(c.FBLMEX_IN) - zeroifnull(c.FBLMEX_out) AS FBLMEX_sage, zeroifnull(c.FBLBBU_IN) - zeroifnull(c.FBLBBU_out) AS FBLBBU_sage, zeroifnull(c.OPALRF_IN) - zeroifnull(c.OPALRF_out) AS OPALRF_sage, zeroifnull(c.FBLSLE_IN) - zeroifnull(c.FBLSLE_out) AS FBLSLE_sage, zeroifnull(c.OGKARU_IN) - zeroifnull(c.OGKARU_out) AS OGKARU_sage, zeroifnull(c.PHI_IN) - zeroifnull(c.PHI_out) AS PHI_sage, zeroifnull(c.CALSHIP_IN) - zeroifnull(c.CALSHIP_out) AS CALSHIP_sage, --- zeroifnull(e.OPALJ_IN) - zeroifnull(e.OPALJ_out) AS OPALJ_sb, zeroifnull(e.PX5_IN) - zeroifnull(e.PX5_out) AS PX5_sb, zeroifnull(e.VZUSOP_IN) - zeroifnull(e.VZUSOP_out) AS VZUSOP_sb, zeroifnull(e.CALCH_IN) - zeroifnull(e.CALCH_out) AS CALCH_sb, zeroifnull(e.OGKATP_IN) - zeroifnull(e.OGKATP_out) AS OGKATP_sb, zeroifnull(e.PX4_IN) - zeroifnull(e.PX4_out) AS PX4_sb, zeroifnull(e.OPALJJ_IN) - zeroifnull(e.OPALJJ_out) AS OPALJJ_sb, zeroifnull(e.FBLBPL_IN) - zeroifnull(e.FBLBPL_out) AS FBLBPL_sb, zeroifnull(e.CALG_IN) - zeroifnull(e.CALG_out) AS CALG_sb, zeroifnull(e.PF4_IN) - zeroifnull(e.PF4_out) AS PF4_sb, zeroifnull(e.FBLEGR_IN) - zeroifnull(e.FBLEGR_out) AS FBLEGR_sb, zeroifnull(e.OM_IN) - zeroifnull(e.OM_out) AS OM_sb, zeroifnull(e.PR8_IN) - zeroifnull(e.PR8_out) AS PR8_sb, zeroifnull(e.VZUSAM_IN) - zeroifnull(e.VZUSAM_out) AS VZUSAM_sb, zeroifnull(e.PC9_IN) - zeroifnull(e.PC9_out) AS PC9_sb, zeroifnull(e.PC11_IN) - zeroifnull(e.PC11_out) AS PC11_sb, zeroifnull(e.CHI_IN) - zeroifnull(e.CHI_out) AS CHI_sb, zeroifnull(e.OGKAJA_IN) - zeroifnull(e.OGKAJA_out) AS OGKAJA_sb, zeroifnull(e.CALEV_IN) - zeroifnull(e.CALEV_out) AS CALEV_sb, zeroifnull(e.TUFAFE_IN) - zeroifnull(e.TUFAFE_out) AS TUFAFE_sb, zeroifnull(e.FBLBEA_IN) - zeroifnull(e.FBLBEA_out) AS FBLBEA_sb, zeroifnull(e.PX6_IN) - zeroifnull(e.PX6_out) AS PX6_sb, zeroifnull(e.FBLEBO_IN) - zeroifnull(e.FBLEBO_out) AS FBLEBO_sb, zeroifnull(e.FBLETR_IN) - zeroifnull(e.FBLETR_out) AS FBLETR_sb, zeroifnull(e.FBLAIR_IN) - zeroifnull(e.FBLAIR_out) AS FBLAIR_sb, zeroifnull(e.OGKAMK_IN) - zeroifnull(e.OGKAMK_out) AS OGKAMK_sb, zeroifnull(e.FBLEUN_IN) - zeroifnull(e.FBLEUN_out) AS FBLEUN_sb, zeroifnull(e.ARC_IN) - zeroifnull(e.ARC_out) AS ARC_sb, zeroifnull(e.FBLLOW_IN) - zeroifnull(e.FBLLOW_out) AS FBLLOW_sb, zeroifnull(e.THRILL_IN) - zeroifnull(e.THRILL_out) AS THRILL_sb, zeroifnull(e.VZUSBA_IN) - zeroifnull(e.VZUSBA_out) AS VZUSBA_sb, zeroifnull(e.CALMED_IN) - zeroifnull(e.CALMED_out) AS CALMED_sb, zeroifnull(e.OPALBB_IN) - zeroifnull(e.OPALBB_out) AS OPALBB_sb, zeroifnull(e.CALATS_IN) - zeroifnull(e.CALATS_out) AS CALATS_sb, zeroifnull(e.PR6_IN) - zeroifnull(e.PR6_out) AS PR6_sb, zeroifnull(e.HEART_IN) - zeroifnull(e.HEART_out) AS HEART_sb, zeroifnull(e.OGKATU_IN) - zeroifnull(e.OGKATU_out) AS OGKATU_sb, zeroifnull(e.FBLMAM_IN) - zeroifnull(e.FBLMAM_out) AS FBLMAM_sb, zeroifnull(e.VZUSSO_IN) - zeroifnull(e.VZUSSO_out) AS VZUSSO_sb, zeroifnull(e.FBLBTA_IN) - zeroifnull(e.FBLBTA_out) AS FBLBTA_sb, zeroifnull(e.OGKASP_IN) - zeroifnull(e.OGKASP_out) AS OGKASP_sb, zeroifnull(e.PD9_IN) - zeroifnull(e.PD9_out) AS PD9_sb, zeroifnull(e.STAND_IN) - zeroifnull(e.STAND_out) AS STAND_sb, zeroifnull(e.SUPER_IN) - zeroifnull(e.SUPER_out) AS SUPER_sb, zeroifnull(e.T1TAN_IN) - zeroifnull(e.T1TAN_out) AS T1TAN_sb, zeroifnull(e.CALSCD_IN) - zeroifnull(e.CALSCD_out) AS CALSCD_sb, zeroifnull(e.CALMAX_IN) - zeroifnull(e.CALMAX_out) AS CALMAX_sb, zeroifnull(e.OGKANR_IN) - zeroifnull(e.OGKANR_out) AS OGKANR_sb, zeroifnull(e.IMP1_IN) - zeroifnull(e.IMP1_out) AS IMP1_sb, zeroifnull(e.IMP2_IN) - zeroifnull(e.IMP2_out) AS IMP2_sb, zeroifnull(e.IMP3_IN) - zeroifnull(e.IMP3_out) AS IMP3_sb, zeroifnull(e.FBLMEX_IN) - zeroifnull(e.FBLMEX_out) AS FBLMEX_sb, zeroifnull(e.FBLBBU_IN) - zeroifnull(e.FBLBBU_out) AS FBLBBU_sb, zeroifnull(e.OPALRF_IN) - zeroifnull(e.OPALRF_out) AS OPALRF_sb, zeroifnull(e.FBLSLE_IN) - zeroifnull(e.FBLSLE_out) AS FBLSLE_sb, zeroifnull(e.OGKARU_IN) - zeroifnull(e.OGKARU_out) AS OGKARU_sb, zeroifnull(e.PHI_IN) - zeroifnull(e.PHI_out) AS PHI_sb, zeroifnull(e.CALSHIP_IN) - zeroifnull(e.CALSHIP_out) AS CALSHIP_sb, zeroifnull(a.CS1_IN) - zeroifnull(b.CS1_out) as CS1_score, zeroifnull(a.CS2_IN) - zeroifnull(b.CS2_out) as CS2_score, zeroifnull(a.CS3_IN) - zeroifnull(b.CS3_out) as CS3_score, zeroifnull(a.CS4_IN) - zeroifnull(b.CS4_out) as CS4_score, zeroifnull(a.CS5_IN) - zeroifnull(b.CS5_out) as CS5_score FROM ac1 left outer join score_in x using (wallet) left outer join score_out y using (wallet) left outer join fc_in a using (wallet) left outer join fc_out b using (wallet) left outer join sage_in c using (wallet) left outer join sb_in e using (wallet) group by ALL ), ships_weight as( Select wallet, OPALJ * OPALJ_vwap AS OPALJ_weight, PX5 * PX5_vwap AS PX5_weight, VZUSOP * VZUSOP_vwap AS VZUSOP_weight, CALCH * CALCH_vwap AS CALCH_weight, OGKATP * OGKATP_vwap AS OGKATP_weight, PX4 * PX4_vwap AS PX4_weight, OPALJJ * OPALJJ_vwap AS OPALJJ_weight, FBLBPL * FBLBPL_vwap AS FBLBPL_weight, CALG * CALG_vwap AS CALG_weight, PF4 * PF4_vwap AS PF4_weight, FBLEGR * FBLEGR_vwap AS FBLEGR_weight, OM * OM_vwap AS OM_weight, PR8 * PR8_vwap AS PR8_weight, VZUSAM * VZUSAM_vwap AS VZUSAM_weight, PC9 * PC9_vwap AS PC9_weight, PC11 * PC11_vwap AS PC11_weight, CHI * CHI_vwap AS CHI_weight, OGKAJA * OGKAJA_vwap AS OGKAJA_weight, CALEV * CALEV_vwap AS CALEV_weight, TUFAFE * TUFAFE_vwap AS TUFAFE_weight, FBLBEA * FBLBEA_vwap AS FBLBEA_weight, PX6 * PX6_vwap AS PX6_weight, FBLEBO * FBLEBO_vwap AS FBLEBO_weight, FBLETR * FBLETR_vwap AS FBLETR_weight, FBLAIR * FBLAIR_vwap AS FBLAIR_weight, OGKAMK * OGKAMK_vwap AS OGKAMK_weight, FBLEUN * FBLEUN_vwap AS FBLEUN_weight, ARC * ARC_vwap AS ARC_weight, FBLLOW * FBLLOW_vwap AS FBLLOW_weight, THRILL * THRILL_vwap AS THRILL_weight, VZUSBA * VZUSBA_vwap AS VZUSBA_weight, CALMED * CALMED_vwap AS CALMED_weight, OPALBB * OPALBB_vwap AS OPALBB_weight, CALATS * CALATS_vwap AS CALATS_weight, PR6 * PR6_vwap AS PR6_weight, HEART * HEART_vwap AS HEART_weight, OGKATU * OGKATU_vwap AS OGKATU_weight, FBLMAM * FBLMAM_vwap AS FBLMAM_weight, VZUSSO * VZUSSO_vwap AS VZUSSO_weight, FBLBTA * FBLBTA_vwap AS FBLBTA_weight, OGKASP * OGKASP_vwap AS OGKASP_weight, PD9 * PD9_vwap AS PD9_weight, STAND * STAND_vwap AS STAND_weight, SUPER * SUPER_vwap AS SUPER_weight, T1TAN * T1TAN_vwap AS T1TAN_weight, zeroifnull(CALSCD) * CALSCD_vwap AS CALSCD_weight, zeroifnull(CALMAX) * CALMAX_vwap AS CALMAX_weight, zeroifnull(OGKANR) * OGKANR_vwap AS OGKANR_weight, zeroifnull(IMP1) * IMP1_vwap AS IMP1_weight, zeroifnull(IMP2) * IMP2_vwap AS IMP2_weight, zeroifnull(IMP3) * IMP3_vwap AS IMP3_weight, zeroifnull(FBLMEX) * FBLMEX_vwap AS FBLMEX_weight, zeroifnull(FBLBBU) * FBLBBU_vwap AS FBLBBU_weight, zeroifnull(OPALRF) * OPALRF_vwap AS OPALRF_weight, zeroifnull(FBLSLE) * FBLSLE_vwap AS FBLSLE_weight, zeroifnull(OGKARU) * OGKARU_vwap AS OGKARU_weight, zeroifnull(PHI) * PHI_vwap AS PHI_weight, zeroifnull(CALSHIP) * CALSHIP_vwap AS CALSHIP_weight, --- score ----- OPALJ_score * OPALJ_vwap AS OPALJ_weight_score, PX5_score * PX5_vwap AS PX5_weight_score, VZUSOP_score * VZUSOP_vwap AS VZUSOP_weight_score, CALCH_score * CALCH_vwap AS CALCH_weight_score, OGKATP_score * OGKATP_vwap AS OGKATP_weight_score, PX4_score * PX4_vwap AS PX4_weight_score, OPALJJ_score * OPALJJ_vwap AS OPALJJ_weight_score, FBLBPL_score * FBLBPL_vwap AS FBLBPL_weight_score, CALG_score * CALG_vwap AS CALG_weight_score, PF4_score * PF4_vwap AS PF4_weight_score, FBLEGR_score * FBLEGR_vwap AS FBLEGR_weight_score, OM_score * OM_vwap AS OM_weight_score, PR8_score * PR8_vwap AS PR8_weight_score, VZUSAM_score * VZUSAM_vwap AS VZUSAM_weight_score, PC9_score * PC9_vwap AS PC9_weight_score, PC11_score * PC11_vwap AS PC11_weight_score, CHI_score * CHI_vwap AS CHI_weight_score, OGKAJA_score * OGKAJA_vwap AS OGKAJA_weight_score, CALEV_score * CALEV_vwap AS CALEV_weight_score, TUFAFE_score * TUFAFE_vwap AS TUFAFE_weight_score, FBLBEA_score * FBLBEA_vwap AS FBLBEA_weight_score, PX6_score * PX6_vwap AS PX6_weight_score, FBLEBO_score * FBLEBO_vwap AS FBLEBO_weight_score, FBLETR_score * FBLETR_vwap AS FBLETR_weight_score, FBLAIR_score * FBLAIR_vwap AS FBLAIR_weight_score, OGKAMK_score * OGKAMK_vwap AS OGKAMK_weight_score, FBLEUN_score * FBLEUN_vwap AS FBLEUN_weight_score, ARC_score * ARC_vwap AS ARC_weight_score, FBLLOW_score * FBLLOW_vwap AS FBLLOW_weight_score, THRILL_score * THRILL_vwap AS THRILL_weight_score, VZUSBA_score * VZUSBA_vwap AS VZUSBA_weight_score, CALMED_score * CALMED_vwap AS CALMED_weight_score, OPALBB_score * OPALBB_vwap AS OPALBB_weight_score, CALATS_score * CALATS_vwap AS CALATS_weight_score, PR6_score * PR6_vwap AS PR6_weight_score, HEART_score * HEART_vwap AS HEART_weight_score, OGKATU_score * OGKATU_vwap AS OGKATU_weight_score, FBLMAM_score * FBLMAM_vwap AS FBLMAM_weight_score, VZUSSO_score * VZUSSO_vwap AS VZUSSO_weight_score, FBLBTA_score * FBLBTA_vwap AS FBLBTA_weight_score, OGKASP_score * OGKASP_vwap AS OGKASP_weight_score, PD9_score * PD9_vwap AS PD9_weight_score, STAND_score * STAND_vwap AS STAND_weight_score, SUPER_score * SUPER_vwap AS SUPER_weight_score, T1TAN_score * T1TAN_vwap AS T1TAN_weight_score, CALSCD_score * CALSCD_vwap AS CALSCD_weight_score, CALMAX_score * CALMAX_vwap AS CALMAX_weight_score, OGKANR_score * OGKANR_vwap AS OGKANR_weight_score, IMP1_score * IMP1_vwap AS IMP1_weight_score, IMP2_score * IMP2_vwap AS IMP2_weight_score, IMP3_score * IMP3_vwap AS IMP3_weight_score, FBLMEX_score * FBLMEX_vwap AS FBLMEX_weight_score, FBLBBU_score * FBLBBU_vwap AS FBLBBU_weight_score, OPALRF_score * OPALRF_vwap AS OPALRF_weight_score, FBLSLE_score * FBLSLE_vwap AS FBLSLE_weight_score, OGKARU_score * OGKARU_vwap AS OGKARU_weight_score, PHI_score * PHI_vwap AS PHI_weight_score, zeroifnull(CALSHIP_score) * CALSHIP_vwap AS CALSHIP_weight_score, --- OPALJ_sage * OPALJ_vwap AS OPALJ_weight_sage, PX5_sage * PX5_vwap AS PX5_weight_sage, VZUSOP_sage * VZUSOP_vwap AS VZUSOP_weight_sage, CALCH_sage * CALCH_vwap AS CALCH_weight_sage, OGKATP_sage * OGKATP_vwap AS OGKATP_weight_sage, PX4_sage * PX4_vwap AS PX4_weight_sage, OPALJJ_sage * OPALJJ_vwap AS OPALJJ_weight_sage, FBLBPL_sage * FBLBPL_vwap AS FBLBPL_weight_sage, CALG_sage * CALG_vwap AS CALG_weight_sage, PF4_sage * PF4_vwap AS PF4_weight_sage, FBLEGR_sage * FBLEGR_vwap AS FBLEGR_weight_sage, OM_sage * OM_vwap AS OM_weight_sage, PR8_sage * PR8_vwap AS PR8_weight_sage, VZUSAM_sage * VZUSAM_vwap AS VZUSAM_weight_sage, PC9_sage * PC9_vwap AS PC9_weight_sage, PC11_sage * PC11_vwap AS PC11_weight_sage, CHI_sage * CHI_vwap AS CHI_weight_sage, OGKAJA_sage * OGKAJA_vwap AS OGKAJA_weight_sage, CALEV_sage * CALEV_vwap AS CALEV_weight_sage, TUFAFE_sage * TUFAFE_vwap AS TUFAFE_weight_sage, FBLBEA_sage * FBLBEA_vwap AS FBLBEA_weight_sage, PX6_sage * PX6_vwap AS PX6_weight_sage, FBLEBO_sage * FBLEBO_vwap AS FBLEBO_weight_sage, FBLETR_sage * FBLETR_vwap AS FBLETR_weight_sage, FBLAIR_sage * FBLAIR_vwap AS FBLAIR_weight_sage, OGKAMK_sage * OGKAMK_vwap AS OGKAMK_weight_sage, FBLEUN_sage * FBLEUN_vwap AS FBLEUN_weight_sage, ARC_sage * ARC_vwap AS ARC_weight_sage, FBLLOW_sage * FBLLOW_vwap AS FBLLOW_weight_sage, THRILL_sage * THRILL_vwap AS THRILL_weight_sage, VZUSBA_sage * VZUSBA_vwap AS VZUSBA_weight_sage, CALMED_sage * CALMED_vwap AS CALMED_weight_sage, OPALBB_sage * OPALBB_vwap AS OPALBB_weight_sage, CALATS_sage * CALATS_vwap AS CALATS_weight_sage, PR6_sage * PR6_vwap AS PR6_weight_sage, HEART_sage * HEART_vwap AS HEART_weight_sage, OGKATU_sage * OGKATU_vwap AS OGKATU_weight_sage, FBLMAM_sage * FBLMAM_vwap AS FBLMAM_weight_sage, VZUSSO_sage * VZUSSO_vwap AS VZUSSO_weight_sage, FBLBTA_sage * FBLBTA_vwap AS FBLBTA_weight_sage, OGKASP_sage * OGKASP_vwap AS OGKASP_weight_sage, PD9_sage * PD9_vwap AS PD9_weight_sage, STAND_sage * STAND_vwap AS STAND_weight_sage, SUPER_sage * SUPER_vwap AS SUPER_weight_sage, T1TAN_sage * T1TAN_vwap AS T1TAN_weight_sage, CALSCD_sage * CALSCD_vwap AS CALSCD_weight_sage, CALMAX_sage * CALMAX_vwap AS CALMAX_weight_sage, OGKANR_sage * OGKANR_vwap AS OGKANR_weight_sage, IMP1_sage * IMP1_vwap AS IMP1_weight_sage, IMP2_sage * IMP2_vwap AS IMP2_weight_sage, IMP3_sage * IMP3_vwap AS IMP3_weight_sage, FBLMEX_sage * FBLMEX_vwap AS FBLMEX_weight_sage, FBLBBU_sage * FBLBBU_vwap AS FBLBBU_weight_sage, OPALRF_sage * OPALRF_vwap AS OPALRF_weight_sage, FBLSLE_sage * FBLSLE_vwap AS FBLSLE_weight_sage, OGKARU_sage * OGKARU_vwap AS OGKARU_weight_sage, PHI_sage * PHI_vwap AS PHI_weight_sage, zeroifnull(CALSHIP_sage) * CALSHIP_vwap AS CALSHIP_weight_sage, --- OPALJ_sb * OPALJ_vwap AS OPALJ_weight_sb, PX5_sb * PX5_vwap AS PX5_weight_sb, VZUSOP_sb * VZUSOP_vwap AS VZUSOP_weight_sb, CALCH_sb * CALCH_vwap AS CALCH_weight_sb, OGKATP_sb * OGKATP_vwap AS OGKATP_weight_sb, PX4_sb * PX4_vwap AS PX4_weight_sb, OPALJJ_sb * OPALJJ_vwap AS OPALJJ_weight_sb, FBLBPL_sb * FBLBPL_vwap AS FBLBPL_weight_sb, CALG_sb * CALG_vwap AS CALG_weight_sb, PF4_sb * PF4_vwap AS PF4_weight_sb, FBLEGR_sb * FBLEGR_vwap AS FBLEGR_weight_sb, OM_sb * OM_vwap AS OM_weight_sb, PR8_sb * PR8_vwap AS PR8_weight_sb, VZUSAM_sb * VZUSAM_vwap AS VZUSAM_weight_sb, PC9_sb * PC9_vwap AS PC9_weight_sb, PC11_sb * PC11_vwap AS PC11_weight_sb, CHI_sb * CHI_vwap AS CHI_weight_sb, OGKAJA_sb * OGKAJA_vwap AS OGKAJA_weight_sb, CALEV_sb * CALEV_vwap AS CALEV_weight_sb, TUFAFE_sb * TUFAFE_vwap AS TUFAFE_weight_sb, FBLBEA_sb * FBLBEA_vwap AS FBLBEA_weight_sb, PX6_sb * PX6_vwap AS PX6_weight_sb, FBLEBO_sb * FBLEBO_vwap AS FBLEBO_weight_sb, FBLETR_sb * FBLETR_vwap AS FBLETR_weight_sb, FBLAIR_sb * FBLAIR_vwap AS FBLAIR_weight_sb, OGKAMK_sb * OGKAMK_vwap AS OGKAMK_weight_sb, FBLEUN_sb * FBLEUN_vwap AS FBLEUN_weight_sb, ARC_sb * ARC_vwap AS ARC_weight_sb, FBLLOW_sb * FBLLOW_vwap AS FBLLOW_weight_sb, THRILL_sb * THRILL_vwap AS THRILL_weight_sb, VZUSBA_sb * VZUSBA_vwap AS VZUSBA_weight_sb, CALMED_sb * CALMED_vwap AS CALMED_weight_sb, OPALBB_sb * OPALBB_vwap AS OPALBB_weight_sb, CALATS_sb * CALATS_vwap AS CALATS_weight_sb, PR6_sb * PR6_vwap AS PR6_weight_sb, HEART_sb * HEART_vwap AS HEART_weight_sb, OGKATU_sb * OGKATU_vwap AS OGKATU_weight_sb, FBLMAM_sb * FBLMAM_vwap AS FBLMAM_weight_sb, VZUSSO_sb * VZUSSO_vwap AS VZUSSO_weight_sb, FBLBTA_sb * FBLBTA_vwap AS FBLBTA_weight_sb, OGKASP_sb * OGKASP_vwap AS OGKASP_weight_sb, PD9_sb * PD9_vwap AS PD9_weight_sb, STAND_sb * STAND_vwap AS STAND_weight_sb, SUPER_sb * SUPER_vwap AS SUPER_weight_sb, T1TAN_sb * T1TAN_vwap AS T1TAN_weight_sb, CALSCD_sb * CALSCD_vwap AS CALSCD_weight_sb, CALMAX_sb * CALMAX_vwap AS CALMAX_weight_sb, OGKANR_sb * OGKANR_vwap AS OGKANR_weight_sb, IMP1_sb * IMP1_vwap AS IMP1_weight_sb, IMP2_sb * IMP2_vwap AS IMP2_weight_sb, IMP3_sb * IMP3_vwap AS IMP3_weight_sb, FBLMEX_sb * FBLMEX_vwap AS FBLMEX_weight_sb, FBLBBU_sb * FBLBBU_vwap AS FBLBBU_weight_sb, OPALRF_sb * OPALRF_vwap AS OPALRF_weight_sb, FBLSLE_sb * FBLSLE_vwap AS FBLSLE_weight_sb, OGKARU_sb * OGKARU_vwap AS OGKARU_weight_sb, PHI_sb * PHI_vwap AS PHI_weight_sb, CALSHIP_sb * CALSHIP_vwap AS CALSHIP_weight_sb, CS1_score * CS1_vwap AS CS1_weight_score, CS2_score * CS2_vwap AS CS2_weight_score, CS3_score * CS3_vwap AS CS3_weight_score, CS4_score * CS4_vwap AS CS4_weight_score, CS5_score * CS5_vwap AS CS5_weight_score FROM ships_staked left outer join ships_data left outer join cs_data group by ALL), final AS ( SELECT wallet, (OPALJ_weight + PX5_weight + VZUSOP_weight + CALCH_weight + OGKATP_weight + PX4_weight + OPALJJ_weight + FBLBPL_weight + CALG_weight + PF4_weight + FBLEGR_weight + OM_weight + PR8_weight + VZUSAM_weight + PC9_weight + PC11_weight + CHI_weight + OGKAJA_weight + CALEV_weight + TUFAFE_weight + FBLBEA_weight + PX6_weight + FBLEBO_weight + FBLETR_weight + FBLAIR_weight + OGKAMK_weight + FBLEUN_weight + ARC_weight + FBLLOW_weight + THRILL_weight + VZUSBA_weight + CALMED_weight + OPALBB_weight + CALATS_weight + PR6_weight + HEART_weight + OGKATU_weight + FBLMAM_weight + VZUSSO_weight + FBLBTA_weight + OGKASP_weight + PD9_weight + STAND_weight + SUPER_weight + T1TAN_weight + CALSCD_weight + CALMAX_weight + OGKANR_weight + IMP1_weight + IMP2_weight + IMP3_weight + FBLMEX_weight + FBLBBU_weight + OPALRF_weight + FBLSLE_weight + OGKARU_weight + PHI_weight + CALSHIP_weight) as ships_vwap_global, (OPALJ_weight_score + PX5_weight_score + VZUSOP_weight_score + CALCH_weight_score + OGKATP_weight_score + PX4_weight_score + OPALJJ_weight_score + FBLBPL_weight_score + CALG_weight_score + PF4_weight_score + FBLEGR_weight_score + OM_weight_score + PR8_weight_score + VZUSAM_weight_score + PC9_weight_score + PC11_weight_score + CHI_weight_score + OGKAJA_weight_score + CALEV_weight_score + TUFAFE_weight_score + FBLBEA_weight_score + PX6_weight_score + FBLEBO_weight_score + FBLETR_weight_score + FBLAIR_weight_score + OGKAMK_weight_score + FBLEUN_weight_score + ARC_weight_score + FBLLOW_weight_score + THRILL_weight_score + VZUSBA_weight_score + CALMED_weight_score + OPALBB_weight_score + CALATS_weight_score + PR6_weight_score + HEART_weight_score + OGKATU_weight_score + FBLMAM_weight_score + VZUSSO_weight_score + FBLBTA_weight_score + OGKASP_weight_score + PD9_weight_score + STAND_weight_score + SUPER_weight_score + T1TAN_weight_score + CALSCD_weight_score + CALMAX_weight_score + OGKANR_weight_score + IMP1_weight_score + IMP2_weight_score + IMP3_weight_score + FBLMEX_weight_score + FBLBBU_weight_score + OPALRF_weight_score + FBLSLE_weight_score + OGKARU_weight_score + PHI_weight_score + CALSHIP_weight_score) as ships_vwap_score, --- (OPALJ_weight_sage + PX5_weight_sage + VZUSOP_weight_sage + CALCH_weight_sage + OGKATP_weight_sage + PX4_weight_sage + OPALJJ_weight_sage + FBLBPL_weight_sage + CALG_weight_sage + PF4_weight_sage + FBLEGR_weight_sage + OM_weight_sage + PR8_weight_sage + VZUSAM_weight_sage + PC9_weight_sage + PC11_weight_sage + CHI_weight_sage + OGKAJA_weight_sage + CALEV_weight_sage + TUFAFE_weight_sage + FBLBEA_weight_sage + PX6_weight_sage + FBLEBO_weight_sage + FBLETR_weight_sage + FBLAIR_weight_sage + OGKAMK_weight_sage + FBLEUN_weight_sage + ARC_weight_sage + FBLLOW_weight_sage + THRILL_weight_sage + VZUSBA_weight_sage + CALMED_weight_sage + OPALBB_weight_sage + CALATS_weight_sage + PR6_weight_sage + HEART_weight_sage + OGKATU_weight_sage + FBLMAM_weight_sage + VZUSSO_weight_sage + FBLBTA_weight_sage + OGKASP_weight_sage + PD9_weight_sage + STAND_weight_sage + SUPER_weight_sage + T1TAN_weight_sage + CALSCD_weight_sage + CALMAX_weight_sage + OGKANR_weight_sage + IMP1_weight_sage + IMP2_weight_sage + IMP3_weight_sage + FBLMEX_weight_sage + FBLBBU_weight_sage + OPALRF_weight_sage + FBLSLE_weight_sage + OGKARU_weight_sage + PHI_weight_sage + CALSHIP_weight_sage) as ships_vwap_sage, --- (OPALJ_weight_sb + PX5_weight_sb + VZUSOP_weight_sb + CALCH_weight_sb + OGKATP_weight_sb + PX4_weight_sb + OPALJJ_weight_sb + FBLBPL_weight_sb + CALG_weight_sb + PF4_weight_sb + FBLEGR_weight_sb + OM_weight_sb + PR8_weight_sb + VZUSAM_weight_sb + PC9_weight_sb + PC11_weight_sb + CHI_weight_sb + OGKAJA_weight_sb + CALEV_weight_sb + TUFAFE_weight_sb + FBLBEA_weight_sb + PX6_weight_sb + FBLEBO_weight_sb + FBLETR_weight_sb + FBLAIR_weight_sb + OGKAMK_weight_sb + FBLEUN_weight_sb + ARC_weight_sb + FBLLOW_weight_sb + THRILL_weight_sb + VZUSBA_weight_sb + CALMED_weight_sb + OPALBB_weight_sb + CALATS_weight_sb + PR6_weight_sb + HEART_weight_sb + OGKATU_weight_sb + FBLMAM_weight_sb + VZUSSO_weight_sb + FBLBTA_weight_sb + OGKASP_weight_sb + PD9_weight_sb + STAND_weight_sb + SUPER_weight_sb + T1TAN_weight_sb + CALSCD_weight_sb + CALMAX_weight_sb + OGKANR_weight_sb + IMP1_weight_sb + IMP2_weight_sb + IMP3_weight_sb + FBLMEX_weight_sb + FBLBBU_weight_sb + OPALRF_weight_sb + FBLSLE_weight_sb + OGKARU_weight_sb + PHI_weight_sb + CALSHIP_weight_sb) as ships_vwap_sb, --- (CS1_weight_score + CS2_weight_score + CS3_weight_score + CS4_weight_score + CS5_weight_score) AS cs_vwap_global_score FROM ships_weight group by ALL ), xx12 as ( SELECT block_timestamp, signers[0] as wallet, zeroifnull(value:parsed:info:amount/pow(10,8)) as value from solana.core.fact_events, lateral flatten(input => inner_instruction:instructions) WHERE program_id = 'SAGE2HAwep459SNq61LHvjxPk4pLPEJLoMETef7f7EE' AND block_timestamp >= '2024-04-01' and value:parsed:type = 'transfer' and value:parsed:info:destination = '5XJei3jBZi8WuqDGUQ5KCe8t72vMRMTWLr6ok3hhXE2R' and value:parsed:info:authority != signers[0] and value:parsed:info:amount > 0 ), s9 as ( SELECT wallet, sum(zeroifnull(value*prices.close)) as starbase_dao_fees FROM xx12 left join prices on date_trunc('day', xx12.block_timestamp) = prices.date WHERE prices.mints = 'ATLASXmbPQxBUYbxPsV97usA3fPQYEqzQBUHgiFCUsXx' GROUP BY 1 ), -- s12a as ( -- SELECT -- block_timestamp, -- signers[0] as wallet, -- instruction:accounts[13] as currency, -- zeroifnull(value:parsed:info:amount) as value -- from solana.core.fact_events, lateral flatten(input => inner_instruction:instructions) -- WHERE -- PROGRAM_ID = 'BUDDYtQp7Di1xfojiCSVDksiYLQx511DPdj2nbtG9Yu5' -- AND block_timestamp >= current_date - 30 --AND block_timestamp < current_date -- and value:parsed:info:destination NOT IN ('DhSBEiDX3vR72U4FrHZtf1FoYKrtAHAkcavQf3rcbg4d','4TttCmZQgjrd7qzWbUFSBxJBqqHS5rQPbGTxy2aKMNnY') -- and instruction:accounts[13] in ('ATLASXmbPQxBUYbxPsV97usA3fPQYEqzQBUHgiFCUsXx','EPjFWdd5AufqSSqeM2qN1xzybapC8G4wEGGkZwyTDt1v') -- ), -- s12 as ( -- SELECT -- wallet, -- SUM(CASE WHEN currency = 'ATLASXmbPQxBUYbxPsV97usA3fPQYEqzQBUHgiFCUsXx' -- THEN zeroifnull(value/pow(10,8)*prices.close) ELSE 0 END) AS referral_atlas_in_usd, -- SUM(CASE WHEN currency = 'EPjFWdd5AufqSSqeM2qN1xzybapC8G4wEGGkZwyTDt1v' -- THEN zeroifnull(value/pow(10,6)) ELSE 0 END) AS referral_usd -- FROM s12a -- left join prices on date_trunc('day', s12a.block_timestamp) = prices.date -- and s12a.currency = prices.mints -- GROUP BY 1 -- ), sb_tx as ( SELECT DISTINCT tx_id from solana.core.fact_events x WHERE program_id::string IN ('FLEET1qqzpexyaDpqb2DGsSzE2sDCizewCg9WjrA6DBW','SAGEqqFewepDHH6hMDcmWy7yjHPpyKLDnRXKb3Ki8e6', 'SAGE2HAwep459SNq61LHvjxPk4pLPEJLoMETef7f7EE','traderDnaR5w6Tcoi3NFm53i48FTDNbGjBSZwWXDRrg','gateVwTnKyFrE8nxUUgfzoZTPKgJQZUbLsEidpG4Dp2','ATLocKpzDbTokxgvnLew3d7drZkEzLzDpzwgrgWKDbmc') AND block_timestamp >= current_date - 30 --AND block_timestamp < current_date ), s14 as ( SELECT f.signers[0] as wallet, -- date_trunc('day',f.block_timestamp) as date, round(SUM(f.fee*prices.price/POW(10,9)),2) as tx_fees from solana.core.fact_transactions f left join solana.price.ez_prices_hourly prices on DATE_TRUNC('hour', f.BLOCK_TIMESTAMP) = prices.hour and prices.TOKEN_ADDRESS = 'So11111111111111111111111111111111111111112' WHERE f.tx_id in (SELECT tx_id FROM sb_tx) AND f.block_timestamp >= current_date - 30 --AND block_timestamp < current_date GROUP BY 1 ), -- s14 as ( -- SELECT -- x.signers[0] as wallet, -- round(SUM(f.fee*prices.price/POW(10,9)),2) as tx_fees -- from solana.core.fact_events x -- INNER JOIN solana.core.fact_transactions f using(tx_id,block_timestamp) -- left join solana.price.ez_prices_hourly prices on DATE_TRUNC('hour', f.BLOCK_TIMESTAMP) = prices.hour -- and prices.TOKEN_ADDRESS = 'So11111111111111111111111111111111111111112' -- WHERE program_id::string IN ('FLEET1qqzpexyaDpqb2DGsSzE2sDCizewCg9WjrA6DBW','SAGEqqFewepDHH6hMDcmWy7yjHPpyKLDnRXKb3Ki8e6', -- 'SAGE2HAwep459SNq61LHvjxPk4pLPEJLoMETef7f7EE','traderDnaR5w6Tcoi3NFm53i48FTDNbGjBSZwWXDRrg','gateVwTnKyFrE8nxUUgfzoZTPKgJQZUbLsEidpG4Dp2','ATLocKpzDbTokxgvnLew3d7drZkEzLzDpzwgrgWKDbmc') -- AND x.block_timestamp >= current_date - 30 --AND block_timestamp < current_date -- AND f.block_timestamp >= current_date - 30 --AND block_timestamp < current_date -- GROUP BY 1 -- ), ac2 as ( SELECT DISTINCT * FROM ( SELECT resource_type FROM s1 UNION SELECT resource_type FROM s2 )), ac AS ( SELECT wallet, resource_type FROM ac1 CROSS JOIN ac2 ), ff as ( SELECT ac.wallet, sum(zeroifnull(usd_value_sold)) as rs_sold, sum(zeroifnull(usd_value_purchased)) as rs_pur, round(sum(zeroifnull(usd_value_sold) - zeroifnull(usd_value_purchased)),2) as net_resource_rec, round(sum(CASE WHEN ac.resource_type = 'R4' then zeroifnull(usd_value_sold) - zeroifnull(usd_value_purchased) else 0 end),2) as r4, round(sum(CASE WHEN ac.resource_type = 'R9' then zeroifnull(usd_value_sold) - zeroifnull(usd_value_purchased) else 0 end),2) as r9, round(sum(CASE WHEN ac.resource_type = 'SDU' then zeroifnull(usd_value_sold) - zeroifnull(usd_value_purchased) else 0 end),2) as sdu FROM ac LEFT OUTER JOIN s1 using (wallet,resource_type) LEFT OUTER JOIN s2 using (wallet,resource_type) GROUP BY 1) SELECT ac1.wallet, round(zeroifnull(score_usd)+zeroifnull(fac_rwds)+zeroifnull(atlas_locker_rwds)+zeroifnull(polis_locker_rwds)+zeroifnull(rs_sold),2) as gross_earnings, round(zeroifnull(sage_sinks)+zeroifnull(mkt_fees)+zeroifnull(mkt_fees_usd)+zeroifnull(starbase_dao_fees)+zeroifnull(rs_pur)+ zeroifnull(tx_fees),2) as gross_expenses, gross_earnings - gross_expenses as "Net Earnings (USD)", round(zeroifnull(ships_vwap_global),2) as "Active Ship VWAP [EOP]", round(((gross_earnings - gross_expenses)/(ships_vwap_global))*100,2) as "Net Earnings (USD)/Active Ship VWAP (%)", round(zeroifnull(score_usd) +zeroifnull(fac_rwds),2) as "Gross Game Earnings", round(zeroifnull(polis_locker_rwds) + zeroifnull(atlas_locker_rwds),2) as "POLIS Rewards", round(zeroifnull(starbase_dao_fees)+zeroifnull(sage_sinks),2) as "Starbased/SAGE Fees", -- round(zeroifnull(referral_atlas_in_usd) + zeroifnull(referral_usd),2) as "Buddylink Referrals", round((zeroifnull(mkt_fees)+zeroifnull(mkt_fees_usd)),2) as "Marketplace Fees Paid", net_resource_rec as "Net Resources Sold (USD)", round(zeroifnull(cs_vwap_global_score),2) as "CS VWAP [EOP]", zeroifnull(rs_sold) as "Resources Sold", zeroifnull(rs_pur) as "Resources Purchased", r4 as "R4", r9 as "R9", sdu as "SDU", round((zeroifnull(score_usd)),2) as "SCORE Rewards", round((zeroifnull(ships_vwap_score)),2) as "SCORE VWAP [EOP]", -- round((zeroifnull(crfr)),2) as "CRFR Rewards", round((zeroifnull(ships_vwap_sage)),2) as "SAGE VWAP [EOP]", round((zeroifnull(fac_rwds)),2) as "Faction Rewards", round(zeroifnull(ships_vwap_sb),2) as "Starbased VWAP [EOP]", round((zeroifnull(sage_sinks)),2) as "SAGE Sinks", round((zeroifnull(starbase_dao_fees)),2) as "Starbased Fees", round((zeroifnull(polis_locker_rwds)),2) as "POLIS Locker Rwds", round((zeroifnull(atlas_locker_rwds)),2) as "ATLAS Locker Rwds", round((zeroifnull(tx_fees)),2) as "Transaction Fees" FROM ac1 LEFT OUTER JOIN ff using (wallet) LEFT OUTER JOIN s3 using (wallet) LEFT OUTER JOIN s4 using (wallet) -- LEFT OUTER JOIN s5 using (wallet) LEFT OUTER JOIN s6 using (wallet) LEFT OUTER JOIN s7 using (wallet) LEFT OUTER JOIN s9 using (wallet) LEFT OUTER JOIN final using (wallet) LEFT OUTER JOIN s10 using (wallet) LEFT OUTER JOIN s11 using (wallet) -- LEFT OUTER JOIN s12 using (wallet) LEFT OUTER JOIN s13 using (wallet) LEFT OUTER JOIN s14 using (wallet) WHERE ships_vwap_global > 0 ORDER BY 4 DESC; -- zeroifnull(referral_atlas_in_usd)+zeroifnull(referral_usd)+zeroifnull(crfr)

Star Atlas Investor Dashboard