AephiaShips traded on marketplace number (weekly)
Updated 2023-06-26
9999
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_volume AS (
select
--*
--date_trunc('week', block_timestamp::date) as date,
-----------------------------------------------------------------------------------------------------
sum(case when inner_instruction:instructions[0]:parsed:info:mint::string = 'Ev3xUhc1Leqi4qR2E5VoG9pcxCvHHmnAaSRVPg485xAT'
then inner_instruction:instructions[0]:parsed:info:tokenAmount:uiAmount
when inner_instruction:instructions[1]:parsed:info:mint::string = 'Ev3xUhc1Leqi4qR2E5VoG9pcxCvHHmnAaSRVPg485xAT'
then inner_instruction:instructions[1]:parsed:info:tokenAmount:uiAmount
when inner_instruction:instructions[2]:parsed:info:mint::string = 'Ev3xUhc1Leqi4qR2E5VoG9pcxCvHHmnAaSRVPg485xAT'
then inner_instruction:instructions[2]:parsed:info:tokenAmount:uiAmount ELSE 0 end) AS OPALJ,
sum(case when inner_instruction:instructions[0]:parsed:info:mint::string = '267DbhCypYzvTqv72ZG5UKHeFu56qXFsuoz3rw832eC5'
then inner_instruction:instructions[0]:parsed:info:tokenAmount:uiAmount
when inner_instruction:instructions[1]:parsed:info:mint::string = '267DbhCypYzvTqv72ZG5UKHeFu56qXFsuoz3rw832eC5'
then inner_instruction:instructions[1]:parsed:info:tokenAmount:uiAmount
when inner_instruction:instructions[2]:parsed:info:mint::string = '267DbhCypYzvTqv72ZG5UKHeFu56qXFsuoz3rw832eC5'
then inner_instruction:instructions[2]:parsed:info:tokenAmount:uiAmount ELSE 0 end) AS PXFIVE,
sum(case when inner_instruction:instructions[0]:parsed:info:mint::string = '9czEqEZ4EkRt7N3HWDcw9qqwys3xRRjGdbn8Jhk8Khwj'
then inner_instruction:instructions[0]:parsed:info:tokenAmount:uiAmount
when inner_instruction:instructions[1]:parsed:info:mint::string = '9czEqEZ4EkRt7N3HWDcw9qqwys3xRRjGdbn8Jhk8Khwj'
then inner_instruction:instructions[1]:parsed:info:tokenAmount:uiAmount
when inner_instruction:instructions[2]:parsed:info:mint::string = '9czEqEZ4EkRt7N3HWDcw9qqwys3xRRjGdbn8Jhk8Khwj'
then inner_instruction:instructions[2]:parsed:info:tokenAmount:uiAmount ELSE 0 end) AS VZUSOP,
sum(case when inner_instruction:instructions[0]:parsed:info:mint::string = 'AkNbg12E9PatjkiAWJ3tAbM479gtcoA1gi6Joa925WKi'
then inner_instruction:instructions[0]:parsed:info:tokenAmount:uiAmount
when inner_instruction:instructions[1]:parsed:info:mint::string = 'AkNbg12E9PatjkiAWJ3tAbM479gtcoA1gi6Joa925WKi'
then inner_instruction:instructions[1]:parsed:info:tokenAmount:uiAmount
when inner_instruction:instructions[2]:parsed:info:mint::string = 'AkNbg12E9PatjkiAWJ3tAbM479gtcoA1gi6Joa925WKi'
then inner_instruction:instructions[2]:parsed:info:tokenAmount:uiAmount ELSE 0 end) AS CALCH,
sum(case when inner_instruction:instructions[0]:parsed:info:mint::string = 'CWxNX9sTexuqvQefqskhP9f6AP5C8hq2VNkicRseqAT5'
then inner_instruction:instructions[0]:parsed:info:tokenAmount:uiAmount
when inner_instruction:instructions[1]:parsed:info:mint::string = 'CWxNX9sTexuqvQefqskhP9f6AP5C8hq2VNkicRseqAT5'
then inner_instruction:instructions[1]:parsed:info:tokenAmount:uiAmount
when inner_instruction:instructions[2]:parsed:info:mint::string = 'CWxNX9sTexuqvQefqskhP9f6AP5C8hq2VNkicRseqAT5'
then inner_instruction:instructions[2]:parsed:info:tokenAmount:uiAmount ELSE 0 end) AS OGKATP,
sum(case when inner_instruction:instructions[0]:parsed:info:mint::string = '2iMhgB4pbdKvwJHVyitpvX5z1NBNypFonUgaSAt9dtDt'
Run a query to Download Data