@overanalyser / New Query

SQL query

1Select 
2date_trunc('day',block_time),
3sum(usd_value_of_eth)
4From(
5
6select block_time, usd_value_of_ETH from uniswap."view_eth_purchase"
7Union all
8select block_time, usd_value_of_ETH from uniswap."view_token_purchase"
9) as eth_usd
10Where block_time > now() - interval '7 days'
11group by 1
12order by 1