shadilTotal number of WETH transactions until now
Updated 2022-08-03
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
›
⌄
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