ArkanOpenSea vs. Foundation
    Updated 2022-12-02
    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