Daily variation of the number of the Reddit NFTs sellers, buyers and sales compared to Other Polygon NFT Collections (last 90 days)
nsa2000Daily variation of the number of the Reddit NFTs sellers, buyers and sales compared to Other Polygon NFT Collections (last 90 days)
Updated 2022-10-30
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
›
⌄
with contracts as
(
SELECT DISTINCT *
FROM (
VALUES ('0xfec90bc707fc93aefeb0c18c2eb56bc79d32163e'),('0x91ac106090fe2b0fa7d01efdf4487a5bfafad7fa'),( '0x7e680862c572e4b945cf45912130c8d884109b59'),(
'0xd5ae5a16fbaf964f96e242645a4a6f10b98fd0c4'),( '0x37db2523d221d19838632eb62d1af911e52632c3'),( '0x5fd4d6fef3b87b91c7df8658727b5edd7210cf5a'),( '0x45ee1caed83525673843321107bccadecb9065d7'),(
'0xe1b5e23fdbc003aec16e6e79726a0b5f75ff93f5'),( '0xbcea6c4029203b8753c856a2514a6ed211c69777'),( '0x334ad326a787dd332f26cbe8b4d7adfa8bd25f92'),( '0xbc096988fa38c78d65c0637453fd3d3c38b1cfd4'),(
'0x0985cb10c5d57dbf44aa473f33839ed38d80f111'),( '0x3e4627665bf2e52c69be03788e664ab545f2be71'),( '0x04f7a676af597f847053b6c02ed42d02fa4046aa'),( '0x79ef499463dae3cd413d78477fa848ecbbda774b'),(
'0x81ba34b90876f42f34a4f232cfc0fe4b6ec949a3'),( '0x621ce7e7e44d43a428a183d5390c4f4572c9ff9d'),( '0x04125a97a0f2583cd485be2c34b651cc13c38a27'),( '0xdaa6e4ba2d4022ed820460bb501b9e061d9614fb'),(
'0x3458161f2dc5d7eafa48e7c8d9acd7f415cf6da6'),( '0x04f087e3191d7a050800a2e04cb20046d2633e35'),( '0x8264e2bad3d2f7afd72a00233b9f841fe4b388cd'),( '0xddbdb65138131dbf2d01b4a5140e1979680c90bb'),(
'0xc70a7496716b3e25546901fe88215531abbd5a10'),( '0x2e90e8af4c319095942c84cfa446e1f206795517'),( '0x150afa2dfcaaada471472dfa6ad4b79e718a197c'),( '0x83feea011baeb1c6d1df7d23903efad83d3c781f'),(
'0x21d426e2b88fbf8b93adf0591a2d5b08d58f089f'),( '0xe4989961ebfdac3e65fcf0059c916452c77d8503'),( '0x6acb8fb82880d39c2b8446f8778a14d34ee6cfb7'),( '0xbfd670667053e517a97afe56c91e4f83f1160bd3'),(
'0xb9c042c3275bc49799688eea1a29b1405d02946b'),( '0x466a330887bdf62d53f968ea824793150f07762e'),( '0x5846728730366d686CdC95dae80a70b44Ec9eAb2'),( '0xfbed9640e37666fe2ac78e1d263670976354cb69'),(
'0xe0743141df04a6b9f3df890429cc994e46db03d9'),( '0x97439ee4c93ff9f76417696ce648aa6f35ab3b25'),( '0xf43bc3f4f1edb7d4c373c8510a2888d69d83ceb7'),( '0x425bf054ef7bad65b7bdd8e6587b1c3500e4f4ca'),(
'0x2956409293da98603025cc0121c06a4244752039'),( '0xa7bb50d90b43752199c45be04053641c3cb5f53f'),( '0x47749c5b970e63f3a0ed57cd6cef773e74fafe9d'),( '0x838c1cd42929543daf9c3ef294fee8c1b3224b37'),(
'0xc5aa1f91b0d52e26d2847f8e51f505d6e2ece795'),( '0xee1ee80338958fa596471ceb70f0177daff80323'),( '0x4670e4890bc1b76f3ae5c7660aa98e0b6668c6f3'),( '0x2d58a44d6c0a355de25761fb33a1f6269a97e2c5'),(
'0xd8cf23bf309de778609d234bd2410b0156118c26'),( '0x91e51b92a2efea89bf1b6f66ad719737264724be'),( '0xd6261320f49d38c137f6e229a2ea4ab0f4fae6de'),( '0xfc190440e8f357ffe8a75940e7d8a291e165d019'),(
'0x808ed3e23aac685126524aa4416d8eaeb2e767b9'),( '0x65a83530ca8abc27969907913fe5e641a5da2e9f'),( '0x6d1c3646e8cce8537e6ec9ecab26762bfaf1f891'),( '0x63e2f0c058ce9a194ec68f04320b7eb8ca555bd3'),(
'0x45308788743bbdae5de7ba9e565c0502d0ebb81f'),( '0x907808732079863886443057c65827a0f1c64357'),( '0x8d0501d85becda92b89e56177ddfcea5fc1f0af2'),( '0x6ad08588568e258b2bdf065e7769fce398f68a1c'),(
'0x946ad8e53db653053e8ef7c02dfca83ce8ba8022'),( '0x27b37e4befacc50b02102d1e2117c4ea8a54beff'),( '0x71dc46607f31f30510f0ccc670b0963f431b212a')
) AS X(con)
)
, final as (
select 'Reddit NFTs' as collection,
date_trunc('Day', block_timestamp) Date,
count (distinct tx_hash) as Sales_Count,
count (distinct event_inputs:_to) as Buyers_Count,
count (distinct event_inputs:_from) as Sellers_Count,
count (distinct event_inputs:_id) as Tokens_Count
from polygon.core.fact_event_logs
join contracts on contract_address = con
and event_name ='TransferSingle'
and tx_status = 'SUCCESS'
and event_inputs:_from != '0x0000000000000000000000000000000000000000'
group by 1, 2
Run a query to Download Data