Flipside Teamtest
Updated 2024-07-17
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
›
⌄
-- 0x7140ab4e3e317db2a0d4dfb1e4245bee25d664d9 0xfaa3f56ac45fa7648ba63e2adc52d4223a47eb79c644d03129fa79b8d10678b7
-- 0x9d1130ca6af07d56dfab9fca37b19986f7f12c39
-- 0xd6f5ce46e1e5a58fb26db8a371b59367052eb46c
-- select
-- *
-- from crosschain.olas.ez_olas_locking
-- where tx_hash = '0xfaa3f56ac45fa7648ba63e2adc52d4223a47eb79c644d03129fa79b8d10678b7'
with t1 as (select
*,
DECODED_LOG:account as account_address,
DECODED_LOG:amount/1e18 as OLAS_amount,
TO_TIMESTAMP(DECODED_LOG:startTime) as startTime,
TO_TIMESTAMP(DECODED_LOG:endTime) as endTime,
2 as numSteps
from ethereum.core.ez_decoded_event_logs
where CONTRACT_ADDRESS = '0xb09ccf0dbf0c178806aaee28956c74bd66d21f73'
and EVENT_NAME = 'Lock'
and TOPICS[0] = '0x0e31f07bae79135368ff475cf6c7f6abb31e0fd731e03c18ad425bd9406cf0c0'
and tx_hash in ('0xfaa3f56ac45fa7648ba63e2adc52d4223a47eb79c644d03129fa79b8d10678b7',
'0x8f0420355fe00a24b3c973705340a5f6d890dce872d51c62126f1dcb309b7a76')
),
t3 as (select
t1.BLOCK_NUMBER,
t1.BLOCK_TIMESTAMP,
t1.TX_HASH,
t1.EVENT_INDEX,
t1.CONTRACT_ADDRESS,
t1.CONTRACT_NAME,
account_address,
OLAS_amount,
startTime,
endTime,
QueryRunArchived: QueryRun has been archived