toming1_price_weekly largest price increase copy
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
›
⌄
-- forked from tarikflipside / 1_price_weekly largest price increase @ https://flipsidecrypto.xyz/tarikflipside/q/8Z83Dou8Rhua/1_price_weekly-largest-price-increase
WITH week_price_changes AS (
SELECT
TOKEN_ADDRESS,
TOKEN_NAME,
SYMBOL,
RECORDED_HOUR,
CLOSE,
LAG(CLOSE, 168) OVER (PARTITION BY TOKEN_ADDRESS ORDER BY RECORDED_HOUR) AS previous_price,
100 * (CLOSE - LAG(CLOSE, 168) OVER (PARTITION BY TOKEN_ADDRESS ORDER BY RECORDED_HOUR)) / NULLIF(LAG(CLOSE, 168) OVER (PARTITION BY TOKEN_ADDRESS ORDER BY RECORDED_HOUR), 0) AS percentage_change
FROM
solana.price.ez_token_prices_hourly
where recorded_hour >= DATEADD('day', -8, CURRENT_DATE())
)
-- select * from daily_price_changes where token_address = 'SLT3iSYKeBuCyxvnfij4RUhMfKxZCY3s12Z5pfkTXhV';
,
latest_week_price_changes AS (
SELECT *
FROM week_price_changes
WHERE RECORDED_HOUR = (SELECT MAX(RECORDED_HOUR) FROM week_price_changes)
),
total_volume_last_week AS (
SELECT
token_out AS TOKEN_ADDRESS,
SUM(amount_in_usd) AS total_volume_usd
FROM
crosschain.defi.ez_dex_swaps
WHERE
BLOCK_TIMESTAMP >= DATEADD('hour', -168, CURRENT_TIMESTAMP())
and blockchain = 'solana'
and token_in in ('so11111111111111111111111111111111111111112',
'epjfwdd5aufqssqem2qn1xzybapc8g4weggkzwytdt1v',
'msolzycxhdygdzu16g5qsh3i5k3z3kzk7ytfqcjm7so',
'7dhbwxmci3dt8ufywyzweblxgycu7y3il6trkn1y7arj',
Run a query to Download Data