SUM(weekly_volume) AS weekly_volume,

week,

symbol

SELECT

SUM(amount_in_usd) AS weekly_volume,

DATE_TRUNC('week', block_timestamp) AS week,

symbol_in AS symbol

FROM crosschain.core.ez_dex_swaps

WHERE

CASE

WHEN '{{Narrative}}' = 'Real-World Asset' THEN token_in IN (

'0xdab396ccf3d84cf2d07c4454e10c8a6f5b008d2b',

'0xe0bCEEF36F3a6eFDd5EEBFACD591423f8549B9D5',

'0xc221b7E65FfC80DE234bbB6667aBDd46593D34F0',

'0x33349b282065b0284d756f0577fb39c158f935e6',

'0xfAbA6f8e4a5E8Ab82F62fe7C39859FA577269BE3',

'0xf21661d0d1d76d3ecb8e1b9f1c923dbfffae4097',

'0x6e5970dbd6fc7eb1f29c6d2edf2bc4c36124c0c1',

'0x4c19596f5aaff459fa38b0f7ed92f11ae6543784',

'0x509a38b7a1cc0dcd83aa9d06214663d9ec7c7f4a'

)

WHEN '{{Narrative}}' = 'Account Abstraction' THEN token_in IN (

'0xf17e65822b568b3903685a7c9f496cf7656cc6c2', -- BICO

'0x3af33bef05c2dcb3c7288b77fe1c8d2aeba4d789', -- KROM

'0x1559fa1b8f28238fd5d76d9f434ad86fd20d1559', -- EDEN

'0x88800092ff476844f74dc2fc427974bbee2794ae' -- WALLET

)

WHEN '{{Narrative}}' = 'Meme Coins' THEN token_in IN (

'0x0b05459e69a78e458df2d66bd00e75c4d626df53', '0x6643de9fcd28a68c60de68e4a64651c75c0e09b1', '0xac8e13ecc30da7ff04b842f21a62a1fb0f10ebd5', '0xc50ef449171a51fbeafd7c562b064b6471c36caa', '0xd41622cfee1ab406a2109fb674e11b6aae1f3942', '0x9d712a2a6fe6be4bc5cbd2b55a0f5be3e6797d4f', '0xf36a7d8745ee2cf0796557517299f01381f97f7d', '0xc6e679846541be7e02b51849c239150680f906ed', '0xfb02b564ca35f1e8673ea7e2b8ab289ca582f1ad', '0x3567272118ed1dac461658d7889b87c99e0201c6', '0xdd04eb61ccab8295409a4b83f9e96779f6f59988', '0xb915134077bb2906a7e9cf55680c1014b4bb5de5', '0xd12f04517a1a7e5a0cfb74942238d23a090a0948', '0x43a57356a852f29c90b6b2f710348711a0403bfc', '0x5d02b5b84c0d1e33725f27de8c5324b06413ef01', '0x98f817765f69c802a7b188a3165a3267ad2d1123', '0xb50844b129731b7578624bf84f7727e430107b64', '0x063567d5eb19a8c0628a434dece04f9c9c3d4787', '0xea4265ee2f4ea8eb9dca4b1dc9dc63772cde3c98', '0xee0402ab24ceab941958b963e02e2b5a97826447', '0x27f04150c7a24355a52412724237279c5ae3d367', '0xe39b4eb2874a3d7b84618609d52f9cefe1fd72bc', '0xfafaa6cb617506af8f7e859b1d77c7e8cabee693', '0x305e46b2c970ea768f266a9a99160849f0f82ce8', '0xb9297352d02c57e1d997d1dfde4be13e60a33306', '0xe48434e4bf2adfde00b6f2de3aff0b58ea94b0f5', '0xcde9d4be1256a8a7ad5afc86f6ad61a2043d03f5', '0x44f433a8921c21d1dd344a6966b911d460b1f004', '0xb0b195aefa3650a6908f15cdac7d92f8a5791b0b', '0xc49b7758c66e459129ff1e919c161b79cd701fef', '0x19eb681c250c711b900fe32c90ca0a1c49dd125d', '0x9eeed3c42944bae761397e19a51d3fb8d85b1fd4', '0xd48c69152b2a014b20d57ab11c9e664c18faaf61', '0x42d557cd2d4cc8ca1f43da32916b7e8587475fba', '0x6e83e5c738db6805ce334d586c2575deeca2e8c9', '0x1e929259b751149640200661ea4eb3ac1c29b329', '0xa143c587b4c90249c441cd9c95a13e8c83b2442b', '0xa4012214ff24bfe2edb6df0446394550071474df', '0xd5525d397898e5502075ea5e830d8914f6f0affe', '0x449163d11530cd0e9b407900948cca60015bb92b', '0x2327590bb709f1505b64d1e4573d7c0dcea4350c', '0x49642110b712c1fd7261bc074105e9e44676c68f', '0xaa9d38859d654ad61988ea01e00c4ff7c195c951', '0x75f109b31f55edd3aae3d7608f298adda9e7dfb4', '0xc12347f8246d36ab592b55782afe754b22ae587c', '0xe2261868c9f6e9348c4d2864a44ef4f503a4a6ed', '0xb8ac00cd7d05531578f92031e095c8a3f9825548', '0x8

)

WHEN '{{Narrative}}' = 'AI' THEN token_in IN (

'0x5b7533812759b45c2b44c19e320ba2cd2681b542', -- AGIX

'0xaea46a60368a7bd060eec7df8cba43b7ef41ad85', -- FET