32 as op_cs1,

243 as op_cs2,

1024 as op_cs3,

3125 as op_cs4,

7776 as op_cs5

),

tab4 as (

with tab3 as (

with tab1 as (

select

tx_from as sender,

sum(case when mint = 'HzUBawF9xxTy4mTuvSkk1a4voJcm65tSHZz6voCDUB33'

then amount * op_cs1

when mint = '2piSPCxbuibsraBnnK4M5rGeHSraNe2oiD8hDw42bPKq'

then amount * op_cs2

when mint = 'C2uF4fECabWryVCV1bDuxP7jMspbf2gei3YAP2UBn292'

then amount * op_cs3

when mint = 'EBEJj1LKuo1k1J2ZvNJxsXATdGYnfaLWzqxck5p4PXSz'

then amount * op_cs4

when mint = '3aTW9zvPz5f7vt2Mfnr5zWA2RcgNTtDSSrBwaxyZ6t7d'

then amount * op_cs5

ELSE 0 end) as cs_vwap_out

from solana.core.fact_transfers, claim_stakes_oprices

where tx_from != 'HrPdPZ1oPNHkbab847dp4AGUMW8eaNAr5oNeRmYZnuwY'

group by 1),

tab2 as (

select

tx_to as receiver,

sum(case when mint = 'HzUBawF9xxTy4mTuvSkk1a4voJcm65tSHZz6voCDUB33'

then amount * op_cs1

when mint = '2piSPCxbuibsraBnnK4M5rGeHSraNe2oiD8hDw42bPKq'