SELECT

DISTINCT tx_id

FROM solana.core.fact_transfers

LEFT outer JOIN solana.core.dim_labels

ON TX_FROM = address

WHERE (address_name LIKE '%ftx%'

OR address_name LIKE '%alameda%' )

AND mint in ('EPjFWdd5AufqSSqeM2qN1xzybapC8G4wEGGkZwyTDt1v', 'Es9vMFrzaCERmJfrF4H2FYD4KCoNkY11McCe8BenwNYB',

'6nuaX3ogrr2CaoAPjtaKHAoBNWok32BMcRozuf32s2QF', 'FYpdBuyAHSbdaAyD1sKkxyLWbAP8uUW9h6uvdhK74ij1')

SELECT

block_timestamp::date as date,

label,

sum(amount) as volume,

sum(volume) over (partition by label order by date) as cum_volume

FROM solana.core.fact_transfers

LEFT outer JOIN solana.core.dim_labels

ON TX_TO = address

WHERE TX_ID IN (SELECT * FROM txTb)

AND not label iLIKE ('ftx')

AND block_timestamp > '2022-10-01'

GROUP BY 1,2