kidaSolana Wallet Balance Over Time v2
Updated 2023-01-26
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
›
⌄
with transactions as (
select *
from solana.core.fact_transactions
where
array_contains('{{address}}'::variant, signers)
and succeeded
order by block_timestamp
)
select
block_timestamp,
tx_id,
'{{address}}' as address,
'SOL' as symbol,
pre_balances[f.index] / 1e9 as account_pre_balance_sol,
post_balances[f.index] / 1e9 as account_post_balance_sol
from
transactions,
lateral flatten(input => account_keys) f
where
f.value:pubkey = '{{address}}'
order by block_timestamp
Run a query to Download Data