SELECT

response:data:result:token_info:supply / POW(10, response:data:result:token_info:decimals) AS real_supply

FROM (

SELECT

helius_das.get_asset(

'mainnet',

{

'id': 'DezXAZ8z7PnrnRJjz3wXBoRgixCa6xjnB7YaB1pPB263'

}

) AS response

) t

),

asset AS (

SELECT

DATE_TRUNC('hour', block_timestamp) AS recorded_Hour,

MEDIAN(swap_to_amount / swap_from_amount) AS asset_Price

FROM solana.defi.fact_swaps

WHERE

swap_to_mint IN (

'EPjFWdd5AufqSSqeM2qN1xzybapC8G4wEGGkZwyTDt1v',

'Es9vMFrzaCERmJfrF4H2FYD4KCoNkY11McCe8BenwNYB'

)

AND swap_from_mint LIKE '{{Token_Address}}'

AND swap_to_amount > 0

AND swap_from_amount > 0

GROUP BY 1

),

market_data AS (

SELECT

DATE_TRUNC('day', recorded_Hour) AS day,

AVG(asset_Price) AS Price,

AVG(asset_Price) * real_supply AS Market_Cap,

real_supply AS Circulating_Supply

FROM asset, supply_info

GROUP BY 1, real_supply