Forefront Tak2023-11-18 01:45 AM copy copy
Updated 2024-01-07
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
›
⌄
-- forked from 2023-11-18 01:45 AM copy @ https://flipsidecrypto.xyz/edit/queries/edc3c01b-f6dc-48b6-a01c-d92cf89a78f1
with c as
( select
distinct OWNER_ID as singer
from near.nft.fact_nft_mints
where TX_STATUS ='Success'and
SIGNER_ID ='tekuno.near'and
RECEIVER_ID='tekuno.near' and
TX_RECEIVER='tekuno.near' and
METHOD_NAME='drop_nft'
)
select
case when BLOCK_TIMESTAMP::date between '2023-11-07' and '2023-11-10' then 'Nearcon2023'
when BLOCK_TIMESTAMP::date < '2023-11-07' then 'Before Nearcon2023' else 'After Nearcon2023'
end as date ,
BLOCK_TIMESTAMP::date as dates,
count(distinct TX_HASH) as "Transactions",
count(distinct TOKEN_ID) as "Tokens minted",
count(distinct OWNER_ID) as "Minter"
from near.nft.fact_nft_mints
where dates>'2023-06-01'
and OWNER_ID in (select singer from c )
group by 1,2