SELECT

tx_hash,

block_timestamp,

origin_from_address AS user,

utils.udf_hex_to_int(data)::bigint / 1e18 AS amount,

IFF(topics[1] = '0x0000000000000000000000000000000000000000000000000000000000000000', 'Stake', 'Unstake') AS event_name

FROM

monad.testnet.fact_event_logs

WHERE

tx_succeeded

AND origin_to_address = '0xb2f82d0f38dc453d596ad40a37799446cc89274a'

AND topics[0] = '0xddf252ad1be2c89b69c2b068fc378daa952ba7f163c4a11628f55a4df523b3ef'

AND contract_address = LOWER('0xb2f82D0f38dc453D596Ad40A37799446Cc89274A')

and block_timestamp >= '2025-02-19'

),

categorized AS (

SELECT

event_name,

CASE

WHEN amount < 1 THEN 'Less than 1 $MON'

WHEN amount BETWEEN 1 AND 2 THEN '1 $MON - 2 $MON'

WHEN amount BETWEEN 2 AND 5 THEN '2 $MON - 5 $MON'

WHEN amount BETWEEN 5 AND 10 THEN '5 $MON - 10 $MON'

WHEN amount BETWEEN 10 AND 20 THEN '10 $MON - 20 $MON'

WHEN amount BETWEEN 20 AND 50 THEN '20 $MON - 50 $MON'

WHEN amount BETWEEN 50 AND 100 THEN '50 $MON - 100 $MON'

WHEN amount BETWEEN 100 AND 500 THEN '100 $MON - 500 $MON'

WHEN amount BETWEEN 500 AND 1000 THEN '500 $MON - 1K $MON'

WHEN amount BETWEEN 1000 AND 5000 THEN '1K $MON - 5K $MON'

ELSE 'More than 5K $MON'

END AS amount_category,

COUNT(*) AS txn_count

FROM main

GROUP BY amount_category, event_name