SELECT

price

FROM crosschain.price.ez_prices_hourly

WHERE symbol = 'AXL'

ORDER BY hour DESC

LIMIT 1

SELECT

b.label AS "Validator Name",

SUM(a.AMOUNT / 1e6) AS "Total Commission Claimed in Axelar",

SUM(a.AMOUNT * cp.price / 1e6) AS "Total Commission Claimed in USD",

a.VALIDATOR_ADDRESS_OPERATOR AS "Validator's Address"

FROM

axelar.gov.fact_validator_commission a

LEFT JOIN axelar.gov.fact_validators b ON a.validator_address_operator = b.address

JOIN CurrentPrice cp ON 1=1

GROUP BY 1, 4

ORDER BY 2 DESC

LIMIT 75;