Analytics eth feeds

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'