Eekeyguy pfp

Eekeyguy

@eekeyguyy

82 Following
25 Followers
Eekeyguy pfp
Eekeyguy
@eekeyguyy
@yosephks.eth fixed the bug , you can check again https://dune.com/eekeyguy_eth/m
0 reply
0 recast
0 reaction
Eekeyguy pfp
Eekeyguy
@eekeyguyy
@betashop.eth my final submission: https://dune.com/blockintel/m
1 reply
0 recast
1 reaction
Jason Goldberg Ⓜ️ 💜 pfp
Jason Goldberg Ⓜ️ 💜
@betashop.eth
very impressive new Moxie <> Dune dashboard in progress by @eekeyguyy https://dune.com/blockintel/m
18 replies
6 recasts
34 reactions
Eekeyguy pfp
Eekeyguy
@eekeyguyy
Query link : https://dune.com/queries/3700764/6226858?order_by_e15077=active_users
0 reply
0 recast
0 reaction
Eekeyguy pfp
Eekeyguy
@eekeyguyy
UXUY seems to be the only reason for surge in active users
1 reply
0 recast
0 reaction
Eekeyguy pfp
Eekeyguy
@eekeyguyy
Query link : https://dune.com/queries/3700764/6226858?order_by_e15077=active_users
0 reply
0 recast
0 reaction
Eekeyguy pfp
Eekeyguy
@eekeyguyy
@0xkofi is right on this UXUY seems to be the only reason that lead to spike in arbitrum transactions
2 replies
0 recast
1 reaction
Eekeyguy pfp
Eekeyguy
@eekeyguyy
Haven’t received any tip yet.
0 reply
0 recast
0 reaction
Eekeyguy pfp
Eekeyguy
@eekeyguyy
wrote a basic query answering your question, there is lot of data which is still not on dune , so have adjusted my query accordingly : https://dune.com/queries/3627255
1 reply
0 recast
1 reaction
Eekeyguy pfp
Eekeyguy
@eekeyguyy
Got it will find it out this week
1 reply
0 recast
0 reaction
Eekeyguy pfp
Eekeyguy
@eekeyguyy
These two dashboards might be relevant to this bytelight https://dune.com/blockintel/l2-inflows-and-outflows https://dune.com/blockintel/cex-inflows-and-outflows
1 reply
0 recast
0 reaction
Eekeyguy pfp
Eekeyguy
@eekeyguyy
Insights covered : 1/ revenue 2/ expense 3/ profit 4/ gas cost changes for common actions 5/ blobspace utilisation https://dune.com/blockintel/blobs-impact-analysis
0 reply
0 recast
1 reaction
Eekeyguy pfp
Eekeyguy
@eekeyguyy
I have analysed few chains and their gas fees post dencun upgrade. Why this dashboard is unique? Well i have segregated all the noise and taken only relevant data like for eth transfers i have only included txs that have simple eth transfer and nothing else . https://dune.com/blockintel/blobs-impact-analysis
1 reply
0 recast
1 reaction
Eekeyguy pfp
Eekeyguy
@eekeyguyy
Taking 3500$ as eth price the value comes around 740m$
0 reply
0 recast
0 reaction
Eekeyguy pfp
Eekeyguy
@eekeyguyy
1 reply
0 recast
1 reaction
Eekeyguy pfp
Eekeyguy
@eekeyguyy
Yes @ilemi has made this amazing dashboard : https://dune.com/queries/1537319/2577384?contract_t6c1ea=0x830BD73E4184ceF73443C15111a1DF14e495C706
0 reply
0 recast
2 reactions
Eekeyguy pfp
Eekeyguy
@eekeyguyy
You can try to find these events in logs ,Or else simply do : select count(*) as auction_count, sum(cast(amount as double) / 1e18) as auction_amount, count(distinct winner) as winner_count from nouns_auctionhouse_ethereum.NounsAuctionHouse_evt_AuctionSettled Check if there are any more contracts
1 reply
0 recast
2 reactions
Eekeyguy pfp
Eekeyguy
@eekeyguyy
We can use arkham , in the network tab i extract data in bulk and then write a code to segregate desired entity Second nansen has put of datas on their site: https://portfolio.nansen.ai/dashboard/binance Some addresses labels can be found in coingecko : https://www.geckoterminal.com/proof_of_reserves/exchanges
1 reply
0 recast
1 reaction
Eekeyguy pfp
Eekeyguy
@eekeyguyy
Cex tracking : https://dune.com/blockintel/cex-inflows-and-outflows
1 reply
0 recast
0 reaction
Eekeyguy pfp
Eekeyguy
@eekeyguyy
Yesterday i built a dashboard to track ERC404. Major volume occuring on dex side. Pandora daily dex volume is 2x times of BAYC daily volume. https://dune.com/blockintel/erc-404
1 reply
0 recast
1 reaction