omer93nouns mints and sales
Updated 2022-07-06
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
›
⌄
WITH
lilnouns_mints as (
select
block_number as mint_block,
block_timestamp as mint_time,
tx_hash as mint_hash,
contract_address
from ethereum.core.fact_event_logs
where block_number > 12000000
and contract_address = lower('0x4b10701Bfd7BFEdc47d50562b76b436fbB5BdB3B')
and topics[0]::string = '0x1106ee9d020bfbb5ee34cf5535a5fbf024a011bd130078088cbf124ab3092478'
),
sales as (
SELECT
*
from ethereum.core.ez_nft_sales
where nft_address=lower('0x4b10701Bfd7BFEdc47d50562b76b436fbB5BdB3B')
)
SELECT
trunc(x.mint_time,'day') as date,
count(distinct mint_hash) as mints,
count(distinct tx_hash) as sales
from lilnouns_mints x
left join sales y on trunc(x.mint_time,'day')=trunc(y.block_timestamp,'day')
where date >='2022-05-22'
group by 1
order by 1 asc
Run a query to Download Data