CryptoGowdaMega Indexer [ Juice Finance ]
Updated 2024-03-02
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 juice_account_creation_indexer as (
select
block_timestamp,
tx_hash,
ORIGIN_FROM_ADDRESS as borrower,
'0x' || SUBSTR(data, 27) as account_id,
null as value,
'Account Created' as action
from
blast.core.fact_event_logs
where
contract_address = '0x6301795aa55b90427cf74c18c8636e0443f2100b'
and origin_to_address = '0x6301795aa55b90427cf74c18c8636e0443f2100b'
and tx_status = 'SUCCESS'
and ORIGIN_FUNCTION_SIGNATURE = '0x9dca362f'
),
juice_collateral_deposit_indexer as (
select
block_timestamp,
tx_hash,
ORIGIN_FROM_ADDRESS as borrower,
'0x' || SUBSTR(data, 27, 40) as account_id,
ethereum.public.udf_hex_to_int(SUBSTR(data, 67, 64)) / POW(10, 18) AS value,
'CollateralDeposit' as action
from
blast.core.fact_event_logs
where
contract_address = '0x6301795aa55b90427cf74c18c8636e0443f2100b'
and origin_to_address = '0x6301795aa55b90427cf74c18c8636e0443f2100b'
and tx_status = 'SUCCESS'
and ORIGIN_FUNCTION_SIGNATURE = '0x6e553f65'
and topics [0] = '0x85a75ad7f484e83157db3f52d6bfcf613d65995bd6546c2ed0d55ee07a51170a'
),
juice_collateral_withdraw_indexer as (
select
block_timestamp,
QueryRunArchived: QueryRun has been archived