part2 copy copy copy copy copy copy copy copy copy copy copy copy copy copy copy copy copy copy copy copy copy 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 copy copy copy copy copy copy copy copy copy copy copy copy copy copy copy copy copy copy copy copy copy

Updated 2023-12-04

-- forked from part2 copy copy copy copy copy copy copy copy copy copy copy copy copy copy copy copy copy copy copy copy copy copy copy copy copy copy copy copy copy copy copy copy copy copy copy copy copy copy copy @ https://flipsidecrypto.xyz/edit/queries/7189b586-f2d1-4b47-b2c1-b1748ec2429a

-- forked from part2 copy copy copy copy copy copy copy copy copy copy copy copy copy copy copy copy copy copy copy copy copy copy copy copy copy copy copy copy copy copy copy copy copy copy copy copy copy copy @ https://flipsidecrypto.xyz/edit/queries/a6bd0ff9-f231-475d-8304-d0f4843e2699

-- forked from part2 copy copy copy copy copy copy copy copy copy copy copy copy copy copy copy copy copy copy copy copy copy copy copy copy copy copy copy copy copy copy copy copy copy copy copy copy copy @ https://flipsidecrypto.xyz/edit/queries/1322c2a9-e44c-4e72-900d-66548f71941d

-- forked from part2 copy copy copy copy copy copy copy copy copy copy copy copy copy copy copy copy copy copy copy copy copy copy copy copy copy copy copy copy copy copy copy copy copy copy copy copy @ https://flipsidecrypto.xyz/edit/queries/e3ffdd22-248e-46f4-8671-d219e696c81f

-- forked from part2 copy copy copy copy copy copy copy copy copy copy copy copy copy copy copy copy copy copy copy copy copy copy copy copy copy copy copy copy copy copy copy copy copy copy copy @ https://flipsidecrypto.xyz/edit/queries/e1793044-fa6a-4ae2-9c5f-2432615709d4

-- forked from part2 copy copy copy copy copy copy copy copy copy copy copy copy copy copy copy copy copy copy copy copy copy copy copy copy copy copy copy copy copy copy copy copy copy copy @ https://flipsidecrypto.xyz/edit/queries/e349819e-9637-4d67-bd6e-7772813c9def

-- forked from part2 copy copy copy copy copy copy copy copy copy copy copy copy copy copy copy copy copy copy copy copy copy copy copy copy copy copy copy copy copy copy copy copy copy @ https://flipsidecrypto.xyz/edit/queries/9c9ea9e7-6d1c-4294-a35e-dba107acffda

-- forked from part2 copy copy copy copy copy copy copy copy copy copy copy copy copy copy copy copy copy copy copy copy copy copy copy copy copy copy copy copy copy copy copy copy @ https://flipsidecrypto.xyz/edit/queries/9c531f8b-ae1a-4228-b080-86438622827c

-- forked from part2 copy copy copy copy copy copy copy copy copy copy copy copy copy copy copy copy copy copy copy copy copy copy copy copy copy copy copy copy copy copy copy @ https://flipsidecrypto.xyz/edit/queries/5f20a6b9-46b9-4e3f-be5e-c708b5e576e6

-- forked from part2 copy copy copy copy copy copy copy copy copy copy copy copy copy copy copy copy copy copy copy copy copy copy copy copy copy copy copy copy copy copy @ https://flipsidecrypto.xyz/edit/queries/0135330a-d413-4acd-ac8e-253eb93ef6fe

-- forked from part2 copy copy copy copy copy copy copy copy copy copy copy copy copy copy copy copy copy copy copy copy copy copy copy copy copy copy copy copy copy @ https://flipsidecrypto.xyz/edit/queries/1d4b9d73-e70b-47cd-b609-38b752e6ca59

-- forked from part2 copy copy copy copy copy copy copy copy copy copy copy copy copy copy copy copy copy copy copy copy copy copy copy copy copy copy copy copy @ https://flipsidecrypto.xyz/edit/queries/088946b4-95ea-451c-a84c-c144ed75fe32

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%'

Run a query to Download Data