BLOCK_NUMBER | BLOCK_TIMESTAMP | TX_HASH | ORIGIN_FUNCTION_SIGNATURE | ORIGIN_FROM_ADDRESS | ORIGIN_TO_ADDRESS | EVENT_INDEX | CONTRACT_ADDRESS | TOPICS | DATA | EVENT_REMOVED | TX_SUCCEEDED | FACT_EVENT_LOGS_ID | INSERTED_TIMESTAMP | MODIFIED_TIMESTAMP | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1 | 1193312 | 2024-07-09 10:44:04.000 | 0xd3e5c8f5e5dad572599d006a2ba01bf165b154160fb3bc4dcabe840fdb1d2251 | 0x617ba037 | 0x441ed56cac1144c56c82fc37f3b78c26ea2bbc86 | 0x30a3039675e5b5cbea49d9a5eacbc11f9199b86d | 261 | 0x8ce5c1c42cd58b7ae61512790e514a82d84375ed | ["0xddf252ad1be2c89b69c2b068fc378daa952ba7f163c4a11628f55a4df523b3ef","0... | 0x0000000000000000000000000000000000000000000000000000029085c19414 | FALSE | TRUE | 9319541e14d20fc14eaeb8bab3d6b9a8 | 2024-07-15 20:36:25.998 | 2024-07-15 20:36:25.998 |
TerpLayertest
Updated 2025-02-10
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 transfer_events AS (
SELECT
CONCAT(
'0x',
RIGHT(JSON_UNQUOTE(JSON_EXTRACT(topics, '$[2]')), 40)
) AS address,
CONV(log_data, 16, 10) / POW(10, 18) AS amount,
COALESCE(
CASE
WHEN block_time >= UNIX_TIMESTAMP(NOW()) - 86400 THEN CONV(log_data, 16, 10) / POW(10, 18)
ELSE 0
END,
0
) AS recent_24h_reward,
block_time
FROM
t_block_log_infos
WHERE
topic = '0xddf252ad1be2c89b69c2b068fc378daa952ba7f163c4a11628f55a4df523b3ef'
AND contract_address = '0x656b95E550C07a9ffe548bd4085c72418Ceb1dba'
AND chain_id = 80094
UNION
ALL
SELECT
CONCAT(
'0x',
RIGHT(JSON_UNQUOTE(JSON_EXTRACT(topics, '$[1]')), 40)
) AS address,
CONV(log_data, 16, 10) / POW(10, 18) * -1 AS amount,
0 AS recent_24h_reward,
block_time
FROM
t_block_log_infos
WHERE
topic = '0xddf252ad1be2c89b69c2b068fc378daa952ba7f163c4a11628f55a4df523b3ef'
AND contract_address = '0x656b95E550C07a9ffe548bd4085c72418Ceb1dba'
Last run: 2 months ago
1
634B
1s