hbd19945. Daily Transfers
Updated 2022-11-22
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
›
⌄
select
date(block_timestamp) as "Date",
count(distinct tx_hash) as "Number of Transfers",
sum("Number of Transfers") over (order by "Date") as "Cumulative Number of Transfers",
count(distinct NFT_TO_ADDRESS) as "Number of Unique NFT Receivers",
sum("Number of Unique NFT Receivers") over (order by "Date") as "Cumulative Number of Unique NFT Receivers",
count(distinct NFT_FROM_ADDRESS) as "Number of Unique NFT Senders",
sum("Number of Unique NFT Senders") over (order by "Date") as "Cumulative Number of Unique NFT Senders",
count(distinct TOKENID) as "Number of Unique NFTs",
sum("Number of Unique NFTs") over (order by "Date") as "Cumulative Number of Unique NFTs"
from ethereum.core.ez_nft_transfers
where NFT_ADDRESS ilike '0x629a673a8242c2ac4b7b8c5d8735fbeac21a6205'
and EVENT_TYPE = 'other'
group by 1
order by 1
Run a query to Download Data