SENDER | TX_COUNT | |
---|---|---|
1 | 0x25573AF1BAEBE490068A3A57ADF42DFEAC24191C | 149 |
2 | 0x8F52F5EAFFA522FFEF4577687041188E34FE8081 | 123 |
3 | 0x8FC4C1492F10A9310DCD94C2E9A2CB68A3DB7CDC | 119 |
4 | 0x06BB6DF0A3956A01240E3D31438633E7D61DD123 | 118 |
5 | 0x6D2023499622D5E29098BAC54995CFCFEF973CC8 | 116 |
6 | 0x5D18B6E6D9612341E043961D57D1C74B66DED583 | 110 |
7 | 0x89A1EBDDF4A8A55F060D1C675A2E01711663E7F2 | 109 |
8 | 0x9AA439B644273C1E1833C71264BE79D9BA30907C | 105 |
9 | 0x07B3172D3D91661C5B9DE297DEE3C091C7FA51CE | 102 |
10 | 0xC2B67053AB979812090E586A5F88F72E191B8CAB | 101 |
11 | 0x8E2BD737A5909A2B554EDDD430085FECEC96395B | 90 |
12 | 0x8DE1CBA1A5B5AAB335BE4E5E97A2DEB6F8D350CA | 78 |
13 | 0xA68D066D56FC4F57F86F4AD9748F3E1F2625F953 | 73 |
14 | 0x7EE6ADD64CF3821167B80BAEBDEBADC3B76C3A39 | 72 |
15 | 0x5D24EAB5D3BF5742C62A214932D3B37B979F8CFD | 70 |
16 | 0x8E8B3A1E230413CACCE34E28CFAC6D50CD751A0E | 69 |
17 | 0x173DE563646A934F30C36016734E13D3791A56F8 | 68 |
18 | 0xD81E07E124E20A1D81B4A2CF4D4AB1878D4965E1 | 64 |
19 | 0xBA2AC535E7E283057395CC5CBDC3E8D1F417B770 | 62 |
20 | 0x6C36188B7CD1FF83C73D9416664261CE4F64A575 | 58 |
aPriorisensible-blush
Updated 2025-03-06
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 token_withdraw_request_raw_dwd as
(
select
-- BLOCK_TIMESTAMP
-- ,TX_HASH
-- ,from_address
-- ,to_address
-- ,depoist_value
-- ,EVENT_INDEX
-- ,CONTRACT_ADDRESS
*
from
(
select
BLOCK_NUMBER
,BLOCK_TIMESTAMP
,TX_HASH
,EVENT_INDEX
,CONTRACT_ADDRESS
,TOPICS
,'0x' || RIGHT(TOPIC_1, 40) as from_address
-- ,'0x' || RIGHT(TOPIC_2, 40) as to_address
,TOPIC_0
,TOPIC_1
,TOPIC_2
,TOPIC_3
,DATA as block_data
,ORIGIN_FROM_ADDRESS
,ORIGIN_TO_ADDRESS
,ORIGIN_FUNCTION_SIGNATURE
,TX_SUCCEEDED
-- ,SUBSTR(REPLACE(data, '0x', ''), 1, 64) as sender
,'0x' || UPPER(SUBSTR(REPLACE(data, '0x', ''), 25, 40)) AS sender
,TRY_TO_NUMBER(utils.udf_hex_to_int(SUBSTR(REPLACE(data, '0x', ''), 65, 64)))/1e18 as shares
,TRY_TO_NUMBER(utils.udf_hex_to_int(SUBSTR(REPLACE(data, '0x', ''), 129, 64)))/1e18 as assets
-- ,TRY_TO_NUMBER(utils.udf_hex_to_int(SUBSTR(LEFT(DATA, 66),3)))/1e18 AS depoist_value
Last run: 12 days ago
...
50770
2MB
5s