Analytics eth feeds
From Chainlink Community Wiki
Revision as of 09:19, 20 May 2022 by Admin (talk | contribs) (Created page with "left|thumb == These are example env Variables for your Ethereum Chainlink Node. == <pre style="white-space:pre-wrap; width:100%; border:1px solid lightgrey; background:black; color:white;">#================================================================# # Ethereum Feed Queries # #================================================================# #-----------------------------------------------------...")
These are example env Variables for your Ethereum Chainlink Node.
#================================================================#
# Ethereum Feed Queries #
#================================================================#
#------------------------------------------------------#
# Ethereum Mainnet: Total OCR Feeds #
#------------------------------------------------------#
SELECT COUNT(DISTINCT("to"))
FROM ethereum."transactions"
WHERE
"from" in (
'\xb976d01275b809333e3efd76d1d31fe9264466d0', -- DexTrac
'\xc74cE67BfC623c803D48AFc74a09A6FF6b599003', -- Chainlayer
'\x218B5a7861dBf368D09A84E0dBfF6C6DDbf99DB8', -- Fiews
'\xcC29be4Ca92D4Ecc43C8451fBA94C200B83991f6' -- LinkPool
)
AND
substring("data"::bytea FROM 0 FOR 5)::bytea = '\xc9807539'