limit 10 */

WITH daily_transactions AS (

SELECT

DATE_TRUNC('day', block_timestamp) AS day,

account_keys,

pre_balances,

post_balances

FROM

solana.core.fact_transactions

WHERE

account_keys::text LIKE '%C3dRLTBgYYQG1Q6czSqjmvgmyLL7upTede6pnzQnco3e%'

AND block_timestamp >= DATE_TRUNC('month', CURRENT_DATE) - INTERVAL '1 month'

AND block_timestamp < DATE_TRUNC('month', CURRENT_DATE)

),

balance_changes AS (

SELECT

day,

CASE

WHEN POSITION('C3dRLTBgYYQG1Q6czSqjmvgmyLL7upTede6pnzQnco3e' IN account_keys::text) > 0 THEN

post_balances[POSITION('C3dRLTBgYYQG1Q6czSqjmvgmyLL7upTede6pnzQnco3e' IN account_keys::text)] -

pre_balances[POSITION('C3dRLTBgYYQG1Q6czSqjmvgmyLL7upTede6pnzQnco3e' IN account_keys::text)]

ELSE 0

END AS daily_balance_change

FROM

daily_transactions

GROUP BY

day, account_keys, pre_balances, post_balances

),

cumulative_balance AS (

SELECT

day,

SUM(daily_balance_change) OVER (ORDER BY day) AS balance

FROM