SELECT 'WIF' AS name,

(

(

(

SELECT COALESCE(SUM(MINT_AMOUNT), 0)

FROM eclipse.defi.fact_token_mint_actions

WHERE MINT = '841P4tebEgNux2jaWSjCoi9LhrVr9eHGjLc758Va3RPH'

) - (

SELECT COALESCE(SUM(BURN_AMOUNT), 0)

FROM eclipse.defi.fact_token_burn_actions

WHERE MINT = '841P4tebEgNux2jaWSjCoi9LhrVr9eHGjLc758Va3RPH'

)

) / 1e6

) * (

SELECT PRICE

FROM solana.price.ez_prices_hourly

WHERE TOKEN_ADDRESS = 'EKpQGSJtjMFqKZ9KQanSqYXRcF8fBopzLHYxdM65zcjm'

ORDER BY HOUR DESC

LIMIT 1

) AS amount

),

query2 AS (

SELECT 'USDC' AS name,

(

(

(

SELECT COALESCE(SUM(MINT_AMOUNT), 0)

FROM eclipse.defi.fact_token_mint_actions

WHERE MINT = 'AKEWE7Bgh87GPp171b4cJPSSZfmZwQ3KaqYqXoKLNAEE'

) - (

SELECT COALESCE(SUM(BURN_AMOUNT), 0)

FROM eclipse.defi.fact_token_burn_actions

WHERE MINT = 'AKEWE7Bgh87GPp171b4cJPSSZfmZwQ3KaqYqXoKLNAEE'

)

) / 1e6