Query editor
WITH address_token_mapping AS (-- Определяем token_mint_address для каждого адресаSELECT DISTINCTaddress,token_mint_addressFROM solana.account_activityWHERE address IN ('{{sol_address}}', '{{token_address}}')AND block_time >= CAST('{{start_date}}' AS TIMESTAMP)AND block_time < CAST('{{end_date}}' AS TIMESTAMP)AND tx_success = trueAND token_mint_address IS NOT NULL),sol_balances AS (-- Балансы SOLSELECTCASEWHEN '{{time_interval}}' = 'hour' THEN DATE_TRUNC('hour', block_time)ELSE DATE_TRUNC('day', block_time)END AS time_period,address,(SELECT token_mint_address FROM address_token_mapping WHERE address = '{{sol_address}}' LIMIT 1) as token_mint_address,'SOL' as token_symbol,LAST_VALUE(post_balance) OVER (PARTITION BY address, DATE_TRUNC('{{time_interval}}', block_time)ORDER BY block_timeROWS BETWEEN UNBOUNDED PRECEDING AND UNBOUNDED FOLLOWING) as balance_lamports,NULL as token_balanceFROM solana.account_activityWHERE address = '{{sol_address}}'AND block_time >= CAST('{{start_date}}' AS TIMESTAMP)AND block_time < CAST('{{end_date}}' AS TIMESTAMP)AND tx_success = true),token_balances AS (-- Балансы токеновSELECTCASEWHEN '{{time_interval}}' = 'hour' THEN DATE_TRUNC('hour', block_time)ELSE DATE_TRUNC('day', block_time)END AS time_period,address,token_mint_address,NULL as token_symbol,NULL as balance_lamports,LAST_VALUE(post_token_balance) OVER (PARTITION BY address, token_mint_address, DATE_TRUNC('{{time_interval}}', block_time)ORDER BY block_timeROWS BETWEEN UNBOUNDED PRECEDING AND UNBOUNDED FOLLOWING) as token_balanceFROM solana.account_activityWHERE address = '{{token_address}}'AND block_time >= CAST('{{start_date}}' AS TIMESTAMP)AND block_time < CAST('{{end_date}}' AS TIMESTAMP)AND tx_success = trueAND token_mint_address IS NOT NULL),combined_balances AS (-- Объединяем балансыSELECT DISTINCT