Methodology

Dashboard Objective

Create a dashboard to track the user activity of Struct Finance and a tool to monitor them.

Dashboard Method

Using Flipside Tables of Avalanche I'll track the activity of Struct Finance Vaults Using:

Method To track Struct Finance Vaults addresses:
select
decoded_log:productAddress as address
from avalanche.core.ez_decoded_event_logs
where tx_status = 'SUCCESS'
and event_name = 'ProductCreated'
and contract_address = '0x46f8765781ac36e5e8f9937658fa311af9d735d7'


Using the Following Table to get the token Transfers:
avalanche.core.ez_token_transfers join avalanche.core.ez_decoded_event_logs using(tx_hash)

Now we filter with event_name:
Deposited     --Deposits
Withdrawn     --Claimed Rewards
ExcessClaimed --Claimed Excess Volume

Dashboard Sources

Struct Finance Icon + Struct Finance Image

A guide to Struct Finance Open Beta

Behind the Tranched Curtain

Struct Finance: User Tracker