-- this is using our solana tables so the tagging algo knows this is a solana dashboard

SELECT MAX(block_timestamp) AS refresh_time

FROM solana.core.fact_transactions

), t0 AS (

-- lifinity

SELECT livequery.live.udf_api(

'https://api.flipsidecrypto.com/api/v2/queries/768b662d-a670-4abd-882c-56cbeaee5e52/data/latest'

):data AS data

UNION

-- liquid staking

SELECT livequery.live.udf_api(

'https://api.flipsidecrypto.com/api/v2/queries/6cd8a4ab-ccdc-4f7d-b467-d1f02282fd13/data/latest'

):data AS data

UNION

-- orca

SELECT livequery.live.udf_api(

'https://api.flipsidecrypto.com/api/v2/queries/5aa2ecc3-f5b7-4c89-afd1-56c1e2cf57b0/data/latest'

):data AS data

UNION

-- raydium

SELECT livequery.live.udf_api(

'https://api.flipsidecrypto.com/api/v2/queries/93314867-9e07-4bac-a11b-182f7d8c5821/data/latest'

):data AS data

UNION

-- general

SELECT livequery.live.udf_api(

'https://api.flipsidecrypto.com/api/v2/queries/fb4974b6-6780-406a-905a-94e645c8c5d2/data/latest'

):data AS data

SELECT d.value:PROJECT AS project

, CASE WHEN d.value:PROJECT = 'Orca' THEN 'DeFi'

WHEN d.value:PROJECT = 'Raydium' THEN 'DeFi'

WHEN d.value:PROJECT = 'DCF' THEN 'Game'

WHEN d.value:PROJECT = 'Magic Eden' THEN 'NFT Marketplace'

WHEN d.value:PROJECT = 'Lifinity' THEN 'DeFi'