Jondar

@jondar

75 Following

148 Followers

Jondar pfp

I often use @neynar tables on Dune to retrieve names, FIDs and verified addresses of users on Farcaster. Cool to see them repost one of my works!

0 reply

2 recasts

2 reactions

Jondar pfp

Great working with you 🫡

0 reply

0 recast

1 reaction

JAKE pfp

NEW: $QR DUNE DASHBOARD this is the official dune dashboard for @qrcoindotfun built in collaboration with dune wizard @jondar for alpha seekers, onchain analysts, and crypto quants the onchain attention machine is doing numbers now you can track them easily and publicly data including but not limited to: + total bid value: $256k + auction revenue: $54k + highest winning bid: $3.5k + average winning bid: $498 + average bids per auction: 10 + $QR volume: $9M + $QR holders: 69k + other stats, charts, tables, and more check it out if you like numbers: https://dune.com/jondar/qr

3 replies

8 recasts

37 reactions

Jondar pfp

In the final section of the dashboard there are two tables showing the distribution of token holders as well as the distribution of Farcaster user holders. The Farcaster holder count is based on the custody addresses linked to each profile. It’s interesting to note that the top Farcaster holder appears as only number 8 in the holders table (6 if we exclude the pool and Sablier Lockup contract)

1 reply

0 recast

2 reactions

Jondar pfp

Thanks to @jake for the help in creating the dashboard and fixing the bugs. Link to the full Dune Dashboard: https://dune.com/jondar/qr

0 reply

0 recast

2 reactions

Jondar pfp

The project is backed by a token deployed by @clanker As of this post, the market cap is around $2.6M, with a total volume of nearly $9M and around 70K holders

2 replies

0 recast

1 reaction

Jondar pfp

In these tables we can see the winners of each auction, as well as general metrics on how each auction performed

1 reply

0 recast

1 reaction

Jondar pfp

On the other hand, the number of bids and bidders seem stable

1 reply

0 recast

1 reaction

Jondar pfp

The project's revenue comes from the winning bids and so far it amounts to $54k. The average winning bid is around $500, so it is expected to reach $100k in revenue in 100 days On the other hand more than $250k has been bid on the platform

1 reply

0 recast

1 reaction

Jondar pfp

Here we can see the cumulative revenue and bid values, as well as the amounts for each auction. Something happened around auction 77 that caused a boost in the average bid amount

1 reply

0 recast

1 reaction

Jondar pfp

New day, new @dune.eth dashboard This time about @qrcoindotfun qrcoindotfun is a daily onchain auction for attention. The winner of the daily auction decides where the QR points for a day. Let’s dive into the data A Dune 🧵:

1 reply

3 recasts

7 reactions

Jondar pfp

Link to the dashboard https://dune.com/jondar/ens-pg-builder-grants

0 reply

0 recast

0 reaction

Jondar pfp

Finally, this table tracks all withdrawals, including the amount withdrawn, the total percentage of the grant withdrawn by each builder and the reason behind each withdrawal.

1 reply

0 recast

0 reaction

Jondar pfp

The same metrics are also available by week and by month.

1 reply

0 recast

0 reaction

Jondar pfp

Here you can see the daily metrics of grants approved and withdrawn.

1 reply

0 recast

0 reaction

Jondar pfp

This table shows each builder’s grant status, including the amount of the grant requested and how much has been withdrawn so far.

1 reply

0 recast

0 reaction

Jondar pfp

Last week I published a @dune.eth dashboard about the ENS Public Goods Grants by @ensdao This dashboard allows anyone to better understand how the funds are being used and easily check the onchain transactions. All the data comes from the smart contract used to stream funds to grantees: 0x72704f28704fe9df50516e0fc29fbd9261a3de64. Here an overview of the dashboard

2 replies

1 recast

10 reactions

Jondar pfp

In this section you can see the number of grants approved, the total amount of ETH approved, the number of unique grantees, as well as the maximum, minimum, and average grant sizes approved. The same metrics are also shown for the amounts withdrawn.

1 reply

0 recast

0 reaction

Jondar pfp

got inspired by your cast to see how many received $100+!

0 reply

0 recast

1 reaction

Jondar pfp

As of today 44 users could buy their farcaster pro subscription just with money received from @noiceapp Source: https://dune.com/jondar/noice-dashboard

2 replies

3 recasts

18 reactions