BLOCK_TIMESTAMP::DATE AS Day,

MEDIAN(FEE / GAS_USED) AS Gas_Price_UATOM

FROM cosmos.core.fact_transactions

WHERE BLOCK_TIMESTAMP >= {{start_date}}

AND FEE_DENOM = 'uatom'

GROUP BY BLOCK_TIMESTAMP::DATE

ORDER BY Day;