Madidistrb tx/amount
Updated 2023-04-30
9
1
2
3
4
5
6
7
8
›
⌄
select
date_trunc('hour', BLOCK_TIMESTAMP) as date,
count(distinct TX_HASH) as TX_count,
sum(PRICE_USD) as Sum_usd
from optimism.core.ez_nft_sales
where NFT_ADDRESS = lower('0x0deaAc29d8A3d4EbBAAa3eCd3cC97C9deF00f720') and event_type = 'sale'-- and date_trunc('hour', BLOCK_TIMESTAMP) >= dateadd(hour,-24,getdate())
group by date
order by TX_count desc, Sum_usd desc
Run a query to Download Data