DATE | LABELS | USERS | TOTAL_TX | FEES_USD | AVG_FEE | |
|---|---|---|---|---|---|---|
1 | 2025-03-13 00:00:00.000 | Echo Lending | 192 | 529 | 11.82575204 | 0.005399886776 |
2 | 2025-03-13 00:00:00.000 | Merkle | 1051 | 11229 | 134.17459475 | 0.002890510238 |
3 | 2025-03-13 00:00:00.000 | Aries | 566 | 1445 | 13.16148119 | 0.001681548638 |
4 | 2025-03-13 00:00:00.000 | Cetus | 392 | 1819 | 13.79617825 | 0.002125759361 |
5 | 2025-03-13 00:00:00.000 | Abtin | 401 | 1174 | 1.92459457 | 0.001609192784 |
6 | 2025-03-13 00:00:00.000 | Thala | 1113 | 10908 | 72.55152286 | 0.003859123556 |
7 | 2025-03-13 00:00:00.000 | Meso Finance | 2602 | 10337 | 6.5701204 | 0.0005933460128 |
8 | 2025-03-13 00:00:00.000 | Echelon | 11194 | 23073 | 221.84856004 | 0.002838353655 |
9 | 2025-03-13 00:00:00.000 | Cellana | 3096 | 19023 | 100.30754771 | 0.001871653905 |
10 | 2025-03-13 00:00:00.000 | Joule Finance | 173 | 1027 | 2.19572288 | 0.00207339271 |
11 | 2025-03-13 00:00:00.000 | Tortuga | 10 | 11 | 0.03694971 | 0.003359064545 |
12 | 2025-03-13 00:00:00.000 | Echelon Market | 5 | 5 | 0.0231922 | 0.0014495125 |
13 | 2025-03-13 00:00:00.000 | Lucid Protocol | 1873 | 3051 | 28.0127241 | 0.004113469031 |
14 | 2025-03-13 00:00:00.000 | Ditto | 43 | 145 | 0.34578928 | 0.001262004672 |
15 | 2025-03-13 00:00:00.000 | Abel | 292 | 714 | 0.8022667 | 0.00023686646 |
16 | 2025-03-13 00:00:00.000 | Hippo Aggregator | 14 | 892 | 2.79871353 | 0.0008384402427 |
17 | 2025-03-13 00:00:00.000 | Amnis Finance | 2549 | 16292 | 15.32399495 | 0.0006146809045 |
18 | 2025-03-13 00:00:00.000 | Kanalabs | 72 | 6927 | 3.29021325 | 0.0004733438714 |
19 | 2025-03-13 00:00:00.000 | Msafe | 7 | 13 | 0.03724609 | 0.002865083846 |
20 | 2025-03-13 00:00:00.000 | Propbase | 6 | 13 | 0.00573289 | 0.0004409915385 |
0xHaM-dDaily Per Label type
Updated 2025-03-14
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
›
⌄
-- forked from Daily Per Label type copy @ https://flipsidecrypto.xyz/edit/queries/82ebc37b-5b2e-4f05-9e7d-c14ecd2b3fea
-- forked from hess / Daily Per Label type @ https://flipsidecrypto.xyz/hess/q/8SciMd9-dnaa/daily-per-label-type
with priceTb as (
SELECT
hour as p_date,
symbol,
PRICE as usd_price
FROM aptos.price.ez_prices_hourly
WHERE symbol = 'APT'
-- GROUP by 1,2
)
,
fee as (
select
-- date(c.block_timestamp) as date,
block_timestamp,
gas_used,
(case
when event_address = '0x17f1e926a81639e9557f4e4934df93452945ec30bc962e11351db59eb0d78c33' then 'defi'
when event_address = '0x5ae6789dd2fec1a9ec9cccfb3acaf12e93d432f0a3a42c92fe1a9d490b7bbc06' then 'defi'
when event_address = '0x3c1d4a86594d681ff7e5d5a233965daeabdc6a15fe5672ceeda5260038857183' then 'defi'
when event_address = '0x6f986d146e4a90b828d8c12c14b6f4e003fdff11a8eecceceb63744363eaac01'then 'defi'
when event_address = '0x6b3720cd988adeaf721ed9d4730da4324d52364871a68eac62b46d21e4d2fa99' then 'defi'
when event_address = '0x3c4a58b4a8dffe6d14448072efcdd5a0e0089a22c6837b94f1d7e8bb1552137f'then 'defi'
when event_address = '0xfaf4e633ae9eb31366c9ca24214231760926576c7b625313b3688b5e900731f6' then 'defi'
when event_address = '0x7893a5d6cd60610f2bad22bb29668e596d14245b682d508a0794ce69613bcaab' then 'defi'
when event_address = '0x16fe2df00ea7dde4a63409201f7f4e536bde7bb7335526a35d05111e68aa322c' then 'dex'
when event_address = '0xd1fd99c1944b84d1670a2536417e997864ad12303d19eac725891691b04d614e' then 'nft'
when event_address = '0xfe2ffdb3a74307f7314a1c8ab3762b6b5869a3c1278cdd5d230249453e15a1db' then 'dapp'
when event_address = '0x43d8cad89263e6936921a0adb8d5d49f0e236c229460f01b14dca073114df2b9' then 'bridge'
when event_address = '0x17f1e926a81639e9557f4e4934df93452945ec30bc962e11351db59eb0d78c33' then 'defi'
when event_address = '0x9770fa9c725cbd97eb50b2be5f7416efdfd1f1554beb0750d4dae4c64e860da3' then 'defi'
when event_address = '0x1c3206329806286fd2223647c9f9b130e66baeb6d7224a18c1f642ffe48f3b4c' then 'dex'
when event_address = '0xc0188ad3f42e66b5bd3596e642b8f72749b67d84e6349ce325b27117a9406bdf' then 'defi'
Last run: 25 days ago
...
7687
558KB
290s