Content pfp
Content
@
https://www.bountycaster.xyz
0 reply
0 recast
0 reaction
Jason Goldberg Ⓜ️ 💜 pfp
Jason Goldberg Ⓜ️ 💜
@betashop.eth
5,000,000 $moxie bounty alert for Dune Wizards! @bountybot Moxie rewards users with Based Rewards for Base Gas and Fan Token trading gas based on this formula: SUM(gas_used * COALESCE(wc.reward_multiplier, 1)) AS total_gas_used, SUM(tx_fee) AS total_gas_spent_native, SUM(tx_fee_usd) AS total_gas_spent_usd A more ideal solution would also factor in the $usd value of each transaction. This bounty is for 5,000,000 $moxie tokens (vest over 90 days) for the first developer to create new dune query that also factors in the $value of each transaction into these queries in a manner that is immediately usable by the Moxie team, as per the requirements below & attached: behaviors we want to easily incentivize are: 1. Incentivize higher $value of the tx 2. Enable multiplier to $value of tx to be added for specific contracts The winning submission must be immediately usable more details https://glory-bellflower-ba8.notion.site/Moxie-Dune-Wizards-dev-bounty-1731feaac80680f9baddeef0ad3af6e4
18 replies
14 recasts
52 reactions
DegenFans 🎩🔵🫂Ⓜ️ pfp
DegenFans 🎩🔵🫂Ⓜ️
@degenfans
you can specify a moxie tx volume and a multiplier (multiple threshold per contract are possible): https://dune.com/queries/4530386
1 reply
0 recast
0 reaction
Jason Goldberg Ⓜ️ 💜 pfp
Jason Goldberg Ⓜ️ 💜
@betashop.eth
the txn's are across all of base, not just $moxie
1 reply
0 recast
1 reaction
DegenFans 🎩🔵🫂Ⓜ️ pfp
DegenFans 🎩🔵🫂Ⓜ️
@degenfans
means all erc20 on base by USD? so config table is: mainContract, erc20Contract, USD threshold ,multiplier?
1 reply
0 recast
0 reaction
Jason Goldberg Ⓜ️ 💜 pfp
Jason Goldberg Ⓜ️ 💜
@betashop.eth
total value of the transactions in $usd (or eth) that made up the gas spent by the user
1 reply
0 recast
0 reaction
DegenFans 🎩🔵🫂Ⓜ️ pfp
DegenFans 🎩🔵🫂Ⓜ️
@degenfans
now i sum(erc20 usd amount) -->can be multiple erc20 transfers in one tx, only from tx_from are sum up + tx eth in USD per transaction config: contract, multiplier, min usd tx value https://dune.com/queries/4530386
2 replies
0 recast
0 reaction
Ignas Peciura Ⓜ️ pfp
Ignas Peciura Ⓜ️
@ipeciura.eth
Hihi we need the actual value of the transfer. Is it $5k worth or $0.01 cents. Not just the gas. Looking at the query it's still just counting the gas or eth spent, but not the actual total value of the transaction.
3 replies
0 recast
1 reaction
DegenFans 🎩🔵🫂Ⓜ️ pfp
DegenFans 🎩🔵🫂Ⓜ️
@degenfans
If you really want to use the usd value also for distribution Then only line 73 gasUsed must be replaced with usdTransfered (value of the transaction) it is already there. But I think it makes more sense to still use gas for distribution and apply higher multiplier if tx value is over x USD for a tx to a known contract . In case of moxie you can just apply a higher multiplier if let’s say more than 20k moxies are transferred. If they then start buying/selling they will loose a lot to the protocol as the burn increase or?
1 reply
0 recast
0 reaction
Ignas Peciura Ⓜ️ pfp
Ignas Peciura Ⓜ️
@ipeciura.eth
Does the usdTransfered value include value for all ERC20 tokens? Can you point me to a table on dune for this? E.g. we would like to know that for example my Degen swap value was ~$19.62 from this tx: https://basescan.org/tx/0x75cedcbcc3817788122d48a02b51a5bcb766d503e7af6223acda5a94ec4c32ef We are not replacing anything yet, working on improving the current approach to discourage high volume of low value txs to farm.
1 reply
0 recast
0 reaction
DegenFans 🎩🔵🫂Ⓜ️ pfp
DegenFans 🎩🔵🫂Ⓜ️
@degenfans
prices are here: blockchain, contract_address (of token) price in usd, per minute prices.usd also i added the tx value if it transfered native eth and i scan the tx logs (events for a erc20 transfer i just take in account the sending side): tokens.transfers
2 replies
0 recast
0 reaction
Jason Goldberg Ⓜ️ 💜 pfp
Jason Goldberg Ⓜ️ 💜
@betashop.eth
thanks, we're looking at this now.
0 reply
0 recast
1 reaction