Content pfp
Content
@
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
16 replies
23 recasts
75 reactions

SaxophoneπŸŽ©πŸ– pfp
SaxophoneπŸŽ©πŸ–
@saxophone55.eth
You can retrieve sent eth from transactions like this!​​​​​​​​​​​​​​​​ I apologize if I misunderstood your requestβ€‹β€‹β€‹β€‹β€‹β€‹β€‹β€‹β€‹β€‹β€‹β€‹β€‹β€‹β€‹β€‹πŸ«  https://dune.com/queries/4530482
1 reply
0 recast
0 reaction

Jason Goldberg Ⓜ️ πŸ’œ pfp
Jason Goldberg Ⓜ️ πŸ’œ
@betashop.eth
I see new column there for Total Value USD, is that $$ value of the transactions in total for that user? I don't see ETH value
1 reply
0 recast
0 reaction