adambalaTofu
Updated 2022-09-04Copy Reference Fork
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
›
⌄
with a as (select
BLOCK_TIMESTAMP,
TX_HASH,
ORIGIN_FROM_ADDRESS as buyer ,
EVENT_INPUTS:from as seller ,
EVENT_INPUTS:tokenId as token_id,
CONTRACT_ADDRESS,ORIGIN_FUNCTION_SIGNATURE
from
arbitrum.core.fact_event_logs
where EVENT_NAME ='Transfer'
and TX_STATUS='SUCCESS'
and BUYER !=SELLER and ORIGIN_TO_ADDRESS=lower('0x7bc8b1b5aba4df3be9f9a32dae501214dc0e4f3f')
order by 1 desc )
select
count(distinct TX_HASH) as txs ,
count(distinct buyer) as buyers ,
count(distinct seller) as sellers ,
count(distinct token_id) as token_id ,
count(distinct CONTRACT_ADDRESS) as collections
from a
Run a query to Download Data