0xCd2d8965A1D3cb529B2E4C3AF6C558676e362739BONK 1 copy
Updated 2024-07-12
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 mattkstew / BONK 1 @ https://flipsidecrypto.xyz/mattkstew/q/63769rX0RCBM/bonk-1
/*
Token Comparison: SOL, WIF, PYTH, JUP, JTO, RAY, and MNDE
Compare:
- Price
- Price / Divided BONK (Periods: daily, monthly, weekly)
- Daily Swappers,
- Holders
BONK: DezXAZ8z7PnrnRJjz3wXBoRgixCa6xjnB7YaB1pPB263
*/
WITH daily_avg_prices AS (
SELECT
Date_trunc('day', hour) AS Date,
Symbol AS Token,
AVG(price) AS Price
FROM
solana.price.ez_prices_hourly
WHERE
token_address IN (
'So11111111111111111111111111111111111111112',
'EKpQGSJtjMFqKZ9KQanSqYXRcF8fBopzLHYxdM65zcjm',
'HZ1JovNiVvGrGNiiYvEozEVgZ58xaU3RKwX8eACQBCt3',
'JUPyiwrYJFskUPiHa7hkeR8VUtAeFoSYbKedZNsDvCN',
'jtojtomepa8beP8AuQc6eXt5FriJwfFMwQx2v2f9mCL',
'4k3Dyjzvzp8eMZWUXbBCjEvwSkkk59S5iCNLY3QrkX6R',
'MNDEFzGvMt87ueuHvVU9VcTqsAP5b3fTGPsHuuPA5ey',
'DezXAZ8z7PnrnRJjz3wXBoRgixCa6xjnB7YaB1pPB263'
)
GROUP BY
1, 2
QueryRunArchived: QueryRun has been archived