Swaps Assets Daily

alitaslimiSwaps Assets Daily

Updated 2023-04-06

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 = '438831' THEN 'MESX'

-- 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

Run a query to Download Data

flipside