shreexSales
Updated 2022-09-22
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
›
⌄
select
date_trunc('day',block_timestamp) as date,
sum(eth_value) as volume,
count(distinct tx_hash) as sale_counts,
count(distinct from_address) as distinct_buyers,
count(distinct tx_json:receipt:logs[2]:decoded:inputs:from) as distinct_sellers,
count(distinct tx_json:receipt:logs[1]:address) as distinct_nft_contracts
from arbitrum.core.fact_transactions where to_address='0x00000000006c3852cbef3e08e8df289169ede581' and date >= '2022-09-21' and status='SUCCESS'
GROUP BY date
ORDER BY date
--0x00000000006c3852cbef3e08e8df289169ede581 opensea -- origin_function_signature 0xfb0f3ee1
-- from address buyer
--
--tx_json:receipt:logs[2]:decoded:inputs:from as sellers
Run a query to Download Data