AephiaFreighter ships staked per wallet
Updated 2023-08-17
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
›
⌄
WITH ships_in as (
select
signers[0] as wallet,
-----------------------------------------------------------------------------------------------------
sum(case when value:parsed:info:mint = '7V9C2XUQgCb31n7hGKqKGu4ENcvqXhJLJzU77CAQtXhw' then value:parsed:info:tokenAmount:uiAmount ELSE 0 end) AS FBLBPL_in,
sum(case when value:parsed:info:mint = 'HzBx8PP86pyPrrboTHqPYWhxnEB5vXDHDBP8femWfPTS' then value:parsed:info:tokenAmount:uiAmount ELSE 0 end) AS OM_in,
sum(case when value:parsed:info:mint = 'EbLBLN44BVLjifLNBbchXFr8QjEkAGYENKuNEaDuyVPL' then value:parsed:info:tokenAmount:uiAmount ELSE 0 end) AS ARC_in,
sum(case when value:parsed:info:mint = '4b4mhSySBcryzBPamw8v4xeneFRA6xTUA4JA99w6vqey' then value:parsed:info:tokenAmount:uiAmount ELSE 0 end) AS OGKASP_in
from solana.core.fact_events, lateral flatten(input => inner_instruction:instructions)
WHERE program_id = 'FLEET1qqzpexyaDpqb2DGsSzE2sDCizewCg9WjrA6DBW'
AND succeeded = 'true'
--AND tx_id = 'SK9XbzbXVy7jgsEPp8Y8bzV8Y69CWnCJ5NJW2XHhAwGZnBhs5ABNtwMRXKqNfWPKN2eYS9fLewhWz3CmcWeddAb'
AND value:parsed:info:authority = signers[0]::string
--AND signers[0] = '4F8g6pCBAo3KWEBai8EZbrQ8bVcYG3kxRrAGsDCTDWFL'
--AND value:parsed:info:mint IN ('9ifQ16N5DdUFoejCwsgR73ihUwadAe3srCo9HhQe2zL2')
--AND value:parsed:info:mint NOT IN ('ammoK8AkX2wnebQb35cDAZtTkvsXQbi82cGeTnUvvfK', 'foodQJAztMzX1DKpLaiounNe2BDMds5RNuPC6jsNrDG', 'fueL3hBZjLLLJHiFH9cqZoozTG3XQZ53diwFPwbzNim', 'tooLsNYLiVqzg8o4m3L2Uetbn62mvMWRqkog6PQeYKL')
AND block_timestamp > '2021-12-16'-- AND block_timestamp < '2023-08-01'
group by 1
),
ships_out as (
select
signers[0] as wallet,
-----------------------------------------------------------------------------------------------------
sum(case when value:parsed:info:mint = '7V9C2XUQgCb31n7hGKqKGu4ENcvqXhJLJzU77CAQtXhw' then value:parsed:info:tokenAmount:uiAmount ELSE 0 end) AS FBLBPL_out,
sum(case when value:parsed:info:mint = 'HzBx8PP86pyPrrboTHqPYWhxnEB5vXDHDBP8femWfPTS' then value:parsed:info:tokenAmount:uiAmount ELSE 0 end) AS OM_out,
sum(case when value:parsed:info:mint = 'EbLBLN44BVLjifLNBbchXFr8QjEkAGYENKuNEaDuyVPL' then value:parsed:info:tokenAmount:uiAmount ELSE 0 end) AS ARC_out,
sum(case when value:parsed:info:mint = '4b4mhSySBcryzBPamw8v4xeneFRA6xTUA4JA99w6vqey' then value:parsed:info:tokenAmount:uiAmount ELSE 0 end) AS OGKASP_out
from solana.core.fact_events, lateral flatten(input => inner_instruction:instructions)
WHERE program_id = 'FLEET1qqzpexyaDpqb2DGsSzE2sDCizewCg9WjrA6DBW'
Run a query to Download Data