Analytics eth feeds

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'