ArkanOpenSea vs. Foundation
Updated 2022-12-02
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 foun as (select
date_trunc('day',block_timestamp::date) as "Daily",
count (tx_hash) as "Foundation - Total Number of Sale Transactions",
count (distinct event_inputs:bidder::string) as "Foundation - Total Number of Unique Purchaser",
count (distinct event_inputs:seller::string) as "Foundation - Total Number of Unique Seller"
from Ethereum_core.fact_event_logs
where contract_address = '0xcda72070e455bb31c7690a170224ce43623d0b6f'
and event_name = 'ReserveAuctionFinalized'
and block_timestamp >= '2022-08-01'
group by 1
order by 1),
open as (select
date_trunc('day',block_timestamp::date) as "Daily",
count(DISTINCT tx_hash) as "OpenSea - Total Number of Sale Transactions",
count(distinct EVENT_INPUTS:_to) as "OpenSea - Total Number of Unique Purchaser",
count(distinct EVENT_INPUTS:_from) as "OpenSea - Total Number of Unique Seller"
from Ethereum_core.fact_event_logs
where contract_address = '0x495f947276749ce646f68ac8c248420045cb7b5e'
and block_timestamp >= '2022-02-01'
and event_name in ('TransferBatch' , 'TransferSingle')
group by 1)
select
foun."Daily",
foun."Foundation - Total Number of Sale Transactions",
open."OpenSea - Total Number of Sale Transactions",
foun."Foundation - Total Number of Unique Purchaser",
open."OpenSea - Total Number of Unique Purchaser",
foun."Foundation - Total Number of Unique Seller",
open."OpenSea - Total Number of Unique Seller"
from foun
full join open on foun."Daily"=open."Daily"
order by 1
Run a query to Download Data