nsa2000WC5
Updated 2022-11-23
99
1
2
3
4
5
6
7
8
9
10
11
12
13
›
⌄
--this code is thankfully burrowed from 0xHaM☰d:https://app.flipsidecrypto.com/dashboard/Jfmu0z
select
date_trunc('{{Frequency}}',block_timestamp) as date,
count(distinct tx_hash) as TX_Cnt,
count(distinct nft_froM_address) as NFT_Sender,
count(distinct nft_to_address) as NFT_Receiver,
count(distinct tokenid) as NFT_Cnt,
sum(TX_Cnt) over (order by date) as Cum_Transfer_Tx_Cnt
from ethereum.core.ez_nft_transfers
where nft_address = '0x629a673a8242c2ac4b7b8c5d8735fbeac21a6205'
and nft_from_address != '0x0000000000000000000000000000000000000000'
and event_type != 'mint'
group by 1