SELECT tx_from AS address

, SUM(-amount) AS net_amount

FROM solana.core.fact_transfers

WHERE mint = 'DezXAZ8z7PnrnRJjz3wXBoRgixCa6xjnB7YaB1pPB263'

GROUP BY 1

UNION

SELECT tx_to AS address

, SUM(amount) AS net_amount

FROM solana.core.fact_transfers

WHERE mint = 'DezXAZ8z7PnrnRJjz3wXBoRgixCa6xjnB7YaB1pPB263'

GROUP BY 1

), tbl2 AS (

SELECT address

, SUM(net_amount) AS net_amount

FROM tbl

GROUP BY 1

),

tbl4 as

with bonk as

(SELECT close as bonk_price

from solana.price.fact_token_prices_hourly

where recorded_hour = current_date

and symbol = 'BONK'

), shib AS

SELECT price as shib_price

from ethereum.price.ez_hourly_token_prices

where hour = current_date

and symbol = 'SHIB'

SELECT (shib_price)/(bonk_price) as k

from bonk join shib

),