zackmendelSolana TVL(Defillama) by Meme Launch Dates
Updated 2024-12-23
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
›
⌄
WITH meme_contracts AS (
SELECT
*
FROM $query('87e12d33-a0d7-4584-b4a5-6622b08b5849')
),
min_date AS (
SELECT
contract_address,
symbol,
MIN(block_timestamp) AS min_date
FROM solana.defi.ez_dex_swaps s JOIN meme_contracts m
ON s.swap_to_mint = m.contract_address OR s.swap_from_mint = m.contract_address
GROUP BY 1,2
)
SELECT
-- DISTINCT chain
date,
CASE
WHEN date_trunc(day, date) = date_trunc(day, min_date) THEN 'Meme_launch_day'
ELSE 'Normal_day'
END AS meme_launch_days,
tvl_usd
FROM external.defillama.fact_chain_tvl tvl LEFT JOIN min_date
ON date::date = min_date::date
WHERE chain = 'Solana'
-- AND date::date > '2022-01-01'
QueryRunArchived: QueryRun has been archived