MLDZMNGreed supply
Updated 2025-01-28
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
29
30
31
32
33
34
35
36
›
⌄
with data_time as (
select
DATE_DAY as day
from ethereum.core.dim_dates
where DATE_DAY>= '2024-06-11'
and DATE_DAY < current_date),
mint as (select
BLOCK_TIMESTAMP::date as day,
'Mint' as action,
zeroifnull(sum(RAW_AMOUNT/1e18)) as mint_vol,
sum(mint_vol) over (order by day) as Total_mint
from blast.core.fact_token_transfers
where CONTRACT_ADDRESS = '0xe6a062fba3918376500a602c800b1e0307420457'
--and SYMBOL = 'GREED'
and FROM_ADDRESS = '0x0000000000000000000000000000000000000000'
and TO_ADDRESS != '0x0000000000000000000000000000000000000000'
group by 1
),
spend as (select
BLOCK_TIMESTAMP::date as day,
'Spend' as action,
zeroifnull(sum(RAW_AMOUNT/1e18)) as burn_vol,
sum(burn_vol) over (order by day) as Total_burn
from blast.core.fact_token_transfers
where CONTRACT_ADDRESS = '0xe6a062fba3918376500a602c800b1e0307420457'
--and SYMBOL = 'GREED'
and TO_ADDRESS = '0x0000000000000000000000000000000000000000'
and FROM_ADDRESS != '0x0000000000000000000000000000000000000000'
group by 1
),
final as (select
d.day as date,
zeroifnull(mint_vol) as "Daily mint",
Auto-refreshes every 12 hours
QueryRunArchived: QueryRun has been archived