AephiaShip sellers daily
    Updated 2022-10-23
    select
    --*
    date_trunc('day', block_timestamp::date) as date,
    count (distinct signers) as ship_sellers_num

    from solana.core.fact_transactions
    WHERE instructions[0]:programId::string = 'traderDnaR5w6Tcoi3NFm53i48FTDNbGjBSZwWXDRrg'
    AND succeeded = 'true'
    AND inner_instructions[0]: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')
    AND inner_instructions[0]:instructions[2]:parsed:info:mint::string = 'ATLASXmbPQxBUYbxPsV97usA3fPQYEqzQBUHgiFCUsXx'
    AND block_timestamp > '2022-07-21' AND block_timestamp < current_date
    group by 1
    order by 1 desc
    Run a query to Download Data