ACTION | VOLUME | PERCENTAGE | |
|---|---|---|---|
1 | Relocked | 26585678.7886667 | 45.350486708 |
2 | Unlocked | 32037019.0446667 | 54.649513292 |
Flipside TeamDAO founding members locked OLAS
Updated 32 minutes ago
999
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
›
⌄
------------------------------- buOLAS ----------------------------------------------------------------------------------
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
from ethereum.core.ez_decoded_event_logs
where CONTRACT_ADDRESS = '0xb09ccf0dbf0c178806aaee28956c74bd66d21f73' -- buOLAS
and EVENT_NAME = 'Lock'
and TOPICS[0] = '0x0e31f07bae79135368ff475cf6c7f6abb31e0fd731e03c18ad425bd9406cf0c0'
--and tx_hash = '0xbdcd664ca41d62e1281e0e59f0e2d1b7b85b5a4769d684fc7cf2dddddb37d80a'
),
t2 as (
select
tx_hash,
case
when tx_hash in ('0xfaa3f56ac45fa7648ba63e2adc52d4223a47eb79c644d03129fa79b8d10678b7',
'0x8f0420355fe00a24b3c973705340a5f6d890dce872d51c62126f1dcb309b7a76') then 2
when EVENT_NAME = 'ClaimBU' then DECODED_LOG:numSteps
end as numSteps
from ethereum.core.ez_decoded_event_logs
WHERE tx_hash in (select tx_hash from t1)
),
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,
Last run: 32 minutes agoAuto-refreshes every 12 hours
2
87B
564s