alitaslimiBlockchain Top To Assets Overview
Updated 2022-12-08
9999
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
›
⌄
WITH
-------------------------------------------------- Algorand --------------------------------------------------
prices_algorand AS (
SELECT
block_hour::date AS day,
TO_VARCHAR(asset_id) AS token_contract,
CASE
WHEN asset_id = '511484048' THEN 'STKE'
WHEN asset_id = '297995609' THEN 'Choice'
WHEN asset_id = '571576867' THEN 'COSG'
WHEN asset_id = '470842789' THEN 'DEFLY'
WHEN asset_id = '684649988' THEN 'GARD'
WHEN asset_id = '793124631' THEN 'gALGO'
WHEN asset_id = '694432641' THEN 'gALGO3'
WHEN asset_id = '694474015' THEN 'fgALGO3'
WHEN asset_id = '287867876' THEN 'OPUL'
WHEN asset_id = '2757561' THEN 'rUSD'
WHEN asset_id = '465865291' THEN 'STBL'
WHEN asset_id = '31566704' THEN 'USDC'
WHEN asset_id = '312769' THEN 'USDT'
WHEN asset_id = '283820866' THEN 'XET'
ELSE asset_name
END AS symbol,
CASE
WHEN symbol = 'ALGO' THEN 'Native Coin'
WHEN symbol IN ('USDC', 'USDT', 'STBL', 'GARD', 'rUSD') THEN 'Stablecoins'
ELSE 'Other Tokens'
END AS token_type,
AVG(price_usd) AS price
FROM (
SELECT
block_hour,
asset_id,
asset_name,
price_usd
FROM
Run a query to Download Data