par_rnUntitled Query
    Updated 2022-12-23
    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