USER_TIER | Users | |
|---|---|---|
1 | d. More than 10 times | 470169 |
2 | b. 2-5 times | 1319641 |
3 | c. 6-10 times | 386589 |
4 | a. One-time swapper | 463447 |
MLDZMNuser 1
Updated 2025-04-30
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 tokens as (select *
from (VALUES
('0x0F0BDEbF0F83cD1EE3974779Bcb7315f9808c714', 'DAK','18'),
('0xfe140e1dCe99Be9F4F15d657CD9b7BF622270C50', 'YAKI','18'),
('0xE0590015A873bF326bd645c3E1266d4db41C4E6B', 'CHOG','18')
) AS t (adress, Symbol, Decimals)
),
pools as (select *
from (VALUES
('0x6e4B7be5Ef7F8950C76BAa0bd90125BC9b33c8db', 'DAK','WMON','DAK-WMON'),
('0x212FdE77A42d55F980D0A0304E7eEbe1E999C60f', 'YAKI','WMON','YAKI-WMON'),
('0xc0ce32EEe0eb8bF24FA2b00923a78abc5002f91e', 'CHOG','WMON','CHOG-WMON')
) AS t (pool_address, token0, token1, pool_name)
),
raw_swaps as (select
BLOCK_TIMESTAMP,
TX_HASH,
ORIGIN_FROM_ADDRESS,
CONTRACT_ADDRESS as pool_address,
pool_name,
token0,
token1,
regexp_substr_all(substr(DATA,3, len(DATA)), '.{64}') as split,
livequery.utils.udf_hex_to_int(split[0])/pow(10,18) as amount0in,
livequery.utils.udf_hex_to_int(split[1])/pow(10,18) as amount1in,
livequery.utils.udf_hex_to_int(split[2])/pow(10,18) as amount0out,
livequery.utils.udf_hex_to_int(split[3])/pow(10,18) as amount1out
from monad.testnet.fact_event_logs logs
join pools p on lower(logs.CONTRACT_ADDRESS) = lower(p.pool_address)
where TOPIC_0 = '0xd78ad95fa46c994b6551d0da85fc275fe613ce37657fb8d5e3d130840159d822'
and ORIGIN_TO_ADDRESS = '0x4c4eabd5fb1d1a7234a48692551eaecff8194ca7'
--and logs.CONTRACT_ADDRESS in (select lower(p.pool_address) from pools)
--and tx_hash = '0x1d56aa50d36d161a4febac210c2479800c53d54eb93912899d2001cbca0664cf'
Last run: about 1 month ago
4
115B
57s