RayyykL2StateOfMind 2
Updated 2022-09-02Copy Reference Fork
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
›
⌄
with table_1 as (select date_trunc('hour', block_timestamp) as hour,
count(distinct(event_inputs:tokenId)) as nft_minted,
sum(nft_minted) over (order by hour) as cumu_nft_minted,
count(distinct(origin_from_address)) as wallets_minted,
sum(wallets_minted) over (order by hour) as cumu_wallets_minted
from optimism.core.fact_event_logs
where contract_address ilike '0x66Deb6cC4d65dc9CB02875DC5E8751d71Fa5D50E'
and tx_status = 'SUCCESS'
and event_name = 'Transfer'
group by 1)
select hour,
nft_minted,
cumu_nft_minted,
wallets_minted,
cumu_wallets_minted,
(select sum(nft_minted) from table_1) as nft,
(select sum(wallets_minted) from table_1) as wallet,
nft/wallet as avg
from table_1
order by 1 desc
Run a query to Download Data