Date | ACTION_TYPE | Number of Transactions | Number of Users | Amount of Transactions | |
|---|---|---|---|---|---|
1 | 2025-04-08 12:00:00.000 | Borrow | 1 | 1 | 9.9902 |
2 | 2025-04-08 12:00:00.000 | Supply | 1 | 1 | 789.55 |
3 | 2025-04-08 14:00:00.000 | Withdraw | 2 | 2 | 1000.044641 |
4 | 2025-04-08 14:00:00.000 | Repay | 16 | 14 | 5819.589789674 |
5 | 2025-04-08 14:00:00.000 | Supply | 285 | 158 | 839133.868365811 |
6 | 2025-04-08 14:00:00.000 | Borrow | 169 | 153 | 287859.135153649 |
7 | 2025-04-08 15:00:00.000 | Supply | 222 | 116 | 2185181.53488338 |
8 | 2025-04-08 15:00:00.000 | Repay | 11 | 5 | 202.7269365 |
9 | 2025-04-08 15:00:00.000 | Borrow | 166 | 118 | 111175.295614658 |
10 | 2025-04-08 15:00:00.000 | Withdraw | 8 | 3 | 76321.654484 |
11 | 2025-04-08 16:00:00.000 | Supply | 167 | 82 | 520625.85868267 |
12 | 2025-04-08 16:00:00.000 | Repay | 4 | 4 | 799.841207105 |
13 | 2025-04-08 16:00:00.000 | Borrow | 112 | 84 | 123495.586676909 |
14 | 2025-04-08 16:00:00.000 | Withdraw | 4 | 3 | 3277.6023698 |
15 | 2025-04-08 17:00:00.000 | Repay | 7 | 6 | 291.021017983 |
16 | 2025-04-08 17:00:00.000 | Borrow | 84 | 64 | 149032.8045921 |
17 | 2025-04-08 17:00:00.000 | Withdraw | 2 | 2 | 1000.244265 |
18 | 2025-04-08 17:00:00.000 | Supply | 119 | 60 | 1477559.126268 |
19 | 2025-04-08 18:00:00.000 | Repay | 9 | 7 | 4380.480523535 |
20 | 2025-04-08 18:00:00.000 | Withdraw | 3 | 3 | 1275.9966 |
Eman-RazStats Over Time
Updated 2025-05-01
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 final_table as (
with blend_table as (SELECT
date_trunc('hour',block_timestamp) as date,
tx_hash,
origin_function_signature,
origin_from_address,
origin_to_address,
'0x' || SUBSTR(INPUT, 35, 40) AS token_address, case
when '0x' || SUBSTR(INPUT, 35, 40)='0x7ec27d448c6437b4dc3561b3b33512680a179c3f' then 'tBTC'
when '0x' || SUBSTR(INPUT, 35, 40)='0xd68308efbe8330a7bf58276edef51d91316e90b4' then 'USDT'
when '0x' || SUBSTR(INPUT, 35, 40)='0x5eaa741552d6af40c7bf46467eaf79eea08eea9f' then 'WBTC'
when '0x' || SUBSTR(INPUT, 35, 40)='0xf08085ed33c0619113ee706fdb4b1b2c96137bee' then 'USDC'
when '0x' || SUBSTR(INPUT, 35, 40)='0x637e22a1ebbca50ea2d34027c238317fd10003eb' then 'MUSD'
end as symbol,
(
TO_NUMBER(SUBSTR(INPUT, 75, 8), 'XXXXXXXX') * POW(16, 56) +
TO_NUMBER(SUBSTR(INPUT, 83, 8), 'XXXXXXXX') * POW(16, 48) +
TO_NUMBER(SUBSTR(INPUT, 91, 8), 'XXXXXXXX') * POW(16, 40) +
TO_NUMBER(SUBSTR(INPUT, 99, 8), 'XXXXXXXX') * POW(16, 32) +
TO_NUMBER(SUBSTR(INPUT, 107, 8), 'XXXXXXXX') * POW(16, 24) +
TO_NUMBER(SUBSTR(INPUT, 115, 8), 'XXXXXXXX') * POW(16, 16) +
TO_NUMBER(SUBSTR(INPUT, 123, 8), 'XXXXXXXX') * POW(16, 8) +
TO_NUMBER(SUBSTR(INPUT, 131, 8), 'XXXXXXXX') * POW(16, 0)
) AS raw_amount, case
when '0x' || SUBSTR(INPUT, 35, 40)='0x7ec27d448c6437b4dc3561b3b33512680a179c3f' then 18
when '0x' || SUBSTR(INPUT, 35, 40)='0xd68308efbe8330a7bf58276edef51d91316e90b4' then 6
when '0x' || SUBSTR(INPUT, 35, 40)='0x5eaa741552d6af40c7bf46467eaf79eea08eea9f' then 18
when '0x' || SUBSTR(INPUT, 35, 40)='0xf08085ed33c0619113ee706fdb4b1b2c96137bee' then 6
when '0x' || SUBSTR(INPUT, 35, 40)='0x637e22a1ebbca50ea2d34027c238317fd10003eb' then 18
end as decimal, case
when origin_function_signature='0x617ba037' then 'Supply'
when origin_function_signature='0xa415bcad' then 'Borrow'
when origin_function_signature='0x573ade81' then 'Repay'
when origin_function_signature='0x69328dec' then 'Withdraw'
end as action_type
FROM mezo.testnet.fact_traces
Last run: about 1 month ago
...
1860
102KB
22s