Hashed[fantasy.top] Minted
Updated 2024-10-21
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
›
⌄
with minted_hour as (
select
date_trunc('hour', block_timestamp) as dt,
count(*) as minted
from blast.core.ez_decoded_event_logs
where CONTRACT_ADDRESS = '0x0aaadcf421a3143e5cb2ddb8452c03ae595b0734'
and topics[0] = '0xddf252ad1be2c89b69c2b068fc378daa952ba7f163c4a11628f55a4df523b3ef'
and DECODED_LOG:from = '0x0000000000000000000000000000000000000000'
group by dt
order by dt desc
)
select
*,
sum(minted) over(order by dt asc) as total_minted
from minted_hour
order by dt desc
QueryRunArchived: QueryRun has been archived