Abbas_ra21meme trading Price
Updated 2023-05-15
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 price_data AS (
SELECT
HOUR AS timestamp,
SYMBOL,
PRice
FROM ethereum.core.fact_hourly_token_prices
WHERE
TOKEN_ADDRESS IN (
'0x95ad61b0a150d79219dcf64e1e6cc01f0b64c4ce',
'0x6982508145454ce325ddbe47a25d4ec3d2311933',
'0x761d38e5ddf6ccf6cf7c55759d5210750b5d60f3',
'0x12970e6868f88f6557b76120662c1b3e50a646bf',
'0xa35923162c49cf95e6bf26623385eb431ad920d3',
'0x5026f006b85729a8b14553fae6af249ad16c9aab',
'0x7d8146cf21e8d7cbe46054e01588207b51198729',
'0x6b89b97169a797d94f057f4a0b01e2ca303155e4'
)
AND HOUR >= dateadd('month', -1, current_date)
UNION ALL
SELECT
RECORDED_HOUR,
SYMBOL,
Close AS Price
FROM
solana.core.fact_token_prices_hourly
WHERE SYMBOL = 'BONK'
AND RECORDED_HOUR >= dateadd('month', -1, current_date)
)
SELECT
timestamp,
SYMBOL,
Price,
((Price / FIRST_VALUE(Price) OVER (PARTITION BY SYMBOL ORDER BY timestamp)) - 1) * 100 AS price_change_percentage
FROM price_data
ORDER BY
SYMBOL,
Run a query to Download Data