Query editor
WITH fundamental_metrics AS(SELECTDATE_TRUNC ('day', block_time)"time",COUNT (DISTINCT (signature)) AS daily_transactions,COUNT (DISTINCT (signer)) AS daily_active_users,(AVG(fee / 1e9)) AS average_gas_sol,SUM (fee / 1e9) AS daily_gas_spent_solFROM solana.transactionsWHERE DATE_TRUNC ('day', block_time) > TRY_CAST('2024-12-31' AS TIMESTAMP)AND DATE_TRUNC ('day', block_time) < CURRENT_DATEGROUP BY 1),sol_price AS (SELECTDATE_TRUNC ('day', "minute") "time",AVG(price) AS daily_priceFROM prices.usdWHERE symbol = 'SOL'AND DATE_TRUNC ('day', "minute") > TRY_CAST('2023-12-31' AS TIMESTAMP)AND DATE_TRUNC ('day', "minute") < CURRENT_DATEGROUP BY 1)SELECTf."time",f.daily_transactions,f.daily_active_users,f.average_gas_sol,(f.average_gas_sol * p.daily_price) AS average_gas_usd,f.daily_gas_spent_sol,(f.daily_gas_spent_sol * p.daily_price) AS daily_gas_spent_usdFROM fundamental_metrics fLEFT JOIN sol_price pON f."time" = p."time"ORDER BY "time" DESC