commanderjoseph-761gwXTOKEN Staking Vs Unstaking BSC
Updated 2024-10-28
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
total
AS
(
SELECT
block_timestamp,
origin_from_address AS user,
'stake' AS tx_type,
utils.udf_hex_to_int(SUBSTR(data, 67, 64))/POW(10, 9) AS amount,
utils.udf_hex_to_int(SUBSTR(data, 3, 64)) AS stake_number,
tx_hash
FROM
bsc.core.fact_event_logs
WHERE
origin_to_address = lower('0x1E7866B5A5A4F09EfD235D28d49568c2Fe2F7EcD') --TOKENFI STAKING
AND
topics[0] = '0x1449c6dd7851abc30abf37f57715f492010519147cc2652fbc38202c18a6ee90' --STAKED
AND
tx_status = 'SUCCESS'
UNION
SELECT
block_timestamp,
origin_from_address AS user,
'unstake' AS tx_type,
(utils.udf_hex_to_int(SUBSTR(data, 67, 64))/POW(10, 9))* -1 AS amount,
utils.udf_hex_to_int(SUBSTR(data, 3, 64)) AS stake_number,
tx_hash
FROM
bsc.core.fact_event_logs
WHERE
origin_to_address = lower('0x1E7866B5A5A4F09EfD235D28d49568c2Fe2F7EcD') --TOKENFI STAKING
AND
topics[0] = '0x7fc4727e062e336010f2c282598ef5f14facb3de68cf8195c2f23e1454b2b74e' --UNSTAKED
AND
QueryRunArchived: QueryRun has been archived