DATE | BETS | Active markets | |
|---|---|---|---|
1 | 2025-04-21 00:00:00.000 | 4322 | 17 |
2 | 2025-02-28 00:00:00.000 | 1361 | 25 |
3 | 2025-03-11 00:00:00.000 | 1060 | 10 |
4 | 2025-03-19 00:00:00.000 | 13672 | 40 |
5 | 2025-03-29 00:00:00.000 | 77497 | 31 |
6 | 2025-02-26 00:00:00.000 | 1041 | 7 |
7 | 2025-03-10 00:00:00.000 | 2128 | 14 |
8 | 2025-03-28 00:00:00.000 | 41712 | 21 |
9 | 2025-04-22 00:00:00.000 | 4515 | 10 |
10 | 2025-02-21 00:00:00.000 | 684 | 12 |
11 | 2025-03-12 00:00:00.000 | 514 | 11 |
12 | 2025-03-21 00:00:00.000 | 72766 | 25 |
13 | 2025-02-19 00:00:00.000 | 10 | 1 |
14 | 2025-02-20 00:00:00.000 | 700 | 4 |
15 | 2025-04-12 00:00:00.000 | 2465 | 17 |
16 | 2025-03-05 00:00:00.000 | 2033 | 20 |
17 | 2025-03-06 00:00:00.000 | 1473 | 16 |
18 | 2025-03-14 00:00:00.000 | 1157 | 16 |
19 | 2025-03-15 00:00:00.000 | 1690 | 14 |
20 | 2025-04-17 00:00:00.000 | 10230 | 14 |
Hessishlbt 1
Updated 2 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 b_data as
(select a.ORIGIN_FROM_ADDRESS,
a.TOPICS[1] as game_id,
--CAST(ethereum.public.udf_hex_to_int(b.data) AS NUMERIC) / 1e6 AS volume,
SUBSTRING(a.data, 193, 2)||'x' as leverage,
a.tx_hash,
a.BLOCK_TIMESTAMP
from monad.testnet.fact_event_logs a
join monad.testnet.fact_event_logs b
on a.tx_hash = b.tx_hash
where --a.tx_hash = '0xb4fad7b9942b28f1d153a4c7c984b791fb1227956756c4fa2293c83f519adbb3' and
a.ORIGIN_TO_ADDRESS = '0x66dd5e0be80417cef966d788079d9be7a8618753'
and a.ORIGIN_FUNCTION_SIGNATURE = '0xf136c3db'
and a.topics[0] = '0xd026f53b49532f9b4c7e59f32feb5b919b08627ac82d92d57e12a19c45054efa'
and b.CONTRACT_ADDRESS = '0xbf7a88acbb8cf66b72af6c399569e37ee4d5195f'
and b.topics[0] = '0xddf252ad1be2c89b69c2b068fc378daa952ba7f163c4a11628f55a4df523b3ef'
having '0x'||SUBSTRING(b.topics[1], 27) = b.ORIGIN_FROM_ADDRESS
union
select a.ORIGIN_FROM_ADDRESS,
a.TOPICS[1] as game_id,
-- CAST(ethereum.public.udf_hex_to_int(b.data) AS NUMERIC) / 1e6 AS volume,
SUBSTRING(a.data, 193, 2)||'x' as leverage,
a.tx_hash,
a.BLOCK_TIMESTAMP
from monad.testnet.fact_event_logs a
join monad.testnet.fact_event_logs b
on a.tx_hash = b.tx_hash
where --a.tx_hash = '0x9f2132d167ba686d0fa496fe991695a1403c0014e1152de717fb4749ed44ccd0' and
a.ORIGIN_TO_ADDRESS = '0x1240a9cf5e2bf10eba09740f7127b9b59218907f'
and a.ORIGIN_FUNCTION_SIGNATURE = '0xf136c3db'
and a.topics[0] = '0xd026f53b49532f9b4c7e59f32feb5b919b08627ac82d92d57e12a19c45054efa'
Last run: about 2 hours ago
66
2KB
196s