WITH addresses AS (
SELECT * FROM solana.core.dim_labels WHERE label = 'ftx'
)
SELECT block_timestamp::DATE AS DAY, label, SUM(amount) AS volume
FROM solana.core.fact_transfers
INNER JOIN solana.core.dim_labels l ON tx_from = address
WHERE tx_to IN (SELECT address FROM addresses)
AND mint IN ('EPjFWdd5AufqSSqeM2qN1xzybapC8G4wEGGkZwyTDt1v', 'Es9vMFrzaCERmJfrF4H2FYD4KCoNkY11McCe8BenwNYB')
AND label <> 'ftx'
AND block_timestamp::DATE >= CURRENT_DATE - 90
GROUP BY 1,2