Early | Contract | Contract Name | User Early Rank | First Interaction Date | Worthiness | Color param | Horizontal line | |
|---|---|---|---|---|---|---|---|---|
1 | ✅ | 0x25ace71c97b33cc4729cf772ae268934f7ab5fa1 | optimism: proxy ovm l1 cross domain messenger | 164 | 2021-07-25 03:27:54.000 | 6.097561 | 1 | 1 |
2 | ✅ | 0x8eca806aecc86ce90da803b080ca4e3a9b8097ad | zkswap | 633 | 2021-02-17 16:50:30.000 | 1.579779 | 1 | 1 |
3 | ✅ | 0x1de3877c9012824c9acc39995647754b1fa9959f | 983 | 2021-01-16 01:39:02.000 | 1.017294 | 1 | 1 | |
4 | ❌ | 0xa4108aa1ec4967f8b52220a4f7e94a8201f2d906 | gravity bridge: bridge | 1155 | 2022-05-03 20:14:31.000 | 0.865801 | 0 | 1 |
5 | ❌ | 0x4672bad527107471cb5067a887f4656d585a8a31 | Dropil | 1159 | 2018-03-16 19:32:05.000 | 0.862813 | 0 | 1 |
6 | ❌ | 0xe33b15629739770a27c4726a22be61128aa1c781 | 1187 | 2021-03-09 17:16:52.000 | 0.84246 | 0 | 1 | |
7 | ❌ | 0x41b856701bb8c24cece2af10651bfafebb57cf49 | 1801 | 2021-04-12 22:34:11.000 | 0.555247 | 0 | 1 | |
8 | ❌ | 0x3b6c03b232f87aee2ea6561ec7bf080a7710d667 | 2025 | 2021-01-16 00:10:23.000 | 0.493827 | 0 | 1 | |
9 | ❌ | 0x8481a6ebaf5c7dabc3f7e09e44a89531fd31f822 | senior pool | 2287 | 2021-09-17 23:47:48.000 | 0.437254 | 0 | 1 |
10 | ❌ | 0x1a9a4d919943340b7e855e310489e16155f4ed29 | 2376 | 2022-11-07 13:46:11.000 | 0.420875 | 0 | 1 | |
11 | ❌ | 0xd3cf4e98e1e432b3d6ae42ae406a78f2ac8293d0 | zapper fi: general contract | 2377 | 2021-01-16 02:25:42.000 | 0.420698 | 0 | 1 |
12 | ❌ | 0xb3999f658c0391d94a37f7ff328f3fec942bcadc | Hashflow | 2751 | 2022-11-07 13:49:47.000 | 0.363504 | 0 | 1 |
13 | ❌ | 0x99c9fc46f92e8a1c0dec1b1747d010903e884be1 | optimism bridge v2 | 2791 | 2021-07-17 15:44:48.000 | 0.358295 | 0 | 1 |
14 | ❌ | 0x0fd829c3365a225fb9226e75c97c3a114bd3199e | dydx: claims proxy | 3315 | 2021-09-08 16:07:49.000 | 0.301659 | 0 | 1 |
15 | ❌ | 0xe4815ae53b124e7263f08dcdbbb757d41ed658c6 | Zks | 3318 | 2021-02-17 16:21:11.000 | 0.301386 | 0 | 1 |
16 | ❌ | 0x7623e9dc0da6ff821ddb9ebaba794054e078f8c4 | ether.fi: early adopter program | 3409 | 2023-03-25 13:45:47.000 | 0.293341 | 0 | 1 |
17 | ❌ | 0xf418588522d5dd018b425e472991e52ebbeeeeee | Ethereum Push Notification Service | 3539 | 2021-05-13 10:51:00.000 | 0.282566 | 0 | 1 |
18 | ❌ | 0x31c8eacbffdd875c74b94b077895bd78cf1e64a3 | Radicle | 4189 | 2021-05-03 10:37:42.000 | 0.23872 | 0 | 1 |
19 | ❌ | 0xa18607ca4a3804cc3cd5730eafefcc47a7641643 | 5507 | 2021-09-16 23:00:42.000 | 0.181587 | 0 | 1 | |
20 | ❌ | 0xf91c7c211db969aafcb1cfc6cbbdca048074ee07 | 5529 | 2021-07-25 04:03:30.000 | 0.180865 | 0 | 1 |
eferUser Interaction Rank In Hot Contracts (>100 $ETH Paid Fee)
Updated 4 days ago
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
›
⌄
-- Forked From:
-- https://flipsidecrypto.xyz/fsds/q/MfPMxAJi9iV3/revised-endpoint-user-interaction-rank-in-hot-contracts-100-eth-paid-fee
select
case when value:RANK::numeric <=1000 then '✅' else '❌' end as "Early",
value:CONTRACT_ADDRESS as "Contract",
value:CONTRACT_NAME as "Contract Name",
value:RANK::numeric as "User Early Rank",
value:MIN_DATE as "First Interaction Date",
1000/"User Early Rank" as "Worthiness",
case when "Worthiness">1 then '1' else '0' end as "Color param",
1 as "Horizontal line"
from (select livequery.live.udf_api('https://api-v2.flipsidecrypto.xyz/table-results/modefi?address={{user_address}}')
as response), lateral FLATTEN (input => response:data:data:rows)
order by "User Early Rank" asc
Last run: 4 days ago
74
8KB
4s