price AS (

SELECT

RECORDED_HOUR::date AS p_date,

symbol,

TOKEN_ADDRESS,

avg(CLOSE) AS price

FROM

solana.core.ez_token_prices_hourly

GROUP BY

1,

2,

3

),

lend AS (

SELECT

BLOCK_TIMESTAMP::DATE AS date,

symbol,

tx_id,

TX_FROM AS signer,

amount,

amount * price AS amount_usd

FROM

solana.core.fact_transfers a

JOIN price c ON a.mint = c.TOKEN_ADDRESS

AND a.BLOCK_TIMESTAMP::DATE = c.p_date

WHERE

TX_TO IN (

'DD3AeAssFvjqTvRTrRAtpfjkBF8FpVKnFuwnMLN9haXD',

'3uxNepDbmkDNq6JhRja5Z8QwbTrfmkKP8AKZV5chYDGG',

'6YxGd65JbXzgFGWjE44jsyVeCnZp7Bb1wfL9jDia1n8w',

'26kcZkdjJc94PdhqiLiEaGiLCYgAVVUfpDaZyK4cqih3'

)

AND block_timestamp >= CURRENT_DATE - INTERVAL '6 months'

),

borrow AS (