Query editor
WITH cut(src, dst, sa, da, cutover) AS (VALUES('bsc','base','0xb274202daba6ae180c665b4fbe59857b7c3a8091','0x3055913c90fcc1a6ce9a358911721eeb942013a1',TIMESTAMP '2026-08-05 07:54:06'),('base','bsc','0x3055913c90fcc1a6ce9a358911721eeb942013a1','0xb274202daba6ae180c665b4fbe59857b7c3a8091',TIMESTAMP '2026-08-06 08:56:24'),('ethereum','bsc','0x152649ea73beab28c5b49b26eb48f7ead6d4c898','0xb274202daba6ae180c665b4fbe59857b7c3a8091',TIMESTAMP '2026-08-08 14:13:44'),('bsc','arbitrum','0xb274202daba6ae180c665b4fbe59857b7c3a8091','0x1b896893dfc86bb67cf57767298b9073d2c1ba2c',TIMESTAMP '2026-08-05 07:54:06'),('arbitrum','bsc','0x1b896893dfc86bb67cf57767298b9073d2c1ba2c','0xb274202daba6ae180c665b4fbe59857b7c3a8091',TIMESTAMP '2026-08-07 07:03:16'),('monad','bsc','0xf59d81cd43f620e722e07f9cb3f6e41b031017a3','0xb274202daba6ae180c665b4fbe59857b7c3a8091',TIMESTAMP '2026-08-13 07:58:58'),('bsc','monad','0xb274202daba6ae180c665b4fbe59857b7c3a8091','0xf59d81cd43f620e722e07f9cb3f6e41b031017a3',TIMESTAMP '2026-08-10 20:13:53'),('bsc','ethereum','0xb274202daba6ae180c665b4fbe59857b7c3a8091','0x152649ea73beab28c5b49b26eb48f7ead6d4c898',TIMESTAMP '2026-08-05 01:53:21'),('zksync','bsc','0x3a287a06c66f9e95a56327185ca2bdf5f031cecd','0xb274202daba6ae180c665b4fbe59857b7c3a8091',TIMESTAMP '2026-09-24 16:20:04'),('arbitrum','base','0x1b896893dfc86bb67cf57767298b9073d2c1ba2c','0x3055913c90fcc1a6ce9a358911721eeb942013a1',TIMESTAMP '2026-08-19 02:36:04'),('arbitrum','ethereum','0x1b896893dfc86bb67cf57767298b9073d2c1ba2c','0x152649ea73beab28c5b49b26eb48f7ead6d4c898',TIMESTAMP '2026-08-19 19:28:51'),('base','arbitrum','0x3055913c90fcc1a6ce9a358911721eeb942013a1','0x1b896893dfc86bb67cf57767298b9073d2c1ba2c',TIMESTAMP '2026-08-17 19:34:52'),('linea','bsc','0x0d1e753a25ebda689453309112904807625befbe','0xb274202daba6ae180c665b4fbe59857b7c3a8091',TIMESTAMP '2026-08-08 09:19:11'),('ethereum','base','0x152649ea73beab28c5b49b26eb48f7ead6d4c898','0x3055913c90fcc1a6ce9a358911721eeb942013a1',TIMESTAMP '2026-08-19 20:46:45'),('bsc','zksync','0xb274202daba6ae180c665b4fbe59857b7c3a8091','0x3a287a06c66f9e95a56327185ca2bdf5f031cecd',TIMESTAMP '2026-08-19 20:57:21'),('base','ethereum','0x3055913c90fcc1a6ce9a358911721eeb942013a1','0x152649ea73beab28c5b49b26eb48f7ead6d4c898',TIMESTAMP '2026-08-19 07:22:13'),('zksync','base','0x3a287a06c66f9e95a56327185ca2bdf5f031cecd','0x3055913c90fcc1a6ce9a358911721eeb942013a1',TIMESTAMP '2026-09-24 18:01:10'),('opbnb','bsc','0x2779106e4f4a8a28d77a24c18283651a2ae22d1c','0xb274202daba6ae180c665b4fbe59857b7c3a8091',TIMESTAMP '2026-08-13 13:47:46'),('bsc','linea','0xb274202daba6ae180c665b4fbe59857b7c3a8091','0x0d1e753a25ebda689453309112904807625befbe',TIMESTAMP '2026-09-08 14:17:53'),('base','zksync','0x3055913c90fcc1a6ce9a358911721eeb942013a1','0x3a287a06c66f9e95a56327185ca2bdf5f031cecd',TIMESTAMP '2026-09-28 11:25:11'),('ethereum','arbitrum','0x152649ea73beab28c5b49b26eb48f7ead6d4c898','0x1b896893dfc86bb67cf57767298b9073d2c1ba2c',TIMESTAMP '2026-08-19 19:31:04'),('linea','base','0x0d1e753a25ebda689453309112904807625befbe','0x3055913c90fcc1a6ce9a358911721eeb942013a1',TIMESTAMP '2026-08-24 16:14:21'),('opbnb','base','0x2779106e4f4a8a28d77a24c18283651a2ae22d1c','0x3055913c90fcc1a6ce9a358911721eeb942013a1',TIMESTAMP '2026-08-06 18:24:57'),('opbnb','arbitrum','0x2779106e4f4a8a28d77a24c18283651a2ae22d1c','0x1b896893dfc86bb67cf57767298b9073d2c1ba2c',TIMESTAMP '2026-08-10 16:18:04'),('zksync','arbitrum','0x3a287a06c66f9e95a56327185ca2bdf5f031cecd','0x1b896893dfc86bb67cf57767298b9073d2c1ba2c',TIMESTAMP '2026-10-04 08:59:38'),('base','monad','0x3055913c90fcc1a6ce9a358911721eeb942013a1','0xf59d81cd43f620e722e07f9cb3f6e41b031017a3',TIMESTAMP '2026-09-07 07:05:37'),('bsc','opbnb','0xb274202daba6ae180c665b4fbe59857b7c3a8091','0x2779106e4f4a8a28d77a24c18283651a2ae22d1c',TIMESTAMP '2026-08-05 19:27:52')),raw AS (SELECT m.*, ROW_NUMBER() OVER (PARTITION BY m.primary_key ORDER BY m._updated_at DESC) AS rnFROM layerzero.messages mWHERE m.ts_source >= TIMESTAMP '2026-07-06 00:00:00'AND lower(m.project) LIKE '%pancake%'),msgs AS (SELECT * FROM raw WHERE rn = 1),tr AS (SELECT messages_foreign_key, SUM(usd_value) AS usdFROM (SELECT t.*, ROW_NUMBER() OVER (PARTITION BY t.primary_key ORDER BY t._updated_at DESC) AS rnFROM layerzero.transfers tWHERE t.messages_foreign_key IN (SELECT primary_key FROM msgs)) WHERE rn = 1GROUP BY 1),j AS (SELECT m.ts_source, COALESCE(tr.usd, 0) AS usd,CASE WHEN c.cutover IS NOT NULL AND m.ts_source >= c.cutover THEN 1 ELSE 0 END AS canaryFROM msgs mLEFT JOIN tr ON tr.messages_foreign_key = m.primary_keyLEFT JOIN cut c ON c.src = m.source_chain_key AND c.dst = m.destination_chain_keyAND c.sa = lower(m.source_contract) AND c.da = lower(m.destination_contract)),b AS (SELECT 'week' AS period_type, CAST(CAST(date_trunc('week', ts_source) AS date) AS varchar) AS period, ts_source, usd, canary FROM jUNION ALLSELECT 'last_30d', 'last_30d', ts_source, usd, canary FROM j WHERE ts_source >= now() - INTERVAL '30' DAYUNION ALLSELECT 'since_2026-07-06', 'since_2026-07-06', ts_source, usd, canary FROM j)