Limit 1 */

WITH price_query AS (

SELECT symbol, price

FROM solana.price.ez_prices_hourly

WHERE token_address = 'DezXAZ8z7PnrnRJjz3wXBoRgixCa6xjnB7YaB1pPB263'

ORDER BY hour DESC

LIMIT 1

),

main_query AS (

SELECT

t.block_timestamp,

to_char(t.amount, 'FM999,999,999,990.00') AS amount,

to_char(SUM(t.amount) OVER (ORDER BY t.block_timestamp ASC), 'FM999,999,999,990.00') AS running_total,

t.tx_from,

t.index,

f.succeeded,

t.tx_id,

f.instructions,

f.inner_instructions,

f.log_messages,

t.tx_to,

SUM(t.amount) OVER (ORDER BY t.block_timestamp ASC) AS running_total_2

FROM

solana.core.fact_transfers t

LEFT JOIN solana.core.fact_transactions f ON t.tx_id = f.tx_id

WHERE

t.mint = 'DezXAZ8z7PnrnRJjz3wXBoRgixCa6xjnB7YaB1pPB263'

AND t.tx_from IN ('9AdEE8AAm1XgJrPEs4zkTPozr3o4U5iGbgvPwkNdLDJ3', '4hX8YQesSk5JmRNrMXMgXyzbH6L4HG6y7Ujd8v1JH1G2')

AND t.tx_to = '{{Address}}'

-- AND LOG_MESSAGES::string NOT LIKE '%Expired%'

-- AND LOG_MESSAGES::string NOT LIKE '%Withdraw%'