wise-purple

datavortexwise-purple

Updated 2025-03-30

WITH decoded_logs AS (

SELECT

l.tx_hash AS transaction_hash,

'0x' || SUBSTR(l.topics[2], 27) AS recipient,

'0x' || SUBSTR(l.topics[1], 27) AS sender,

l.event_index,

ROW_NUMBER() OVER (PARTITION BY l.tx_hash ORDER BY l.event_index ASC) AS row_num,

l.contract_address AS pool_address,

CAST(ethereum.public.udf_hex_to_int(SUBSTRING(l.data, 3, 64)) AS DECIMAL(38,0)) AS amount0In,

CAST(ethereum.public.udf_hex_to_int(SUBSTRING(l.data, 67, 64)) AS DECIMAL(38,0)) AS amount1In,

CAST(ethereum.public.udf_hex_to_int(SUBSTRING(l.data, 131, 64)) AS DECIMAL(38,0)) AS amount0Out,

CAST(ethereum.public.udf_hex_to_int(SUBSTRING(l.data, 195, 64)) AS DECIMAL(38,0)) AS amount1Out

FROM boba.core.fact_event_logs l

WHERE l.contract_address = '0x6398a59ca706c11d02de1ea3d921742771bcd06f' -- Filter to only this contract

AND l.topics[0] = '0xd78ad95fa46c994b6551d0da85fc275fe613ce37657fb8d5e3d130840159d822'

pool_metadata AS (

SELECT

CONTRACT_ADDRESS AS pool_address,

SYMBOL_1,

SYMBOL_2,

SYMBOL_1_DECIMALS,

SYMBOL_2_DECIMALS,

DEX

FROM $query('2c8e4b07-10b1-4ca2-aa0e-528d0c158522')

)

SELECT

d.transaction_hash,

d.pool_address,

p.DEX,

d.recipient,

d.sender,

d.event_index,

d.row_num,

p.SYMBOL_1 AS symbol1,

p.SYMBOL_2 AS symbol2,

Last run: about 1 month ago

	TRANSACTION_HASH	POOL_ADDRESS	DEX	RECIPIENT	SENDER	EVENT_INDEX	ROW_NUM	SYMBOL1	SYMBOL2	FINAL_AMOUNT_IN	FINAL_AMOUNT_OUT	TOKEN_IN_SYMBOL	TOKEN_OUT_SYMBOL
1	0xf647a5acdf184e56da4683a058e3b4f70564196142e8ba8269146c5c779ab559	0x6398a59ca706c11d02de1ea3d921742771bcd06f	Sushiswap	0x4f059f8d45230cd5b37544e87eebba033a5f1b17	0x1b02da8cb0d097eb8d57a175b88c7d8b47997506	7	1	WBTC	WETH	0.00208872	0.03625274164	WBTC	WETH
2	0xf6798de19491f8d1dd876ffd7dd032fb8dbc86c0130a1aee253d5026b8094bcd	0x6398a59ca706c11d02de1ea3d921742771bcd06f	Sushiswap	0x9f034dddd9c6464e827f648110dda4b6a3a42844	0x1b02da8cb0d097eb8d57a175b88c7d8b47997506	3	1	WBTC	WETH	0.2297321117	0.01461204	WETH	WBTC
3	0xf67e6b033b998ec2c1bb783e4d8691be8595e6e4da3138f74e3ff8b43d3f14c1	0x6398a59ca706c11d02de1ea3d921742771bcd06f	Sushiswap	0xb2bb815784685b3c5b996e002d442e1113c56ab0	0x1b02da8cb0d097eb8d57a175b88c7d8b47997506	3	1	WBTC	WETH	0.18	0.00993079	WETH	WBTC
4	0xf68ea79209f32f557361db60bae5e0cc4a78db63078c031722ea751e5bee8179	0x6398a59ca706c11d02de1ea3d921742771bcd06f	Sushiswap	0x000000000003b57982426680c8eeeaf1920ffe21	0x000000000003b57982426680c8eeeaf1920ffe21	6	1	WBTC	WETH	0.00029714	0.009366798519	WBTC	WETH
5	0xf6d71678f7324aa620fe226748dc95ecd42e51a1e87009ab8873446069984dd7	0x6398a59ca706c11d02de1ea3d921742771bcd06f	Sushiswap	0xeef227ecccec2213f80bb92cb648b0ddbaab00ab	0x000000000003b57982426680c8eeeaf1920ffe21	10	1	WBTC	WETH	0.002126041063	0.00004953	WETH	WBTC
6	0xf6eba32bf7ec54b0cc65234281cbffb57b61b2de129d338354c599f77779e449	0x6398a59ca706c11d02de1ea3d921742771bcd06f	Sushiswap	0xf2614a233c7c3e7f08b1f887ba133a13f1eb2c55	0xf2614a233c7c3e7f08b1f887ba133a13f1eb2c55	3	1	WBTC	WETH	0.5092	0.01922102	WETH	WBTC
7	0xf7104b33333c98eecaa61184a923413446d6e6f9d1a894ab90cb71267da81a65	0x6398a59ca706c11d02de1ea3d921742771bcd06f	Sushiswap	0xb2bb815784685b3c5b996e002d442e1113c56ab0	0x1b02da8cb0d097eb8d57a175b88c7d8b47997506	3	1	WBTC	WETH	0.18	0.00991162	WETH	WBTC
8	0xf752cb45cd777566d8b44864c8093a273913d9ad85decdcef45ef1140c2e4679	0x6398a59ca706c11d02de1ea3d921742771bcd06f	Sushiswap	0xb2bb815784685b3c5b996e002d442e1113c56ab0	0x1b02da8cb0d097eb8d57a175b88c7d8b47997506	4	1	WBTC	WETH	0.014	0.2470131948	WBTC	WETH
9	0xf7afd88a0385b1a526422d9bf3b7ce30de23423e52f7c8e3a0b6af2547139b28	0x6398a59ca706c11d02de1ea3d921742771bcd06f	Sushiswap	0x9f3423c7177f3e15211f7c9b7521bce06fd324b6	0x9f3423c7177f3e15211f7c9b7521bce06fd324b6	6	1	WBTC	WETH	0.01402748	0.1891529645	WBTC	WETH
10	0xf7da7ef49b3b0867b7afba3fc6a7b492da626b94565380af8c49480f38d44b7f	0x6398a59ca706c11d02de1ea3d921742771bcd06f	Sushiswap	0x2b8cd75d3e679531918feebb9f095a17c982baca	0x1b02da8cb0d097eb8d57a175b88c7d8b47997506	7	1	WBTC	WETH	0.1763673921	0.013	WETH	WBTC
11	0xf7f3af0fbdabb036ca20c28664f8652c4d1effcb05de9c7539692e7835fffa48	0x6398a59ca706c11d02de1ea3d921742771bcd06f	Sushiswap	0x3a42696894d44edd10f0e2c853e9aaf107271d78	0x3a42696894d44edd10f0e2c853e9aaf107271d78	7	1	WBTC	WETH	0.0001485	0.00481951388	WBTC	WETH
12	0xf867d57fa30ad979491deaaf7ca2690cd810a615e7e8cd109bbb955189291039	0x6398a59ca706c11d02de1ea3d921742771bcd06f	Sushiswap	0xeef227ecccec2213f80bb92cb648b0ddbaab00ab	0x81242ef631362b0de648a7e10349b116f6fba8e6	4	1	WBTC	WETH	0.1562045031	0.00897642	WETH	WBTC
13	0xf883bdf8813be649e946f04838e5789abaf0bd595f7338fd244de46051025aa0	0x6398a59ca706c11d02de1ea3d921742771bcd06f	Sushiswap	0x06011bac714818bc4a198932e51e7f029eacf109	0x06011bac714818bc4a198932e51e7f029eacf109	8	1	WBTC	WETH	0.002471715832	0.00012522	WETH	WBTC
14	0xf8a668f5633e2c81ddc6e4082db84c1132c86abddb4855ab1be26d89cd3c2e4b	0x6398a59ca706c11d02de1ea3d921742771bcd06f	Sushiswap	0xb2bb815784685b3c5b996e002d442e1113c56ab0	0xe43ca1dee3f0fc1e2df73a0745674545f11a59f5	3	1	WBTC	WETH	0.1898	0.01009649	WETH	WBTC
15	0x7dc1742c458a25cb34754ddf199ea0fa48c052e25d4a5f52ce5ab18bb80a36ef	0x6398a59ca706c11d02de1ea3d921742771bcd06f	Sushiswap	0xb2bb815784685b3c5b996e002d442e1113c56ab0	0x1b02da8cb0d097eb8d57a175b88c7d8b47997506	4	1	WBTC	WETH	0.015	0.3023731763	WBTC	WETH
16	0x7dc5a47043bc05e03fcf93d3a0787d5672ecdd60028f4d12abaa8d3f0a20b62d	0x6398a59ca706c11d02de1ea3d921742771bcd06f	Sushiswap	0x842fab064cdc9dc0715cd4bdca5756f7d347efee	0xbe811a0d44e2553d25d11cb8dc0d3f0d0e6430e6	4	1	WBTC	WETH	0.1	0.00584098	WETH	WBTC
17	0x7ddc25b21f1619da199f52ac28dc6bbde7e5be19de42da9d6484b5937a3c7dd1	0x6398a59ca706c11d02de1ea3d921742771bcd06f	Sushiswap	0xf2614a233c7c3e7f08b1f887ba133a13f1eb2c55	0xf2614a233c7c3e7f08b1f887ba133a13f1eb2c55	4	1	WBTC	WETH	0.1	0.0039485	WETH	WBTC
18	0x7de6cda1e997207f52e2a9658265d52d4c3e84e59e83e25ab5c56c2aa136aa37	0x6398a59ca706c11d02de1ea3d921742771bcd06f	Sushiswap	0x1b02da8cb0d097eb8d57a175b88c7d8b47997506	0x1b02da8cb0d097eb8d57a175b88c7d8b47997506	4	1	WBTC	WETH	0.01742182	0.24	WBTC	WETH
19	0x7df7aee9fb223ca58f880a90226bb268fb1675e28139f6363973f25fae19c769	0x6398a59ca706c11d02de1ea3d921742771bcd06f	Sushiswap	0x06011bac714818bc4a198932e51e7f029eacf109	0x06011bac714818bc4a198932e51e7f029eacf109	4	1	WBTC	WETH	0.04292561	0.7336452617	WBTC	WETH
20	0x7dfd8eb7f36a7b16e7ea6d398686305ec453126e7e56048cd918e805600c5120	0x6398a59ca706c11d02de1ea3d921742771bcd06f	Sushiswap	0xb2bb815784685b3c5b996e002d442e1113c56ab0	0x1b02da8cb0d097eb8d57a175b88c7d8b47997506	4	1	WBTC	WETH	0.015	0.3140254601	WBTC	WETH

...

200

53KB

18s

flipside

flipside