hildobby Profile picture
data @dragonfly_xyz / host @indexed_pod
Mar 10, 2023 โ€ข 5 tweets โ€ข 3 min read
Lower NFT trading fees lead to increased wash trading? ๐Ÿค”

Given the lack of direct incentives, @opensea's trading data before and after lowering their fees should contain some insights

Unfortunately, wash trading seems like an inevitable byproduct of lower fees ๐Ÿ˜”

๐Ÿงต 1/5 Trading volume

Between January 1st and February 17th, my wash trading filter flagged 0.7% of OpenSea's trading volume

This past week, 5.4% of total volume was flagged as wash trading, it even reached 11% on February 7th

2/5
Feb 27, 2023 โ€ข 9 tweets โ€ข 6 min read
NFT royalties and fees have been extensively discussed with virtually no data, so let's look into a few charts ๐Ÿง

Did you know that @blur_io started paying more to creator ~20 days before @opensea changed its policy on fees?

๐Ÿงต 1/8 All the charts in this thread can be found on my new ๐—ก๐—™๐—ง ๐—ฅ๐—ผ๐˜†๐—ฎ๐—น๐˜๐—ถ๐—ฒ๐˜€ ๐—ฎ๐—ป๐—ฑ ๐— ๐—ฎ๐—ฟ๐—ธ๐—ฒ๐˜๐—ฝ๐—น๐—ฎ๐—ฐ๐—ฒ ๐—™๐—ฒ๐—ฒ๐˜€ @DuneAnalytics dashboard๐Ÿ’ฐ๐Ÿช

Dashboard: dune.hildobby.xyz/NFT-Fees

2/8
Jan 31, 2023 โ€ข 4 tweets โ€ข 4 min read
I just reworked my ๐—˜๐—ง๐—› ๐—ฆ๐˜๐—ฎ๐—ธ๐—ถ๐—ป๐—ด @DuneAnalytics dashboard from the ground up ๐Ÿฅฉ

TLDR;
๐Ÿ†• Migrated to Dune v2
๐Ÿ”“ Open-sourced tables on spellbook
๐Ÿ‘ฅ Added more entities I uncovered
๐Ÿ“Š Added some charts

Dashboard: dune.hildobby.xyz/ETH-Staking Image I migrated the entire dashboard to Dune v2 and as part of the migration created the following tables on spellbook:
- staking_ethereum.entities: List of identified staking deposit addresses.
- staking_ethereum.deposits: All ETH deposit events.

Code here: github.com/duneanalytics/โ€ฆ
Dec 16, 2022 โ€ข 5 tweets โ€ข 3 min read
I made an open-source wash trading filter available for all to use on Dune v2 and managed to flag $30B of NFT wash trades - that's ~44% of volume traded ๐Ÿคฏ

๐Ÿงต I wrote about it in this article highlighting:
โ“What wash trading is and some context
โš™๏ธ How my method works
๐Ÿงฎ The resulting data
๐Ÿช„ How you too can use it

Article ๐Ÿ‘‰ dune.hildobby.xyz/NFT-Wash-Analyโ€ฆ
Sep 14, 2022 โ€ข 8 tweets โ€ข 5 min read
As we head into the merge, I thought it would be interesting to look into current Ethereum staking stats ๐Ÿฅฉ

Thus far, 80k addresses have sent a total of 13.7M $ETH to be staked, that's ~11.4% of ETH's current circulating supply. Let's look into a more granular breakdown ๐Ÿ‘€๐Ÿงต 1/ Liquid Staking ๐Ÿ’ง

Liquid staking remains predominant thanks to @LidoFinance having facilitated over 30% of all staked ETH. Looking into liquid staking marketshare we have the following:
Sep 14, 2022 โ€ข 21 tweets โ€ข 10 min read
.@DuneAnalytics is a great resource for free & always up-to-date on-chain stats ๐Ÿ”ฅ

