winnie-fsSwap -Daily 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 / Swap -Daily @ https://flipsidecrypto.xyz/Lordking/q/ufPy2bqFferH/swap--daily
-- 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'),
( '18', 'REF', 'token.v2.ref-finance.near'),
( '24', 'LiNEAR', 'linear-protocol.near'),
( '8', 'LONK', 'token.lonkingnearbackto2024.near'),
( '18', 'DAI', '6b175474e89094c44da98b954eedeac495271d0f.factory.bridge.near'),
( '18', 'Woo', '4691937a7508860f876c9c0a2a617e7d9e945d4b.factory.bridge.near'),
( '6', 'USDT', 'usdt.tether-token.near'),
( '6', 'USDC', '17208628f84f5d6ad33f0da3bbbeb27ffcb398eac501a31bd6ad2011e36133a1'),
QueryRunArchived: QueryRun has been archived