fidamtrend
Updated 2024-09-16
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
›
⌄
WITH summer AS (
Select block_timestamp, tx_hash,
nft_to_address, tokenid
from base.nft.ez_nft_transfers
where nft_address = '0xdff7f56115568bcdd0e1f9dfdb73dd14ec83f6f7'
--and tx_hash='0x7a218fc568d295e9413476e3f66ad1fb0dad787a15192a3129b9502186ed4a1b'
AND event_type = 'mint'
)
SELECT date_trunc('day', Block_timestamp) AS date,
COUNT(DISTINCT tx_hash) as transaction,
--SUM(transaction) OVER (ORDER BY date) AS cum_transaction,
COUNT(DISTINCT nft_to_address) as USER,
COUNT(DISTINCT tokenid) AS minted
FROM summer
GROUP BY date
ORDER BY DATE DESC
-- partion
-- windown function
-- with clause
QueryRunArchived: QueryRun has been archived