ORIGIN_FROM_ADDRESS | TRANSACTION | TICKETS | |
|---|---|---|---|
1 | 0xbaf554b98339fb0bd10e1a5f825c38ad3eea4912 | 2 | 346 |
2 | 0x52a68e231507d3f57aca0036c03c5e838a3b052b | 2 | 321 |
3 | 0x1eb96eee3cb006809876d7941a005a1c80b56ce4 | 2 | 241 |
4 | 0x4bccfe191d794bd8317e2b0c3b3a0138e8d0ba80 | 8 | 230 |
5 | 0x81e1fc75755dfa9840a667d6e270687ba2d80762 | 1 | 191 |
6 | 0x26873cbf6b70f9f59a24f27d8c6ec42025069a56 | 1 | 111 |
7 | 0x3a8f9f86b0a23185853d70472b0068220d9b44db | 1 | 110 |
8 | 0x24f557f66d292e3d73ddaac23dbc367da790abee | 1 | 77 |
9 | 0xae65ce556fa1a624a876453474219279527301e1 | 3 | 69 |
10 | 0x557e032c0851b886916a0f69e8e953dbea15b653 | 2 | 62 |
11 | 0x9a38c84bb6c564da9af8dfbffc97c3d65911e437 | 3 | 59 |
12 | 0xa2aaae4a59bf35cb4d0f78e3a33b27d10cf4e839 | 1 | 50 |
13 | 0xa9b7ad2a22325722780b0a4fd94db906999ca8d0 | 1 | 50 |
14 | 0x2754d53f27fde52e67199044247601c445ef06c4 | 1 | 49 |
15 | 0x5418dad6851efb17428669e7dc5d06b25c5e4527 | 3 | 44 |
16 | 0xc693d87ea43656cd5494065a531381338e6d56a3 | 10 | 40 |
17 | 0xf508c2be6c8b5f10a6ea4637332ec9e3270a6fd0 | 1 | 30 |
18 | 0x6cd17235a5e4edb2fa77389b8b5170dcddf08f32 | 1 | 28 |
19 | 0x47bb6bc7814257e5dce83564b2ba7337bd5c8b6e | 1 | 25 |
20 | 0xa0254d470333e65c9de3e722a55079dbb3bec65f | 1 | 25 |
Ali3NParticpants Leaderboard Blubbrr Raffllrr
Updated 2025-02-27
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
›
⌄
⌄
select origin_from_address,
count (distinct tx_hash) as Transaction,
sum (decoded_log:ticketCount) as Tickets
from avalanche.core.ez_decoded_event_logs
where origin_to_address = '0xea82821f75d3cb02c2b450eb43ae528603ea614a'
and topic_0 = '0xaf2aee3d8cdab65f2d45ee09beee32f3c25f465d16fa61f5c86cca3f13e86057'
and contract_address = '0xea82821f75d3cb02c2b450eb43ae528603ea614a'
and decoded_log:raffleId = '6285'
group by 1
order by Tickets desc
/*select *
from avalanche.core.ez_decoded_event_logs
where tx_hash = '0x7e9d588ec94cefc3f97943f5086a09049f261f5aaf6bf9006733633f3b1e98ca'*/
Last run: 2 months ago
...
830
41KB
2s