par_rnUntitled Query
Updated 2022-12-23Copy Reference Fork
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
›
⌄
with tb AS( select HOUR,Price from ethereum.core.fact_hourly_token_prices
where TOKEN_ADDRESS='0x45804880de22913dafe09f4980848ece6ecbaf78' order by 1 desc limit 1),
tb2 AS( select HOUR,Price from ethereum.core.fact_hourly_token_prices
where TOKEN_ADDRESS='0x68749665ff8d2d112fa859aa293f07a622782f38' order by 1 desc limit 1)
select
'PAXG' 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='0x45804880de22913dafe09f4980848ece6ecbaf78') join tb
union ALL
select
'XAUT' 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='0x68749665ff8d2d112fa859aa293f07a622782f38') join tb2
Run a query to Download Data