mucryptoEthereum, active wallets
    Updated 2023-03-06
    with ethereum as (select
    date_trunc('day', block_timestamp) as day,
    count(distinct from_address) as "ACTIVE WALLETS"
    from ethereum.core.fact_transactions
    where block_timestamp::date between '2022-05-04' and '2022-05-15'
    and to_address is not null
    group by 1),
    luna as (select
    date(hour) as "Day",
    avg(price) as "AVERAGE LUNA PRICE, USD"
    from ethereum.core.fact_hourly_token_prices
    where "Day" between '2022-05-04' and '2022-05-15'
    and symbol = 'LUNA'
    group by 1)

    select ethereum."ACTIVE WALLETS", luna."AVERAGE LUNA PRICE, USD", luna."Day"
    from ethereum
    join luna
    on ethereum.day=luna."Day"
    Run a query to Download Data