Afonso_Diaz4 copy copy copy copy
Updated 2023-12-05
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 4 copy copy copy @ https://flipsidecrypto.xyz/edit/queries/4472812a-7e80-4d87-b49d-5e43de9243a1
-- forked from 4 copy copy @ https://flipsidecrypto.xyz/edit/queries/3cb0af29-83ff-4a37-9f33-f3a2e2cf68da
-- forked from 4 copy @ https://flipsidecrypto.xyz/edit/queries/775acb26-c829-4a01-934e-14b24a91a0e9
-- forked from 4 @ https://flipsidecrypto.xyz/edit/queries/eb1d6f45-055b-48d4-839b-8842082e8a84
-- forked from 2023-12-03 02:47 AM copy copy @ https://flipsidecrypto.xyz/edit/queries/317deef1-0d6e-4310-aab2-a27dccd20956
-- forked from 2023-12-03 02:47 AM copy @ https://flipsidecrypto.xyz/edit/queries/146f42c6-de68-4faf-8465-35b64c92e046
-- forked from 2023-12-03 02:47 AM @ https://flipsidecrypto.xyz/edit/queries/50005a74-ca7b-4827-935c-786d4af5a193
with t as (
select
tx_id,
block_timestamp,
nvl(signers[1], signers[0]) as user,
(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: Claim rewards%'
and succeeded = 1
and pre.value:owner = user
and pre.value:owner = post.value:owner
)
select * from t
where block_timestamp::date >= '2023-04-01' and block_timestamp::date < '2023-06-01'
limit 15000
Run a query to Download Data