WITH sales AS (

SELECT

BLOCK_TIMESTAMP,

tx_id AS id

FROM

solana.core.fact_transactions

WHERE

BLOCK_TIMESTAMP >= (CURRENT_DATE - interval '60 days')

AND (

array_contains(parse_json('{"pubkey":"M2mx93ekt1fmXSVkTrUL9xVFHkmME8HTUi5Cyc5aF7K","signer":false,"source":"transaction","writable":false}'),account_keys)

OR array_contains(parse_json('{"pubkey":"HYPERfwdTjyJ2SCaKHmpF2MtrXqWxrsotYDsTrshHWq8","signer":false,"source":"transaction","writable":false}'),account_keys)

OR array_contains(parse_json('{"pubkey":"5SKmrbAxnHV2sgqyDXkGrLrokZYtWWVEEk5Soed7VLVN","signer":false,"source":"transaction","writable":false}'),account_keys)

OR array_contains(parse_json('{"pubkey":"CJsLwbP1iu5DuUikHEJnLfANgKy6stB2uFgvBBHoyxwz","signer":false,"source":"transaction","writable":false}'),account_keys)

OR array_contains(parse_json('{"pubkey":"hausS13jsjafwWwGqZTUQRmWyvyxn9EQpqMwV1PBBmk","signer":false,"source":"transaction","writable":false}'),account_keys)

)

), fff_treasury AS (

SELECT

tx_id,

amount

FROM

solana.core.fact_transfers

WHERE

BLOCK_TIMESTAMP >= CURRENT_DATE - INTERVAL '60 days'

AND tx_to = '3pMvTLUA9NzZQd4gi725p89mvND1wRNQM3C8XEv1hTdA'

AND mint = 'So11111111111111111111111111111111111111112'

), tff_treasury AS (

SELECT

tx_id,

amount

FROM

solana.core.fact_transfers

WHERE

BLOCK_TIMESTAMP >= CURRENT_DATE - INTERVAL '60 days'

AND tx_to = 'MwW2RfWAfGrKmh9QAkDELdEV7Ue39FoP885dhuHmqr9'

AND mint = 'So11111111111111111111111111111111111111112'