0-MID6-
Updated 2023-10-17
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
›
⌄
with tab1 as (
select
AMOUNT_USD
,TX_HASH
,ORIGIN_FROM_ADDRESS
from arbitrum.core.ez_token_transfers
where ORIGIN_to_ADDRESS='0x7bc8b1b5aba4df3be9f9a32dae501214dc0e4f3f' --tufu nft market
and BLOCK_TIMESTAMP::date>='2023-09-18' and BLOCK_TIMESTAMP::date <'2023-10-02'
and ORIGIN_FUNCTION_SIGNATURE='0xba847759'
),
tab2 as (
select
PROJECT_NAME
,TOKENID
,TX_HASH
from arbitrum.nft.ez_nft_transfers
)
select
PROJECT_NAME
,sum(AMOUNT_USD) as volume
,count(distinct TOKENID) as tokens
,count(distinct ORIGIN_FROM_ADDRESS) as buyers
from tab1
left join tab2
on tab1.TX_HASH=tab2.TX_HASH
where PROJECT_NAME is not null
group by 1
order by 2 desc
limit 5
Run a query to Download Data