TIMESTAMP | TVL_USD | FEES_USD | |
|---|---|---|---|
1 | 2025-04-10 00:00:00.000 | 5.326304 | 0.005326304 |
2 | 2025-04-08 00:00:00.000 | 1.409904 | 0.001409904 |
3 | 2025-04-07 00:00:00.000 | 25.84824 | 0.02584824 |
4 | 2025-04-06 00:00:00.000 | 22.71512 | 0.02271512 |
5 | 2025-04-05 00:00:00.000 | 1645.357968 | 1.645357968 |
6 | 2025-04-03 00:00:00.000 | 66.5788 | 0.0665788 |
7 | 2025-04-02 00:00:00.000 | 11.122576 | 0.011122576 |
8 | 2025-03-30 00:00:00.000 | 4.229712 | 0.004229712 |
9 | 2025-03-23 00:00:00.000 | 6.422896 | 0.006422896 |
10 | 2025-03-21 00:00:00.000 | 0.469968 | 0.000469968 |
11 | 2025-03-14 00:00:00.000 | 0.00156656 | 0.00000156656 |
12 | 2025-03-10 00:00:00.000 | 15.6656 | 0.0156656 |
13 | 2025-03-04 00:00:00.000 | 31.3312 | 0.0313312 |
14 | 2025-03-03 00:00:00.000 | 30953.14677488 | 30.953146775 |
15 | 2025-02-16 00:00:00.000 | 77.388064 | 0.077388064 |
16 | 2025-02-15 00:00:00.000 | 24.28168 | 0.02428168 |
17 | 2025-02-14 00:00:00.000 | 30292.88716512 | 30.292887165 |
18 | 2025-02-11 00:00:00.000 | 11854.334144194 | 11.854334144 |
19 | 2025-02-06 00:00:00.000 | 32.89776 | 0.03289776 |
20 | 2025-02-03 00:00:00.000 | 23264.98256 | 23.26498256 |
zakkisyedTVL, Fees [Protocol Level]
Updated 2025-04-11
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 daily_TVL AS (
SELECT
DATE_TRUNC('day', block_timestamp) AS day,
SUM(raw_amount) / 1e18 AS total_value_locked
FROM
arbitrum.core.fact_token_transfers
WHERE
to_address = LOWER('0x376A7564AF88242D6B8598A5cfdD2E9759711B61')
GROUP BY
1
),
latest_eth_price AS (
SELECT
price AS eth_price
FROM
arbitrum.price.ez_prices_hourly
WHERE
symbol = 'WETH'
ORDER BY
hour DESC
LIMIT
1
)
-- Protocol fees configured on the contract is 0.1% from 22nd April 2024
SELECT
d.day AS timestamp,
d.total_value_locked * p.eth_price AS tvl_usd,
CASE
WHEN d.day >= '2024-04-22' THEN d.total_value_locked * p.eth_price * 0.001
ELSE 0
END AS fees_usd
FROM
daily_TVL d
CROSS JOIN latest_eth_price p
WHERE
timestamp >= '{{timestamp}}'
Last run: 17 days agoAuto-refreshes every 1 hour
...
166
8KB
245s