Content
@
0 reply
0 recast
0 reaction
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
16 replies
23 recasts
75 reactions
Ryan J. Shaw
@rjs
Does this help you? It's your query but with a USD tx value included, also expressed as per user % of all user's USD tx value. You can then use that e.g. to scale up/down the users final rewards based on what makes sense to you. The USD value is calculated based on the prevailing ETH price at the time of the individual txs. https://dune.com/queries/4531516
1 reply
0 recast
0 reaction
Ryan J. Shaw
@rjs
Request for clarity: do you want the *literal* transaction value i.e. the ETH sent with it or the *logical* transaction value e.g. ERC20 token transfer values? I did the former; the latter is also possible.
1 reply
0 recast
0 reaction
