kky1112024-04-25 01:48 PM
Updated 2024-04-30
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
›
⌄
-- add liquidity
-- topics[0] = '0xee0675525fac605bfcf2ae26dcd769c6d0871098b6eed3ade01f7247b3b28071'
-- open perps long, close perps short
-- topics[0] = '0x4858d822a60a8f40ed0ced2eff407b999867b6dc5a641e8154e7a77d5992e1b2'
select
cast(utils.udf_hex_to_int( substr(data, 259, 64) ) as bigint)/1e18 as data5_actual_trd_vol_after_leverage
, topics[0]
, *
from blast.core.fact_event_logs
where 1=1
and tx_hash in (
'0x5577cf2fbe770862933eafe98a3261a34754bbf16c90792047acd57bf4c2938a'
--, '0x4feccaac6355b3b77542d98312720bd3b686b55c6e62549fc0cbd4a1d08e52ec'
)
select *
from blast.core.fact_token_transfers
where tx_hash = '0x22888b73795d234e1bbda97f77de69a422c5d8cb9a3409e85823b2e749903498'
Auto-refreshes every 12 hours
QueryRunArchived: QueryRun has been archived