freemartianDay 8 NFTs Hourly
Updated 2023-08-30
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
28
›
⌄
-- forked from Day 8 NFTs @ https://flipsidecrypto.xyz/edit/queries/74c65415-7e01-412d-a524-a1a675f636ed
with mints as (
select * from base.core.ez_nft_transfers
where nft_address in (
'0x0651996b6a6eebd1fc697e5735a2dca541bbe06b',
'0xbd52c54ab5116b1d9326352f742e6544ffdeb2cb',
'0x6ee6e88eb8ae143bb9b4b4b0a2269a080a45ef7e',
'0xb999ec5e57000540cbf821addbc69c37bf506f9f')
and event_type = 'mint')
select
date_trunc('hour', block_timestamp) as time,
case
when project_name != 'SS23' then project_name
when project_name = 'SS23' then 'Zorb On-chain Summer'
end as Quest_NFT,
count(distinct nft_to_address) as Unique_minters,
count(tx_hash) as Total_mints,
Total_mints * 0.000777 as Earnings
from mints
where block_timestamp > '2023-08-16 15:00:00.000'
group by 1 , 2
Run a query to Download Data