Methodology

Dashboard Objective

Show the Impact of Dexalot Announcement of adding a new trading Pair in their activity on Avalanche (C-chain) through LayerZERO Bridges.

Dashboard Structure

Introduction
Overview
- The Impact of Dexalot Announcement
Activity by Flow Type
- Activity by Flow Type
Activity by Tokens
- Daily Activity by Tokens in July 2023
- Total Activity by Tokens After the Announcement (July 5th)
Key Takeaways
Methodology

Dashboard Method

Using Flipside Tables of Avalanche I'll track the activity of Dexalot Bridges With:

Table to Get Bridge Activity:

avalanche.core.ez_decoded_event_logs

Table to Get Transaction Activity (Gas Fees):

avalanche.core.fact_transactions

Table to Get Oracle Prices:

crosschain.core.fact_hourly_prices


To get the Bridge Activity I used the Methodology from cloudr3n dashboard:
https://flipsidecrypto.xyz/cloudr3n/q/OScaKsQU525v/dexalot-asset-flow

Where he used this address 0x1fd108cf42a59c635bd4703b8dbc8a741ff834be as the LayerZero Dexalot ↔ Avalanche (C-Chain) Bridge.

But I wrote all of my SQL, and used only his dashboard as inspiration to correctly get the Activity of Dexalot in the Avalanche (C-Chain)

Dashboard Sources

Dexalot Logo by Medium

Dexalot x Layer Zero Image by Medium

Dexalot x EUROC / USDC Image by Medium

CaesarJulius0 Tweet Thread

Avalanche Watch June Edition

MetricsDAO Bounty Question

Follow the following AVAX influencers and tune into what they are paying attention to! Choose a topic from one of the twitter threads below and create a dashboard covering the topic, protocol, project, etc that is featured in one of their tweets. Feel free to explore other influencers or topics in the ecosystem as well!

Important:

Make the title of your dashboard relevant to the project or topic you are covering. Next, respond to one of the tweets in the twitter thread or one of the "quote tweeted" tweets with an insight or twitter thread from your dashboard that will strengthen the narrative they are sharing. There is no need to mention this is a MDAO challenge as a part of your tweet- keep it authentic and real!

Twitter Threads & Influencers To Watch

https://twitter.com/CaesarJulius0/status/1676969343241048064

https://twitter.com/Ommiii_/status/1674881097380016128

https://twitter.com/Ommiii_/status/1677058083108044801

https://twitter.com/demirelo

https://twitter.com/yieldyak_/status/1675831903998361600

Note

If one of these CT Influencers releases a new twitter thread, feel free to cover a topic in that twitter thread.

You cannot choose a tweet that references another Flipside dashboard.

Dexalot Bridge Activity After EUROC/USDC