AephiaMarketplace 2.0 volumes copy
Updated 2023-11-22
999
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
›
⌄
-- forked from Marketplace 2.0 volumes @ https://flipsidecrypto.xyz/edit/queries/520b0ff4-acb2-4265-a76b-32705f027cc4
WITH total_sales AS (
select
--*
date_trunc('day', block_timestamp::date) as date,
-----------------------------------------------------------------------------------------------------
sum(case WHEN inner_instruction:instructions[0]:parsed:info:mint::string IN ('Ev3xUhc1Leqi4qR2E5VoG9pcxCvHHmnAaSRVPg485xAT', '267DbhCypYzvTqv72ZG5UKHeFu56qXFsuoz3rw832eC5', '9czEqEZ4EkRt7N3HWDcw9qqwys3xRRjGdbn8Jhk8Khwj', 'AkNbg12E9PatjkiAWJ3tAbM479gtcoA1gi6Joa925WKi', 'CWxNX9sTexuqvQefqskhP9f6AP5C8hq2VNkicRseqAT5', '2iMhgB4pbdKvwJHVyitpvX5z1NBNypFonUgaSAt9dtDt', '9ABNesWj7NVdkDgko7UjVaDp5pTh8a6wfXHLWz3bZM6W', '7V9C2XUQgCb31n7hGKqKGu4ENcvqXhJLJzU77CAQtXhw', 'DdpXnnYsyUQgJby8TDHbmPwkKyGF4U6bXwCXTQZsrfKP', '9MvZS3TVfv4DZL9W2pT12po384aBHf7wi89KXQ9Z7uwW', 'FpwV1Da6BZJnYPr1JSLUm14UwBmZHA7J5WLY4TXgbde8', 'HzBx8PP86pyPrrboTHqPYWhxnEB5vXDHDBP8femWfPTS', '2bCgKTo11QayWBy6QryHZMqZL2ZgWd5LEAZKiTGQi4g7', 'H2jHqvXA2oxSpEp6dKkpK7WeszQEdFW5n25mNfrJFAc1', '5f1jUARhtSypVA4uTpgpLp76WYGdB2dGr8zMbh4WjYRf', '9ifQ16N5DdUFoejCwsgR73ihUwadAe3srCo9HhQe2zL2', 'DsJHgpnNovjJ981QJJnqMggexAekNawbSavfV1QuTpis', 'HJBmBYyGR8z1oajAM4jiK46uobuxeJoKDYpFwzWHBvhb', '4txpjHspP4usEsQTr3AcrpyHVjN4fi3d4taM6cmKJnd1', 'HsdbLvZrEgN2ZhsrZs5ag4F2FNFCHjjuXPfbVAhkeJBZ', '6SqLuwHNRC1qjo9KATLKJLszFHMWyYaNxDXraCEUtfdR', '8RveLFEyteyL1vbCKPQJxjf3JT1ACyrzs46TXbJStrHG', '7M6RHgPiHXiZAin5ManH63cLYGt3miQ54KaGynUQoERS', 'HqPN13pLUVJRiuGSsKjfWZvGKAagK98PshuKu51bnG4E', 'Fw8PqtznYtg4swMk7Yjj89Tsj23u5CJLfW5Bk8ro4G1s', 'FMHHwUB6amLWYhWxtiZHC2g5azy9usPTLMq46N3HEgFU', '9zrgra3XQkZPt8XNs4fowbqmj7B8bBx76aEmsKSnm9BW', 'EbLBLN44BVLjifLNBbchXFr8QjEkAGYENKuNEaDuyVPL', '7Xs3yt9eJPuEexZrKSGVbQMXHwWUKHGeDZnM4ZksZmyS', 'FTk1E5UoWkiZEUttCWSYYaVokxWNNp3yJ42HbNDCAkdt', 'FFkPvwLDYuKDW9eAAr5UNfuX3U9PcTGeSk7gqNX7EpNc', '4gR3ChfdQxR4BTbgeWSdf6b8kD8Ysu6WBAQqtJ9oLgbF', '8pPDsMNcz4m8jaajFMFXHGcvaeVeiQhcenvSD6a4XNyq', '2XYd22LSFGxN7kWgoEeaXVZqgrsPeQLHLEgNhnS12Mny', 'Fys8J53cquYsg5zYfeZStVGNwM9FopFw8QFkiE9CCR1J', '6HzZJwrcuBBmrE7SLDfxheZGAD3NYJ531C9JsNesL9BP', 'J8Q6jYsrhhaeczyPBo9xzVyy4GpfCnJwj14LJn2HnuKp', '6Zj61HuX1E7SCUCf9WsKXw1jdJCobAwK4RSjZvbv35tM', 'HjFijcGWKgfDwGpFX2rqFwEU9jtEgFuRQAJe1ERXFsA3', '4ns3shP4WunCtJbr2HFu31RjjxSJxDymEFcBZxiHr11s', '4b4mhSySBcryzBPamw8v4xeneFRA6xTUA4JA99w6vqey', 'H3cgBXWpUiNsYjUWS7cNR5Bmehh7k5CgpJccc5wSfRbJ', 'DB8CSxoakPRtXhHcc2cA3iETWfGaYY6zE2T8huJTE2Nw', '2BMTgfgapuqYBwSRGu6HCafwDGRVTxMkQVhYrNWQGTWH', '56nh4FvMJnSpkWJcmXc1nJtYhSQXuqb7nVMGALr31RVc', 'F3HitKsp52UPqBMEWSeTFqrGgnfYbS9DMrJCz9dM3w6D', 'GxpbUDxYYvxiUejHcAMzeV2rzdHf6KZZvT86ACrpFgXa', '7SUoWHWWJCxCe5g9XqZkCRufGHXRV8nauuz69HPjuewr', 'DTbNmLWfu1pm4AuXRKYTApnDNfxMz73VET7nW5wizG5t', 'ARNZXUQoBKx3JCX3UJB4aitSnvcjMMphN9YVDFy1PdKq', 'GmVKV9W3qZcERxk7hjqwRDcn9Kgtz3XDi7KfFLdGqyaW', 'MEXfyQHowwqoTHsN6yjfeXVaxZxALUFJAHuzY8gFiUu', 'BBUTCn3jcXKjFYuuYtY8MNo8bDg9VsZaKwaSYnRr2Qse', 'RaYfM1RLfxQJWF8RZravTshKj1aHaWBNXF94VWToY9n')
AND inner_instruction:instructions[0]:parsed:info:authority != 'MRKT9mCmNU2R4KnZt9BV5uh9MESj7Phxws4AR7fUhRc'
AND inner_instruction:instructions[1]:parsed:info:mint = 'ATLASXmbPQxBUYbxPsV97usA3fPQYEqzQBUHgiFCUsXx'
then inner_instruction:instructions[1]:parsed:info:tokenAmount:uiAmount + inner_instruction:instructions[2]:parsed:info:tokenAmount:uiAmount
WHEN inner_instruction:instructions[1]:parsed:info:mint::string IN ('Ev3xUhc1Leqi4qR2E5VoG9pcxCvHHmnAaSRVPg485xAT', '267DbhCypYzvTqv72ZG5UKHeFu56qXFsuoz3rw832eC5', '9czEqEZ4EkRt7N3HWDcw9qqwys3xRRjGdbn8Jhk8Khwj', 'AkNbg12E9PatjkiAWJ3tAbM479gtcoA1gi6Joa925WKi', 'CWxNX9sTexuqvQefqskhP9f6AP5C8hq2VNkicRseqAT5', '2iMhgB4pbdKvwJHVyitpvX5z1NBNypFonUgaSAt9dtDt', '9ABNesWj7NVdkDgko7UjVaDp5pTh8a6wfXHLWz3bZM6W', '7V9C2XUQgCb31n7hGKqKGu4ENcvqXhJLJzU77CAQtXhw', 'DdpXnnYsyUQgJby8TDHbmPwkKyGF4U6bXwCXTQZsrfKP', '9MvZS3TVfv4DZL9W2pT12po384aBHf7wi89KXQ9Z7uwW', 'FpwV1Da6BZJnYPr1JSLUm14UwBmZHA7J5WLY4TXgbde8', 'HzBx8PP86pyPrrboTHqPYWhxnEB5vXDHDBP8femWfPTS', '2bCgKTo11QayWBy6QryHZMqZL2ZgWd5LEAZKiTGQi4g7', 'H2jHqvXA2oxSpEp6dKkpK7WeszQEdFW5n25mNfrJFAc1', '5f1jUARhtSypVA4uTpgpLp76WYGdB2dGr8zMbh4WjYRf', '9ifQ16N5DdUFoejCwsgR73ihUwadAe3srCo9HhQe2zL2', 'DsJHgpnNovjJ981QJJnqMggexAekNawbSavfV1QuTpis', 'HJBmBYyGR8z1oajAM4jiK46uobuxeJoKDYpFwzWHBvhb', '4txpjHspP4usEsQTr3AcrpyHVjN4fi3d4taM6cmKJnd1', 'HsdbLvZrEgN2ZhsrZs5ag4F2FNFCHjjuXPfbVAhkeJBZ', '6SqLuwHNRC1qjo9KATLKJLszFHMWyYaNxDXraCEUtfdR', '8RveLFEyteyL1vbCKPQJxjf3JT1ACyrzs46TXbJStrHG', '7M6RHgPiHXiZAin5ManH63cLYGt3miQ54KaGynUQoERS', 'HqPN13pLUVJRiuGSsKjfWZvGKAagK98PshuKu51bnG4E', 'Fw8PqtznYtg4swMk7Yjj89Tsj23u5CJLfW5Bk8ro4G1s', 'FMHHwUB6amLWYhWxtiZHC2g5azy9usPTLMq46N3HEgFU', '9zrgra3XQkZPt8XNs4fowbqmj7B8bBx76aEmsKSnm9BW', 'EbLBLN44BVLjifLNBbchXFr8QjEkAGYENKuNEaDuyVPL', '7Xs3yt9eJPuEexZrKSGVbQMXHwWUKHGeDZnM4ZksZmyS', 'FTk1E5UoWkiZEUttCWSYYaVokxWNNp3yJ42HbNDCAkdt', 'FFkPvwLDYuKDW9eAAr5UNfuX3U9PcTGeSk7gqNX7EpNc', '4gR3ChfdQxR4BTbgeWSdf6b8kD8Ysu6WBAQqtJ9oLgbF', '8pPDsMNcz4m8jaajFMFXHGcvaeVeiQhcenvSD6a4XNyq', '2XYd22LSFGxN7kWgoEeaXVZqgrsPeQLHLEgNhnS12Mny', 'Fys8J53cquYsg5zYfeZStVGNwM9FopFw8QFkiE9CCR1J', '6HzZJwrcuBBmrE7SLDfxheZGAD3NYJ531C9JsNesL9BP', 'J8Q6jYsrhhaeczyPBo9xzVyy4GpfCnJwj14LJn2HnuKp', '6Zj61HuX1E7SCUCf9WsKXw1jdJCobAwK4RSjZvbv35tM', 'HjFijcGWKgfDwGpFX2rqFwEU9jtEgFuRQAJe1ERXFsA3', '4ns3shP4WunCtJbr2HFu31RjjxSJxDymEFcBZxiHr11s', '4b4mhSySBcryzBPamw8v4xeneFRA6xTUA4JA99w6vqey', 'H3cgBXWpUiNsYjUWS7cNR5Bmehh7k5CgpJccc5wSfRbJ', 'DB8CSxoakPRtXhHcc2cA3iETWfGaYY6zE2T8huJTE2Nw', '2BMTgfgapuqYBwSRGu6HCafwDGRVTxMkQVhYrNWQGTWH', '56nh4FvMJnSpkWJcmXc1nJtYhSQXuqb7nVMGALr31RVc', 'F3HitKsp52UPqBMEWSeTFqrGgnfYbS9DMrJCz9dM3w6D', 'GxpbUDxYYvxiUejHcAMzeV2rzdHf6KZZvT86ACrpFgXa', '7SUoWHWWJCxCe5g9XqZkCRufGHXRV8nauuz69HPjuewr', 'DTbNmLWfu1pm4AuXRKYTApnDNfxMz73VET7nW5wizG5t', 'ARNZXUQoBKx3JCX3UJB4aitSnvcjMMphN9YVDFy1PdKq', 'GmVKV9W3qZcERxk7hjqwRDcn9Kgtz3XDi7KfFLdGqyaW', 'MEXfyQHowwqoTHsN6yjfeXVaxZxALUFJAHuzY8gFiUu', 'BBUTCn3jcXKjFYuuYtY8MNo8bDg9VsZaKwaSYnRr2Qse', 'RaYfM1RLfxQJWF8RZravTshKj1aHaWBNXF94VWToY9n')
AND inner_instruction:instructions[1]:parsed:info:authority != 'MRKT9mCmNU2R4KnZt9BV5uh9MESj7Phxws4AR7fUhRc'
AND inner_instruction:instructions[0]:parsed:info:mint = 'ATLASXmbPQxBUYbxPsV97usA3fPQYEqzQBUHgiFCUsXx'
then inner_instruction:instructions[0]:parsed:info:tokenAmount:uiAmount + inner_instruction:instructions[2]:parsed:info:tokenAmount:uiAmount
WHEN inner_instruction:instructions[2]:parsed:info:mint::string IN ('Ev3xUhc1Leqi4qR2E5VoG9pcxCvHHmnAaSRVPg485xAT', '267DbhCypYzvTqv72ZG5UKHeFu56qXFsuoz3rw832eC5', '9czEqEZ4EkRt7N3HWDcw9qqwys3xRRjGdbn8Jhk8Khwj', 'AkNbg12E9PatjkiAWJ3tAbM479gtcoA1gi6Joa925WKi', 'CWxNX9sTexuqvQefqskhP9f6AP5C8hq2VNkicRseqAT5', '2iMhgB4pbdKvwJHVyitpvX5z1NBNypFonUgaSAt9dtDt', '9ABNesWj7NVdkDgko7UjVaDp5pTh8a6wfXHLWz3bZM6W', '7V9C2XUQgCb31n7hGKqKGu4ENcvqXhJLJzU77CAQtXhw', 'DdpXnnYsyUQgJby8TDHbmPwkKyGF4U6bXwCXTQZsrfKP', '9MvZS3TVfv4DZL9W2pT12po384aBHf7wi89KXQ9Z7uwW', 'FpwV1Da6BZJnYPr1JSLUm14UwBmZHA7J5WLY4TXgbde8', 'HzBx8PP86pyPrrboTHqPYWhxnEB5vXDHDBP8femWfPTS', '2bCgKTo11QayWBy6QryHZMqZL2ZgWd5LEAZKiTGQi4g7', 'H2jHqvXA2oxSpEp6dKkpK7WeszQEdFW5n25mNfrJFAc1', '5f1jUARhtSypVA4uTpgpLp76WYGdB2dGr8zMbh4WjYRf', '9ifQ16N5DdUFoejCwsgR73ihUwadAe3srCo9HhQe2zL2', 'DsJHgpnNovjJ981QJJnqMggexAekNawbSavfV1QuTpis', 'HJBmBYyGR8z1oajAM4jiK46uobuxeJoKDYpFwzWHBvhb', '4txpjHspP4usEsQTr3AcrpyHVjN4fi3d4taM6cmKJnd1', 'HsdbLvZrEgN2ZhsrZs5ag4F2FNFCHjjuXPfbVAhkeJBZ', '6SqLuwHNRC1qjo9KATLKJLszFHMWyYaNxDXraCEUtfdR', '8RveLFEyteyL1vbCKPQJxjf3JT1ACyrzs46TXbJStrHG', '7M6RHgPiHXiZAin5ManH63cLYGt3miQ54KaGynUQoERS', 'HqPN13pLUVJRiuGSsKjfWZvGKAagK98PshuKu51bnG4E', 'Fw8PqtznYtg4swMk7Yjj89Tsj23u5CJLfW5Bk8ro4G1s', 'FMHHwUB6amLWYhWxtiZHC2g5azy9usPTLMq46N3HEgFU', '9zrgra3XQkZPt8XNs4fowbqmj7B8bBx76aEmsKSnm9BW', 'EbLBLN44BVLjifLNBbchXFr8QjEkAGYENKuNEaDuyVPL', '7Xs3yt9eJPuEexZrKSGVbQMXHwWUKHGeDZnM4ZksZmyS', 'FTk1E5UoWkiZEUttCWSYYaVokxWNNp3yJ42HbNDCAkdt', 'FFkPvwLDYuKDW9eAAr5UNfuX3U9PcTGeSk7gqNX7EpNc', '4gR3ChfdQxR4BTbgeWSdf6b8kD8Ysu6WBAQqtJ9oLgbF', '8pPDsMNcz4m8jaajFMFXHGcvaeVeiQhcenvSD6a4XNyq', '2XYd22LSFGxN7kWgoEeaXVZqgrsPeQLHLEgNhnS12Mny', 'Fys8J53cquYsg5zYfeZStVGNwM9FopFw8QFkiE9CCR1J', '6HzZJwrcuBBmrE7SLDfxheZGAD3NYJ531C9JsNesL9BP', 'J8Q6jYsrhhaeczyPBo9xzVyy4GpfCnJwj14LJn2HnuKp', '6Zj61HuX1E7SCUCf9WsKXw1jdJCobAwK4RSjZvbv35tM', 'HjFijcGWKgfDwGpFX2rqFwEU9jtEgFuRQAJe1ERXFsA3', '4ns3shP4WunCtJbr2HFu31RjjxSJxDymEFcBZxiHr11s', '4b4mhSySBcryzBPamw8v4xeneFRA6xTUA4JA99w6vqey', 'H3cgBXWpUiNsYjUWS7cNR5Bmehh7k5CgpJccc5wSfRbJ', 'DB8CSxoakPRtXhHcc2cA3iETWfGaYY6zE2T8huJTE2Nw', '2BMTgfgapuqYBwSRGu6HCafwDGRVTxMkQVhYrNWQGTWH', '56nh4FvMJnSpkWJcmXc1nJtYhSQXuqb7nVMGALr31RVc', 'F3HitKsp52UPqBMEWSeTFqrGgnfYbS9DMrJCz9dM3w6D', 'GxpbUDxYYvxiUejHcAMzeV2rzdHf6KZZvT86ACrpFgXa', '7SUoWHWWJCxCe5g9XqZkCRufGHXRV8nauuz69HPjuewr', 'DTbNmLWfu1pm4AuXRKYTApnDNfxMz73VET7nW5wizG5t', 'ARNZXUQoBKx3JCX3UJB4aitSnvcjMMphN9YVDFy1PdKq', 'GmVKV9W3qZcERxk7hjqwRDcn9Kgtz3XDi7KfFLdGqyaW', 'MEXfyQHowwqoTHsN6yjfeXVaxZxALUFJAHuzY8gFiUu', 'BBUTCn3jcXKjFYuuYtY8MNo8bDg9VsZaKwaSYnRr2Qse', 'RaYfM1RLfxQJWF8RZravTshKj1aHaWBNXF94VWToY9n')
AND inner_instruction:instructions[2]:parsed:info:authority != 'MRKT9mCmNU2R4KnZt9BV5uh9MESj7Phxws4AR7fUhRc'
AND inner_instruction:instructions[0]:parsed:info:mint = 'ATLASXmbPQxBUYbxPsV97usA3fPQYEqzQBUHgiFCUsXx'
then inner_instruction:instructions[0]:parsed:info:tokenAmount:uiAmount + inner_instruction:instructions[1]:parsed:info:tokenAmount:uiAmount
WHEN inner_instruction:instructions[4]:parsed:info:mint::string IN ('Ev3xUhc1Leqi4qR2E5VoG9pcxCvHHmnAaSRVPg485xAT', '267DbhCypYzvTqv72ZG5UKHeFu56qXFsuoz3rw832eC5', '9czEqEZ4EkRt7N3HWDcw9qqwys3xRRjGdbn8Jhk8Khwj', 'AkNbg12E9PatjkiAWJ3tAbM479gtcoA1gi6Joa925WKi', 'CWxNX9sTexuqvQefqskhP9f6AP5C8hq2VNkicRseqAT5', '2iMhgB4pbdKvwJHVyitpvX5z1NBNypFonUgaSAt9dtDt', '9ABNesWj7NVdkDgko7UjVaDp5pTh8a6wfXHLWz3bZM6W', '7V9C2XUQgCb31n7hGKqKGu4ENcvqXhJLJzU77CAQtXhw', 'DdpXnnYsyUQgJby8TDHbmPwkKyGF4U6bXwCXTQZsrfKP', '9MvZS3TVfv4DZL9W2pT12po384aBHf7wi89KXQ9Z7uwW', 'FpwV1Da6BZJnYPr1JSLUm14UwBmZHA7J5WLY4TXgbde8', 'HzBx8PP86pyPrrboTHqPYWhxnEB5vXDHDBP8femWfPTS', '2bCgKTo11QayWBy6QryHZMqZL2ZgWd5LEAZKiTGQi4g7', 'H2jHqvXA2oxSpEp6dKkpK7WeszQEdFW5n25mNfrJFAc1', '5f1jUARhtSypVA4uTpgpLp76WYGdB2dGr8zMbh4WjYRf', '9ifQ16N5DdUFoejCwsgR73ihUwadAe3srCo9HhQe2zL2', 'DsJHgpnNovjJ981QJJnqMggexAekNawbSavfV1QuTpis', 'HJBmBYyGR8z1oajAM4jiK46uobuxeJoKDYpFwzWHBvhb', '4txpjHspP4usEsQTr3AcrpyHVjN4fi3d4taM6cmKJnd1', 'HsdbLvZrEgN2ZhsrZs5ag4F2FNFCHjjuXPfbVAhkeJBZ', '6SqLuwHNRC1qjo9KATLKJLszFHMWyYaNxDXraCEUtfdR', '8RveLFEyteyL1vbCKPQJxjf3JT1ACyrzs46TXbJStrHG', '7M6RHgPiHXiZAin5ManH63cLYGt3miQ54KaGynUQoERS', 'HqPN13pLUVJRiuGSsKjfWZvGKAagK98PshuKu51bnG4E', 'Fw8PqtznYtg4swMk7Yjj89Tsj23u5CJLfW5Bk8ro4G1s', 'FMHHwUB6amLWYhWxtiZHC2g5azy9usPTLMq46N3HEgFU', '9zrgra3XQkZPt8XNs4fowbqmj7B8bBx76aEmsKSnm9BW', 'EbLBLN44BVLjifLNBbchXFr8QjEkAGYENKuNEaDuyVPL', '7Xs3yt9eJPuEexZrKSGVbQMXHwWUKHGeDZnM4ZksZmyS', 'FTk1E5UoWkiZEUttCWSYYaVokxWNNp3yJ42HbNDCAkdt', 'FFkPvwLDYuKDW9eAAr5UNfuX3U9PcTGeSk7gqNX7EpNc', '4gR3ChfdQxR4BTbgeWSdf6b8kD8Ysu6WBAQqtJ9oLgbF', '8pPDsMNcz4m8jaajFMFXHGcvaeVeiQhcenvSD6a4XNyq', '2XYd22LSFGxN7kWgoEeaXVZqgrsPeQLHLEgNhnS12Mny', 'Fys8J53cquYsg5zYfeZStVGNwM9FopFw8QFkiE9CCR1J', '6HzZJwrcuBBmrE7SLDfxheZGAD3NYJ531C9JsNesL9BP', 'J8Q6jYsrhhaeczyPBo9xzVyy4GpfCnJwj14LJn2HnuKp', '6Zj61HuX1E7SCUCf9WsKXw1jdJCobAwK4RSjZvbv35tM', 'HjFijcGWKgfDwGpFX2rqFwEU9jtEgFuRQAJe1ERXFsA3', '4ns3shP4WunCtJbr2HFu31RjjxSJxDymEFcBZxiHr11s', '4b4mhSySBcryzBPamw8v4xeneFRA6xTUA4JA99w6vqey', 'H3cgBXWpUiNsYjUWS7cNR5Bmehh7k5CgpJccc5wSfRbJ', 'DB8CSxoakPRtXhHcc2cA3iETWfGaYY6zE2T8huJTE2Nw', '2BMTgfgapuqYBwSRGu6HCafwDGRVTxMkQVhYrNWQGTWH', '56nh4FvMJnSpkWJcmXc1nJtYhSQXuqb7nVMGALr31RVc', 'F3HitKsp52UPqBMEWSeTFqrGgnfYbS9DMrJCz9dM3w6D', 'GxpbUDxYYvxiUejHcAMzeV2rzdHf6KZZvT86ACrpFgXa', '7SUoWHWWJCxCe5g9XqZkCRufGHXRV8nauuz69HPjuewr', 'DTbNmLWfu1pm4AuXRKYTApnDNfxMz73VET7nW5wizG5t', 'ARNZXUQoBKx3JCX3UJB4aitSnvcjMMphN9YVDFy1PdKq', 'GmVKV9W3qZcERxk7hjqwRDcn9Kgtz3XDi7KfFLdGqyaW', 'MEXfyQHowwqoTHsN6yjfeXVaxZxALUFJAHuzY8gFiUu', 'BBUTCn3jcXKjFYuuYtY8MNo8bDg9VsZaKwaSYnRr2Qse', 'RaYfM1RLfxQJWF8RZravTshKj1aHaWBNXF94VWToY9n')
AND inner_instruction:instructions[4]:parsed:info:authority != 'MRKT9mCmNU2R4KnZt9BV5uh9MESj7Phxws4AR7fUhRc'
AND inner_instruction:instructions[3]:parsed:info:mint = 'ATLASXmbPQxBUYbxPsV97usA3fPQYEqzQBUHgiFCUsXx'
then inner_instruction:instructions[1]:parsed:info:amount / POW (10,8) + inner_instruction:instructions[3]:parsed:info:tokenAmount:uiAmount
ELSE 0 end) as ships_bought_with_ATLAS,
sum(case WHEN inner_instruction:instructions[0]:parsed:info:mint::string IN ('Ev3xUhc1Leqi4qR2E5VoG9pcxCvHHmnAaSRVPg485xAT', '267DbhCypYzvTqv72ZG5UKHeFu56qXFsuoz3rw832eC5', '9czEqEZ4EkRt7N3HWDcw9qqwys3xRRjGdbn8Jhk8Khwj', 'AkNbg12E9PatjkiAWJ3tAbM479gtcoA1gi6Joa925WKi', 'CWxNX9sTexuqvQefqskhP9f6AP5C8hq2VNkicRseqAT5', '2iMhgB4pbdKvwJHVyitpvX5z1NBNypFonUgaSAt9dtDt', '9ABNesWj7NVdkDgko7UjVaDp5pTh8a6wfXHLWz3bZM6W', '7V9C2XUQgCb31n7hGKqKGu4ENcvqXhJLJzU77CAQtXhw', 'DdpXnnYsyUQgJby8TDHbmPwkKyGF4U6bXwCXTQZsrfKP', '9MvZS3TVfv4DZL9W2pT12po384aBHf7wi89KXQ9Z7uwW', 'FpwV1Da6BZJnYPr1JSLUm14UwBmZHA7J5WLY4TXgbde8', 'HzBx8PP86pyPrrboTHqPYWhxnEB5vXDHDBP8femWfPTS', '2bCgKTo11QayWBy6QryHZMqZL2ZgWd5LEAZKiTGQi4g7', 'H2jHqvXA2oxSpEp6dKkpK7WeszQEdFW5n25mNfrJFAc1', '5f1jUARhtSypVA4uTpgpLp76WYGdB2dGr8zMbh4WjYRf', '9ifQ16N5DdUFoejCwsgR73ihUwadAe3srCo9HhQe2zL2', 'DsJHgpnNovjJ981QJJnqMggexAekNawbSavfV1QuTpis', 'HJBmBYyGR8z1oajAM4jiK46uobuxeJoKDYpFwzWHBvhb', '4txpjHspP4usEsQTr3AcrpyHVjN4fi3d4taM6cmKJnd1', 'HsdbLvZrEgN2ZhsrZs5ag4F2FNFCHjjuXPfbVAhkeJBZ', '6SqLuwHNRC1qjo9KATLKJLszFHMWyYaNxDXraCEUtfdR', '8RveLFEyteyL1vbCKPQJxjf3JT1ACyrzs46TXbJStrHG', '7M6RHgPiHXiZAin5ManH63cLYGt3miQ54KaGynUQoERS', 'HqPN13pLUVJRiuGSsKjfWZvGKAagK98PshuKu51bnG4E', 'Fw8PqtznYtg4swMk7Yjj89Tsj23u5CJLfW5Bk8ro4G1s', 'FMHHwUB6amLWYhWxtiZHC2g5azy9usPTLMq46N3HEgFU', '9zrgra3XQkZPt8XNs4fowbqmj7B8bBx76aEmsKSnm9BW', 'EbLBLN44BVLjifLNBbchXFr8QjEkAGYENKuNEaDuyVPL', '7Xs3yt9eJPuEexZrKSGVbQMXHwWUKHGeDZnM4ZksZmyS', 'FTk1E5UoWkiZEUttCWSYYaVokxWNNp3yJ42HbNDCAkdt', 'FFkPvwLDYuKDW9eAAr5UNfuX3U9PcTGeSk7gqNX7EpNc', '4gR3ChfdQxR4BTbgeWSdf6b8kD8Ysu6WBAQqtJ9oLgbF', '8pPDsMNcz4m8jaajFMFXHGcvaeVeiQhcenvSD6a4XNyq', '2XYd22LSFGxN7kWgoEeaXVZqgrsPeQLHLEgNhnS12Mny', 'Fys8J53cquYsg5zYfeZStVGNwM9FopFw8QFkiE9CCR1J', '6HzZJwrcuBBmrE7SLDfxheZGAD3NYJ531C9JsNesL9BP', 'J8Q6jYsrhhaeczyPBo9xzVyy4GpfCnJwj14LJn2HnuKp', '6Zj61HuX1E7SCUCf9WsKXw1jdJCobAwK4RSjZvbv35tM', 'HjFijcGWKgfDwGpFX2rqFwEU9jtEgFuRQAJe1ERXFsA3', '4ns3shP4WunCtJbr2HFu31RjjxSJxDymEFcBZxiHr11s', '4b4mhSySBcryzBPamw8v4xeneFRA6xTUA4JA99w6vqey', 'H3cgBXWpUiNsYjUWS7cNR5Bmehh7k5CgpJccc5wSfRbJ', 'DB8CSxoakPRtXhHcc2cA3iETWfGaYY6zE2T8huJTE2Nw', '2BMTgfgapuqYBwSRGu6HCafwDGRVTxMkQVhYrNWQGTWH', '56nh4FvMJnSpkWJcmXc1nJtYhSQXuqb7nVMGALr31RVc', 'F3HitKsp52UPqBMEWSeTFqrGgnfYbS9DMrJCz9dM3w6D', 'GxpbUDxYYvxiUejHcAMzeV2rzdHf6KZZvT86ACrpFgXa', '7SUoWHWWJCxCe5g9XqZkCRufGHXRV8nauuz69HPjuewr', 'DTbNmLWfu1pm4AuXRKYTApnDNfxMz73VET7nW5wizG5t', 'ARNZXUQoBKx3JCX3UJB4aitSnvcjMMphN9YVDFy1PdKq', 'GmVKV9W3qZcERxk7hjqwRDcn9Kgtz3XDi7KfFLdGqyaW', 'MEXfyQHowwqoTHsN6yjfeXVaxZxALUFJAHuzY8gFiUu', 'BBUTCn3jcXKjFYuuYtY8MNo8bDg9VsZaKwaSYnRr2Qse', 'RaYfM1RLfxQJWF8RZravTshKj1aHaWBNXF94VWToY9n')
AND inner_instruction:instructions[0]:parsed:info:authority != 'MRKT9mCmNU2R4KnZt9BV5uh9MESj7Phxws4AR7fUhRc'
AND inner_instruction:instructions[1]:parsed:info:mint = 'EPjFWdd5AufqSSqeM2qN1xzybapC8G4wEGGkZwyTDt1v'
then inner_instruction:instructions[1]:parsed:info:tokenAmount:uiAmount + inner_instruction:instructions[2]:parsed:info:tokenAmount:uiAmount
WHEN inner_instruction:instructions[1]:parsed:info:mint::string IN ('Ev3xUhc1Leqi4qR2E5VoG9pcxCvHHmnAaSRVPg485xAT', '267DbhCypYzvTqv72ZG5UKHeFu56qXFsuoz3rw832eC5', '9czEqEZ4EkRt7N3HWDcw9qqwys3xRRjGdbn8Jhk8Khwj', 'AkNbg12E9PatjkiAWJ3tAbM479gtcoA1gi6Joa925WKi', 'CWxNX9sTexuqvQefqskhP9f6AP5C8hq2VNkicRseqAT5', '2iMhgB4pbdKvwJHVyitpvX5z1NBNypFonUgaSAt9dtDt', '9ABNesWj7NVdkDgko7UjVaDp5pTh8a6wfXHLWz3bZM6W', '7V9C2XUQgCb31n7hGKqKGu4ENcvqXhJLJzU77CAQtXhw', 'DdpXnnYsyUQgJby8TDHbmPwkKyGF4U6bXwCXTQZsrfKP', '9MvZS3TVfv4DZL9W2pT12po384aBHf7wi89KXQ9Z7uwW', 'FpwV1Da6BZJnYPr1JSLUm14UwBmZHA7J5WLY4TXgbde8', 'HzBx8PP86pyPrrboTHqPYWhxnEB5vXDHDBP8femWfPTS', '2bCgKTo11QayWBy6QryHZMqZL2ZgWd5LEAZKiTGQi4g7', 'H2jHqvXA2oxSpEp6dKkpK7WeszQEdFW5n25mNfrJFAc1', '5f1jUARhtSypVA4uTpgpLp76WYGdB2dGr8zMbh4WjYRf', '9ifQ16N5DdUFoejCwsgR73ihUwadAe3srCo9HhQe2zL2', 'DsJHgpnNovjJ981QJJnqMggexAekNawbSavfV1QuTpis', 'HJBmBYyGR8z1oajAM4jiK46uobuxeJoKDYpFwzWHBvhb', '4txpjHspP4usEsQTr3AcrpyHVjN4fi3d4taM6cmKJnd1', 'HsdbLvZrEgN2ZhsrZs5ag4F2FNFCHjjuXPfbVAhkeJBZ', '6SqLuwHNRC1qjo9KATLKJLszFHMWyYaNxDXraCEUtfdR', '8RveLFEyteyL1vbCKPQJxjf3JT1ACyrzs46TXbJStrHG', '7M6RHgPiHXiZAin5ManH63cLYGt3miQ54KaGynUQoERS', 'HqPN13pLUVJRiuGSsKjfWZvGKAagK98PshuKu51bnG4E', 'Fw8PqtznYtg4swMk7Yjj89Tsj23u5CJLfW5Bk8ro4G1s', 'FMHHwUB6amLWYhWxtiZHC2g5azy9usPTLMq46N3HEgFU', '9zrgra3XQkZPt8XNs4fowbqmj7B8bBx76aEmsKSnm9BW', 'EbLBLN44BVLjifLNBbchXFr8QjEkAGYENKuNEaDuyVPL', '7Xs3yt9eJPuEexZrKSGVbQMXHwWUKHGeDZnM4ZksZmyS', 'FTk1E5UoWkiZEUttCWSYYaVokxWNNp3yJ42HbNDCAkdt', 'FFkPvwLDYuKDW9eAAr5UNfuX3U9PcTGeSk7gqNX7EpNc', '4gR3ChfdQxR4BTbgeWSdf6b8kD8Ysu6WBAQqtJ9oLgbF', '8pPDsMNcz4m8jaajFMFXHGcvaeVeiQhcenvSD6a4XNyq', '2XYd22LSFGxN7kWgoEeaXVZqgrsPeQLHLEgNhnS12Mny', 'Fys8J53cquYsg5zYfeZStVGNwM9FopFw8QFkiE9CCR1J', '6HzZJwrcuBBmrE7SLDfxheZGAD3NYJ531C9JsNesL9BP', 'J8Q6jYsrhhaeczyPBo9xzVyy4GpfCnJwj14LJn2HnuKp', '6Zj61HuX1E7SCUCf9WsKXw1jdJCobAwK4RSjZvbv35tM', 'HjFijcGWKgfDwGpFX2rqFwEU9jtEgFuRQAJe1ERXFsA3', '4ns3shP4WunCtJbr2HFu31RjjxSJxDymEFcBZxiHr11s', '4b4mhSySBcryzBPamw8v4xeneFRA6xTUA4JA99w6vqey', 'H3cgBXWpUiNsYjUWS7cNR5Bmehh7k5CgpJccc5wSfRbJ', 'DB8CSxoakPRtXhHcc2cA3iETWfGaYY6zE2T8huJTE2Nw', '2BMTgfgapuqYBwSRGu6HCafwDGRVTxMkQVhYrNWQGTWH', '56nh4FvMJnSpkWJcmXc1nJtYhSQXuqb7nVMGALr31RVc', 'F3HitKsp52UPqBMEWSeTFqrGgnfYbS9DMrJCz9dM3w6D', 'GxpbUDxYYvxiUejHcAMzeV2rzdHf6KZZvT86ACrpFgXa', '7SUoWHWWJCxCe5g9XqZkCRufGHXRV8nauuz69HPjuewr', 'DTbNmLWfu1pm4AuXRKYTApnDNfxMz73VET7nW5wizG5t', 'ARNZXUQoBKx3JCX3UJB4aitSnvcjMMphN9YVDFy1PdKq', 'GmVKV9W3qZcERxk7hjqwRDcn9Kgtz3XDi7KfFLdGqyaW', 'MEXfyQHowwqoTHsN6yjfeXVaxZxALUFJAHuzY8gFiUu', 'BBUTCn3jcXKjFYuuYtY8MNo8bDg9VsZaKwaSYnRr2Qse', 'RaYfM1RLfxQJWF8RZravTshKj1aHaWBNXF94VWToY9n')
AND inner_instruction:instructions[1]:parsed:info:authority != 'MRKT9mCmNU2R4KnZt9BV5uh9MESj7Phxws4AR7fUhRc'
AND inner_instruction:instructions[0]:parsed:info:mint = 'EPjFWdd5AufqSSqeM2qN1xzybapC8G4wEGGkZwyTDt1v'
then inner_instruction:instructions[0]:parsed:info:tokenAmount:uiAmount + inner_instruction:instructions[2]:parsed:info:tokenAmount:uiAmount
WHEN inner_instruction:instructions[2]:parsed:info:mint::string IN ('Ev3xUhc1Leqi4qR2E5VoG9pcxCvHHmnAaSRVPg485xAT', '267DbhCypYzvTqv72ZG5UKHeFu56qXFsuoz3rw832eC5', '9czEqEZ4EkRt7N3HWDcw9qqwys3xRRjGdbn8Jhk8Khwj', 'AkNbg12E9PatjkiAWJ3tAbM479gtcoA1gi6Joa925WKi', 'CWxNX9sTexuqvQefqskhP9f6AP5C8hq2VNkicRseqAT5', '2iMhgB4pbdKvwJHVyitpvX5z1NBNypFonUgaSAt9dtDt', '9ABNesWj7NVdkDgko7UjVaDp5pTh8a6wfXHLWz3bZM6W', '7V9C2XUQgCb31n7hGKqKGu4ENcvqXhJLJzU77CAQtXhw', 'DdpXnnYsyUQgJby8TDHbmPwkKyGF4U6bXwCXTQZsrfKP', '9MvZS3TVfv4DZL9W2pT12po384aBHf7wi89KXQ9Z7uwW', 'FpwV1Da6BZJnYPr1JSLUm14UwBmZHA7J5WLY4TXgbde8', 'HzBx8PP86pyPrrboTHqPYWhxnEB5vXDHDBP8femWfPTS', '2bCgKTo11QayWBy6QryHZMqZL2ZgWd5LEAZKiTGQi4g7', 'H2jHqvXA2oxSpEp6dKkpK7WeszQEdFW5n25mNfrJFAc1', '5f1jUARhtSypVA4uTpgpLp76WYGdB2dGr8zMbh4WjYRf', '9ifQ16N5DdUFoejCwsgR73ihUwadAe3srCo9HhQe2zL2', 'DsJHgpnNovjJ981QJJnqMggexAekNawbSavfV1QuTpis', 'HJBmBYyGR8z1oajAM4jiK46uobuxeJoKDYpFwzWHBvhb', '4txpjHspP4usEsQTr3AcrpyHVjN4fi3d4taM6cmKJnd1', 'HsdbLvZrEgN2ZhsrZs5ag4F2FNFCHjjuXPfbVAhkeJBZ', '6SqLuwHNRC1qjo9KATLKJLszFHMWyYaNxDXraCEUtfdR', '8RveLFEyteyL1vbCKPQJxjf3JT1ACyrzs46TXbJStrHG', '7M6RHgPiHXiZAin5ManH63cLYGt3miQ54KaGynUQoERS', 'HqPN13pLUVJRiuGSsKjfWZvGKAagK98PshuKu51bnG4E', 'Fw8PqtznYtg4swMk7Yjj89Tsj23u5CJLfW5Bk8ro4G1s', 'FMHHwUB6amLWYhWxtiZHC2g5azy9usPTLMq46N3HEgFU', '9zrgra3XQkZPt8XNs4fowbqmj7B8bBx76aEmsKSnm9BW', 'EbLBLN44BVLjifLNBbchXFr8QjEkAGYENKuNEaDuyVPL', '7Xs3yt9eJPuEexZrKSGVbQMXHwWUKHGeDZnM4ZksZmyS', 'FTk1E5UoWkiZEUttCWSYYaVokxWNNp3yJ42HbNDCAkdt', 'FFkPvwLDYuKDW9eAAr5UNfuX3U9PcTGeSk7gqNX7EpNc', '4gR3ChfdQxR4BTbgeWSdf6b8kD8Ysu6WBAQqtJ9oLgbF', '8pPDsMNcz4m8jaajFMFXHGcvaeVeiQhcenvSD6a4XNyq', '2XYd22LSFGxN7kWgoEeaXVZqgrsPeQLHLEgNhnS12Mny', 'Fys8J53cquYsg5zYfeZStVGNwM9FopFw8QFkiE9CCR1J', '6HzZJwrcuBBmrE7SLDfxheZGAD3NYJ531C9JsNesL9BP', 'J8Q6jYsrhhaeczyPBo9xzVyy4GpfCnJwj14LJn2HnuKp', '6Zj61HuX1E7SCUCf9WsKXw1jdJCobAwK4RSjZvbv35tM', 'HjFijcGWKgfDwGpFX2rqFwEU9jtEgFuRQAJe1ERXFsA3', '4ns3shP4WunCtJbr2HFu31RjjxSJxDymEFcBZxiHr11s', '4b4mhSySBcryzBPamw8v4xeneFRA6xTUA4JA99w6vqey', 'H3cgBXWpUiNsYjUWS7cNR5Bmehh7k5CgpJccc5wSfRbJ', 'DB8CSxoakPRtXhHcc2cA3iETWfGaYY6zE2T8huJTE2Nw', '2BMTgfgapuqYBwSRGu6HCafwDGRVTxMkQVhYrNWQGTWH', '56nh4FvMJnSpkWJcmXc1nJtYhSQXuqb7nVMGALr31RVc', 'F3HitKsp52UPqBMEWSeTFqrGgnfYbS9DMrJCz9dM3w6D', 'GxpbUDxYYvxiUejHcAMzeV2rzdHf6KZZvT86ACrpFgXa', '7SUoWHWWJCxCe5g9XqZkCRufGHXRV8nauuz69HPjuewr', 'DTbNmLWfu1pm4AuXRKYTApnDNfxMz73VET7nW5wizG5t', 'ARNZXUQoBKx3JCX3UJB4aitSnvcjMMphN9YVDFy1PdKq', 'GmVKV9W3qZcERxk7hjqwRDcn9Kgtz3XDi7KfFLdGqyaW', 'MEXfyQHowwqoTHsN6yjfeXVaxZxALUFJAHuzY8gFiUu', 'BBUTCn3jcXKjFYuuYtY8MNo8bDg9VsZaKwaSYnRr2Qse', 'RaYfM1RLfxQJWF8RZravTshKj1aHaWBNXF94VWToY9n')
AND inner_instruction:instructions[2]:parsed:info:authority != 'MRKT9mCmNU2R4KnZt9BV5uh9MESj7Phxws4AR7fUhRc'
AND inner_instruction:instructions[0]:parsed:info:mint = 'EPjFWdd5AufqSSqeM2qN1xzybapC8G4wEGGkZwyTDt1v'
then inner_instruction:instructions[0]:parsed:info:tokenAmount:uiAmount + inner_instruction:instructions[1]:parsed:info:tokenAmount:uiAmount
Run a query to Download Data