MostlyData_Solana Testing CTEs
Updated 2025-03-18
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
›
⌄
⌄
--/*
with jito_payment_id as(
select
tx_id
from solana.core.fact_transactions
where
signers[0] = 'EG2ziPBR4uc9MzCLxBmnrE7cozKZV8DTvVSxPWXiQ8vh'
and block_timestamp between cast('2025-03-12' as timestamp) and cast('2025-03-18' as timestamp)
)
,balance_change_info as (
select
sb.block_id,
sb.tx_id,
sb.account_address,
sb.balance,
sb.balance - sb.pre_balance as balance_change
from solana.core.fact_sol_balances sb
--join jito_payment_id jpi
-- on jpi.tx_id = sb.tx_id
where
sb.account_address = 'Chorus6Kis8tFHA7AowrPMcRJk3LbApHTYpgSNXzY5KE'
and block_timestamp between cast('2025-03-01' as timestamp) and cast('2025-03-10' as timestamp)
)
select
*
from balance_change_info --limit 100
where balance_change > 0 and balance_change > 0.1
--*/
/*
QueryRunArchived: QueryRun has been archived