Analytics eth feeds: Difference between revisions
From Chainlink Community Wiki
No edit summary |
|||
| Line 5: | Line 5: | ||
<pre style="white-space:pre-wrap; width:100%; border:1px solid lightgrey; background:black; color:white;">#================================================================# | <pre style="white-space:pre-wrap; width:100%; border:1px solid lightgrey; background:black; color:white;">#================================================================# | ||
''' | |||
# Ethereum OCR Feed Queries # | # Ethereum OCR Feed Queries # | ||
#================================================================# | #================================================================# | ||
''' | |||
''' | |||
#-------------------------------------------------------# | #-------------------------------------------------------# | ||
# Ethereum Mainnet: Total OCR Feeds (counter) # | # Ethereum Mainnet: Total OCR Feeds (counter) # | ||
#-------------------------------------------------------# | #-------------------------------------------------------# | ||
''' | |||
<pre style="white-space:pre-wrap; width:100%; border:1px solid lightgrey; background:black; color:yellow;"> | <pre style="white-space:pre-wrap; width:100%; border:1px solid lightgrey; background:black; color:yellow;"> | ||
Revision as of 09:25, 20 May 2022
These are queries to retrieve on-chain stats about Ethereum OCR feeds and node operator transmissions.
#================================================================#
# Ethereum OCR Feed Queries #
#================================================================#
#-------------------------------------------------------#
# Ethereum Mainnet: Total OCR Feeds (counter) #
#-------------------------------------------------------#
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'