Methodology

Dashboard Objective

Show a Competitive Comparison between Squid against Hop Protocol and THORchain.

Dashboard Structure

Introduction
Transaction Activity
- Transaction Activity Over Time.
- Total Transaction Activity.
User Activity
- User Activity Over Time.
- User Retention.
- Unique Users.
USD Volume Activity
- USD Volume over Time.
- Total USD Volume Activity.
Conclusion
Methodology

Dashboard Method

Using Flipside Tables of Axelar, THORchain and EVM I'll track the activity of Smart Contracts and dApps Using:

-- Table used to get Squid Activity:

axelar.core.ez_squid

-- Table used to get THORchain Activity:

thorchain.core.fact_swaps

-- Table used to get Hop Activity:

polygon.core.fact_token_transfers
polygon.core.dim_contracts
optimism.core.fact_token_transfers
optimism.core.dim_contracts
arbitrum.core.fact_token_transfers
arbitrum.core.dim_contracts
ethereum.core.ez_token_transfers
ethereum.core.ez_eth_transfers
ethereum.core.dim_contracts

Most of the Hop Activity Query is from 0xHaM-d https://flipsidecrypto.xyz/0xHaM-d/q/li-fi-YLbqqT
to get all the data from bridges, however the way I used his data is different,
adding new metrics and other points of view.

-- Table used to get Prices

crosschain.core.ez_hourly_prices
Union all
osmosis.core.ez_prices

Dashboard Sources

Thorchain Logo

Hop Protocol Logo

Squid Logo

MetricsDAO Bounty Question

Analyze Squid and their growth metrics against their competitors (Stargate, LiFi, Bungee, Celer cBridge, Anyswap, and THORChain).

Popex404