date_trunc(hour, block_timestamp) AS hour,

AVG(avax_value/(tokenflow_eth.hextoint(SUBSTRING(input_data, 74, 137)))) AS GLP_price

FROM avalanche.core.fact_transactions

WHERE origin_function_signature = '0x53a8aa03'

AND block_timestamp > CURRENT_DATE() - interval '3 months'

GROUP BY 1

ORDER BY 1