I've been building & using the tool for over a year and here are my 20 favourite high-level Ethereum dashboards ๐Ÿงตโญ๏ธ ๐Ÿ. ๐„๐ญ๐ก๐ž๐ซ๐ž๐ฎ๐ฆ - ๐“๐ก๐ž ๐Ž๐ฏ๐ž๐ซ๐ฏ๐ข๐ž๐ฐ ๐Ÿฆ‡๐Ÿ”Š (by me)

This dashboard provides a high-level overview of the Ethereum blockchain, including stats on addresses, blocks, transactions, smart contracts, price & more.

1/20
dune.com/hildobby/Etherโ€ฆ
Aug 26, 2022 โ€ข 8 tweets โ€ข 3 min read
This week, @coinbase announced their $ETH liquid staking token called $cbETH and minted 643k on Ethereum mainnet ๐Ÿ’ง๐Ÿฅฉ

Unfortunately, they are yet to prove that they have 643k+ $ETH currently staked, that's critical information all liquid staking providers should disclose ๐Ÿงต ๐Ÿ. ๐‚๐จ๐ง๐ญ๐ž๐ฑ๐ญ

Here is a thread explaining the launch of $cbETH
Jul 15, 2022 โ€ข 4 tweets โ€ข 2 min read
Vested $LOOKS tokens from the @LooksRare private sale unlocked a few hours ago and ~74% have already been redeemed ๐Ÿงต 1/ 1,504 $ETH ($5.7m at time of raise) were originally raised from 71 angels for 33m $LOOKS.

The ROI is currently:
+528% in $ETH ๐Ÿ“ˆ
+102% in $USD ๐Ÿ“ˆ
Mar 30, 2022 โ€ข 5 tweets โ€ข 3 min read
Curious about the stats of a specific DEX pool? Checkout this dashboard where you will find: volume, generated fees, TVL, token prices, yield, impermanent loss, APY... ๐Ÿ“Š

All @Uniswap (v1, v2 & v3) & @SushiSwap DEX pools are supported!

Here ๐Ÿ‘‰ dune.xyz/hildobby/DEX-Pโ€ฆ

๐Ÿค๐Ÿงต๐Ÿ‘‡ 1/ Use the parameters at the top to change what is shown:
- ๐†๐ซ๐š๐ง๐ฎ๐ฅ๐š๐ซ๐ข๐ญ๐ฒ: Change it to aggregate the data by daily, weekly, monthly or yearly
- ๐๐จ๐จ๐ฅ: Input address of the studied DEX pool here
- ๐’๐ข๐ง๐œ๐ž: First computed date
- ๐”๐ง๐ญ๐ข๐ฅ: Last computed date
Mar 23, 2022 โ€ข 8 tweets โ€ข 6 min read
I just updated my ๐‘Š๐‘Ž๐‘ โ„Ž ๐‘‡๐‘Ÿ๐‘Ž๐‘‘๐‘–๐‘›๐‘” ๐น๐‘–๐‘™๐‘ก๐‘’๐‘Ÿ for @LooksRareNFT data on all of my concerned dashboards. It now also filters out sales of tokens traded 3+ times the same day ๐Ÿงผ

๐Ÿค๐Ÿงต๐Ÿ‘‡ Image 1/ You can read about my previous filtering method here ๐Ÿ‘‡
Oct 27, 2021 โ€ข 12 tweets โ€ข 8 min read
Today it's easy to find overall stats for the @SushiSwap platform but I had trouble finding an analysis on SushiSwap's $SUSHI token specifically so I made a @DuneAnalytics dashboard where I analysed it ๐Ÿฃ๐Ÿ“Š
Here is a ๐Ÿงต all about it ๐Ÿ‘‡ Image 1/ You will first stumble across the price and volume (split between buy and sell volume) chart for the most traded $SUSHI pair, SUSHI/WETH on @SushiSwap, all converted into dollar value.
The token's market cap is also shown in $USD and $ETH value over time. ImageImageImage