DAY | TOTAL_FEES | CUMULATIVE_FEES | VOLUME | NUMBER_OF_TRANSACTIONS | OWNERSHIP_RATIO | PROTOCOL_EARNED_FEES | EXTERNAL_EARNED_FEES | CUMULATIVE_PROTOCOL_EARNED_FEES | CUMULATIVE_EXTERNAL_FEES | |
|---|---|---|---|---|---|---|---|---|---|---|
1 | 2025-06-19 00:00:00.000 | 0 | 28882.4 | 0 | 0 | 0.9146118096 | 0 | 0 | 26416.184129631 | 2466.215870369 |
2 | 2025-06-18 00:00:00.000 | 6.61 | 28882.4 | 2203.47 | 78 | 0.9146118096 | 6.045584061 | 0.5644159385 | 26416.184129631 | 2466.215870369 |
3 | 2025-06-17 00:00:00.000 | 14.06 | 28875.79 | 4686.33 | 97 | 0.9146118096 | 12.859442043 | 1.200557957 | 26410.138545569 | 2465.651454431 |
4 | 2025-06-16 00:00:00.000 | 10.69 | 28861.73 | 3562.93 | 88 | 0.9146118096 | 9.777200245 | 0.9127997554 | 26397.279103526 | 2464.450896474 |
5 | 2025-06-15 00:00:00.000 | 10.54 | 28851.04 | 3514.04 | 81 | 0.9146118096 | 9.640008473 | 0.8999915268 | 26387.501903282 | 2463.538096718 |
6 | 2025-06-14 00:00:00.000 | 25.18 | 28840.5 | 8393.67 | 113 | 0.9146118096 | 23.029925366 | 2.150074634 | 26377.861894809 | 2462.638105191 |
7 | 2025-06-13 00:00:00.000 | 22.47 | 28815.32 | 7488.54 | 138 | 0.9146118096 | 20.551327362 | 1.918672638 | 26354.831969443 | 2460.488030557 |
8 | 2025-06-12 00:00:00.000 | 22.96 | 28792.85 | 7652.59 | 85 | 0.9146118096 | 20.999487148 | 1.960512852 | 26334.280642081 | 2458.569357919 |
9 | 2025-06-11 00:00:00.000 | 8.16 | 28769.89 | 2718.91 | 71 | 0.9146118096 | 7.463232366 | 0.6967676337 | 26313.281154933 | 2456.608845067 |
10 | 2025-06-10 00:00:00.000 | 48.12 | 28761.73 | 16040.11 | 105 | 0.9146118096 | 44.011120278 | 4.108879722 | 26305.817922566 | 2455.912077434 |
11 | 2025-06-09 00:00:00.000 | 20.58 | 28713.61 | 6858.99 | 95 | 0.9146118096 | 18.822711042 | 1.757288958 | 26261.806802288 | 2451.803197712 |
12 | 2025-06-08 00:00:00.000 | 8.18 | 28693.03 | 2727.96 | 22 | 0.9146118096 | 7.481524603 | 0.6984753975 | 26242.984091247 | 2450.045908753 |
13 | 2025-06-07 00:00:00.000 | 8.74 | 28684.85 | 2911.87 | 39 | 0.9146118096 | 7.993707216 | 0.7462927841 | 26235.502566644 | 2449.347433356 |
14 | 2025-06-06 00:00:00.000 | 10.22 | 28676.11 | 3406.7 | 84 | 0.9146118096 | 9.347332694 | 0.8726673059 | 26227.508859428 | 2448.601140572 |
15 | 2025-06-05 00:00:00.000 | 28.56 | 28665.89 | 9520.14 | 94 | 0.9146118096 | 26.121313282 | 2.438686718 | 26218.161526734 | 2447.728473266 |
16 | 2025-06-04 00:00:00.000 | 4.53 | 28637.33 | 1511.07 | 48 | 0.9146118096 | 4.143191497 | 0.3868085025 | 26192.040213452 | 2445.289786548 |
17 | 2025-06-03 00:00:00.000 | 5.67 | 28632.8 | 1889.38 | 63 | 0.9146118096 | 5.18584896 | 0.4841510396 | 26187.897021954 | 2444.902978046 |
18 | 2025-06-02 00:00:00.000 | 6.29 | 28627.13 | 2097.86 | 82 | 0.9146118096 | 5.752908282 | 0.5370917176 | 26182.711172994 | 2444.418827006 |
19 | 2025-06-01 00:00:00.000 | 6.63 | 28620.84 | 2209.01 | 80 | 0.9146118096 | 6.063876298 | 0.5661237023 | 26176.958264712 | 2443.881735288 |
20 | 2025-05-31 00:00:00.000 | 10.38 | 28614.21 | 3460.58 | 42 | 0.9146118096 | 9.493670584 | 0.8863294163 | 26170.894388414 | 2443.315611586 |
MLDZMNbase- fee
Updated 32 seconds ago
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 date_initial as (
select
DATE_DAY as day,
from crosschain.core.dim_dates
where day>= '2024-03-28'
and day <= current_date
),
amount_in_lp as (
select
date_trunc('day', BLOCK_TIMESTAMP) as dt,
sum(RAW_AMOUNT)/1e18 as amount_lp
from base.core.ez_token_transfers
where contract_address = lower('0x5332584890D6E415a6dc910254d6430b8aaB7E69')
and FROM_ADDRESS = '0x0000000000000000000000000000000000000000'
and TO_ADDRESS != '0x0000000000000000000000000000000000000000'
group by 1),
amount_out_lp as (
select date_trunc('day',BLOCK_TIMESTAMP) as dt,
-1*(sum(RAW_AMOUNT)/1e18)as amount_lp
from base.core.ez_token_transfers
where
contract_address = lower('0x5332584890D6E415a6dc910254d6430b8aaB7E69')
and FROM_ADDRESS != '0x0000000000000000000000000000000000000000'
and TO_ADDRESS = '0x0000000000000000000000000000000000000000'
group by 1),
daily_liquidity as (
select * from amount_in_lp
union all
select * from amount_out_lp
),
total_supply as (
select
Last run: 1 minute agoAuto-refreshes every 12 hours
...
449
51KB
430s