shreexSales
    Updated 2022-09-22
    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