AephiaShip sellers daily
Updated 2022-10-23
99
1
2
3
4
5
6
7
8
9
10
11
12
13
›
⌄
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