Date | SYMBOL | Number of Transactions | Number of Users | Amount of Transactions | |
|---|---|---|---|---|---|
1 | 2025-04-08 12:00:00.000 | WBTC | 1 | 1 | 789.55 |
2 | 2025-04-08 14:00:00.000 | WBTC | 40 | 37 | 152125.59831534 |
3 | 2025-04-08 14:00:00.000 | USDC | 38 | 37 | 40745.573855 |
4 | 2025-04-08 14:00:00.000 | USDT | 54 | 52 | 61904.989332 |
5 | 2025-04-08 14:00:00.000 | MUSD | 57 | 53 | 210151.176467171 |
6 | 2025-04-08 14:00:00.000 | tBTC | 96 | 91 | 374206.5303963 |
7 | 2025-04-08 15:00:00.000 | MUSD | 31 | 30 | 21475.897336429 |
8 | 2025-04-08 15:00:00.000 | tBTC | 75 | 65 | 1122366.1779 |
9 | 2025-04-08 15:00:00.000 | USDC | 35 | 32 | 131601.98414425 |
10 | 2025-04-08 15:00:00.000 | WBTC | 38 | 33 | 724513.3688 |
11 | 2025-04-08 15:00:00.000 | USDT | 43 | 41 | 185224.1067027 |
12 | 2025-04-08 16:00:00.000 | USDT | 29 | 27 | 42079.08809 |
13 | 2025-04-08 16:00:00.000 | tBTC | 59 | 54 | 261629.52437 |
14 | 2025-04-08 16:00:00.000 | WBTC | 28 | 25 | 149575.898528 |
15 | 2025-04-08 16:00:00.000 | MUSD | 31 | 30 | 31789.45204887 |
16 | 2025-04-08 16:00:00.000 | USDC | 20 | 20 | 35551.8956458 |
17 | 2025-04-08 17:00:00.000 | WBTC | 22 | 19 | 603444.359 |
18 | 2025-04-08 17:00:00.000 | USDT | 23 | 22 | 93980.674854 |
19 | 2025-04-08 17:00:00.000 | USDC | 23 | 22 | 102293.941231 |
20 | 2025-04-08 17:00:00.000 | tBTC | 39 | 33 | 671252.1297 |
Eman-RazSupply 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
...
2688
135KB
19s