part2 copy copy copy copy copy copy copy copy copy copy copy copy copy copy copy copy copy copy copy
Afonso_Diazpart2 copy copy copy copy copy copy copy copy copy copy copy copy copy copy copy copy copy copy copy
Updated 2023-12-03
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
34
35
36
›
⌄
-- forked from part2 copy copy copy copy copy copy copy copy copy copy copy copy copy copy copy copy copy copy @ https://flipsidecrypto.xyz/edit/queries/82163291-9c5c-4aae-94ac-98e2f299007f
-- forked from part2 copy copy copy copy copy copy copy copy copy copy copy copy copy copy copy copy copy @ https://flipsidecrypto.xyz/edit/queries/ba2f8e84-a722-449e-8ec4-6481b312eb3c
-- forked from part2 copy copy copy copy copy copy copy copy copy copy copy copy copy copy copy copy @ https://flipsidecrypto.xyz/edit/queries/11441d43-0307-44e7-9b0d-c995217ed67b
-- forked from part2 copy copy copy copy copy copy copy copy copy copy copy copy copy copy copy @ https://flipsidecrypto.xyz/edit/queries/8fdd152c-288d-4c79-b0a0-a3068d8e9a79
-- forked from part2 copy copy copy copy copy copy copy copy copy copy copy copy copy copy @ https://flipsidecrypto.xyz/edit/queries/46372113-6a41-4002-b080-474ceb1a472a
-- forked from part2 copy copy copy copy copy copy copy copy copy copy copy copy copy @ https://flipsidecrypto.xyz/edit/queries/60d922b4-3f38-4768-9b50-4674fb5aa07c
-- forked from part2 copy copy copy copy copy copy copy copy copy copy copy copy @ https://flipsidecrypto.xyz/edit/queries/30384960-4939-4242-aa12-f82818250f3f
-- forked from part2 copy copy copy copy copy copy copy copy copy copy copy @ https://flipsidecrypto.xyz/edit/queries/42e3d470-3e9a-4caa-b449-5afa514d526d
with t as (
select
tx_id,
block_timestamp,
nvl(signers[1], signers[0]) as user,
iff(pre.value:owner = 'FK1VcVh5PqEUm8U3aEz69DRSNSCjD6cMjzGx3KKbiE8', 'Fee', 'Subscribe') as type,
(post.value:uiTokenAmount:amount - pre.value:uiTokenAmount:amount)/1e6 as amount_acs
from solana.core.fact_transactions
join lateral flatten (input => pre_token_balances) pre
join lateral flatten (input => post_token_balances) post
where log_messages::string ilike '%6HW8dXjtiTGkD4jzXs7igdFmZExPpmwUrRN5195xGup%'
and log_messages::string ilike '%Program log: Instruction: Stake%'
and succeeded = 1
and pre.value:owner != user
and pre.value:owner = post.value:owner
)
select * from t
where block_timestamp::date >= '2023-07-01' and block_timestamp::date < '2023-08-01'
Run a query to Download Data