freemartianSWC on Ethereum - Daily
Updated 2023-09-21
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
›
⌄
-- forked from SWC on Ethereum @ https://flipsidecrypto.xyz/edit/queries/dde9eab4-ea00-4c60-ad23-a60be100dc8e
-- SELECT * from ethereum.core.ez_nft_mints
-- where tx_hash = '0xd259c0b9558b6ca246d2c3e717a3f9f28004f869e9b387f7fc7b182213b2a4ba'
select
date_trunc('day', block_timestamp) as time,
count(distinct nft_to_address) as unique_minters,
count(distinct tx_hash) as total_mints,
total_mints * 0.00077 as earnings
from ethereum.core.ez_nft_mints
where EVENT_TYPE = 'nft_mint'
and nft_address = '0x9d90669665607f08005cae4a7098143f554c59ef'
group by time
Run a query to Download Data