ramishoowUntitled Query
Updated 2022-10-20
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
›
⌄
with ramishow as (select date_trunc('hour', block_timestamp) as hour,
count(distinct(tx_hash)) as mint_count,
sum(mint_count) over (order by hour) as cumu_mint_count
from optimism.core.fact_event_logs
where block_timestamp >= '2022-09-22'
and event_inputs:from = '0x0000000000000000000000000000000000000000'
and contract_address = '0xac3b9b3f5956b52c448158c0a07ddfa9d5c53a3b'
group by 1)
select hour,
mint_count,
cumu_mint_count,
(select sum(mint_count) from ramishow) as total_minted,
(total_minted / 25000) * 100 as mint_percentage
from ramishow
order by 1 desc
Run a query to Download Data