routerv21 AS (

select

CASE

-- WHEN ORIGIN_FUNCTION_SIGNATURE = '0x212a1d94' THEN 'swapExactTokensForTokensSupportingFeeOnTransferTokens'

-- WHEN ORIGIN_FUNCTION_SIGNATURE = '0x264bb94e' THEN 'swapExactAVAXForTokens'

-- WHEN ORIGIN_FUNCTION_SIGNATURE = '0xb066ea7c' THEN 'swapExactAVAXForTokens' --v21

-- WHEN ORIGIN_FUNCTION_SIGNATURE = '0x42f564a0' THEN 'swapAVAXForExactTokens'

-- WHEN ORIGIN_FUNCTION_SIGNATURE = '0x2075ad22' THEN 'swapAVAXForExactTokens' --v21

-- WHEN ORIGIN_FUNCTION_SIGNATURE = '0x440830bd' THEN 'swapExactAVAXForTokensSupportingFeeOnTransferTokens'

-- WHEN ORIGIN_FUNCTION_SIGNATURE = '0x6d0ff495' THEN 'swapExactTokensForTokens'

-- WHEN ORIGIN_FUNCTION_SIGNATURE = '0x2a443fae' THEN 'swapExactTokensForTokens'

-- WHEN ORIGIN_FUNCTION_SIGNATURE = '0x6d3420ed' THEN 'swapTokensForExactAVAX'

-- WHEN ORIGIN_FUNCTION_SIGNATURE = '0x3dc8f8ec' THEN 'swapTokensForExactAVAX' --v21

-- WHEN ORIGIN_FUNCTION_SIGNATURE = '0x8803dbee' THEN 'swapTokensForExactTokens'

-- WHEN ORIGIN_FUNCTION_SIGNATURE = '0x92fe8e70' THEN 'swapTokensForExactTokens' --v21

-- WHEN ORIGIN_FUNCTION_SIGNATURE = '0x9a17e820' THEN 'swapExactTokensForAVAXSupportingFeeOnTransferTokens'

-- WHEN ORIGIN_FUNCTION_SIGNATURE = '0xa2a1623d' THEN 'swapExactAVAXForTokens'

-- WHEN ORIGIN_FUNCTION_SIGNATURE = '0xa7b856d3' THEN 'swapTokensForExactTokens'

-- WHEN ORIGIN_FUNCTION_SIGNATURE = '0xfb321c70' THEN 'swapExactTokensForAVAX'

-- WHEN ORIGIN_FUNCTION_SIGNATURE = '0x9ab6156b' THEN 'swapExactTokensForAVAX' --v21

WHEN ORIGIN_FUNCTION_SIGNATURE = '0xbcb1c957' THEN 'removeLiquidityAVAX'

WHEN ORIGIN_FUNCTION_SIGNATURE = '0x81c2fdfb' THEN 'removeLiquidityAVAX' --v21

WHEN ORIGIN_FUNCTION_SIGNATURE = '0xc22159b6' THEN 'removeLiquidity'

WHEN ORIGIN_FUNCTION_SIGNATURE = '0xe324a3e4' THEN 'addLiquidity'

WHEN ORIGIN_FUNCTION_SIGNATURE = '0xa3c7271a' THEN 'addLiquidity' --v21

WHEN ORIGIN_FUNCTION_SIGNATURE = '0xea8f43d8' THEN 'addLiquidityAVAX'

WHEN ORIGIN_FUNCTION_SIGNATURE = '0x8efc2b2c' THEN 'addLiquidityAVAX' --v21

ELSE 'OTHERS'

END AS FUNCTION_NAME,

NULLIF(

COUNT(

CASE

WHEN BLOCK_TIMESTAMP >= TO_TIMESTAMP(1680714000) THEN 1

END