BLOCK_TIMESTAMP | VALUE | BET_AMT | PROFIT | CARDS_IN_SLIP | USR | BET_ID | TX_HASH | TX | |
|---|---|---|---|---|---|---|---|---|---|
1 | 2025-03-17 20:26:34.000 | 0.25 | 0.1 | 150% | 2 | 0x9d7412b1e1b47e933e0964d8e7bde9657baa95dc | 86062 | 0x29b89468ec7dca5e30c5cacc0718a367ffbf873686a54c9ffb6c6a7249368079 | 0xdec415c72e413bd0b48ff76dfa1b2525134d666930006f787253bb52f44d4147 |
2 | 2025-03-17 20:11:16.000 | 0.8 | 0.1 | 700% | 4 | 0xe4f978da61b9351827b6a5b5181026e3ae4cb5b5 | 92696 | 0xf04fd4a2e89275c65c586d813e78c3b862fc2b1307156a324472f7bcc892ae72 | 0xf38c0f8177b0c5048c0deeacb5f1709a401dd404806ed4df19d21995a12b96c7 |
3 | 2025-03-17 20:08:26.000 | 1.25 | 0.5 | 150% | 2 | 0xee0e88d00bfdb91670e6b4d102827cac8e0363b1 | 36747 | 0x61eaaf9fc91c0a376492f76692cee13b1bc59c2cde9e4d10baf3cb134ee0e5e9 | 0x1449a7e05cd35683879c7794d24af22737ec1aad592b4e7c311522ee904b946c |
4 | 2025-03-17 20:04:26.000 | 0.25 | 0.1 | 150% | 2 | 0xfc5e4000844e56689f12361c0e122ec1f0e10db1 | 90536 | 0xfd658bf64f6bf93f89527895b7278e4edf5ea1c7d167fa20fc700658d5f6aa48 | 0xe755dd89238624a347a66e4d0363fafeaa38bd96c15489fb929ad35f17744fc1 |
5 | 2025-03-17 20:02:56.000 | 0.8 | 0.1 | 700% | 4 | 0x866a0ef437701294d2606b1a9d1136f43758fbf7 | 94656 | 0x0372c24e41eafe54b1be54809f3d0391e6927d5cb27e9e565662199fd2c84d6a | 0x2ff9dba19f9b3612751b871684918c6dc4a561e792146f1087ea104b0e0b78ef |
6 | 2025-03-17 19:47:35.000 | 3.25 | 1.3 | 150% | 2 | 0x3bfc64d70445c3b9055af0cb124043447e69cf04 | 92899 | 0x5fe7b4c10c9acebb9466b32eca2cb330afb03839a38b70844539831fba261511 | 0x8a88c0825d4a424f12f30fd35109d7662b0cb40276891fc435c450d2312c7931 |
7 | 2025-03-17 19:27:11.000 | 2.5 | 1 | 150% | 2 | 0x302fa522306f2676171889ded11d6c88defe4d66 | 91107 | 0xfcd531fd5bec91fb7381263adf269f1a1b5dc79a408f75ea94c67f69148338a3 | 0xbae0cbf8e7da8ddb44236bff606a629e3cf077c4839827fb36f170b5c583b85d |
8 | 2025-03-17 19:12:19.000 | 12.5 | 5 | 150% | 2 | 0xc9b4d9fba6ffd48e47537307cff0a9f8a11783f6 | 60424 | 0xf7c901785437ab46bf8b67019a8678bed3d4d865a9c38bf4be45e4e95d0e9b62 | 0x2768edeacbfaf913fd697f6bbd890a697bfaabbc3254a93b16d580b613ab2319 |
9 | 2025-03-17 18:50:26.000 | 0.4 | 0.1 | 300% | 3 | 0xa3e9ef0aeb80a456004f88368f6663b666eccbd2 | 94590 | 0x9ff3029045e06178c564921b32070b971497d9e43fbd00bfd72699c6780e400a | 0x8d83b47ffc9463017341aef765116c2ceb4bde30cf6fc22d8349b6ce3f62c217 |
10 | 2025-03-17 18:46:14.000 | 0.25 | 0.1 | 150% | 2 | 0x7d2234b12cb614fb122c44405a76709945f2f889 | 93486 | 0xd7a64244529926d5fc7f8d4e7195a46db8585f37998ba2a529fa6b36612676d4 | 0xa00131425c61d859a6a2e57f26e02d2897a61ad686c8228552478fe60f783092 |
11 | 2025-03-17 18:14:57.000 | 0.25 | 0.1 | 150% | 2 | 0x7f8668fb97d998ae9573bff4f0abcb6bad750a8d | 87632 | 0x188614dfc4e36c099582f8ff38c6988e4e6e716dd5793339adee4059ed87dbf2 | 0x3844d92bec0a861230472e4482ae9f0e4792ceb2abc60198da0f44f2e77618e9 |
12 | 2025-03-17 18:13:33.000 | 0.25 | 0.1 | 150% | 2 | 0x9a269d663875f6c06954e66ddfd0a8ff410d807d | 90307 | 0xef484ee4a7c3c233b0a455bdbaa63ab24de2057593436b2434e86f64c34244cb | 0x9a091fab171dee86e6cf8ab8552bbd1b36dd487fc520e704d4c370cd66bf2250 |
13 | 2025-03-17 18:12:22.000 | 0.25 | 0.1 | 150% | 2 | 0x9a269d663875f6c06954e66ddfd0a8ff410d807d | 90278 | 0xcb81b5f4ffa4f79950cb5a27c5612e55fbb6cc27506f48b5314cf0011543e377 | 0x97dd9ef5489404f0cc1a0f731ab6fb97c637babc9ef7e2ebba436b1f2e3cb65c |
14 | 2025-03-17 18:12:09.000 | 0.25 | 0.1 | 150% | 2 | 0x9a269d663875f6c06954e66ddfd0a8ff410d807d | 90287 | 0x7bbea8fd19822b4866215200517f304ba2f7c6239e20822c346e3fcf73a9fc25 | 0xefadbb17af3674980e29232a19b34b5c085dcddfbe420a515308c9a24049f94d |
15 | 2025-03-17 18:04:03.000 | 0.25 | 0.1 | 150% | 2 | 0xa8af975118bafffcd14addabd1ff3f03c1e1f6d8 | 93679 | 0xe59a601242c2a0b96533e2983621a11ba6eabea47f41b74d304bdb2cbb77eed7 | 0xb0288aad854bbc13597be770e095967b151524a1137f6afd5f1a8555a2b6949b |
16 | 2025-03-17 18:01:59.000 | 0.25 | 0.1 | 150% | 2 | 0x32d367f93150e41417f5a491eb319ec0aea92284 | 93476 | 0xdf31eb44e69a1d42c7e058b4296de42f495d0da09c2767e04a01e03bb7aec32e | 0x6c67d342b3ed2cdc2e4fb1714b1e233c67d602919db47d12a87b8744bcfee790 |
17 | 2025-03-17 17:57:27.000 | 0.25 | 0.1 | 150% | 2 | 0x70a67188aaba127947cbe59a6d3b26704735d99b | 86185 | 0x64fe5943a5827655971bd20af2622f45cc9d1d2ebab8ed2b5dd8b8986981d426 | 0xd78587209f3350c493ad875b12b95f4db3eeff8e8c395567e579d77f603b3c41 |
18 | 2025-03-17 17:50:25.000 | 0.25 | 0.1 | 150% | 2 | 0xb2ad37e2eedad32a236a9f5f69497097fedff1a9 | 94768 | 0x07cc0c9ae43f631964975d66383f8f53c3cc318b6574735192b07c4c3271d74a | 0xbecd87a349aa07817a4ec8a4b47d5d2e07df582d05e4edd4b65993adca0c3ab2 |
19 | 2025-03-17 17:50:19.000 | 0.25 | 0.1 | 150% | 2 | 0xb2ad37e2eedad32a236a9f5f69497097fedff1a9 | 94772 | 0x699fe94eef847a756b39f92146fa2f22663583edf21021ac8b84bf2181b098ef | 0xd196a3138c72273782d243cf12d49b8b86c26921b3ad8ef14f514dbaee8c3e72 |
20 | 2025-03-17 17:50:09.000 | 0.25 | 0.1 | 150% | 2 | 0xb2ad37e2eedad32a236a9f5f69497097fedff1a9 | 94773 | 0x13c072f6183452fe124a6a9083d6e7c82758b3d2f55da71cdaa7fce22d6b2515 | 0xb1c8dbf25c860b47e1fb82e8fa20ecaf6003de5fa47339165e6f29b635fc46ab |
Hessishrbts rew exp
Updated 4 hours ago
99
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
›
⌄
with sub_tx as (select
b.value as bet_amt,
count(c.tx_hash) as cards_in_slip,
ethereum.public.udf_hex_to_int(a.TOPICS[2]) as bet_id_decoded,
a.tx_hash as tx,
a.ORIGIN_FROM_ADDRESS as usr,
a.BLOCK_TIMESTAMP as time
from monad.testnet.fact_event_logs a
join monad.testnet.fact_traces b
on a.tx_hash = b.tx_hash
join monad.testnet.fact_traces c
on a.tx_hash = c.tx_hash
WHERE
a.ORIGIN_FUNCTION_SIGNATURE = '0x5029defb'
and a.ORIGIN_TO_ADDRESS = '0x3ad50059d6008b711209a509fe58e68f0b672a42'
and b.TO_ADDRESS = '0x3ad50059d6008b711209a509fe58e68f0b672a42'
and c.TO_ADDRESS = '0xf70da0470b81315fe9ceb695c9be89f67713c815'
group by all),
all_rew as
(select
b.value,
ethereum.public.udf_hex_to_int(a.TOPICS[2]) as bet_id,
a.tx_hash,
a.ORIGIN_FROM_ADDRESS,
a.BLOCK_TIMESTAMP
from monad.testnet.fact_event_logs a
join monad.testnet.fact_traces b
on a.tx_hash = b.tx_hash and a.ORIGIN_from_ADDRESS = b.TO_ADDRESS
WHERE --a.tx_hash = '0x13e5fb9b3048e0983a9a5cba212620238859d338e2a4ff2cf38e7ea19a73e8ed' and
a.ORIGIN_FUNCTION_SIGNATURE = '0xa11fd1e3'
and a.ORIGIN_TO_ADDRESS = '0x3ad50059d6008b711209a509fe58e68f0b672a42'
and b.from_ADDRESS = '0x3ad50059d6008b711209a509fe58e68f0b672a42'
and a.TOPICS[0] = '0x9f930e45e5f186baa9054d3efb58f5f12c8894372119fb461d8abd2b9418cf2d')
select
Last run: about 4 hours ago
...
5000
1MB
110s