DATE_TRUNC('hour', BLOCK_TIMESTAMP) AS "Hour",

COUNT(DISTINCT ORIGIN_FROM_ADDRESS) AS "Unique Staking Users",

COUNT(DISTINCT TX_HASH) AS "Staking Transactions",

SUM(CAST(livequery.utils.udf_hex_to_int(DATA::string) AS DECIMAL)) / 1e18 AS "Total Amount Staked"

avalanche.core.fact_event_logs

TOPIC_0 = LOWER('0x9e71bc8eea02a63969f509818f2dafb9254532904319f9dbda79b67bd34a5f3d')

AND CONTRACT_ADDRESS = LOWER('0x0f465a2b46cad4ac53e83d7a766be47f9ea18190')

GROUP BY

1

ORDER BY

1 ASC;