messariAtlas - NFT Txns (30d Trailing)
Updated 2024-01-04
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
nft_data as
(select
block_timestamp::date as day,
tx_hash,
method_name,
receiver_id,
signer_id,
owner_id as owner,
token_id
from near.nft.fact_nft_mints
union
select
block_timestamp::date as day,
tx_hash,
method_name,
receiver_id,
signer_id,
args['receiver_id'] as owner,
args['token_id'] as token_id
from near.core.fact_actions_events_function_call
where method_name = 'nft_transfer')
select
a.day,
count(b.tx_hash) as txns
from (select distinct day from nft_data) a
left join nft_data b
on b.day > a.day - interval '30 day' and b.day <= a.day
group by 1
order by 1 desc
QueryRunArchived: QueryRun has been archived