DB_comparing against other.
    Updated 2022-12-21
    with
    UNI as (
    select
    date_trunc('day', block_timestamp) as date,
    count(distinct tx_hash) as uni_transactions,
    sum(eth_value) as UNI_volume,
    sum(tx_fee) as UNI_total_fees,
    avg(tx_fee) as uni_avg_fee
    from
    ethereum.core.fact_transactions
    where
    to_address = lower('0xEf1c6E67703c7BD7107eed8303Fbe6EC2554BF6B')
    group by
    1
    ),
    opensea AS (
    SELECT
    date_trunc('day', block_timestamp) as sale_date,
    count(distinct tx_hash) as opensea_transactions,
    SUM(price) as opensea_volume,
    sum(tx_fee) as opensea_total_fees,
    avg(tx_fee) as opensea_avg_fee
    FROM
    ethereum.core.ez_nft_sales
    WHERE
    platform_name = 'opensea'
    AND currency_symbol = 'ETH' group by
    1
    ),
    blur AS (
    SELECT
    date_trunc('day', block_timestamp) as sale_date,
    count(distinct tx_hash) as blur_transactions,
    SUM(price) as blur_volume,
    sum(tx_fee) as blur_total_fees,
    avg(tx_fee) as blur_avg_fee
    Run a query to Download Data