Aephiaold_Aephia Firepower Calculator
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_ins1 as (
select
'{{wallet}}' as wallet_in,
-----------------------------------------------------------------------------------------------------
sum(case when (case when value:accountIndex = 2 then value:mint end = 'Ev3xUhc1Leqi4qR2E5VoG9pcxCvHHmnAaSRVPg485xAT' AND value:uiTokenAmount:uiAmount IS NOT NULL) then value:uiTokenAmount:uiAmount ELSE 0 end) as OPALJ_in,
20 as opalj_vwap,
2 as opalj_fp,
-----------------------------------------------------------------------------------------------------
sum(case when (case when value:accountIndex = 2 then value:mint end = '267DbhCypYzvTqv72ZG5UKHeFu56qXFsuoz3rw832eC5' AND value:uiTokenAmount:uiAmount IS NOT NULL) then value:uiTokenAmount:uiAmount ELSE 0 end) as PXFIVE_in,
140.48 as pxfive_vwap,
16 as pxfive_fp,
-----------------------------------------------------------------------------------------------------
sum(case when (case when value:accountIndex = 2 then value:mint end = '9czEqEZ4EkRt7N3HWDcw9qqwys3xRRjGdbn8Jhk8Khwj' AND value:uiTokenAmount:uiAmount IS NOT NULL) then value:uiTokenAmount:uiAmount ELSE 0 end) as VZUSOP_in,
1666 as vzusop_vwap,
100 as vzusop_fp,
-----------------------------------------------------------------------------------------------------
sum(case when (case when value:accountIndex = 2 then value:mint end = 'AkNbg12E9PatjkiAWJ3tAbM479gtcoA1gi6Joa925WKi' AND value:uiTokenAmount:uiAmount IS NOT NULL) then value:uiTokenAmount:uiAmount ELSE 0 end) as CALCH_in,
3786 as calch_vwap,
120 as calch_fp,
-----------------------------------------------------------------------------------------------------
sum(case when (case when value:accountIndex = 2 then value:mint end = 'CWxNX9sTexuqvQefqskhP9f6AP5C8hq2VNkicRseqAT5' AND value:uiTokenAmount:uiAmount IS NOT NULL) then value:uiTokenAmount:uiAmount ELSE 0 end) as OGKATP_in,
8506 as ogkatp_vwap,
432 as ogkatp_fp,
-----------------------------------------------------------------------------------------------------
sum(case when (case when value:accountIndex = 2 then value:mint end = '2iMhgB4pbdKvwJHVyitpvX5z1NBNypFonUgaSAt9dtDt' AND value:uiTokenAmount:uiAmount IS NOT NULL) then value:uiTokenAmount:uiAmount ELSE 0 end) as PXFOUR_in,
22.6 as PXFOUR_vwap,
4 as PXFOUR_fp,
-----------------------------------------------------------------------------------------------------
sum(case when (case when value:accountIndex = 2 then value:mint end = '9ABNesWj7NVdkDgko7UjVaDp5pTh8a6wfXHLWz3bZM6W' AND value:uiTokenAmount:uiAmount IS NOT NULL) then value:uiTokenAmount:uiAmount ELSE 0 end) as OPALJJ_in,
308.91 as OPALJJ_vwap,
8 as OPALJJ_fp,
-----------------------------------------------------------------------------------------------------
sum(case when (case when value:accountIndex = 2 then value:mint end = '7V9C2XUQgCb31n7hGKqKGu4ENcvqXhJLJzU77CAQtXhw' AND value:uiTokenAmount:uiAmount IS NOT NULL) then value:uiTokenAmount:uiAmount ELSE 0 end) as FBLBPL_in,
3513 as FBLBPL_vwap,
80 as FBLBPL_fp,
-----------------------------------------------------------------------------------------------------
Run a query to Download Data