PLAYER | PLAY_COUNT | WAGERED | WINNINGS | NET_LOSS | RANK_WAGERED | RANK_LOSS | |
|---|---|---|---|---|---|---|---|
1 | 0x26737fb3fb631a057a085b51af5087e578b02584 | 462 | 964083.3293 | 0.6656125 | 964082.6636875 | 1 | 1 |
2 | 0x2962f50c660287834a617d0a8de7dd1a5affcf44 | 417 | 786584.729733333 | 0 | 786584.729733333 | 2 | 2 |
3 | 0x9bfe0a05a274b229e0e4bd162bd22aea9276cdbf | 512 | 767576.716885417 | 0 | 767576.716885417 | 3 | 3 |
4 | 0x94f35b2444ec6e60296002e028a7fcd74fd6c5ed | 313 | 541626.858745833 | 0 | 541626.858745833 | 4 | 4 |
5 | 0xfa80c1a8f2968d6526607d780b06acb68d61beb8 | 431 | 452830.02843125 | 0 | 452830.02843125 | 5 | 5 |
6 | 0x75333d612f37fcb6c3a0da520bee0ba8380318bf | 4217 | 388268.258281771 | 0 | 388268.258281771 | 6 | 6 |
7 | 0x19a88cfc0b097e6f9f2bfdd0cc18765e169ca05c | 874 | 380591.691904167 | 0 | 380591.691904167 | 7 | 7 |
8 | 0xaad01bec406b83850f2870dd5e19b36c2cda58d4 | 236 | 375089.5133125 | 0 | 375089.5133125 | 8 | 8 |
9 | 0x327d9c5d98000e84cf3375cb5607da2ae5cc4850 | 139 | 369276.312603333 | 0 | 369276.312603333 | 9 | 9 |
10 | 0x1afd1968f6081c88dad6da186cc15286512e90c6 | 426 | 366596.72532851 | 0 | 366596.72532851 | 10 | 10 |
11 | 0x1142184c427c843172c14025df52501536cafe26 | 301 | 342452.365322292 | 2005.355625 | 340447.009697292 | 11 | 11 |
12 | 0xf83128ae01dc7d66d4d8807903fa0431efb4e123 | 137 | 331135.070083333 | 0 | 331135.070083333 | 12 | 12 |
13 | 0x6954f7add88b0c0a2761a5dd0a56913df88894c8 | 366 | 243592.008331667 | 700.4073125 | 242891.601019167 | 13 | 13 |
14 | 0x808a7287d7ce25f06b6f2201a95042e15f047c6b | 650 | 237496.661271458 | 0 | 237496.661271458 | 14 | 14 |
15 | 0xa9614ce2adfff408877b56caff111ba591196997 | 101 | 217513.383431156 | 0 | 217513.383431156 | 15 | 15 |
16 | 0xfda8a1094327e78ea9748176867977bad05e5b1b | 315 | 191704.27415125 | 0 | 191704.27415125 | 16 | 16 |
17 | 0x65690116a8b689e434754c7d58930e4741b71b83 | 592 | 172375.441364063 | 0 | 172375.441364063 | 17 | 17 |
18 | 0x37099c929a51083c83f3eff38e811dda24c783c6 | 710 | 161833.951278542 | 0 | 161833.951278542 | 18 | 18 |
19 | 0x95894a9da8596206545787300f2e77c5b68e5ac6 | 276 | 148182.351085417 | 1351.47425 | 146830.876835417 | 19 | 19 |
20 | 0x59de758485f31c989d5ceda62f78bab94f735c83 | 417 | 142041.531355625 | 0 | 142041.531355625 | 20 | 20 |
permarywins and loss
Updated 2025-02-25
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 avax_price AS (
SELECT
DATE_TRUNC('day', hour) AS day,
AVG(price) AS price
FROM avalanche.price.ez_prices_hourly
WHERE symbol = 'WAVAX'
GROUP BY 1
),
player_stats AS (
SELECT
a.origin_from_address AS player,
COUNT(DISTINCT a.tx_hash) AS play_count,
SUM(a.amount * b.price) AS wagered,
SUM(CASE WHEN a.origin_function_signature = '0x999bc83e' THEN a.amount * b.price ELSE 0 END) AS winnings,
SUM(a.amount * b.price) - SUM(CASE WHEN a.origin_function_signature = '0x999bc83e' THEN a.amount * b.price ELSE 0 END) AS net_loss
FROM avalanche.core.ez_native_transfers a
JOIN avax_price b ON DATE_TRUNC('day', a.block_timestamp) = b.day
WHERE LOWER(a.origin_to_address) IN (
LOWER('0x7D812a58DD63Eb3A7b3b84f9290BD84dB148893F'),
LOWER('0x08E1e965b485Ed4f8F4E4b32bc65bBbE5F302D72'),
LOWER('0x5035fC7a8b92C21e5146a4F00ccE543Df4B35A3e'),
LOWER('0x0382DF14B587c51052FFcCA53DB8697849Ca1B2e'),
LOWER('0x50e50B4076817b10C341CaB216C28012069eC3Ed'),
LOWER('0x8425E43C147329BF5B12b17Aba180bb5834e3Bbf'),
LOWER('0x02C1eDfbA909Dafd1ECf6aA9182FC69ee4c10e11'),
LOWER('0x8a06D417df79e271B99C42dfB55158de3594f963'),
LOWER('0x3d74Cbac40E2F23a795C665056613e3f3a83d160')
)
AND a.origin_function_signature IN (
'0x53ccbeea', '0x2426b72b', '0x53ccbeea', '0xe427275b', '0x14ea3539',
'0x51ea0b03', '0x3eefe77e', '0x999bc83e', '0x11af445d'
)
AND a.block_timestamp >= DATEADD('day', -30, CURRENT_DATE) -- Last 30 days
GROUP BY 1
)
SELECT
Last run: 2 months ago
100
9KB
8s