AephiaShips bought from SA (number)
Updated 2023-05-02
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
›
⌄
select
--*
date_trunc('month', block_timestamp::date) as date,
-----------------------------------------------------------------------------------------------------
sum(case WHEN inner_instruction:instructions[2]:parsed:info:source = 'Dnj8FE3ckU2DWtoh1GoARV4SZWPVQ32uALbjqfhQnJ4K'
AND inner_instruction:instructions[1]:parsed:info:mint IN ('ATLASXmbPQxBUYbxPsV97usA3fPQYEqzQBUHgiFCUsXx', 'EPjFWdd5AufqSSqeM2qN1xzybapC8G4wEGGkZwyTDt1v')
then inner_instruction:instructions[2]:parsed:info:tokenAmount:uiAmount
WHEN inner_instruction:instructions[1]:parsed:info:source = 'Dnj8FE3ckU2DWtoh1GoARV4SZWPVQ32uALbjqfhQnJ4K'
AND inner_instruction:instructions[2]:parsed:info:mint IN ('ATLASXmbPQxBUYbxPsV97usA3fPQYEqzQBUHgiFCUsXx', 'EPjFWdd5AufqSSqeM2qN1xzybapC8G4wEGGkZwyTDt1v')
then inner_instruction:instructions[1]:parsed:info:tokenAmount:uiAmount ELSE 0 end) as PXFOUR,
sum(case WHEN inner_instruction:instructions[2]:parsed:info:source = 'EuHDxSYdMjfAkff2Uc8KonQVJeQetiY35X9sowybmAHv'
AND inner_instruction:instructions[1]:parsed:info:mint IN ('ATLASXmbPQxBUYbxPsV97usA3fPQYEqzQBUHgiFCUsXx', 'EPjFWdd5AufqSSqeM2qN1xzybapC8G4wEGGkZwyTDt1v')
then inner_instruction:instructions[2]:parsed:info:tokenAmount:uiAmount
WHEN inner_instruction:instructions[1]:parsed:info:source = 'EuHDxSYdMjfAkff2Uc8KonQVJeQetiY35X9sowybmAHv'
AND inner_instruction:instructions[2]:parsed:info:mint IN ('ATLASXmbPQxBUYbxPsV97usA3fPQYEqzQBUHgiFCUsXx', 'EPjFWdd5AufqSSqeM2qN1xzybapC8G4wEGGkZwyTDt1v')
then inner_instruction:instructions[1]:parsed:info:tokenAmount:uiAmount ELSE 0 end) as CALEV,
sum(case WHEN inner_instruction:instructions[2]:parsed:info:source = 'Ajam1feHKuoKcVS2F5E22PFQtDK5G96trTTdFrhafhgT'
AND inner_instruction:instructions[1]:parsed:info:mint IN ('ATLASXmbPQxBUYbxPsV97usA3fPQYEqzQBUHgiFCUsXx', 'EPjFWdd5AufqSSqeM2qN1xzybapC8G4wEGGkZwyTDt1v')
then inner_instruction:instructions[2]:parsed:info:tokenAmount:uiAmount
WHEN inner_instruction:instructions[1]:parsed:info:source = 'Ajam1feHKuoKcVS2F5E22PFQtDK5G96trTTdFrhafhgT'
AND inner_instruction:instructions[2]:parsed:info:mint IN ('ATLASXmbPQxBUYbxPsV97usA3fPQYEqzQBUHgiFCUsXx', 'EPjFWdd5AufqSSqeM2qN1xzybapC8G4wEGGkZwyTDt1v')
then inner_instruction:instructions[1]:parsed:info:tokenAmount:uiAmount ELSE 0 end) as FBLAIR,
sum(case when inner_instruction:instructions[2]:parsed:info:source = 'HFDaVWD1gB26i2PVwnNmiTPkrRUtW6fXHQpkqEE2MJCp'
AND inner_instruction:instructions[1]:parsed:info:mint IN ('ATLASXmbPQxBUYbxPsV97usA3fPQYEqzQBUHgiFCUsXx', 'EPjFWdd5AufqSSqeM2qN1xzybapC8G4wEGGkZwyTDt1v')
then inner_instruction:instructions[2]:parsed:info:tokenAmount:uiAmount
when inner_instruction:instructions[1]:parsed:info:source = 'HFDaVWD1gB26i2PVwnNmiTPkrRUtW6fXHQpkqEE2MJCp'
AND inner_instruction:instructions[2]:parsed:info:mint IN ('ATLASXmbPQxBUYbxPsV97usA3fPQYEqzQBUHgiFCUsXx', 'EPjFWdd5AufqSSqeM2qN1xzybapC8G4wEGGkZwyTDt1v')
then inner_instruction:instructions[1]:parsed:info:tokenAmount:uiAmount ELSE 0 end) as OGKAMK,
sum(case when inner_instruction:instructions[2]:parsed:info:source = '328U5iSeo7gVSgSGMreYt3pB1i4jYLPf1bbVXY6DDJxC'
AND inner_instruction:instructions[1]:parsed:info:mint IN ('ATLASXmbPQxBUYbxPsV97usA3fPQYEqzQBUHgiFCUsXx', 'EPjFWdd5AufqSSqeM2qN1xzybapC8G4wEGGkZwyTDt1v')
then inner_instruction:instructions[2]:parsed:info:tokenAmount:uiAmount
when inner_instruction:instructions[1]:parsed:info:source = '328U5iSeo7gVSgSGMreYt3pB1i4jYLPf1bbVXY6DDJxC'
AND inner_instruction:instructions[2]:parsed:info:mint IN ('ATLASXmbPQxBUYbxPsV97usA3fPQYEqzQBUHgiFCUsXx', 'EPjFWdd5AufqSSqeM2qN1xzybapC8G4wEGGkZwyTDt1v')
then inner_instruction:instructions[1]:parsed:info:tokenAmount:uiAmount ELSE 0 end) as FBLEUN,
sum(case when inner_instruction:instructions[2]:parsed:info:source = '9mebonYzdx1gXgG4Hrn8DmWedd8Lg8ZFep2k56u9eepw'
AND inner_instruction:instructions[1]:parsed:info:mint IN ('ATLASXmbPQxBUYbxPsV97usA3fPQYEqzQBUHgiFCUsXx', 'EPjFWdd5AufqSSqeM2qN1xzybapC8G4wEGGkZwyTDt1v')
Run a query to Download Data