Yousefi_1994[Main] Colend - Main BTC Market Stats
Updated 2024-11-16
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
›
⌄
--------------------------------------- Assets ---------------------------------------
WITH CORE_ASSETS_LIST AS (
SELECT
ADDRESS,
NAME::STRING AS NAME,
SYMBOL::STRING AS SYMBOL,
DECIMALS
FROM
core.core.dim_contracts
WHERE
SYMBOL IS NOT NULL
AND DECIMALS IS NOT NULL
),
--------------------------------------- Prices ---------------------------------------
ALL_ASSET_PRICE_FROM_API AS (
SELECT
*,
RANK() OVER (PARTITION BY SYMBOL ORDER BY DATE DESC) AS PRICE_RANK
FROM
$query('e2e36f29-5f36-4b16-a3b1-5ec4517d6d46')
),
ALL_ASSET_CURRENT_PRICE AS (
SELECT
SYMBOL,
PRICE_USD
FROM
ALL_ASSET_PRICE_FROM_API
WHERE
PRICE_RANK = 1
),
--------------------------------------- Initialized Pools ---------------------------------------
QueryRunArchived: QueryRun has been archived