Analytics eth feeds: Difference between revisions
From Chainlink Community Wiki
(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 # #================================================================# #-----------------------------------------------------...") |
No edit summary |
||
| Line 1: | Line 1: | ||
[[File:EthereumLogo.png|left|thumb]] | [[File:EthereumLogo.png|left|thumb|100x100px]] | ||
== These are example env Variables for your Ethereum Chainlink Node. == | == These are example env Variables for your Ethereum Chainlink Node. == | ||
Revision as of 09:20, 20 May 2022
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'