Arkanntoken 1
Updated 2023-01-21
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
›
⌄
WITH
table1 as (
SELECT
HOUR,
Price
FROM
ethereum.core.fact_hourly_token_prices
WHERE TOKEN_ADDRESS= LOWER('0x92D6C1e31e14520e676a687F0a93788B716BEff5')
ORDER BY 1 desc
LIMIT 1
)
SELECT
'DYDX' as symbol,
"supply",
"Holders number",
"supply"* Price AS "Market Cap"
FROM (select
sum(CURRENT_BAL) AS "supply",
count(distinct USER_ADDRESS) AS "Holders number"
FROM
ethereum.core.ez_current_balances
WHERE CONTRACT_ADDRESS= LOWER('0x92D6C1e31e14520e676a687F0a93788B716BEff5')) join table1
Run a query to Download Data