Eman-Raz30d % Price Change
Updated 2023-08-06
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
›
⌄
----------------------------------------PEPE----------------------------------------------------
with pepe as (with tab1 as (select AVG(price) as pre_month_PRICE
from ethereum.core.fact_hourly_token_prices
where token_address=lower('0x6982508145454ce325ddbe47a25d4ec3d2311933')
AND HOUR::DATE=CURRENT_DATE-30),
tab2 as (select price as current_price
from ethereum.core.fact_hourly_token_prices
where token_address=lower('0x6982508145454ce325ddbe47a25d4ec3d2311933')
order by hour DESC
limit 1)
select ((current_price-pre_month_PRICE)/pre_month_PRICE)*100 as "%Price Change", 'PEPE' as "Memecoin"
from tab1 , tab2),
----------------------------------------SHIB---------------------------------------------------
shib as (with tab1 as (select AVG(price) as pre_month_PRICE
from ethereum.core.fact_hourly_token_prices
where token_address=lower('0x95ad61b0a150d79219dcf64e1e6cc01f0b64c4ce')
AND HOUR::DATE=CURRENT_DATE-30),
tab2 as (select price as current_price
from ethereum.core.fact_hourly_token_prices
where token_address=lower('0x95ad61b0a150d79219dcf64e1e6cc01f0b64c4ce')
order by hour DESC
limit 1)
select ((current_price-pre_month_PRICE)/pre_month_PRICE)*100 as "%Price Change", 'SHIB' as "Memecoin"
from tab1 , tab2),
----------------------------------------CHAD-----------------------------------------------------
chad as (with tab1 as (select AVG(price) as pre_month_PRICE
from ethereum.core.fact_hourly_token_prices
where token_address=lower('0x6B89B97169a797d94F057F4a0B01E2cA303155e4')
AND HOUR::DATE=CURRENT_DATE-30),
tab2 as (select price as current_price
from ethereum.core.fact_hourly_token_prices
where token_address=lower('0x6B89B97169a797d94F057F4a0B01E2cA303155e4')
Run a query to Download Data