MONTH_DATE | BLOCKCHAIN | TX_TYPE | TX_COUNT | FEE_AMOUNT_USD | |
|---|---|---|---|---|---|
1 | 2025-05-01 00:00:00.000 | arbitrum | redeem | 7 | 67.788268677 |
2 | 2025-05-01 00:00:00.000 | arbitrum | trade | 11932 | 30252.614692259 |
3 | 2025-05-01 00:00:00.000 | polygon | redeem | 13 | 25.096887564 |
4 | 2025-05-01 00:00:00.000 | polygon | trade | 2940 | 39457.644188699 |
5 | 2025-04-01 00:00:00.000 | arbitrum | redeem | 18 | 269.846355078 |
6 | 2025-04-01 00:00:00.000 | arbitrum | trade | 5346 | 15654.237327324 |
7 | 2025-04-01 00:00:00.000 | polygon | redeem | 7 | 146.493745833 |
8 | 2025-04-01 00:00:00.000 | polygon | trade | 1662 | 6280.768981113 |
9 | 2025-03-01 00:00:00.000 | arbitrum | redeem | 10 | 50.462408672 |
10 | 2025-03-01 00:00:00.000 | arbitrum | trade | 2838 | 2138.629109672 |
11 | 2025-03-01 00:00:00.000 | polygon | trade | 2173 | 3015.47358626 |
12 | 2025-02-01 00:00:00.000 | arbitrum | redeem | 8 | 69.471396685 |
13 | 2025-02-01 00:00:00.000 | arbitrum | trade | 5984 | 7080.807494142 |
14 | 2025-02-01 00:00:00.000 | polygon | redeem | 9 | 15.761451297 |
15 | 2025-02-01 00:00:00.000 | polygon | trade | 4250 | 10218.996168538 |
lockon-financeIndex contract fee
Updated 6 hours 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 trade_fees_polygon as (
select
'polygon' as blockchain,
'trade' as tx_type,
log.tx_hash,
log.block_timestamp,
log.decoded_log:_setToken as index_token_address,
log.decoded_log:_receiveToken as token_address,
log.decoded_log:_protocolFee as amount
from
polygon.core.ez_decoded_event_logs log
where
log.block_timestamp >= date_trunc('month', CURRENT_TIMESTAMP) - interval '3 month'
and log.tx_succeeded = true
and log.event_name = 'ComponentExchanged'
and log.contract_address in ('0x6cc11e2de10f7539bfd38b49549957a9081c3b01') -- TradeModule
),
trade_fees_arbitrum as (
select
'arbitrum' as blockchain,
'trade' as tx_type,
log.tx_hash,
log.block_timestamp,
log.decoded_log:_setToken as index_token_address,
log.decoded_log:_receiveToken as token_address,
log.decoded_log:_protocolFee as amount
from
arbitrum.core.ez_decoded_event_logs log
where
log.block_timestamp >= date_trunc('month', CURRENT_TIMESTAMP) - interval '3 month'
and log.tx_succeeded = true
and log.event_name = 'ComponentExchanged'
and log.contract_address in ('0x4951133b9429ac86ea894b428ff6409b08a026a6') -- TradeModule
),
redeem_fees_polygon as (
select
Last run: about 6 hours agoAuto-refreshes every 12 hours
15
980B
48s