TRANSACTION_HASH | POOL_ADDRESS | DEX | RECIPIENT | SENDER | EVENT_INDEX | ROW_NUM | SYMBOL1 | SYMBOL2 | FINAL_AMOUNT | TOKEN_SYMBOL | AMOUNT_USED | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
1 | 0x2040726f8ee6e35f7332a780b4e76413323928b83e0d368c8eefc84294fe8fcc | 0x4f059f8d45230cd5b37544e87eebba033a5f1b17 | Sushiswap | 0x2b8cd75d3e679531918feebb9f095a17c982baca | 0x1b02da8cb0d097eb8d57a175b88c7d8b47997506 | 4 | 1 | USDC | WETH | 5.31160338e-10 | WETH | amount1 |
2 | 0x2040830046ff49ddfab2def51ff5e375ff989bf6d7986952b312ad689b9e5cc7 | 0x4f059f8d45230cd5b37544e87eebba033a5f1b17 | Sushiswap | 0x1e70222c0bead73864a9c4ddde682056dd8f9543 | 0x1b02da8cb0d097eb8d57a175b88c7d8b47997506 | 3 | 1 | USDC | WETH | 5.87642117e-10 | WETH | amount1 |
3 | 0x2040be81722eb6a88c0365f9fafe2cf52d2f0af305fab9bfc09f909fc063b09e | 0x247442181b8baa03b3c7dc0d8e971bd4686db27c | Sushiswap | 0x4f059f8d45230cd5b37544e87eebba033a5f1b17 | 0x1b02da8cb0d097eb8d57a175b88c7d8b47997506 | 4 | 1 | BOBA | WETH | 500 | BOBA | amount0 |
4 | 0x2040d06094c8888b1a96986f74b131f6cc5c54352e913ccda3827d19349b446e | 0x247442181b8baa03b3c7dc0d8e971bd4686db27c | Sushiswap | 0x000000000003b57982426680c8eeeaf1920ffe21 | 0x000000000003b57982426680c8eeeaf1920ffe21 | 8 | 1 | BOBA | WETH | 53.680191704 | BOBA | amount0 |
5 | 0x2040d2b17ea8136f399cfbaa332d382b16773913eaa7d01f83084d565c63c8ac | 0x247442181b8baa03b3c7dc0d8e971bd4686db27c | Sushiswap | 0xfdad73963d4c83fd4eb748263cae7583d1192d62 | 0xbe811a0d44e2553d25d11cb8dc0d3f0d0e6430e6 | 3 | 1 | BOBA | WETH | 460.64316198 | WETH | amount1 |
6 | 0x2040e86fbcea5f189d95d3994f4057749ec82ea56b09af50a7f609c51c049e90 | 0x247442181b8baa03b3c7dc0d8e971bd4686db27c | Sushiswap | 0x9f034dddd9c6464e827f648110dda4b6a3a42844 | 0x1b02da8cb0d097eb8d57a175b88c7d8b47997506 | 4 | 1 | BOBA | WETH | 716.138331854 | BOBA | amount0 |
7 | 0x20416daf67919c69273c521a60210fe957798369921123497d1a88ad92857ce1 | 0x4f059f8d45230cd5b37544e87eebba033a5f1b17 | Sushiswap | 0x000000000003b57982426680c8eeeaf1920ffe21 | 0x000000000003b57982426680c8eeeaf1920ffe21 | 5 | 1 | USDC | WETH | 193.227288 | USDC | amount0 |
8 | 0x2041a84e915c419665d82975743e33633d575bc9d28ee2691bff41d26b9b7740 | 0x6398a59ca706c11d02de1ea3d921742771bcd06f | Sushiswap | 0xa608ff30563ceed3f0bc52efc4abfc9502f1a71c | 0xa608ff30563ceed3f0bc52efc4abfc9502f1a71c | 4 | 1 | WBTC | WETH | 0.01 | WBTC | amount0 |
9 | 0x2041ff3c442776cd4c5e7bdd464ac8222aa8a1a7952411b393e6e2d165d43cb4 | 0x0ec9d6d21358221cccfc933530a8026038cedc12 | Uniswap | 0xbb3d9dbd9fa392cc0b7a8d7bfbb688d4787313d1 | 0x599fbdc7a399f359a683f5e1cdc05a373a345346 | 4 | 1 | USDC | WETH | 3.575758 | USDC | amount0 |
10 | 0x2042a03a6e07abee93b8a5881b4fa2a431877ef6a6dfa0cb55c4a35377f90b0e | 0x0ec9d6d21358221cccfc933530a8026038cedc12 | Uniswap | 0x254a63ed6936e445cb9aa3fcb0d6d4255d6160b2 | 0x599fbdc7a399f359a683f5e1cdc05a373a345346 | 4 | 1 | USDC | WETH | 3.259579 | USDC | amount0 |
11 | 0x2042dc0a450e124e9ec65ea095695e2c2712d53569d27363b70e4ac24b4bd016 | 0x247442181b8baa03b3c7dc0d8e971bd4686db27c | Sushiswap | 0x4f059f8d45230cd5b37544e87eebba033a5f1b17 | 0x1b02da8cb0d097eb8d57a175b88c7d8b47997506 | 6 | 1 | BOBA | WETH | 495.406529338 | BOBA | amount0 |
12 | 0x20439939b2effc6fc172868ff578149a8c7e823f4a63f18ab95d159a5d3ea50a | 0x0ec9d6d21358221cccfc933530a8026038cedc12 | Uniswap | 0xe99c4c38f127758799e7806ce7130428e086db7f | 0x599fbdc7a399f359a683f5e1cdc05a373a345346 | 3 | 1 | USDC | WETH | 3.439224e-12 | WETH | amount1 |
13 | 0x2044aa6f78584be9c0574ff401a3fc590d8b0e213116d0f25a71f57c85850511 | 0x0ec9d6d21358221cccfc933530a8026038cedc12 | Uniswap | 0x361cf2208a15f92a6244d6dadf9db9250a7b05cc | 0x599fbdc7a399f359a683f5e1cdc05a373a345346 | 3 | 1 | USDC | WETH | 4.008163e-12 | WETH | amount1 |
14 | 0x2044ad1445d7494b2def00214e2877fbfec63c25b03af141a12c1267eca299d6 | 0x247442181b8baa03b3c7dc0d8e971bd4686db27c | Sushiswap | 0x9f034dddd9c6464e827f648110dda4b6a3a42844 | 0x1b02da8cb0d097eb8d57a175b88c7d8b47997506 | 4 | 1 | BOBA | WETH | 777.456200161 | BOBA | amount0 |
15 | 0x2045e608356d885614496ce82547eff2359807243febf3492640bfd9f43979d9 | 0x247442181b8baa03b3c7dc0d8e971bd4686db27c | Sushiswap | 0x000000000003b57982426680c8eeeaf1920ffe21 | 0x000000000003b57982426680c8eeeaf1920ffe21 | 8 | 1 | BOBA | WETH | 327.263946834 | BOBA | amount0 |
16 | 0x2046c2f3af0a03e6f825c49954a7cd1ebda269d75f462c9f36bd301f9a5af389 | 0x0ec9d6d21358221cccfc933530a8026038cedc12 | Uniswap | 0x000000000003b57982426680c8eeeaf1920ffe21 | 0x000000000003b57982426680c8eeeaf1920ffe21 | 3 | 1 | USDC | WETH | 7.5328035e-11 | WETH | amount1 |
17 | 0x2047225f2ca414e7a9330bcfc73089301cdb2c5efbb2ea8c24254b8c8c79bb4d | 0x247442181b8baa03b3c7dc0d8e971bd4686db27c | Sushiswap | 0x9f034dddd9c6464e827f648110dda4b6a3a42844 | 0x1b02da8cb0d097eb8d57a175b88c7d8b47997506 | 3 | 1 | BOBA | WETH | 876.867712602 | WETH | amount1 |
18 | 0x2048a3976b7d0e6cac89b2cfdb311964cb0740e732a4867a7cb8973b7152f4c3 | 0x4f059f8d45230cd5b37544e87eebba033a5f1b17 | Sushiswap | 0xb2bb815784685b3c5b996e002d442e1113c56ab0 | 0x1b02da8cb0d097eb8d57a175b88c7d8b47997506 | 4 | 1 | USDC | WETH | 303.632469 | USDC | amount0 |
19 | 0x2049b5c16d13a9d6d64654012eb9a74078affbce1e42ff204e7320bbc0dcc729 | 0x247442181b8baa03b3c7dc0d8e971bd4686db27c | Sushiswap | 0x1966760b8ae5a486b0c79472aac0d5658149b966 | 0xe43ca1dee3f0fc1e2df73a0745674545f11a59f5 | 4 | 1 | BOBA | WETH | 144.405180456 | WETH | amount1 |
20 | 0x204b0a9d87d59a51df85967952421e6af9925d8cfb17588eb8c364e066c9be30 | 0x247442181b8baa03b3c7dc0d8e971bd4686db27c | Sushiswap | 0x9f034dddd9c6464e827f648110dda4b6a3a42844 | 0x1b02da8cb0d097eb8d57a175b88c7d8b47997506 | 3 | 1 | BOBA | WETH | 9054.570017633 | WETH | amount1 |
datavortextested 2
Updated 2025-03-30
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
›
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
...
200
52KB
3s