shadilTotal number of WETH transactions until now
    Updated 2022-08-03
    select sum(amount_in_usd) as total_sale_usd, sum(total_tranasctions) as total_all_tranasctions
    from (select prices.price_in_usd * sum(price) as amount_in_usd,
    count(distinct tx_hash) as total_tranasctions,
    date_trunc('day', block_timestamp) as time_d
    from optimism.core.ez_nft_sales join (select avg(price) as price_in_usd,
    date_trunc('day', hour) as date_time
    from ethereum.core.fact_hourly_token_prices
    where symbol ilike 'weth%'
    group by date_time) as prices
    on prices.date_time = date_trunc('day', block_timestamp)
    where currency_symbol in ('ETH')
    and event_type in ('sale')
    and platform_name ilike '%quixotic%'
    group by time_d, prices.price_in_usd)
    Run a query to Download Data