MLDZMNYield Guild Games
    Updated 2024-02-23

    with users as (
    select
    date_trunc(day, fst_tx) as date,
    count(distinct sender) as new_users,
    sum(new_users) over( order by date) as cumulative_new_users
    from
    (
    select
    FROM_ADDRESS as sender,
    min(BLOCK_TIMESTAMP) as fst_tx
    from ethereum.core.fact_transactions
    where TO_ADDRESS = lower('0x25f8087EAD173b73D6e8B84329989A8eEA16CF73')
    group by 1
    )
    group by
    1
    ),

    token_price as (
    select
    date_trunc(day, HOUR) as day,
    avg(PRICE) as YGG_price
    from ethereum.price.ez_hourly_token_prices
    where TOKEN_ADDRESS= lower('0x25f8087EAD173b73D6e8B84329989A8eEA16CF73')
    group by 1),

    total_supply AS (
    with ethereum_mints as (
    select
    date_trunc('day', block_timestamp) as date,
    count(distinct tx_hash) as transactions,
    count(distinct to_address) as addresses,
    sum(amount) as volume
    from
    ethereum.core.ez_token_transfers
    QueryRunArchived: QueryRun has been archived