post
https://api.zettablock.com/api/v1/dataset/sq_61fe621f471b4e2c80670e19cd95c241/graphql
Get the Ethereum token price since 2022, denominated in the blockchain's native token and USD.
Recent Requests
Log in to see full request history
| Time | Status | User Agent | |
|---|---|---|---|
Retrieving recent requests… | |||
Loading…
API detailed page: [link]
Transformation Logic:
SELECT
p.name,
p.symbol,
p.slug,
p.ethereum_token_address,
p.price,
p.minute,
t.decimals,
p.data_creation_date
FROM
prices.usd p
-- only keep the verified Ethereum tokens
INNER join ethereum_mainnet.ethereum_erc20_tokens t
ON LOWER(p.ethereum_token_address) = LOWER(t.contract_address)
WHERE
data_creation_date >= date('2022-01-01')