sELECT

*,

sum(net_volume) over (order by day) as cume_volume

from (

SELECT

date_trunc('day', block_timestamp) as day,

CASE WHEN TRANSFER_TYPE LIKE 'IBC_TRANSFER_OUT'

THEN CASE WHEN receiver LIKE 'osmo%' THEN 'Osmosis'

WHEN receiver LIKE 'comdex%' THEN 'Comdex'

WHEN receiver LIKE 'kujira%' THEN 'Kujira'

WHEN receiver LIKE 'juno%' THEN 'Juno'

WHEN receiver LIKE 'umee%' THEN 'Umee'

WHEN receiver LIKE 'axelar%' THEN 'Axelar'

WHEN receiver LIKE 'evmos%' THEN 'Evmos'

WHEN receiver LIKE 'secret%' THEN 'Secret'

WHEN receiver LIKE 'stride%' THEN 'Strider'

WHEN receiver LIKE 'kava%' THEN 'Kava'

WHEN receiver LIKE 'cre%' THEN 'Cre'

WHEN receiver LIKE 'crc' THEN 'CRC'

WHEN receiver LIKE 'tori%' THEN 'Tori'

WHEN receiver LIKE 'inj%' THEN 'Injective'

ELSE 'Other' END

ELSE

CASE WHEN sender LIKE 'osmo%' THEN 'Osmosis'

WHEN sender LIKE 'comdex%' THEN 'Comdex'

WHEN sender LIKE 'kujira%' THEN 'Kujira'

WHEN sender LIKE 'juno%' THEN 'Juno'

WHEN sender LIKE 'umee%' THEN 'Umee'

WHEN sender LIKE 'axelar%' THEN 'Axelar'

WHEN sender LIKE 'evmos%' THEN 'Evmos'

WHEN sender LIKE 'secret%' THEN 'Secret'

WHEN sender LIKE 'stride%' THEN 'Strider'

WHEN sender LIKE 'kava%' THEN 'Kava'