Methodology

Dashboard Objective

Show Trisolaris Swap Activity and Growth over Time.

Dashboard Method

Using the Flipside Tables of Aurora I'll track the activity Using:

Transaction, User, and Fees Activity from: 
aurora.core.fact_transactions

Smart Contracts Activity from: 
aurora.core.fact_logs

Table for WETH Price
ethereum.core.fact_hourly_token_prices

Base Query from Frodo:
https://flipsidecrypto.xyz/Frodo/q/3HvF6GaRblji/trisolaris---swaps-overview

Most of the Activity can be tracked looking at activity received by the Trisolaris Router:
0x2CB45Edb4517d5947aFdE3BEAbF95A582506858B

LPs Contracts:
'0x84b123875F0F36B966d0B6Ca14b31121bd9676AD' -- 'wNEAR - TRI'
'0x5eeC60F348cB1D661E4A5122CF4638c7DB7A886e') --'AURORA - ETH'
'0xd1654a7713617d41A8C9530Fb9B948d00e162194') -- 'AURORA - TRI'
'0x1e0e812FBcd3EB75D8562AD6F310Ed94D258D008') -- 'AURORA - wNEAR'
'0x20F8AeFB5697B77E0BB835A8518BE70775cdA1b0') -- 'wNEAR - USDC'
'0x03B666f3488a7992b2385B12dF7f35156d7b29cD') -- 'wNEAR - USDT'

Dashboard Sources

Images

Trisolaris Banner, Trisolaris Logo

Documents

Trisolaris DEX