AIRDROP_TIME | AIRDROP_TX_HASH | USER | AIRDROP_AMOUNT | EXIT_TX_LINK | ORIGIN_FUNCTION_SIGNATURE | EXIT_TIME | COUNTERPARTY | STATUS | DAYS_HELD | |
|---|---|---|---|---|---|---|---|---|---|---|
1 | 2024-05-01 07:59:35.000 | 0x5c67370ac0a2054024fafa1da18d05b9428e68acf838c81a2de401d8b28776bd | 0xf28134e12621be99baa28fb93f4fff3a271f7088 | 1434001388888888888888 | https://etherscan.io/tx/0x82f7c115e88a8fe391f45ee2e362252323e363f906aa3d647f5db8a0823e7e34 | 0x0d5f0e3b | 2025-01-03 10:44:23.000 | 0x7a233f0e957a9ff4726c738e9d790b9956f4c894 | exited | 247 |
2 | 2024-05-14 19:07:35.000 | 0x10d9163b67a04d64424aeab9806a3ed8e827b4ee5d13523be8f0efdc45e59718 | 0x048f51203c0412e17f4e49f425ba76494b7ecd31 | 7004159722222222222222 | https://etherscan.io/tx/0x7e4fec97f49cd40d3ae8cee1066f031b7515a99969f8e157644edc97b202bd87 | 0x5ae401dc | 2024-12-02 17:55:59.000 | 0x7a233f0e957a9ff4726c738e9d790b9956f4c894 | exited | 202 |
3 | 2024-09-19 03:22:47.000 | 0xbb411aafbc65b4ce082d22f0fa5bc764cc9dc61bc819785c424cec4d2719102d | 0x30320770c27c747e6c9cd30f5046c5313b0a1858 | 1125000000000000000000 | https://etherscan.io/tx/0x475802748e0c8e3a20a0990ab3282a98590dcd49a8290225599691185eb03216 | 0x6e553f65 | 2024-08-19 01:46:59.000 | 0x0fdc7b5ce282763d5372a44b01db65e14830d8ff | exited | -31 |
4 | 2024-04-22 17:01:47.000 | 0xd28e451898824a68a099beef5bf3a3abbda82ce9258ae6de905c98d1f8c3552f | 0x406cbfc2d391bed42078138165465128b4e0cb06 | 1125000000000000000000 | https://etherscan.io/tx/0xd929c7d438fa023c6e743a893fe1ca2ea29309cc1732274bf126a6e2b291e499 | 0x803ba26d | 2024-11-19 05:43:47.000 | 0x7a233f0e957a9ff4726c738e9d790b9956f4c894 | exited | 211 |
5 | 2024-04-22 16:37:59.000 | 0xf22d276c154ae0e636fa6cf456d6d477e66003e737bae94eb075636031f69760 | 0x12f8c380f0e236b5631eb79804c1e4ec8ec57846 | 10819961111111111111105 | https://etherscan.io/tx/0xdb19d84ae3967959a0214d9764d11193cb2a1a8410281fc42b1bfe59ecb454a3 | 0xac9650d8 | 2024-11-30 18:48:59.000 | 0x7a233f0e957a9ff4726c738e9d790b9956f4c894 | exited | 222 |
6 | 2024-04-23 09:54:35.000 | 0x9bc2cc354fa41139816550e7a8fc749aa65225bacfe04329c3290782338d1b30 | 0xefeb3c96038fb738872880f53940adc3d2fd43e2 | 7474217592592592592592 | https://etherscan.io/tx/0xbd073b51cf86c7db946fa4f1a67f251fb68073b07ca31a173a3575b4b839028a | 0xd5bc7be1 | 2024-07-02 18:55:23.000 | 0x1231deb6f5749ef6ce6943a275a1d3e7486f4eae | exited | 70 |
7 | 2024-04-22 21:28:11.000 | 0x90c1584f1a48869a802119012f65bfb87c5074fa742174d9a0ebbdd3d757add9 | 0x3557f623bf64ca41287e892130ce0551b0c6ffd1 | 10608137847222222222210 | https://etherscan.io/tx/0xb84d423fd7feabdd82bf04343b43a776c571154a47b6f88119d7dd78aa91de04 | 0x88316456 | 2024-04-22 21:46:47.000 | 0x7a233f0e957a9ff4726c738e9d790b9956f4c894 | exited | 0 |
8 | 2024-04-26 12:54:35.000 | 0x7f798905f866d2f2dfe812accb83d6315e342aee062cb4c36b38fac5b32b0c52 | 0x5286d56816ed9df4c806aee6df6d467307fd3e58 | 7556725231481481481479 | https://etherscan.io/tx/0xa6ce5d9775f85aa697cea951ecee547a403d924d311f6894156856677c5d5139 | 0x2213bc0b | 2025-01-30 10:57:23.000 | 0x7a233f0e957a9ff4726c738e9d790b9956f4c894 | exited | 279 |
9 | 2024-04-24 21:30:47.000 | 0xc33fe193e6d89473f662debf7e555a3fcfc180d9f68fc254f66a6eb734078d7f | 0x28f4cec1e53a57eadd11e139d1c0d5a7ce3d64bc | 1125000000000000000000 | https://etherscan.io/tx/0xb57e6cbb3d99b935bc8e8ea1ad0a1a12712355ca381a3d2b3bba31cc49fc9276 | 0x83800a8e | 2024-05-27 12:32:35.000 | 0x7a233f0e957a9ff4726c738e9d790b9956f4c894 | exited | 33 |
10 | 2024-04-23 02:28:23.000 | 0x14bf12d283913c8e1356449ee5640fa7d974d5e2690365831611a89e58d272d8 | 0x1b121b74eb70d01c9a2f9466af4b4c90084710c8 | 1125000000000000000000 | https://etherscan.io/tx/0xaab5fc894220b21fddd6de2994d3d55e8ec1e8034522825c916a0ca0ca57d478 | 0xc04b8d59 | 2024-04-23 02:34:23.000 | 0x7a233f0e957a9ff4726c738e9d790b9956f4c894 | exited | 0 |
11 | 2024-04-22 14:12:23.000 | 0x13d5fb970f25b9b066f316aa4de4051151606391d04d20f6d416159aece9316d | 0xfed14eda4012639c484061ee44df74a8b0eb0c98 | 6782716736111111111094 | https://etherscan.io/tx/0xf3ae15f73a2387b600bc1928fd2f7a3e129ac4cf7ccf4f2427ae37dff6f0ea7f | 0x8770ba91 | 2024-06-28 22:09:47.000 | 0x7a233f0e957a9ff4726c738e9d790b9956f4c894 | exited | 67 |
12 | 2024-04-24 18:04:11.000 | 0xa3c9065ef979c88b3d6611d52fe54c0a2a05a0ded957411839bfe4a0f5c17295 | 0x48e6f62271aca47a94bc9227a5c6ca164578a234 | 7549672800925925925925 | https://etherscan.io/tx/0x8dde4ddd059d8676a0e604721befa08cd44cbcfbcb70e408a11e8e9ddb12a93a | 0x5f575529 | 2025-02-07 18:27:35.000 | 0x74de5d4fcbf63e00296fd95d33236b9794016631 | exited | 289 |
13 | 2024-04-22 23:58:35.000 | 0xadeab9ef576efcaa2e98e28c1389c3d2d41fc38a21bb7159f29df853f413e112 | 0x36fb0a00746027790d03ece898b931e3759d3242 | 1125000000000000000000 | https://etherscan.io/tx/0x3e4fcf997414f686e86862cf089e5577686120847791ef71a5a681cd19ed1857 | 0xa0000000 | 2024-04-23 00:03:59.000 | 0x7a233f0e957a9ff4726c738e9d790b9956f4c894 | exited | 1 |
14 | 2024-04-22 17:53:35.000 | 0x343aace1daad53813a893e61ae5704f7bfaf52aba17c4ac148776253bbeb1be3 | 0x2fc67edbb3d37cf8c373e8b53215a0e9ac347767 | 7455891087962962962962 | https://etherscan.io/tx/0x36392fb6a71118e1dffbb0b945b45318db5425e301f9ede3a0f2d98ac0a2adb5 | 0x415565b0 | 2024-05-14 01:01:11.000 | 0x22f9dcf4647084d6c31b2765f6910cd85c178c18 | exited | 22 |
15 | 2024-11-24 04:34:23.000 | 0xb5cdf3b8ded6e263f9059cca3870fde085e7d4f44364b0ba9ac6b1a70d9ae8ce | 0x2e6d9adba8164dd78190ed387ee17dea4322e447 | 4607848611111111111110 | https://etherscan.io/tx/0x71043a8fa2c495bec12a5667fe1fd09a1fc36fabbe692c6f944ca915270490ef | 0x6af479b2 | 2024-12-29 04:44:59.000 | 0x7a233f0e957a9ff4726c738e9d790b9956f4c894 | exited | 35 |
16 | 2024-04-27 14:59:23.000 | 0x36b790c272d70cf5e6b224c4e8a0f03daee0aff3bfabd87f312b34ab9d4eb186 | 0xdbccea4c4fbe723aca82fd4bd605d80617f53d68 | 1341774768518518518518 | https://etherscan.io/tx/0x1317d0f443b9c4606d175663c674441c5678bb25b08283f6ea1232fadda1393f | 0x146ee74d | 2024-06-18 03:54:11.000 | 0xad3b67bca8935cb510c8d18bd45f0b94f54a968f | exited | 52 |
17 | 2024-04-28 08:21:23.000 | 0x78a036b52f452f6eb7322830f9b5137fd22f6b8d426b7eb35c7c870c7ae3d2f8 | 0x7031a25ec4ac1a2b3cc1300cbbc8e047a819b742 | 1125000000000000000000 | https://etherscan.io/tx/0x5ded00157f1ad1a8862655e3d3b7a540fee247170daaf288b8d3f9e8c99cad7d | 0x12aa3caf | 2024-06-25 10:07:11.000 | 0xe37e799d5077682fa0a244d46e5649f71457bd09 | exited | 58 |
18 | 2024-12-09 07:20:23.000 | 0x1e0929785d6bed28a247f5faa0902a6768dde789278949ee4d083d10a33f3330 | 0x6f754370cef4c943d56cb769468950f7988ebdd3 | 1359202777777777777777 | https://etherscan.io/tx/0xcfebfdb4af6bb43921975cbb55f7482ab00e4a07738d1c8459e208f6195b37bd | 0x13d79a0b | 2024-12-09 08:45:23.000 | 0x9008d19f58aabd9ed0d60971565aa8510560ab41 | exited | 0 |
19 | 2024-07-10 22:21:47.000 | 0xfcd206c895a75f341679d8457537999923c3d4ee3f774a829fc7399cea495f8f | 0x99d9cc271dcdb1ec44dad67d91a8fccea8f58b1a | 9158107361111111111093 | https://etherscan.io/tx/0x461aab7f078241319ec2e544b03da2a0300ba5df1d0d4b2e9c021fbdc7d552d6 | 0x07ed2379 | 2024-07-10 22:24:23.000 | 0xe37e799d5077682fa0a244d46e5649f71457bd09 | exited | 0 |
20 | 2024-04-22 16:41:11.000 | 0xfa410b1e609ce534886073a4cd7ad4eefa2ff4ee662dcfcef0a724f153631ab2 | 0xcd0fc2f5f1db2f20792a2d04c57c7f322f6f8362 | 7851207777777777777773 | https://etherscan.io/tx/0x0ad8e9e2f17fde81a3048c2e3e0124adacafb43cb8b984f992b78a5183da5616 | 0x0301027a | 2024-04-22 21:53:11.000 | 0x7a233f0e957a9ff4726c738e9d790b9956f4c894 | exited | 0 |
Sandeshdiamond hands karrat
Updated 2025-02-11
999
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
›
⌄
-- forked from average days held airdrop pirate @ https://flipsidecrypto.xyz/studio/queries/b34a9397-9c81-4999-b34d-6186c98903be
-- Who are diamond hands ? They are users who have never had a balance of 0 after airdrop. So partital sellers are also considered as diamond hands as they are still part of the project.
-- Caveat in this query: User might get multiple airdrops over time. We only look at the first airdrop and
-- and look at if thier balance ever reached zero after that.
-- Staking and unstaking transactions have been removed so. It will nor be displayed as selling it.
with airdrop_table AS (
(
select
block_timestamp, tx_hash, decoded_log['holder'] as user, decoded_log['amount'] as airdrop_amount
from ethereum.core.ez_decoded_event_logs
where 1=1
and origin_to_address=lower('0x5ba16591c2b46e1395a13df1a926da87a2d3887d')
and topics[0]='0x4f05c48fefd874a99acab00ec698d72b07f2d8ae974ad712750d276e6e7c4d38'
qualify(row_number() over(partition by user order by block_timestamp asc)=1) -- the first airdrop
)
),
-- Step 2: Build the balance table
balance_table AS (
-- Incoming transactions
WITH inn AS (
SELECT
block_timestamp,
event_index,
tx_hash,
origin_function_signature,
from_address AS counterparty,
to_address AS user,
amount
FROM ethereum.core.ez_token_transfers
WHERE block_timestamp >= '2024-04-01 00:00:00.000'
AND contract_address = LOWER('0xAcd2c239012D17BEB128B0944D49015104113650') -- Karrat token
Last run: 3 months ago
29
10KB
42s