Madicommon chart
Updated 2023-04-30Copy Reference Fork
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
›
⌄
select
date_trunc('day', BLOCK_TIMESTAMP) as date,
count(distinct TX_HASH) as TX_count,
count(distinct SELLER_ADDRESS) as Sellers,
count(distinct BUYER_ADDRESS) as Buyers,
sum(PRICE_USD) as Sum_usd,
avg(PRICE_USD) as Avg_usd,
median(PRICE_USD) as median_usd,
sum(TOTAL_FEES_USD) as TOTAL_FEES_USD,
sum(Sellers) over (order by date asc rows between unbounded preceding and current row) as cum_sellers,
sum(Buyers) over (order by date asc rows between unbounded preceding and current row) as cum_buyers,
sum(Sum_usd) over (order by date asc rows between unbounded preceding and current row) as cum_sum_usd,
sum(TX_count) over (order by date asc rows between unbounded preceding and current row) as cum_TX,
Sellers/Buyers as Seller_Buyer_Ratio
from optimism.core.ez_nft_sales
where NFT_ADDRESS = lower('0x0deaAc29d8A3d4EbBAAa3eCd3cC97C9deF00f720') and event_type = 'sale'
group by date
Run a query to Download Data