CUBE3extended-chocolate
Updated 2024-10-02
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
›
⌄
/* SELECT ORIGIN_FUNCTION_SIGNATURE, count(*) as "count" */
SELECT *
FROM ethereum.core.ez_token_transfers
where ethereum.core.ez_token_transfers.tx_hash in (
SELECT DISTINCT(tx_hash)
FROM ethereum.core.ez_decoded_event_logs
WHERE event_name = 'Approval'
/*AND TX_HASH = '0x12f419903a54f333b8f7bdedf3184b33017cfc2ef1421142d62858c653ef2eff'*/
AND DECODED_LOG:value = '115792089237316195423570985008687907853269984665640564039457584007913129639935'
AND BLOCK_TIMESTAMP >= CURRENT_DATE - INTERVAL '1 days'
AND BLOCK_TIMESTAMP < CURRENT_DATE
)
AND ethereum.core.ez_token_transfers.from_address != ethereum.core.ez_token_transfers.origin_from_address
AND ethereum.core.ez_token_transfers.from_address != ethereum.core.ez_token_transfers.origin_to_address
AND ethereum.core.ez_token_transfers.to_address != ethereum.core.ez_token_transfers.origin_to_address
AND ethereum.core.ez_token_transfers.to_address != ethereum.core.ez_token_transfers.origin_from_address
AND ethereum.core.ez_token_transfers.origin_function_signature not in (select TEXT_SIGNATURE from ethereum.core.dim_function_signatures)
AND ORIGIN_FUNCTION_SIGNATURE = '0x81a16445'
/* group by ORIGIN_FUNCTION_SIGNATURE */
/* ORDER BY "count" DESC */
/*LIMIT 100*/
QueryRunArchived: QueryRun has been archived