adambalatofunft11
Updated 2022-09-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
›
⌄
with a as (select
bb.BLOCK_TIMESTAMP,
bb.TX_HASH,
bb.ORIGIN_FROM_ADDRESS as buyer ,
bb.EVENT_INPUTS:from as seller ,
bb.EVENT_INPUTS:tokenId as token_id,
bb.CONTRACT_ADDRESS,bb.ORIGIN_FUNCTION_SIGNATURE ,
aa.RAW_AMOUNT / pow(10,18) as volume
from
arbitrum.core.fact_event_logs as bb inner join arbitrum.core.fact_token_transfers as aa
on bb.ORIGIN_TO_ADDRESS = aa.TO_ADDRESS and aa.tx_hash=bb.tx_hash
where aa.FROM_ADDRESS='0x0000000000000000000000000000000000000000'
and EVENT_NAME ='Transfer'
and TX_STATUS='SUCCESS'
and BUYER !=SELLER and bb.ORIGIN_TO_ADDRESS=lower('0x7bc8b1b5aba4df3be9f9a32dae501214dc0e4f3f') and TOKEN_ID is not null
order by 1 desc )
select
--count(distinct TX_HASH) as txs ,
--count(distinct buyer) as buyers ,
seller ,
--count(distinct token_id) as token_id ,
sum(volume) as volumes
--token_id ,
--ORIGIN_FUNCTION_SIGNATURE,
--BLOCK_TIMESTAMP::date as date ,
-- CONTRACT_ADDRESS
from a
group by seller
order by volumes desc limit 10
Run a query to Download Data