AephiaLP spend by faction
Updated 2024-04-07
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
›
⌄
⌄
select
--*
--/*
date_trunc('week', block_timestamp::date) as date,
instruction:data as LP,
HE_ENCODE(LP,1) as LP2
--to_number(instruction:data, 'XXXXXXXXXXXXXXXX') //2161818620009140166
/*
sum(value:parsed:info:amount) / POW(10,8) AS atlas_SCORE,
---
sum(atlas_score) over (order by date) as atlas_score_cum
--avg(atlas_score) over (order by date rows between 28 preceding and current row) as avg_atlas_score
*/
from solana.core.fact_events--, lateral flatten(input => inner_instruction:instructions)
WHERE program_id = 'ComputeBudget111111111111111111111111111111'
AND succeeded = 'true'
AND index = 0
AND tx_id = '3pJuJAgLVqN8d8GYkCmKXLZzCnD42EQHqc4mhLp3j4TFtxB6vbmhxgVwHZN8tWoR9eVFsBLtbnJ59k6cgd3KmyVE'
--AND log_messages::string LIKE '%Harvesting%'
AND block_timestamp > '2024-04-01' --AND block_timestamp < current_date
--group by 1
--order by 1 desc
QueryRunArchived: QueryRun has been archived