alitaslimiBlockchain Top To Assets Overview
    Updated 2022-12-08
    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