paraswap / paraswap-rewards-snapshot Goto Github PK

There is an off-by-one error in the snapshot SQL file.

line 652 of https://github.com/paraswap/paraswap-rewards-snapshot/blob/master/snapshot.sql

CREATE materialized VIEW EligibleUsers AS
SELECT useraddress
FROM allfilteredtxs
WHERE EXISTS
(SELECT 1
FROM networkFilteredUsers
WHERE networkFilteredUsers.useraddress = allfilteredtxs.useraddress)
OR referrer IN ('argent',
'3')
GROUP BY useraddress
HAVING count(*) > 5; <- should be greater than or equal to (line 652)

This view creates the list of eligible users for the airdrop. It filters based on counts the number of transactions that meet the airdrop criteria (for example, no wrapping/unwrapping transactions). Since it filters based on count(*) > 5, the user needs to have more than 6 transactions to be included in the airdrop.

Note that the medium post says that 5 transactions are the minimum to be included in the airdrop.

from medium article

"We also decided that we only wanted to distribute rewards to the users who had used Paraswap at least 5 times in the last 6 months."