freemartianBP Brush Mints Horly
Updated 2024-09-22
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
›
⌄
-- forked from BP Brush Mint & Distinct Minters @ https://flipsidecrypto.xyz/edit/queries/a27f37cb-aeec-47c8-848a-aa1e68ef54f7
SELECT
date_trunc('day', block_timestamp) as time,
count(tx_hash) as brush_count
from base.nft.ez_nft_transfers
where event_type = 'mint'
and nft_address = '0xd68fe5b53e7e1abeb5a4d0a6660667791f39263a'
group by time
QueryRunArchived: QueryRun has been archived