rerolls copy

hrst79rerolls copy

Updated 2025-05-23

SELECT

sender as Account_address,

sum(event_data:amount / 5000000) as rerolls_count,

sum(event_data:amount / 1e8) as reroll_fee

from

aptos.core.fact_events a

join aptos.core.fact_transactions b using(tx_hash) --where tx_hash = '0x158be687eea0b0e0ff98eb88dc58923bef86d2d733c634b15d7a210db9c6f4f7'

where

EVENT_RESOURCE = 'DepositEvent'

and PAYLOAD_FUNCTION = '0x380dec3b333b636ab1f17322b2e5c768b5281dbc7640ff1d750ce044293e70bb::amaterasu::reveal_many'

group by

order by

2 desc

Last run: 11 days ago

	ACCOUNT_ADDRESS	REROLLS_COUNT	REROLL_FEE
1	0x514b130b75234ba177c84623db56ea0e1fe5208872cf35eb5e11a17f1efaddae	3410	170.5
2	0x6186c6d887f743f834b55a3a4241c3a6670b57729025a337759e324c13beff46	1918	95.9
3	0xb9244d53617ae9627e5fd0b57ce378a6a8517485c3ae6e7bfca1c4372337ef58	1553	77.65
4	0x72487b93691f85eb3b1a0d01f7a29618fb4a4c41481870c13ecaeed75ad6e360	1520	76
5	0xdedef60f74e132a7a2808cf9b9813e105bf7f6e26a11ec48fd5e5de6cadbc03d	1308	65.4
6	0x7795cce772dd630aa84979b4733fbfa6935d70b424c7e4bfd4f9f2bd27142611	1280	64
7	0x137a00864d78d52fbb3a3529d20e0a025fdbaa645cdbade4837fff050b8d8b4c	1253	62.65
8	0x12866e7a932f528fc3a06831950e7039945f07918df46b4ff7c5c80d36006bd7	1250	62.5
9	0x8b0fdfd0ad24f4f8e91a87a41e25af8335aa6c9771543d2d3357410b0685f094	1214	60.7
10	0xf7affc836917eaa1be59c35cd5b6ef5fcb02a72eb04145d56475a56ed8c3640a	748	37.4
11	0x2f8315675476fcc680628d5ef4d90467533f96915d2441183419665fba279573	612	30.6
12	0x4c5fcc660bb19bfc33445c078c4bcfb66907bde9fb3222ad34adaede2acd113b	556	27.8
13	0xb895533bd870bddb0347ac6e61901e043ac20438e74649f6fec7ede52ebb2167	541	27.05
14	0x566ddcbc29506520ad4c4c991eac852fcb176b56c7b7f7fa7f3a80399176eef2	536	26.8
15	0x6513e5e9cf32833859c8afa4248fcdb25bfe331d56e154b01f0536e689ef0e7f	513	25.65
16	0x2b137666fb25263d3dddd7386742026263c833bd61d7042d49d057ba1946d8a1	496	24.8
17	0xf74766bdff442a8aa1ac2bd5dd411fe8896a00707a4714032a02828857f6d613	489	24.45
18	0x8ed919bcb76846005ee1a433173ed6f34d152124ec1492597addfa3b00ab1956	470	23.5
19	0xc3e0156c97696d0fad4d9f1eba2500d902420314c661cc7a687ef3532c553ed	456	22.8
20	0x544ace745e96abaf67ffe538a58546f3db7824ecdd1e93ba169953fa26bd348f	450	22.5

...

1269

97KB

207s

flipside

flipside