winnie-fsPrice & other daily parameters copy
Updated 2024-10-25
999
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 Lordking / Price & other daily parameters @ https://flipsidecrypto.xyz/Lordking/q/MirHDO_0kVC2/price-other-daily-parameters
-- forked from Price & other daily parameters @ https://flipsidecrypto.xyz/studio/queries/8324416c-4452-40b4-b19d-778286949067
-- hint:
-- to use this query for other tokens, you should notice to two major points:
-- 1- just replace (token contract) address with existing one.
-- 2- take a look at (round) functions and be careful about them
-- 3- somewhere, the lable of tokens like (Neko) were used. please kindly change the symbol
-- pool_id
with token_bonk as (
select
*
from
(
values
('24', 'Neko', 'ftv2.nekotoken.near'),
(
'6',
'USDC.e',
'a0b86991c6218b36c1d19d4a2e9eb0ce3606eb48.factory.bridge.near'
),
('24', 'wNEAR', 'wrap.near'),
('8', 'USMeme', 'usmeme.tg'),
('8', 'MEPT', 'pre.meteor-token.near'),
('8', 'NEARVIDIA', 'nearnvidia.near'),
(
'18',
'UWON ',
'438e48ed4ce6beecf503d43b9dbd3c30d516e7fd.factory.bridge.near'
),
(
'6',
'USDT.e',
'dac17f958d2ee523a2206206994597c13d831ec7.factory.bridge.near'
),
('24', 'blackdragon', 'blackdragon.tkn.near'),
QueryRunArchived: QueryRun has been archived