rezarwz2024-08-16 07:15 AM
Updated 2024-08-16
999
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
›
⌄
SELECT
tx_hash,
from_Address,
'Thruster' as Dapp_Name,
VALUE
FROM
blast.core.fact_transactions
where
to_Address in (
'0x98994a9a7a2570367554589189dc9772241650f6',
'0x44889b52b71e60de6ed7de82e2939fcc52fb2b4e',
'0x337827814155ecbf24d20231fca4444f530c0555'
)
and ORIGIN_FUNCTION_SIGNATURE not in (
'0xe8e33700',
'0xf305d719',
'0xbaa2abde',
'0x02751cec',
'0xaf2979eb',
'0xded9382a',
'0x5b0d5984',
'0x2195995c'
)
and STATUS = 'SUCCESS'
union
all
SELECT
tx_hash,
from_Address,
'Ring' as Dapp_Name,
VALUE
FROM
blast.core.fact_transactions
where
to_Address in (
'0x2c8754b44865002415dd5ceba6cd67258d1ece2e',
QueryRunArchived: QueryRun has been archived