MLDZMNYield Guild Games
Updated 2024-02-23
999
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
29
30
31
32
33
34
35
36
›
⌄
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