hmxinternDeposit
Updated 2024-05-02
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
›
⌄
WITH deposit_withdraw as (
select
BLOCK_TIMESTAMP,
DECODED_LOG['primaryAccount'] as account,
lower(DECODED_LOG['token']) as token,
iff(
EVENT_NAME = 'LogDepositCollateral',
DECODED_LOG['amount'],
-DECODED_LOG['amount']
) as amount,
iff(
EVENT_NAME = 'LogDepositCollateral',
'deposit',
'withdraw'
) as type
from blast.core.fact_decoded_event_logs
where CONTRACT_ADDRESS = lower('0x0b71cBBAd974B9DF8BDF6A83973B710AAa48e7ac')
and EVENT_NAME in ('LogDepositCollateral', 'LogWithdrawCollateral')
),
QueryRunArchived: QueryRun has been archived