SELECT

SUM(COALESCE(tf.total_fee_sol, 0)) AS total_fees_sol

FROM

solana.nft.fact_nft_sales s

LEFT JOIN (

SELECT

tx_id,

SUM(fee) / POWER(10, 9) AS total_fee_sol

FROM

solana.core.fact_transactions

WHERE

block_timestamp BETWEEN '2024-09-01' AND '2024-09-30'

GROUP BY

tx_id

) tf ON s.tx_id = tf.tx_id

WHERE

s.block_timestamp BETWEEN '2024-09-01' AND '2024-09-30'

),

sol_price AS (

SELECT

PERCENTILE_CONT(0.5) WITHIN GROUP (ORDER BY price) AS median_price

FROM

solana.price.ez_prices_hourly

WHERE

hour BETWEEN '2024-08-31 00:00:00' AND '2024-09-30 23:59:59'

AND

token_address = 'So11111111111111111111111111111111111111112'

SELECT

tf.total_fees_sol,

p.median_price,

(tf.total_fees_sol * p.median_price) AS total_fees_usd

FROM