tested worked

datavortextested worked

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 IN (

'0xaf3da220bc03bdbf9b0280d6e2813ea0ffe03f69',

'0x78c6db2b6073e762f89a23eb3da71d2feeb18315',

'0x4f059f8d45230cd5b37544e87eebba033a5f1b17',

'0x6398a59ca706c11d02de1ea3d921742771bcd06f',

'0xce4956c398ba118f4eacabca1b32ae97bd31df2a',

'0x247442181b8baa03b3c7dc0d8e971bd4686db27c',

'0x48643395833882729032170078bf7791a0999f8c',

'0x3b444d1dbf68d1cfc64a8158affb6a24a6bdf038',

'0x2e014fe08247a080f2ed6d230b2594911f9f9a69',

'0x0ec9d6d21358221cccfc933530a8026038cedc12'

)

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')

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	0x5ed283be0bca106fc634501c67dbcefd741f1fe79ba09ef2ffb09b0126db94e9	0x4f059f8d45230cd5b37544e87eebba033a5f1b17	Sushiswap	0x1b02da8cb0d097eb8d57a175b88c7d8b47997506	0x1b02da8cb0d097eb8d57a175b88c7d8b47997506	6	1	USDC	WETH	27.859266	0.008169856265	USDC	WETH
2	0x5ed33742d7679aa8c915d8398071e75ed828f4ffa8d51c2cdbe9e7d362ac65d2	0x0ec9d6d21358221cccfc933530a8026038cedc12	Uniswap	0xda426897b34d30aa88ce3bf2f721999bb3861420	0xda426897b34d30aa88ce3bf2f721999bb3861420	4	1	USDC	WETH	0.01880083203	60.713194	WETH	USDC
3	0x5ed34e0ddaeec4611ce9ab814789b7621e04b3bf6dfeb325f91b979ff290933c	0x0ec9d6d21358221cccfc933530a8026038cedc12	Uniswap	0xbb3d9dbd9fa392cc0b7a8d7bfbb688d4787313d1	0x599fbdc7a399f359a683f5e1cdc05a373a345346	4	1	USDC	WETH	12.004689	0.002982062014	USDC	WETH
4	0x5ed357868c16cecb1432443de6ba0087d44a557104709cb333a911674b265bea	0x0ec9d6d21358221cccfc933530a8026038cedc12	Uniswap	0xd559a33d7d611555a1cba0d653cef693cc2e0501	0x599fbdc7a399f359a683f5e1cdc05a373a345346	3	1	USDC	WETH	0.002	6.770633	WETH	USDC
5	0x5ed3b8aab5d6aa7eede104ab1645f192d15e8b3a432e7bbbd207d4dcc7eea8e0	0x4f059f8d45230cd5b37544e87eebba033a5f1b17	Sushiswap	0x9f034dddd9c6464e827f648110dda4b6a3a42844	0x1b02da8cb0d097eb8d57a175b88c7d8b47997506	4	1	USDC	WETH	174.189607	0.05541436795	USDC	WETH
6	0x5ed48b9b8ad62cf8a4111216a6cfffbc70f086c6df8afe79f769a3d76be3dd2c	0x0ec9d6d21358221cccfc933530a8026038cedc12	Uniswap	0x361cf2208a15f92a6244d6dadf9db9250a7b05cc	0x599fbdc7a399f359a683f5e1cdc05a373a345346	3	1	USDC	WETH	0.002	7.110923	WETH	USDC
7	0x5ed6bdb017cac81a8a7b1db04ddab1498c73541d28d48b75efb4c47bf8ce6a40	0x0ec9d6d21358221cccfc933530a8026038cedc12	Uniswap	0xab25d840e74ea25530d876807afe34434cc4d2bf	0x599fbdc7a399f359a683f5e1cdc05a373a345346	3	1	USDC	WETH	0.002	6.66133	WETH	USDC
8	0x5ed757af4b2dec014e6e635317fb25fb741940a7432003ee60fbf3c9d609823c	0x0ec9d6d21358221cccfc933530a8026038cedc12	Uniswap	0x77d3efa54ebb2ef803f0d77dcbccb920ae48bbdf	0x599fbdc7a399f359a683f5e1cdc05a373a345346	4	1	USDC	WETH	9.829727	0.002982057562	USDC	WETH
9	0x5ed7e0df6c2ec4df2abb15d68c4a622b91723c6589d7802ff38d757b4ed1046f	0x247442181b8baa03b3c7dc0d8e971bd4686db27c	Sushiswap	0xdd2b78570f7cceec490bb854ce81d85a6f9d9959	0x1b02da8cb0d097eb8d57a175b88c7d8b47997506	4	1	BOBA	WETH	0.01659538211	283.3	WETH	BOBA
10	0x5ed8e02520ee3df239aa073bd79bc11abf3ad639a8f03dd1282d0d4a679da927	0x0ec9d6d21358221cccfc933530a8026038cedc12	Uniswap	0x000000000003b57982426680c8eeeaf1920ffe21	0x000000000003b57982426680c8eeeaf1920ffe21	3	1	USDC	WETH	0.008099642121	29.912826	WETH	USDC
11	0x5ed91691d0458143cb6f66f26797ca74d511043ad74da66cb7e590df6187d5d4	0x247442181b8baa03b3c7dc0d8e971bd4686db27c	Sushiswap	0xbe811a0d44e2553d25d11cb8dc0d3f0d0e6430e6	0xbe811a0d44e2553d25d11cb8dc0d3f0d0e6430e6	4	1	BOBA	WETH	2500	0.2183762042	BOBA	WETH
12	0x5edbc25cbc861886275ccc4e5970926d837e2c3d2a6b72417b1c000402bdf226	0x4f059f8d45230cd5b37544e87eebba033a5f1b17	Sushiswap	0x9f034dddd9c6464e827f648110dda4b6a3a42844	0x1b02da8cb0d097eb8d57a175b88c7d8b47997506	4	1	USDC	WETH	169.533113	0.05235814162	USDC	WETH
13	0x5edc53f149e2409cbe4eab81cef0e7c78af3dd3ce1a8e0da26f629f0fab47084	0x247442181b8baa03b3c7dc0d8e971bd4686db27c	Sushiswap	0x000000000003b57982426680c8eeeaf1920ffe21	0x000000000003b57982426680c8eeeaf1920ffe21	3	1	BOBA	WETH	0.02156387875	360.169536425	WETH	BOBA
14	0x5edcbff96b5da88269b5eeac59682f8cd6baa2d018301d240e643782ba816c4c	0x0ec9d6d21358221cccfc933530a8026038cedc12	Uniswap	0xf2630ca4592fc63afafd69a2cf92315df3caae82	0x599fbdc7a399f359a683f5e1cdc05a373a345346	4	1	USDC	WETH	7.20601	0.001988032682	USDC	WETH
15	0x5ede1ebb92f41447daf17dab6b5d7ab8fc493e8b5c1038bf3c36a3008f8cb413	0x0ec9d6d21358221cccfc933530a8026038cedc12	Uniswap	0x361cf2208a15f92a6244d6dadf9db9250a7b05cc	0x599fbdc7a399f359a683f5e1cdc05a373a345346	4	1	USDC	WETH	7.335663	0.001988032755	USDC	WETH
16	0x5ede915c2a2389a7df37cc46667bb694bf52b2af7ca1d977043b30920ebc3449	0x4f059f8d45230cd5b37544e87eebba033a5f1b17	Sushiswap	0x85cd07ea01423b1e937929b44e4ad8c40bbb5e71	0x85cd07ea01423b1e937929b44e4ad8c40bbb5e71	9	1	USDC	WETH	0.1537	403.415674	WETH	USDC
17	0x5edea98eb22142e514434d04a79830302a95126f4c50be43137cd0d281b0d1b3	0x247442181b8baa03b3c7dc0d8e971bd4686db27c	Sushiswap	0x9f034dddd9c6464e827f648110dda4b6a3a42844	0x1b02da8cb0d097eb8d57a175b88c7d8b47997506	3	1	BOBA	WETH	0.09941898477	1728.110304282	WETH	BOBA
18	0x5edfaed46efa6d9d8d31ba48afb52080070f73eb6eff50f8ba2794c6f9b535b5	0x4f059f8d45230cd5b37544e87eebba033a5f1b17	Sushiswap	0x9f034dddd9c6464e827f648110dda4b6a3a42844	0x1b02da8cb0d097eb8d57a175b88c7d8b47997506	3	1	USDC	WETH	0.05476380472	176.697511	WETH	USDC
19	0x5ee1af1d1c8fce6a7e0d524881f1c55152b9e336abd8a56518da87f2b0ca471d	0x4f059f8d45230cd5b37544e87eebba033a5f1b17	Sushiswap	0x000000000003b57982426680c8eeeaf1920ffe21	0x000000000003b57982426680c8eeeaf1920ffe21	3	1	USDC	WETH	0.0146011377	40.280333	WETH	USDC
20	0x5ee26695df4b456ea4982b1b49c4b581c037469563903bf727618d2bd6270ba2	0x0ec9d6d21358221cccfc933530a8026038cedc12	Uniswap	0xdaeb0289fe992370ad8dc91af86d2c6d532abf38	0x599fbdc7a399f359a683f5e1cdc05a373a345346	4	1	USDC	WETH	6.880648	0.001988032006	USDC	WETH

...

200

53KB

flipside

flipside