swolsolkevin-run
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
›
⌄
select
s1.tx_from, s1.tx_id, s1.mint, s1.block_timestamp, s1.tx_to
from solana.core.fact_transfers s1
where
mint not in ('So11111111111111111111111111111111111111112','LUSHqQZX8DxXjGUrEp9Nh3U6ym7U45srgqrQHrE4NX2','DezXAZ8z7PnrnRJjz3wXBoRgixCa6xjnB7YaB1pPB263', '2nNdA6tfP6myy7QjgjiDgaGQ9nC6gnP9qYjKKnW1NAm5', 'AzYjLWjXvB6fRMr7eFbfKP1qj7yG8VcjbPzNwMc21NLa', 'F6svd9vonELRwuBc69PyX66G3mxxEpH5JwGdwxZgafHD', '2e52LQDCouTCgAf4PLSaw2iZA4iEZ7fQhG5GUHmd7YAy', '6YyEBUMUoQH8QjMpR1bWR5LYfgM1yRM6qC3SSrFees5M', '4f254fdpKVt6BJorqRNWB3TQkyFwnRd9jeFejFWREyMs')
and
s1.tx_to in
('E9os5EE5KvwNuNGv1WcuWYaqiY5iexTa5UtQcHtiDu75', 'E9kM89iE8d5YRqed9Z5NZZXfgtJ9ECkXc1KwnHLAg67G', 'E9iSgG6VCXqSroUpM8ydCMftEB1wGTLNYo7QyYDgECpf', 'EAbmdQw9KEcuxV5yiEQv6wntcHhR7wtJub2mEnfuiQPb', 'EB6oSV6GXuXmmRbsCFbHYbbLiPsGALDTkD3Yp25cWsjy', 'EBC7TSeExmve97DWVgBX9a9yoPxWWChkkVLvR96hNH2b', 'EAfQfVUmRNjycWhR9VmHjdQohtEUzR8HEhVg5ZNRNZBK', 'EAwxusRyfrZ54NRdqyLQVtNutAhfuFfg6PmHFLQFXChd', 'EB5bFE7ip4rEhTxKHEYCJgqXqSXzqXsfc8UxgAKS9V4v', 'EBBNShqqCTwCN6hPrGFBSwSVvgrsFQTS7LrWobaFHcxG', 'EBXgVAiZc2yccTJWi5K8mtZP7PvKeqh4BCdVfKrLTk4p', 'EBh1cSXJSe5f9XTCagTQrXzwNBZ3r8y2jkpgD8gFcdKd', 'EBCtjAzL5aAfdwuBBTM9hcGEF2Znrj3V1b89WMEGS5Zw', 'EBXeqRisUMwmys5Muv6msmmE9zsnjAuRTuU2CE82GZyA', 'EBt7ij9K3r7QtUttQLvfEevBskGeN2zJMCDXo9R1ZopB', 'EBozoMycqBdpK8QGLqqUjmcMBf3JjM7kqf4JHmM9AnFG', 'ED8siAxNJVRvQFeowNMqvrkds6ZPkSza2iRZzRnfEiFR', 'ECVZ7ZDqPDYXnJ6vbaxi5fW4WJCQdvf3Lr8uAFoiL6f8', 'ECkz5L87ePz2ydZKXRBPA91kNRWJg9Nu7d6AGC9s8YyP', 'ED5zT8CkRMHBjaDKWq8fG1Wgfrgab8fpxeR9sN4mhkrc', 'EDE6oZpouWpssvLnUUzb9N5YCb9yzz2EcUWV3vvbvf99', 'ECiAJTdyPnmDoC4Par4nwmNHqj3Ky4SkF5ytY6V6sZDC', 'ECow1XxTFht1xxXZDJNFeKSeuYzayoeRp8QBEHL1n5tV', 'EDLJYA3Y8zQqBKYBoiBRzc7apySDTqnEA9ARGJcfqHKC', 'EDPrcHnNMCSiQkZfi77G8T9rmLgZiBfzJ2pcw6UGzkLQ', 'EDtqLB4eyW3vuSTBFXWrr3jA4f3kRZ8v7iYbT1NFyszd', 'EDs4ru3YbgGUBRwbEXN7BFnLacFyaYSbgpzo1MeMTFQR', 'EEKZV3QURj4Qo1QT4QqdkkXaTxrsNLFY6HGgSM8K39JD', 'EEGdsZn5YXYAEKDqNwLticGQgjgz7AK1UYybg4ZCRyWQ', 'EEDK7x5QgKAuEYWDCJbojhh6NdN6evnodZNKtj86iyNH', 'EEPet1gpN4ibeTXtUAcSzu19bEfWG7juNBcAUuzxBh3P', 'EEv6UJrWHn9Sv6wG7p15puxViitYF41skpy3rhEn3ykr', 'EEXvi8gce2UBn1JzqWk5Whu4okZue8xVBHpLXXvS8Y9w', 'EEz6MmvvbNuRZi8RBC212n8P5WebQgQC2Vgae3pXSPq2', 'EEpUxRJRoVu1HwAiw2xEGLgqhyaYLDHrXKHEjtyv415V', 'EF5CyQ9YMQgboZe9cYdnyhxPedVqv247v4SfJHPE8JF6', 'EF1RLg2vaKASYQXQLcUUmFKs1nVSAaZWxAt5yWndoj4M', 'EF6evQVuJJNKg4GxsKKQUgKWQyX9mWKR8wnuGv8LrAfC', 'EF2B9nYrtdFEPfNaMayg5uKbLiMj6YYYah4RwrpsZtvN', 'EFHui2CGB7yheJ6ju5WzsMVgu8gb9hD2TZURYUSjvicK', 'EFHo8Fx2Ns2j7XTFGCunYYcUCHvhavx9UYTLzHNRALvi', 'EFqpJxevqhyaNaCtKX1M6YjEoWztU2MgJKG3feXBwSu6', 'EFmSjM67zjTTMytM8HUTuqcWw4R6Kxh8ySdopDxRo34H', 'EFcpwA1ntcb2SDaexuM37N8KAzzKS4sVjHoR131VgJA4', 'EFrAwPKShq1fazHNjXh2qYoavgcomqHhXthuRD1YKRRJ', 'EFsLLy2bdBtgmheCw1
and
s1.block_timestamp < '2022-12-24 12:00:00'
and not exists (
select 1
from solana.core.fact_transfers s2
where s2.tx_to = s1.tx_to
and s2.block_timestamp > s1.block_timestamp
and s2.block_timestamp < '2022-12-24 12:00:00'
and s2.mint = s1.mint
)
limit 100000 offset 0
Run a query to Download Data