select

--*

date_trunc('day', block_timestamp::date) as date,

signers[0] as atlas_claimers

--count(distinct signers) as atlas_claimers_num

from solana.core.fact_transactions

WHERE instructions[0]:programId::string = 'FLEET1qqzpexyaDpqb2DGsSzE2sDCizewCg9WjrA6DBW'

AND succeeded = 'true'

AND log_messages::string LIKE '%Harvesting%'

AND block_timestamp > '2022-11-30' AND block_timestamp < current_date

group by 1,2

),

ship_buyers AS (

select

--*

date_trunc('day', block_timestamp::date) as date,

signers[0] as ship_buyers

from solana.core.fact_transactions, atlas_claimers

WHERE instructions[0]:programId::string = 'traderDnaR5w6Tcoi3NFm53i48FTDNbGjBSZwWXDRrg'

AND succeeded = 'true'

AND signers[0] IN (atlas_claimers)

AND inner_instructions[0]: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')

AND block_timestamp > '2022-11-30' --AND block_timestamp < current_date

group by 1,2

),

atlas_sellers AS (

select