datavortexassociated-sapphire
Updated 2025-03-21
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
›
⌄
⌄
⌄
SELECT DISTINCT tx_hash,
decoded_log:to AS distinct_to_address
FROM
ethereum.core.ez_decoded_event_logs
WHERE
decoded_log:from = LOWER('0xdc9b93a8a336fe5dc9db97616ea2118000d70fc0')
AND origin_function_signature = ('0x23024408') --0x6a761202 -- 0x70a10c89
ORDER BY
distinct_to_address;
/*
SELECT DISTINCT origin_function_signature
FROM ethereum.core.ez_decoded_event_logs
WHERE decoded_log:from = LOWER('0xdc9b93a8a336fe5dc9db97616ea2118000d70fc0')
AND decoded_log:to = LOWER('0xDA28e780472B5754a1144bcE6e83aF06a33107D2')
*/
/*
SELECT
decoded_log:from,
decoded_log:to, decoded_log:value / 1e6,
event_name,
block_timestamp,
origin_function_signature,
tx_hash
FROM
ethereum.core.ez_decoded_event_logs
WHERE
-- event_name = 'Transfer'
--decoded_log:to = LOWER('0x028FFcfF8c8d9C0E75186F62fF483adDbBC50075')
decoded_log:from = LOWER('0xdc9b93a8a336fe5dc9db97616ea2118000d70fc0') --
and origin_function_signature = '0x23024408'
--AND date(block_timestamp) = '2025-03-17'
*/
QueryRunArchived: QueryRun has been archived