Jondar pfp

Jondar

@jondar

75 Following
148 Followers


Jondar pfp
Jondar
@jondar
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
Jondar
@jondar
Great working with you 🫡
0 reply
0 recast
1 reaction

JAKE pfp
JAKE
@jake
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
Jondar
@jondar
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
Jondar
@jondar
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
Jondar
@jondar
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
Jondar
@jondar
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
Jondar
@jondar
On the other hand, the number of bids and bidders seem stable
1 reply
0 recast
1 reaction

Jondar pfp
Jondar
@jondar
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
Jondar
@jondar
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
Jondar
@jondar
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
Jondar
@jondar
Link to the dashboard https://dune.com/jondar/ens-pg-builder-grants
0 reply
0 recast
0 reaction

Jondar pfp
Jondar
@jondar
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
Jondar
@jondar
The same metrics are also available by week and by month.
1 reply
0 recast
0 reaction

Jondar pfp
Jondar
@jondar
Here you can see the daily metrics of grants approved and withdrawn.
1 reply
0 recast
0 reaction

Jondar pfp
Jondar
@jondar
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
Jondar
@jondar
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
Jondar
@jondar
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
Jondar
@jondar
got inspired by your cast to see how many received $100+!
0 reply
0 recast
1 reaction

Jondar pfp
Jondar
@jondar
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