DATE | TYPE | TRANSACTIONS | USERS | VOLUME | AMOUNT | |
|---|---|---|---|---|---|---|
1 | 2024-05-30 00:00:00.000 | Borrow | 2 | 2 | 0.51051 | 0.51 |
2 | 2024-05-30 00:00:00.000 | Supply | 5 | 2 | 2.275001592 | 2.51 |
3 | 2024-05-31 00:00:00.000 | Repay | 1 | 1 | 0.009972963 | 0.009963 |
4 | 2024-06-01 00:00:00.000 | Repay | 3 | 1 | ||
5 | 2024-06-01 00:00:00.000 | Borrow | 7 | 4 | 301.396835 | 301.396835 |
6 | 2024-06-01 00:00:00.000 | Withdraw | 1 | 1 | 0.2544504793 | 0.5 |
7 | 2024-06-01 00:00:00.000 | Supply | 14 | 4 | 1582.248743242 | 2258.004475572 |
8 | 2024-06-02 00:00:00.000 | Withdraw | 10 | 5 | 1244.896796814 | 2186.525797744 |
9 | 2024-06-02 00:00:00.000 | Borrow | 2 | 1 | 200.400079158 | 200.000079 |
10 | 2024-06-02 00:00:00.000 | Supply | 14 | 6 | 261.32535171 | 522.102322473 |
11 | 2024-06-02 00:00:00.000 | Repay | 5 | 3 | 401.783730534 | 400.981767 |
12 | 2024-06-03 00:00:00.000 | Withdraw | 7 | 2 | 589.787359756 | 594.150171566 |
13 | 2024-06-03 00:00:00.000 | Repay | 4 | 3 | 225.651101676 | 225.425676 |
14 | 2024-06-03 00:00:00.000 | Borrow | 9 | 3 | 1294.256663707 | 1649.830927965 |
15 | 2024-06-03 00:00:00.000 | Supply | 21 | 5 | 3172.347744106 | 4579.725403046 |
16 | 2024-06-04 00:00:00.000 | Repay | 15 | 6 | 138233.205412366 | 139438.532683 |
17 | 2024-06-04 00:00:00.000 | Supply | 165 | 26 | 3648780.80795025 | 6013616.22688716 |
18 | 2024-06-04 00:00:00.000 | Withdraw | 20 | 9 | 86747.815980268 | 88035.172259512 |
19 | 2024-06-04 00:00:00.000 | Borrow | 85 | 13 | 708384.788829507 | 724572.201552234 |
20 | 2024-06-05 00:00:00.000 | Borrow | 106 | 20 | 1522349.33752371 | 1491689.935892 |
hessDaily Per Type
Updated 2025-03-30
999
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 supply_decode as (select block_timestamp,
tx_hash,
regexp_substr_all(substr(input,11, len(input)), '.{64}') as segmented,
'0x' || substr(segmented[0]::string, 25 ) as token_address,
'0x' || substr(segmented[2]::string, 25 ) as user_address,
livequery.utils.udf_hex_to_int(segmented [1] :: STRING) AS amount,
case when token_address = '0x43edd7f3831b08fe70b7555ddd373c8bf65a9050' then amount/pow(10,18)
when token_address = '0xb75d0b03c06a926e488e2659df1a861f860bd3d1' then amount/pow(10,6)
when token_address = '0x5cf6826140c1c56ff49c808a1a75407cd1df9423' then amount/pow(10,6)
when token_address = '0x160345fc359604fc6e70e3c5facbde5f7a9342d8' then amount/pow(10,18)
when token_address = '0xe30fedd158a2e3b13e9badaeabafc5516e95e8c7' then amount/pow(10,18)
when token_address = '0x3894085ef7ff0f0aedf52e2a2704928d1ec074f1' then amount/pow(10,6)
when token_address = '0x80eede496655fb9047dd39d9f418d5483ed600df' then amount/pow(10,18)
when token_address = '0x5bff88ca1442c2496f7e475e9e7786383bc070c0' then amount/pow(10,18) end as amt
from sei.core_evm.fact_traces
where to_address = '0x4a4d9abd36f923cba0af62a39c01dec2944fb638'
and left(input,10) in ('0x617ba037','0xe8eda9df')
and (TX_STATUS = 'SUCCESS' or tx_status is null)
and tx_hash != '0xc2a36963760985236d97ffc5e05102d4201186d8fd297b1a9fb28c5cebd1a1ab')
,
supply_ez as ( select ifnull(block_timestamp,INSERTED_TIMESTAMP) as block_time,
tx_hash,
INSERTED_TIMESTAMP,
case when contract_address = lower('0x809FF4801aA5bDb33045d1fEC810D082490D63a4') then '0xe30fedd158a2e3b13e9badaeabafc5516e95e8c7'
when contract_address = lower('0xa524c4a280f3641743eBa56e955a1c58e300712b') then '0x5cf6826140c1c56ff49c808a1a75407cd1df9423'
when contract_address = lower('0xc1a6F27a4CcbABB1C2b1F8E98478e52d3D3cB935') then '0x3894085ef7ff0f0aedf52e2a2704928d1ec074f1'
when contract_address = lower('0x093066736E6762210de13F92b39Cf862eee32819') then '0x160345fc359604fc6e70e3c5facbde5f7a9342d8'
when contract_address = lower('0xd3C367195f96A9387564287a28D935adb44D4531') then '0xe30fedd158a2e3b13e9badaeabafc5516e95e8c7'
when contract_address = lower('0x1C4b5c523f859c0F1f14A722a1EAFDe10348F995') then '0x3ec3849c33291a9ef4c5db86de593eb4A37fde45'
when contract_address = lower('0xF37d13B0008b177fF47296Fc0A15c9935086821d') then '0x3894085ef7ff0f0aedf52e2a2704928d1ec074f1'
when contract_address = lower('0x945C042a18A90Dd7adb88922387D12EfE32F4171') then '0xb75d0b03c06a926e488e2659df1a861f860bd3d1'
when contract_address = lower('0xC15dce4e1BfABbe0897845d7f7Ee56bc37113E08') then '0x80eede496655fb9047dd39d9f418d5483ed600df'
when contract_address = lower('0x7090D5fdCEfB496651B55c20D56282CbcdDC2EE2') then '0x5bff88ca1442c2496f7e475e9e7786383bc070c0'
when contract_address = lower('0x2a662eF26556a7d8795BF7a678E3Dd4b36FDec1e') then '0x43edd7f3831b08fe70b7555ddd373c8bf65a9050' end as token_address,
ORIGIN_FROM_ADDRESS as user_address,
amount,
Last run: 11 days ago
...
1211
93KB
22s