AephiaUntitled Query
Updated 2022-12-07
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('day', block_timestamp::date) as date,
-----------------------------------------------------------------------------------------------------
sum(case when f3.value:instructions[2]:parsed:info:mint::string = 'Ev3xUhc1Leqi4qR2E5VoG9pcxCvHHmnAaSRVPg485xAT'
AND f3.value:instructions[1]:parsed:info:mint::string IN ('ATLASXmbPQxBUYbxPsV97usA3fPQYEqzQBUHgiFCUsXx', 'EPjFWdd5AufqSSqeM2qN1xzybapC8G4wEGGkZwyTDt1v')
then f3.value:instructions[2]:parsed:info:tokenAmount:uiAmount
when f3.value:instructions[1]:parsed:info:mint::string = 'Ev3xUhc1Leqi4qR2E5VoG9pcxCvHHmnAaSRVPg485xAT'
AND f3.value:instructions[2]:parsed:info:mint::string IN ('ATLASXmbPQxBUYbxPsV97usA3fPQYEqzQBUHgiFCUsXx', 'EPjFWdd5AufqSSqeM2qN1xzybapC8G4wEGGkZwyTDt1v')
then f3.value:instructions[1]:parsed:info:tokenAmount:uiAmount ELSE 0 end) AS OPALJ,
sum(case when f3.value:instructions[2]:parsed:info:mint::string = '267DbhCypYzvTqv72ZG5UKHeFu56qXFsuoz3rw832eC5'
AND f3.value:instructions[1]:parsed:info:mint::string IN ('ATLASXmbPQxBUYbxPsV97usA3fPQYEqzQBUHgiFCUsXx', 'EPjFWdd5AufqSSqeM2qN1xzybapC8G4wEGGkZwyTDt1v')
then f3.value:instructions[2]:parsed:info:tokenAmount:uiAmount
when f3.value:instructions[1]:parsed:info:mint::string = '267DbhCypYzvTqv72ZG5UKHeFu56qXFsuoz3rw832eC5'
AND f3.value:instructions[2]:parsed:info:mint::string IN ('ATLASXmbPQxBUYbxPsV97usA3fPQYEqzQBUHgiFCUsXx', 'EPjFWdd5AufqSSqeM2qN1xzybapC8G4wEGGkZwyTDt1v')
then f3.value:instructions[1]:parsed:info:tokenAmount:uiAmount ELSE 0 end) as PXFIVE,
sum(case when f3.value:instructions[2]:parsed:info:mint::string = '9czEqEZ4EkRt7N3HWDcw9qqwys3xRRjGdbn8Jhk8Khwj'
AND f3.value:instructions[1]:parsed:info:mint::string IN ('ATLASXmbPQxBUYbxPsV97usA3fPQYEqzQBUHgiFCUsXx', 'EPjFWdd5AufqSSqeM2qN1xzybapC8G4wEGGkZwyTDt1v')
then f3.value:instructions[2]:parsed:info:tokenAmount:uiAmount
when f3.value:instructions[1]:parsed:info:mint::string = '9czEqEZ4EkRt7N3HWDcw9qqwys3xRRjGdbn8Jhk8Khwj'
AND f3.value:instructions[2]:parsed:info:mint::string IN ('ATLASXmbPQxBUYbxPsV97usA3fPQYEqzQBUHgiFCUsXx', 'EPjFWdd5AufqSSqeM2qN1xzybapC8G4wEGGkZwyTDt1v')
then f3.value:instructions[1]:parsed:info:tokenAmount:uiAmount ELSE 0 end) as VZUSOP,
sum(case when f3.value:instructions[2]:parsed:info:mint::string = 'AkNbg12E9PatjkiAWJ3tAbM479gtcoA1gi6Joa925WKi'
AND f3.value:instructions[1]:parsed:info:mint::string IN ('ATLASXmbPQxBUYbxPsV97usA3fPQYEqzQBUHgiFCUsXx', 'EPjFWdd5AufqSSqeM2qN1xzybapC8G4wEGGkZwyTDt1v')
then f3.value:instructions[2]:parsed:info:tokenAmount:uiAmount
when f3.value:instructions[1]:parsed:info:mint::string = 'AkNbg12E9PatjkiAWJ3tAbM479gtcoA1gi6Joa925WKi'
AND f3.value:instructions[2]:parsed:info:mint::string IN ('ATLASXmbPQxBUYbxPsV97usA3fPQYEqzQBUHgiFCUsXx', 'EPjFWdd5AufqSSqeM2qN1xzybapC8G4wEGGkZwyTDt1v')
then f3.value:instructions[1]:parsed:info:tokenAmount:uiAmount ELSE 0 end) as CALCH,
sum(case when f3.value:instructions[2]:parsed:info:mint::string = 'CWxNX9sTexuqvQefqskhP9f6AP5C8hq2VNkicRseqAT5'
AND f3.value:instructions[1]:parsed:info:mint::string IN ('ATLASXmbPQxBUYbxPsV97usA3fPQYEqzQBUHgiFCUsXx', 'EPjFWdd5AufqSSqeM2qN1xzybapC8G4wEGGkZwyTDt1v')
then f3.value:instructions[2]:parsed:info:tokenAmount:uiAmount
when f3.value:instructions[1]:parsed:info:mint::string = 'CWxNX9sTexuqvQefqskhP9f6AP5C8hq2VNkicRseqAT5'
AND f3.value:instructions[2]:parsed:info:mint::string IN ('ATLASXmbPQxBUYbxPsV97usA3fPQYEqzQBUHgiFCUsXx', 'EPjFWdd5AufqSSqeM2qN1xzybapC8G4wEGGkZwyTDt1v')
then f3.value:instructions[1]:parsed:info:tokenAmount:uiAmount ELSE 0 end) as OGKATP,
sum(case when f3.value:instructions[2]:parsed:info:mint::string = '2iMhgB4pbdKvwJHVyitpvX5z1NBNypFonUgaSAt9dtDt'
Run a query to Download Data