DeFiBarbarian

Writing about DeFi primarily to help teach myself and maybe useful to others
Tweets should be read as me thinking out loud
Not financial advice

[DeFiBarbarian @defiprophecy]

@PaulPublisher Gold again, really appreciate your tweets and love the style of the story telling

[DeFiBarbarian @defiprophecy]

Hope this helps and explains my personal approach for trying to find what I need!

Happy querying on @DuneAnalytics

[DeFiBarbarian @defiprophecy]

How to find and explore the data you require on @DuneAnalytics 🧵👇

[DeFiBarbarian @defiprophecy]

(5) Looking on Dune I can find a table called "bancor."StandardPoolConverter_evt_LiquidityAdded" and can query for what liquidity added data

There will be extra reading of the API docs required to understand the data but this will allow you to find the right data to look at

[DeFiBarbarian @defiprophecy]

TIL (2/2)

ERC20 Tokens are sent to the token contract address when a transfer takes place rather than directly to the recipients address.

More details here: https://t.co/CHsYv2qbMd

[DeFiBarbarian @defiprophecy]

TIL (1/2)

Using the tx_hash id from rows in the dex.trades table in @DuneAnalytics you can plug this value into @etherscan to get more details about the transaction

[DeFiBarbarian @defiprophecy]

Further statistics for 6 monthly and yearly can be found on the link in the first tweet.

#DeFi #onchainanalysis

[DeFiBarbarian @defiprophecy]

Summary dashboard created for Eth Dex's on @DuneAnalytics using the abstracted "dex". trades table.

Created summary statistics around trading volumes and market share of Eth Dex's across daily/weekly/monthly/6 monthly and yearly time periods

https://t.co/jQ0zBLRWsR

[DeFiBarbarian @defiprophecy]

Monthly Summary

- Top 3 Trading Volume: Uniswap, Sushiswap, Curve
- Top 3 Absolute Trading Volume Increase: Uniswap, Sushiswap, DODO
- Top 3 Relative Trading Volume Increase: DODO, SNX, Curve
- Top 3 Monthly Market Share Increase: DODO, Sushiswap, Curve

[DeFiBarbarian @defiprophecy]

@0xcetirizin Great thread and analysis, can't wait to read this later. I actually had on my list how to compare DEX's - will use this as a guide as I've been doing some volume/market share trends on Dune for Eth DEX's.

[DeFiBarbarian @defiprophecy]

Summary:

- Uniswap still holds the majority of the market share (57.2%)
- The largest gainers of USD volume (T-1 vs T-2) was Synthetix +443%, dYdX +120%, 1inch +96%
- Biggest gainers in market share were Synthetix + 3.85%, Sushiswap + 3.56%
- Biggest loser was Uniswap - 6.47%

[DeFiBarbarian @defiprophecy]

Created a summary dashboard for DEX's that highlights daily changes

https://t.co/jQ0zBLRWsR

- DEX USD Volume for Last Completed Day (T-1)
- DEX Daily Volume Change for Last 2 Completed Days (T-1 vs T-2)
- DEX Market Share % Change for Last 2 Completed Days (T-1 vs T-2)

[DeFiBarbarian @defiprophecy]

Weekly/Monthly/6 Monthly and Yearly to be added next

Some example images attached