Timestamp | Total TVL in USD | Total TVL in KAIA | Average TVL in USD | Average TVL in KAIA | Total TVL Growth in USD (%) | Total TVL Growth in KAIA (%) | Average TVL Growth in USD (%) | Average TVL Growth in KAIA (%) | |
|---|---|---|---|---|---|---|---|---|---|
1 | After Mainnet Launch | 21515668241 | 127339003058.39 | 120199263.916201 | 711391078.538489 | 37.9 | 55.7 | 37.13 | 54.83 |
2 | Before Mainnet Launch | 15601963946 | 81782787362.4398 | 87651482.842697 | 459453861.586741 |
Sajjadiii2.Comparative For TVL
Updated 2025-02-23
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_ranges AS (
-- Calculate the number of days between 2024-08-29 and today
SELECT
CURRENT_DATE AS today,
CAST('2024-08-29' AS DATE) AS mainnet_launch_date,
DATEDIFF(DAY, CAST('2024-08-29' AS DATE), CURRENT_DATE) AS days_since_launch,
DATEADD(DAY, -DATEDIFF(DAY, CAST('2024-08-29' AS DATE), CURRENT_DATE), CAST('2024-08-29' AS DATE)) AS comparison_start_date -- Balanced pre-launch period
),
price_tab AS (
-- Fetch token price data
SELECT
hour::date AS date,
'WKLAY' AS symbol,
'0x57d1a61e4fd09fbf16e35b04959e94dcf2032974' AS token_address,
AVG(price) AS token_price
FROM
kaia.price.ez_prices_hourly
WHERE
symbol = 'KLAY'
AND hour::date >= current_date - interval '1 year'
GROUP BY 1, 2, 3
),
categorized_tvl AS (
-- Join TVL data with price data and categorize by launch date
SELECT
a.date AS "Date",
TVL_USD AS "Tvl In $USD",
TVL_USD / b.token_price AS "TVL In $KAIA",
CASE
WHEN a.date < '2024-08-29'
AND a.date >= (SELECT comparison_start_date FROM date_ranges) THEN 'Before Mainnet Launch'
WHEN a.date >= '2024-08-29' THEN 'After Mainnet Launch'
ELSE NULL
END AS "Timestamp"
FROM
external.defillama.fact_chain_tvl a
Last run: about 1 month ago
2
218B
3s