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
DegenFans 🎩🔵🫂Ⓜ️ pfp
DegenFans 🎩🔵🫂Ⓜ️
@degenfans
USD version: https://dune.com/queries/4531711
0 reply
0 recast
0 reaction
DegenFans 🎩🔵🫂Ⓜ️ pfp
DegenFans 🎩🔵🫂Ⓜ️
@degenfans
I thought you will still count the real gas usage and just apply a multiplier if the tx value is higher x usd. So you want ignore gas usage and just use USD worth of a tx to distribute? But then someone could just send 1000 usd from a to be and back?!
0 reply
0 recast
0 reaction