DATE | PSP volume | BETS | Active bettors | Avg leverage | CHAIN | |
|---|---|---|---|---|---|---|
1 | 2025-04-22 00:00:00.000 | 91110 | 17 | 5 | 4 | Avalanche |
2 | 2025-03-14 00:00:00.000 | 1917563.27 | 1157 | 541 | 3 | Monad |
3 | 2025-03-13 00:00:00.000 | 1341665.86 | 647 | 364 | 3 | Monad |
4 | 2025-04-21 00:00:00.000 | 16752307.945579 | 4322 | 2872 | 3 | Monad |
5 | 2025-03-21 00:00:00.000 | 6879739.966379 | 72766 | 35628 | 3 | Monad |
6 | 2025-02-24 00:00:00.000 | 994733 | 259 | 84 | 3 | Avalanche |
7 | 2025-04-15 00:00:00.000 | 23723772.51 | 8775 | 3274 | 3 | Monad |
8 | 2025-02-11 00:00:00.000 | 769863 | 156 | 36 | 3 | Avalanche |
9 | 2025-03-28 00:00:00.000 | 28768704.141807 | 41712 | 20740 | 3 | Monad |
10 | 2025-03-23 00:00:00.000 | 608849 | 124 | 61 | 3 | Avalanche |
11 | 2025-04-09 00:00:00.000 | 31647632.48 | 9409 | 2956 | 3 | Monad |
12 | 2025-01-24 00:00:00.000 | 313682.16 | 100 | 44 | 3 | Avalanche |
13 | 2025-03-29 00:00:00.000 | 345116 | 36 | 18 | 3 | Avalanche |
14 | 2025-03-04 00:00:00.000 | 831644 | 261 | 67 | 3 | Avalanche |
15 | 2025-04-01 00:00:00.000 | 18485823.56 | 58989 | 31927 | 3 | Monad |
16 | 2025-02-04 00:00:00.000 | 1727413 | 172 | 58 | 3 | Avalanche |
17 | 2025-04-07 00:00:00.000 | 1583700.49 | 46 | 11 | 3 | Avalanche |
18 | 2025-04-03 00:00:00.000 | 504008 | 89 | 29 | 3 | Avalanche |
19 | 2025-03-20 00:00:00.000 | 238526 | 81 | 25 | 3 | Avalanche |
20 | 2025-03-31 00:00:00.000 | 42817273.06 | 101419 | 38773 | 3 | Monad |
Hessishlvr agg 1
Updated 1 day 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_avax as
(select ORIGIN_FROM_ADDRESS,
DECODED_LOG:gameId as game_Id,
DECODED_LOG:collateral/1e6 as amount,
DECODED_LOG:leverageRate as leverage,
tx_hash,
BLOCK_TIMESTAMP
from avalanche.core.ez_decoded_event_logs
where-- tx_hash = '0x37252c2832e5e236bf09fdd9cf0685dff7c12822e9e0567c7d202748fc462587' and
ORIGIN_TO_ADDRESS = '0xf57e80863fe17086dd6956349c18ee027788c352' and
ORIGIN_FUNCTION_SIGNATURE = '0xf136c3db' and
TOPICS[0] = '0xd026f53b49532f9b4c7e59f32feb5b919b08627ac82d92d57e12a19c45054efa'),
b_data_mon 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 amount,
SUBSTRING(a.data, 193, 2)::number 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,
Last run: 1 day ago
...
158
9KB
134s