medvedev1088 · June 16, 2019 16:56
diff --git a/ether_supply.sql b/ether_supply.sql
 with ether_emitted_by_date  as (
  select date(block_timestamp) as date, sum(value) as value
  from `bigquery-public-data.crypto_ethereum.traces`
  where trace_type in ('genesis', 'reward')
  group by date(block_timestamp)
 )
 select date, sum(value) OVER (ORDER BY date) / power(10, 18) AS supply
 from ether_emitted_by_date
	with ether_emitted_by_date as (
	select date(block_timestamp) as date, sum(value) as value
	from `bigquery-public-data.crypto_ethereum.traces`
	where trace_type in ('genesis', 'reward')
	group by date(block_timestamp)
	)
	select date, sum(value) OVER (ORDER BY date) / power(10, 18) AS supply
	from ether_emitted_by_date