FIRST_DAY | LAST_DAY | INITIAL_PRICE | FINAL_PRICE | PRICE_CHANGE_PERCENTAGE | INITIAL_HOLDERS | FINAL_HOLDERS | HOLDERS_CHANGE_PERCENTAGE | INITIAL_DAILY_VOLUME | FINAL_DAILY_VOLUME | VOLUME_CHANGE_PERCENTAGE | |
|---|---|---|---|---|---|---|---|---|---|---|---|
1 | 2025-03-28 00:00:00.000 | 2025-04-02 00:00:00.000 | 0.005228598333 | 0.029349891 | 461.33 | 6171 | 6291 | 1.94 | 5406727.01 | 5417033.08 | 0.19 |
defi__josh% changes in the last 5 days
Updated 2025-04-02
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_metrics AS (
-- Get trading volume and unique traders
SELECT
DATE_TRUNC('day', block_timestamp) as date,
SUM(CASE
WHEN swap_from_mint = 'FtUEW73K6vEYHfbkfpdBZfWpxgQar2HipGdbutEhpump' THEN swap_from_amount_usd
WHEN swap_to_mint = 'FtUEW73K6vEYHfbkfpdBZfWpxgQar2HipGdbutEhpump' THEN swap_to_amount_usd
END) as daily_volume_usd,
COUNT(DISTINCT swapper) as daily_traders
FROM solana.defi.ez_dex_swaps
WHERE block_timestamp >= DATEADD('day', -5, CURRENT_DATE)
AND (swap_from_mint = 'FtUEW73K6vEYHfbkfpdBZfWpxgQar2HipGdbutEhpump'
OR swap_to_mint = 'FtUEW73K6vEYHfbkfpdBZfWpxgQar2HipGdbutEhpump')
GROUP BY 1
),
daily_prices AS (
-- Get daily average prices
SELECT
DATE_TRUNC('day', hour) as date,
AVG(price) as avg_daily_price
FROM solana.price.ez_prices_hourly
WHERE token_address = 'FtUEW73K6vEYHfbkfpdBZfWpxgQar2HipGdbutEhpump'
AND hour >= DATEADD('day', -5, CURRENT_DATE)
GROUP BY 1
),
daily_holders AS (
-- Get daily unique token holders
SELECT
DATE_TRUNC('day', block_timestamp) as date,
COUNT(DISTINCT owner) as holder_count
FROM solana.core.fact_token_balances
WHERE mint = 'FtUEW73K6vEYHfbkfpdBZfWpxgQar2HipGdbutEhpump'
AND balance > 0
AND block_timestamp >= DATEADD('day', -5, CURRENT_DATE)
GROUP BY 1
),
Last run: 25 days ago
1
131B
10s