freemartiantotal pools gets from API
Updated 2024-03-22
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
›
⌄
-- all datas comes from imperator.co API
SELECT
'LVN' AS symbol1, 1328460.784525 AS mount1,
'OSMO' AS symbol2, 182148.462921 AS mount2,
554462.865 AS liquidity, 2.731 AS liquidity_24h_change,
84005.434 AS volume_24h, -31.94 AS volume_24h_change,
'LVN-OSMO' AS pool_name
UNION
SELECT
'LVN' AS symbol1, 401202.850376 AS mount1,
'USDC' AS symbol2, 62639.854299 AS mount2,
150376.733 AS liquidity, 39.027 AS liquidity_24h_change,
81724.732 AS volume_24h, -14.55 AS volume_24h_change,
'LVN-USDC' AS pool_name
UNION
SELECT
'LVN' AS symbol1, 182399.434081 AS mount1,
'ATOM' AS symbol2, 4282.742836 AS mount2,
79682.533 AS liquidity, -0.99 AS liquidity_24h_change,
3609.448 AS volume_24h, -63.82 AS volume_24h_change,
'LVN-ATOM' AS pool_name
UNION
SELECT
'LVN' AS symbol1, 11694.031587 AS mount1,
'WOSMO' AS symbol2, 243199.452637 AS mount2,
2561.2341 AS liquidity, 15.883 AS liquidity_24h_change,
481.281 AS volume_24h, 81.166 AS volume_24h_change,
'LVN-WOSMO' AS pool_name
QueryRunArchived: QueryRun has been archived