For this first airdrop, The Unlock Foundation wants to reward UDT holders who have migrated to UP AND then held on to their UP.
We use Basescan to get all transfers of UP from the swapping contract.
- For each transfer from the swap contract
- check the balance current balance of the recipient.
- If balance on base >= then transfer amount, keep track of date, apply bonus based on time to the amount transfered.
Note: since there was no transaction that swapped back UP for UDT, we don't need to check the balance on mainnet.
See the data folder for the latest export (performed on October 31st at 9AM).
$ node src/index.js data/export-token-0xac27fa800955849d6d17cc8952ba9dd6eaa66187.csv
> Excluded recipient 0xF5C28ce24Acf47849988f147d5C75787c0103534
> 0x246A13358Fb27523642D86367a51C2aEB137Ac6C held 400.0 UP for 10 weeks. Bonus: 20.0
> 0x9d3ea9e9adde71141f4534dB3b9B80dF3D03Ee5f held 100.0 UP for 10 weeks. Bonus: 5.0
> 0x9d3ea9e9adde71141f4534dB3b9B80dF3D03Ee5f held 100.0 UP for 10 weeks. Bonus: 5.0
> 0x9d3ea9e9adde71141f4534dB3b9B80dF3D03Ee5f held 100.0 UP for 10 weeks. Bonus: 5.0
> 0x9d3ea9e9adde71141f4534dB3b9B80dF3D03Ee5f held 100.0 UP for 10 weeks. Bonus: 5.0
> 0x246A13358Fb27523642D86367a51C2aEB137Ac6C held 1000.0 UP for 10 weeks. Bonus: 50.0
> 0x9d3ea9e9adde71141f4534dB3b9B80dF3D03Ee5f held 100.0 UP for 10 weeks. Bonus: 5.0
> 0xED59e0fB105F003e508A1f59Fe9F4AE5a755BDeD held 24.510359894537121 UP for 10 weeks. Bonus: 1.22551799472685605
> 0x6aeC5228fDA60525F59AfC773Ada7df6a6d8e43f held 4839930.0 UP for 10 weeks. Bonus: 241996.5
> 0x5FEDB4362EC2c4fbae539223d5ACC63F99735e1C held 2635150.0 UP for 10 weeks. Bonus: 131757.5
> 0x1111fd96fD579642c0D589cd477188e29b47b738 held 5000.0 UP for 10 weeks. Bonus: 250.0
> 0xB0dEb259a566f071c62F4F740EB294F0F55AE4A6 held 11000.0 UP for 10 weeks. Bonus: 550.0
> 0xBCcf3780cD5EFe5cd73321dCBB86fEcFDA7d3d7e held 1000000.0 UP for 10 weeks. Bonus: 50000.0
> 0x65CeB2927A89f25a7a56F56008D059adBEA54Cc2 held 2000000.0 UP for 10 weeks. Bonus: 100000.0
> 0xc0948A2f0B48A2AA8474f3DF54FD7C364225AD7d held 1000688.0 UP for 10 weeks. Bonus: 50034.4
> 0x81Dd955D02D337DB81BA6c9C5F6213E647672052 held 8.701029500871797 UP for 10 weeks. Bonus: 0.43505147504358985
> Excluded recipient 0xF5C28ce24Acf47849988f147d5C75787c0103534
> 0x4846162806B025Dcd0759cACF9ec6F9474274282 held 59760.65759045037726 UP for 10 weeks. Bonus: 2988.032879522518863
> 0x4846162806B025Dcd0759cACF9ec6F9474274282 held 89000.0 UP for 10 weeks. Bonus: 4450.0
> 0xFf4eC2057A4180A4Cd18FDEA144e53245e39869D held 52735.0 UP for 10 weeks. Bonus: 2636.75
> 0xD2BC5cb641aE6f7A880c3dD5Aee0450b5210BE23 held 460087.790394820666868 UP for 10 weeks. Bonus: 23004.3895197410333434
> 0xde22DE740609532FC0F48287b7F258776bE814FD held 4061698.0 UP for 10 weeks. Bonus: 203084.9
> 0xfF9dFc6110DEf605eB08532b5232051A1fb1F12E held 50120.0 UP for 9 weeks. Bonus: 1754.2
> 0x3bDbBe3ABBe6f7f3f8FB9d0C2484C8Ce8A76Df60 held 150064.5 UP for 9 weeks. Bonus: 5252.2575
> 0x83540330a1A813Ce878D1675d2A98c9b023DC69E held 1000.0 UP for 9 weeks. Bonus: 35.0
> 0x83540330a1A813Ce878D1675d2A98c9b023DC69E held 132318.0 UP for 9 weeks. Bonus: 4631.13
> 0x4846162806B025Dcd0759cACF9ec6F9474274282 held 13030.0 UP for 9 weeks. Bonus: 456.05
> 0x06217CD389fe0B598CFAaDe7e2e3C8A544cedAd6 held 2730.0 UP for 9 weeks. Bonus: 95.55
> 0xF1D3Ae318edd8dAA3Bd97B24a6CCb6c3A8b581cF held 57400.0 UP for 9 weeks. Bonus: 2009.0
> 0x19Bc334ab56C18128c188a6543Acb49C84b43c2e held 31124.0 UP for 9 weeks. Bonus: 1089.34
> 0x0D8410643ae7a4d833C7219E5C6faDfa5Ce912CD held 6689.0 UP for 9 weeks. Bonus: 234.115
> 0x0D8410643ae7a4d833C7219E5C6faDfa5Ce912CD Balance on Base is insufficient! 6040886.91196150762341855 vs 7040886.911961507623346
> 0x0D8410643ae7a4d833C7219E5C6faDfa5Ce912CD held 6040886.91196150762341855 UP for 9 weeks. Bonus: 211431.041918652766819649
> 0x6B0EA34cC854316dd8784502Ff85C1CB24F800b4 held 1000.0 UP for 9 weeks. Bonus: 35.0
> 0x84284527483df52B5d37dbb4fB4119F6055288A1 held 17000.0 UP for 9 weeks. Bonus: 595.0
> 0xaA3600788b72863ff51C8f0dB5F10bB65fbFeAB4 held 122353.0 UP for 9 weeks. Bonus: 4282.355
> 0xcFd35259E3A468E7bDF84a95bCddAc0B614A9212 held 109999.0 UP for 9 weeks. Bonus: 3849.965
> 0x78d08a94CA2dEE362373ff5910F52ef3A0a2ba97 held 100900.0 UP for 8 weeks. Bonus: 2522.5
> 0xCA7632327567796e51920F6b16373e92c7823854 held 68200.0 UP for 8 weeks. Bonus: 1705.0
> 0x968dcB921A822643Fa28CCa5f4CF6034399ab40e held 11000.0 UP for 8 weeks. Bonus: 275.0
> 0xE6d7194F927a01c1682D5f10aEF0E7162c0C5834 held 3355.11 UP for 8 weeks. Bonus: 83.87775
> 0x2fdD1FbB9793f4ac4e51CEb7a75660371796C19A held 6543.0 UP for 7 weeks. Bonus: 98.145
> 0x895d036ed1a3BE41C30CEf01A135995fA12Fb207 held 3209.403608886211322 UP for 7 weeks. Bonus: 48.14105413329316983
> 0x5990afF0E95b2C75B3727EA00B580Fc8E4DF27e9 held 105450.0 UP for 7 weeks. Bonus: 1581.75
> 0x9D5611bf0DAdddb4441A709141d9229d7F6b3e47 held 1000.0 UP for 7 weeks. Bonus: 15.0
> 0xc2fB4B3EA53E10c88D193E709A81C4dc7aEC902e held 10000.0 UP for 7 weeks. Bonus: 150.0
> 0x557DEd245bffa8F21CC2217776B210A882C1D2d8 held 15000.0 UP for 6 weeks. Bonus: 150.0
> 0xED59e0fB105F003e508A1f59Fe9F4AE5a755BDeD held 99999.9 UP for 6 weeks. Bonus: 999.999
> 0xC8dfE3D00dE485bce147845a1df294292073F79a Balance on Base is insufficient! 0.0 vs 73879.549662726245846
> 0xde22DE740609532FC0F48287b7F258776bE814FD held 334675.72 UP for 5 weeks. Bonus: 1673.3786
> 0x0C8993Ce05569E1B5Cb5E07AEc439799175CeCa8 held 11465.0 UP for 4 weeks. Bonus: 34.395
> Excluded recipient 0x3074517c5F5428f42C74543C68001E0Ca86FE7dd
> Excluded recipient 0x3074517c5F5428f42C74543C68001E0Ca86FE7dd
> 0x0cc296c8d7Dd9342dbb07B343f882c09223c56Fd held 154531.0 UP for 4 weeks. Bonus: 463.593
> Excluded recipient 0xB34567C4cA697b39F72e1a8478f285329A98ed1b
> 0xA788E0586409FA4eaF986E24604003adaa3dcC9d held 10062.3 UP for 4 weeks. Bonus: 30.1869
> 0xFC6b98a5A28cB374c9ce08363E374a795462252B held 161000.0 UP for 3 weeks. Bonus: 241.5
> 0x9492510BbCB93B6992d8b7Bb67888558E12DCac4 held 2193085.0237404643 UP for 3 weeks. Bonus: 3289.62753561069645
> 0xC8dfE3D00dE485bce147845a1df294292073F79a Balance on Base is insufficient! 0.0 vs 74098.473748103713081
> 0x0aF9431E73b9ccd393242804c221Dc92C9017345 held 2000.0 UP for 3 weeks. Bonus: 3.0
> 0x31da8F32BB76F0d2c1CAa14B79087CA2Fbe0277E held 184333.0 UP for 3 weeks. Bonus: 276.4995
> 0xC8dfE3D00dE485bce147845a1df294292073F79a Balance on Base is insufficient! 0.0 vs 227973.418035579772518
> 0x8851362132466e9a1836921f59D8a20d6FBF950b Balance on Base is insufficient! 79999.0 vs 80000.0
> 0x8851362132466e9a1836921f59D8a20d6FBF950b held 79999.0 UP for 3 weeks. Bonus: 119.9985
> 0x8c9b739df17131Dc670964EeCe0861cB209Ce2d4 held 506676.69 UP for 3 weeks. Bonus: 760.015035
> 0xC8dfE3D00dE485bce147845a1df294292073F79a Balance on Base is insufficient! 0.0 vs 109259.435946746991133
> 0xeDb5f894CE46C4e4FC94f0d33745707AE0dA32e6 Balance on Base is insufficient! 1000.0 vs 5800.0
> 0xeDb5f894CE46C4e4FC94f0d33745707AE0dA32e6 held 1000.0 UP for 3 weeks. Bonus: 1.5
> 0x78c0A25CcC21604B3D117100DE7c9523f53236C7 held 1000.0 UP for 3 weeks. Bonus: 1.5
> 0xC8dfE3D00dE485bce147845a1df294292073F79a Balance on Base is insufficient! 0.0 vs 138404.753547979206276
> 0x203ff8d26324e91A74bD07cc162936A6EFB10E61 held 50660.0 UP for 2 weeks. Bonus: 50.66
> 0x6f375Cbeb518f03c43CA6552EF64cECBC090780B held 32605.0 UP for 2 weeks. Bonus: 32.605
> 0xb44ACba8325F94fB1D120481bb8B4824f7A4DceE Balance on Base is insufficient! 0.0 vs 100143.882303945000915
> 0x1Fde40a4046Eda0cA0539Dd6c77ABF8933B94260 held 540.0 UP for 2 weeks. Bonus: 0.54
> 0xC8dfE3D00dE485bce147845a1df294292073F79a Balance on Base is insufficient! 0.0 vs 48582.201689141943353
> 0x4ba6655490b5D820be9Ff45772E402afBC556eC0 held 122353.642641146221427 UP for 2 weeks. Bonus: 122.353642641146221427
> 0x8A743c8AaCf070cff044623c9C087005299Ed996 Balance on Base is insufficient! 0.0 vs 331.719893331244319
> 0xC8dfE3D00dE485bce147845a1df294292073F79a Balance on Base is insufficient! 0.0 vs 75870.205400865942434
Check the airdrop.json file for the full JSON export (imported in Merkl).