AephiaGlo Rainbros
Updated 2022-09-18
99
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_ins1 as (
select
signers[0]::string as wallet_in,
-----------------------------------------------------------------------------------------------------
sum(case when value:mint = 'HzBx8PP86pyPrrboTHqPYWhxnEB5vXDHDBP8femWfPTS' then value:uiTokenAmount:uiAmount ELSE 0 end) as OM_in,
sum(case when value:mint = 'DsJHgpnNovjJ981QJJnqMggexAekNawbSavfV1QuTpis' then value:uiTokenAmount:uiAmount ELSE 0 end) as CHI_in,
sum(case when value:mint = 'EbLBLN44BVLjifLNBbchXFr8QjEkAGYENKuNEaDuyVPL' then value:uiTokenAmount:uiAmount ELSE 0 end) as ARC_in
from solana.core.fact_transactions, lateral flatten(input => pre_token_balances)
WHERE instructions[0]:programId::string = 'FLEET1qqzpexyaDpqb2DGsSzE2sDCizewCg9WjrA6DBW'
AND value:owner = signers[0]::string
AND log_messages::string LIKE '%Transferring to Ship Escrow Account%'
AND value:mint NOT IN ('ammoK8AkX2wnebQb35cDAZtTkvsXQbi82cGeTnUvvfK', 'foodQJAztMzX1DKpLaiounNe2BDMds5RNuPC6jsNrDG', 'fueL3hBZjLLLJHiFH9cqZoozTG3XQZ53diwFPwbzNim', 'tooLsNYLiVqzg8o4m3L2Uetbn62mvMWRqkog6PQeYKL')
AND block_timestamp > '2021-12-16' AND block_timestamp <= '2022-03-31'
group by 1),
ships_outs1 as (
select
signers[0]::string as wallet_out,
-----------------------------------------------------------------------------------------------------
sum(case when value:mint = 'HzBx8PP86pyPrrboTHqPYWhxnEB5vXDHDBP8femWfPTS' then value:uiTokenAmount:uiAmount ELSE 0 end) as OM_out,
sum(case when value:mint = 'DsJHgpnNovjJ981QJJnqMggexAekNawbSavfV1QuTpis' then value:uiTokenAmount:uiAmount ELSE 0 end) as CHI_out,
sum(case when value:mint = 'EbLBLN44BVLjifLNBbchXFr8QjEkAGYENKuNEaDuyVPL' then value:uiTokenAmount:uiAmount ELSE 0 end) as ARC_out
from solana.core.fact_transactions, lateral flatten(input => post_token_balances)
WHERE instructions[0]:programId::string = 'FLEET1qqzpexyaDpqb2DGsSzE2sDCizewCg9WjrA6DBW'
AND value:owner = signers[0]::string
AND log_messages::string LIKE '%Transferring to Ship Escrow Account%'
AND value:mint NOT IN ('ammoK8AkX2wnebQb35cDAZtTkvsXQbi82cGeTnUvvfK', 'foodQJAztMzX1DKpLaiounNe2BDMds5RNuPC6jsNrDG', 'fueL3hBZjLLLJHiFH9cqZoozTG3XQZ53diwFPwbzNim', 'tooLsNYLiVqzg8o4m3L2Uetbn62mvMWRqkog6PQeYKL')
AND block_timestamp > '2021-12-16' AND block_timestamp <= '2022-03-31'
group by 1)
Run a query to Download Data