SELECT

date_trunc('day', BLOCK_TIMESTAMP) AS "Day",

MEDIAN (ATTACHED_GAS / 1e12) as "Gas Limit",

MEDIAN (GAS_USED / 1e12) as "Gas Used"

FROM flipside_prod_db.mdao_near.transactions

where block_timestamp::date > current_date - 90

GROUP BY 1;