USER_TIER | Users | |
|---|---|---|
1 | a. Less then 10 MON | 1286841 |
2 | e. More than 1000 MON | 152489 |
3 | b. 10-50 MON | 502413 |
4 | c. 50-200 MON | 425031 |
5 | d. 200-1000 MON | 273072 |
MLDZMNuser 2
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
›
⌄
-- forked from user 1 @ https://flipsidecrypto.xyz/studio/queries/987026aa-4af6-4c00-8877-8b660b929594
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'
Last run: about 2 months ago
5
142B
64s